Add fields as conditon for tcode FAGLL03 XREF3

Situation and Purpurse:Need to add customer fields as query conditon for sap tcode FAGLL03. Solution: 1.Key in sap tcode FAGLL03. 2.Choose[自由选择],double click[总账科目行项目]file directory. In [Field data], find out table name. 3.Double click table name,Such as [BSIS_FS]. 4.Tcode se11, goto  sap data dictionnary. Choose[Append structure] that have new choose fields, such as XREF3. 5.Save and aveive

SAP F-44 BTE ENHANCEMENT:Check with Error.00000940

Purpose: Check BSEG-XREF2 IF THE same when in TCODE F-44, If not , thorow error message. Solution:Do SAP ABAP enhancement in BTE event 00000940. Config: ***** TABLES TPS01. TPS01-PROCS = ‘00000940’. MODIFY TPS01. *** TABLES TPS01T. TPS01T-SPRAS = ‘1’. TPS01T-PROCS = ‘00000940’. MODIFY TPS01T. ***** TABLES TBE24. TBE34-AKTIV = ‘X’. TBE34-PRDKT = ‘ZF_44’. MODIFY TBE34.

Auto log in SAP system without change regedit

Purpuse: Without input the SAP password, log into the SAP system with only a click. and open transaction code se11 with the default value “T001”.   Solution:Use the parameters of SAPshortcut.exe of windows system. 1、Open window’s notepad.exe ,save to login.bat script. 2、Key in below command: start sapshcut.exe -user=SAPDDIC -pw=12345678 -language=DE -SYSTEM=PRD -CLIENT=100 -sysname=hot583SAP_SYSTEM -maxgui -command=”*se11

Batch upload/ download SAP table data

Situation: Sometimes, we need to upload/ download customer config table to other system. Now this is the sample ABAP code . FIELD-SYMBOLS: <fs_tab_fil> TYPE STANDARD TABLE, <fs_tab_db>  TYPE STANDARD TABLE. PARAMETERS upload  RADIOBUTTON GROUP g1 . PARAMETERS download  RADIOBUTTON GROUP g1 . PARAMETERS filepath TYPE string. PARAMETERS table TYPE string LOWER CASE. DATA: answer     TYPE char1, litab_tb   TYPE REF TO data, litab_tb2  TYPE REF TO data, lc_tab_fst TYPE char1. CREATE DATA litab_tb TYPE STANDARD TABLE OF (table) WITH NON-UNIQUE DEFAULT KEY. CREATE DATA litab_tb2 TYPE STANDARD TABLE OF (table) WITH NON-UNIQUE DEFAULT KEY. ASSIGN litab_tb->* TO <fs_tab_fil>. ASSIGN litab_tb2->* TO <fs_tab_db>. AT SELECTION-SCREEN ON VALUE-REQUEST FOR filepath. DATA gt_tab TYPE STANDARD TABLE OF file_table . DATA li TYPE i. CALL METHOD cl_gui_frontend_services=>file_open_dialog CHANGING file_table = gt_tab rc         = li. IF sy–subrc <> 0. MESSAGE ‘open file path error.’ TYPE  ‘E’. ELSE. READ TABLE gt_tab INTO filepath INDEX 1. ENDIF. AT SELECTION-SCREEN. IF filepath IS INITIAL. SET CURSOR FIELD ‘FILEPATH’. MESSAGE ‘please input the required FILEPATH’ TYPE ‘E’. ENDIF. IF table IS INITIAL.