What are SAP BDC Tools
SAP BDC is the most effective method of mass data migration from legacy systems to SAP system. There are two methods of BDC tools i.e Call Transaction Method and Batch Input Session Method. In our previous SAP training tutorials we have discussed about what is SAP BDC
Here, we are going to explain BDC tools through the implementation of an program is done using the call transaction method.
To perform BDC using the Call transaction method, we need to do the following:
1. Analyze the legacy data. Closely study how the data which is to be transferred can be mapped into a recognized SAP structure. Also determine the necessary data types that need to be used as well as the data length conversions.
2. Next, create SAP data structures which are used to export the data. (Creation of internal table, BDCDATA)
3. Now, export the data in to a sequential file. Be very careful about the character format which is used.
4. You can use the standard SAP batch input program or customize and create your own program, depending on your requirements. Choose call transaction method or batch input session method according to your needs.
5. Now, execute the program, process the data, add it to the SAP System.
6.. For batch input session method, you will have to analyze the process log. But for the CALL TRANSACTION method, there is no proper log, you will have to use the messages that are collected by your program.
7. Closely study the results of the process analysis, correct and reprocess the data entries that are displayed as errors.
Important points to be noted While writing the BDC program.
- Use the right transaction to process batch input data.
- The data has to be stored in the batch input structure, BDCDATA.
- Do you want to use call transaction method or batch input session method?.
- Now read the data from a sequential file.
- Do the data conversion as well as the error checking.
- Generate a batch input session if you are using batch input sessions method,or execute the program with CALL TRANSACTION USING statement, which processes the data directly, without using a session.
BDC DATA internal table has the following structure, which has to be followed throughout the BDC program
Here, we present a simple BDC program using the Call Transaction method, which has been created using all the instructions given above. The transaction being processed here is MM01.
report ZMAT_UPLOAD_CT no standard page heading line-size 255.
TABLES : RLGRAP.
*DATA : IT_MESG LIKE BDCMSGCOLL OCCURS 0 WITH HEADER LINE.
include bdcrecx1.
DATA : BEGIN OF IT_MM01 OCCURS 0,
MATNR(18),
MBRSH,
MTART(4),
KZSEL,
MAKTX(40),
MEINS(3),
END OF IT_MM01.
DATA : IT_SUCCESS LIKE IT_MM01 OCCURS 0 WITH HEADER LINE,
IT_ERROR LIKE IT_MM01 OCCURS 0 WITH HEADER LINE.
DATA : STR_FPATH TYPE STRING.
*DATA : SUCC_FPATH LIKE RLGRAP-FILENAME,
* SUCC_FPATH_STR TYPE STRING,
* ERROR_FPATH_STR TYPE STRING.
PARAMETERS : P_FPATH LIKE RLGRAP-FILENAME.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FPATH.
CALL FUNCTION ‘F4_FILENAME’
* EXPORTING
* PROGRAM_NAME = SYST-CPROG
* DYNPRO_NUMBER = SYST-DYNNR
* FIELD_NAME = ‘ ‘
IMPORTING
FILE_NAME = P_FPATH.
start-of-selection.
IF P_FPATH IS NOT INITIAL.
STR_FPATH = P_FPATH.
ENDIF.
CALL FUNCTION ‘GUI_UPLOAD’
EXPORTING
filename = STR_FPATH
FILETYPE = ‘ASC’
tables
data_tab = IT_MM01.
LOOP AT IT_MM01.
WRITE :/10 IT_MM01.
ENDLOOP.
perform open_group.
LOOP AT IT_MM01.
perform bdc_dynpro using ‘SAPLMGMM’ ‘0060’.
perform bdc_field using ‘BDC_CURSOR’
‘RMMG1-MTART’.
perform bdc_field using ‘BDC_OKCODE’
‘=AUSW’.
perform bdc_field using ‘RMMG1-MATNR’
IT_MM01-MATNR.
perform bdc_field using ‘RMMG1-MBRSH’
IT_MM01-MBRSH.
perform bdc_field using ‘RMMG1-MTART’
IT_MM01-MTART.
perform bdc_dynpro using ‘SAPLMGMM’ ‘0070’.
perform bdc_field using ‘BDC_CURSOR’
‘MSICHTAUSW-DYTXT(01)’.
perform bdc_field using ‘BDC_OKCODE’
‘=ENTR’.
perform bdc_field using ‘MSICHTAUSW-KZSEL(01)’
IT_MM01-KZSEL.
perform bdc_dynpro using ‘SAPLMGMM’ ‘4004’.
perform bdc_field using ‘BDC_OKCODE’
‘/00’.
perform bdc_field using ‘MAKT-MAKTX’
IT_MM01-MAKTX.
perform bdc_field using ‘BDC_CURSOR’
‘MARA-MEINS’.
perform bdc_field using ‘MARA-MEINS’
IT_MM01-MEINS.
perform bdc_dynpro using ‘SAPLSPO1’ ‘0300’.
perform bdc_field using ‘BDC_OKCODE’
‘=YES’.
CALL TRANSACTION ‘MM01’ USING BDCDATA MODE ‘E’ UPDATE ‘S’ MESSAGES INTO MESSTAB.
*perform bdc_transaction using ‘MM01’.
READ TABLE MESSTAB INDEX 1.
IF MESSTAB-MSGTYP EQ ‘S’.
IT_SUCCESS = IT_MM01.
APPEND IT_SUCCESS.
ELSE.
*perform bdc_transaction using ‘MM01’.
IT_ERROR = IT_MM01.
APPEND IT_ERROR.
ENDIF.
REFRESH : BDCDATA,
MESSTAB.
CLEAR : MESSTAB.
ENDLOOP.
perform close_group.
**DOWNLOAD ALL succ and error recs as files on to the desktop
IF IT_SUCCESS[] IS NOT INITIAL.
CALL FUNCTION ‘GUI_DOWNLOAD’
EXPORTING
filename = ‘C:\Users\Reliance\Desktop\ZSUCCESS.TXT’
FILETYPE = ‘ASC’
WRITE_FIELD_SEPARATOR = ‘X’
tables
data_tab = IT_SUCCESS.
ENDIF.
IF IT_ERROR[] IS NOT INITIAL.
CALL FUNCTION ‘GUI_DOWNLOAD’
EXPORTING
filename = ‘C:\Users\Reliance\Desktop\ZERROR.TXT’
FILETYPE = ‘ASC’
WRITE_FIELD_SEPARATOR = ‘X’
tables
data_tab = IT_ERROR.
ENDIF.
Read more for SAP BDC tools and BDC programming interview questions with scenarios.