topic Re: bdc in Application Development and Automation Discussions

The concept is easy: it has to indicate the index of the table control in the field name, so if you have to populate the first record of table control:

BDC-FIELDNAME = <FIELDNAME>(01).

If you fill the second row:

BDC-FIELDNAME = <FIELDNAME>(02).

and so....

Now the problem is usually on how many records you have to load, because u can fill only the rows of table control available in the screen, If you have more records than it can be displayed yuo have to simulate the command to go next page.

The number of recod can be displayed can depend on pc resolution and many program haven't command to go to next page (in this case it could be impossible create a BDC program9.

A way to create a bdc program resolution indipendent is to work on the first and second row.

- Place the first hit in the first row of bdc;

- Place the second insert in the second row of bdc;

- Place the last hit to the top of table control;

- Place the next hit in the second row;

- Place the last hit to the top of table control;

- Place the next hit in the second row;

- .... and so

For more info: Search in SDN with TABLE CONTROL IN BDC.

Will get a lot of related links.

Reward points if this Helps.

Manish

Re: bdc

Former Member — Tue, 26 Feb 2008 09:51:32 GMT

REPORT ZMHYDXCV.

*.......Structures the SAP flat file does use (SAPstructures)...........

TABLES: BGR00, "Depends on the business object

BMM00, "here for the material master

BMMH1.

*.......Structures the data your provided flat file does use............

DATA: BEGIN OF MY_STRUCTURE OCCURS 1000, "Depends on your legacy data

MATERIAL_NO(10) TYPE C,

DESCRIPTION(20) TYPE C,

ORGANIZATION(10) TYPE C,

MATERIAL_TYPE(5) TYPE C,

MAT_GROUP(5) TYPE C,

WEIGHT(10) TYPE C,

PRICE(10) TYPE C.

DATA: END OF MY_STRUCTURE.

*......Some other data that's needed....................................

DATA: BEGIN OF WORK_AREA OCCURS 1000,

STRING(1500) TYPE C.

DATA: END OF WORK_AREA.

DATA: FLAT_FILE(50) TYPE C VALUE 'C:\matmaster.txt',

FLAT_FILE_SAP(50) TYPE C VALUE 'C:\material.txt',

IDENTIFIER(1) TYPE C. "Identifies different struct.

*......At start-of-selection............................................

START-OF-SELECTION.

PERFORM READ_FLAT_FILE.

PERFORM ANALYZE.

PERFORM CONVERT_AND_WRITE.

*......Read the your flat file and fill internal table my_structure.....

FORM READ_FLAT_FILE.

OPEN DATASET FLAT_FILE FOR INPUT

IN TEXT MODE.

IF SY-SUBRC GT 0.

" Error message has to be issued, because you can't open the file

ENDIF.

DO.

CLEAR WORK_AREA.

READ DATASET FLAT_FILE INTO WORK_AREA.

IF SYST-SUBRC GT 0.

EXIT.

ENDIF.

ENDDO.

CLOSE DATASET FLAT_FILE.

ENDFORM.

*.....Analyze work_area and move fields into my_structure...............

FORM ANALYZE.

LOOP AT WORK_AREA.

"loop at all fields in the record

"get field and move it in the corresponding field in my_structure

"endloop

ENDLOOP.

ENDFORM.

*.......Convert and write the SAP flat file.............................

FORM CONVERT_AND_WRITE.

OPEN DATASET FLAT_FILE_SAP FOR OUTPUT IN TEXT MODE.

IF SY-SUBRC GT 0.

"Open has failed, so issue an error message

ENDIF.

LOOP AT MY_STRUCTURE.

"determine the target-structure and set identifier.

CASE IDENTIFIER.

"when structure1

"fill fields of structure1.

"transfer the needed SAPstructure(s) to flat_file_sap.

"when structure2.

"...

"when others.

"that should probably provoke an error!

ENDCASE.

ENDLOOP.

CLOSE DATASET FLAT_FILE_SAP.

ENDFORM.

************************************************************************chk these links

http://www.sappoint.com/abap/bdcconcept.pdf

http://www.sap-img.com/bdc.htm

http://www.sapdevelopment.co.uk/bdc/updhome.htm

Table control in BDC

http://www.sap-img.com/abap/bdc-example-using-table-control-in-bdc.htm

http://www.sapgenie.com/abap/bdc.htm

http://www.sapdevelopment.co.uk/bdc/bdchome.htm

http://www.sap-img.com/abap/learning-bdc-programming.htm

http://www.sap-img.com/sap-download/bdcrecording.zip

http://www.sappoint.com/abap/bdcconcept.pdf

http://www.sap-img.com/abap/question-about-bdc-program.htm

-siva

Edited by: SivaKumar on Feb 26, 2008 3:22 PM

Re: bdc

Former Member — Tue, 26 Feb 2008 10:05:40 GMT

hi,

BATCH DATA COMMUNICATIONS:

This concept deals with data migration from legacy system database into SAP database. Whenever a company moves into SAP from legacy system, BDC is used to populate the new SAP database with their old required records.

Methods in BDC:

1. DIRECT INPUT METHOD - Using this method, records from the flat file are uploaded first into an internal table created for the flat file structure. Using a string function (SPLIT functionality), the records are splitted based on the separators and then inserted into a new internal table which is created for a table where the datas are to be inserted.

eg. code:

DATA : BEGIN OF ITAB OCCURS 0,

STR(255),

END OF ITAB.

DATA ITAB1 LIKE KNA1 OCCURS 0 WITH HEADER LINE.

CALL FUNCTION 'UPLOAD'

EXPORTING

FILENAME = 'C:\BASK.TXT'

FILETYPE = 'ASC'

TABLES

data_tab = ITAB.

LOOP AT ITAB.

SPLIT ITAB-STR AT ' ' INTO ITAB1-KUNNR ITAB1-NAME1 ITAB1-LAND1

ITAB1-ORT01.

APPEND ITAB1.

ENDLOOP.

LOOP AT ITAB1.

INSERT INTO KNA1 VALUES ITAB1.

IF SY-SUBRC = 0.

WRITE 😕 'RECORDS ARE INSERTED'.

ELSEIF SY-SUBRC = 4.

WRITE 😕 'RECORDS ALREADY EXIST'.

ENDIF.

ENDLOOP.

In the above program, 'UPLOAD' function module is used to fetch the flat file records and then insert into internal table created for flat file structure (ITAB).

2. CALL TRANSACTION METHOD.

CODE:

DATA : BEGIN OF ITAB OCCURS 0,

STR(255),

END OF ITAB.

CALL FUNCTION 'UPLOAD'

EXPORTING

FILENAME = 'C:\STAL.TXT'

FILETYPE = 'ASC'

TABLES

data_tab = ITAB.

DATA ITAB1 LIKE KNA1 OCCURS 0 WITH HEADER LINE.

LOOP AT ITAB.

SPLIT ITAB-STR AT ',' INTO ITAB1-KUNNR ITAB1-NAME1 ITAB1-ORT01 ITAB1-LAND1.

APPEND ITAB1.

ENDLOOP.

DATA JTAB LIKE BDCDATA OCCURS 0 WITH HEADER LINE.

DATA KTAB LIKE BDCMSGCOLL OCCURS 0 WITH HEADER LINE.

LOOP AT ITAB1.

PERFORM PROGINFO USING 'SAPMZSTALINCT' '100'.

PERFORM FLDINFO USING 'WA-KUNNR' ITAB1-KUNNR.

PERFORM FLDINFO USING 'WA-NAME1' ITAB1-NAME1.

PERFORM FLDINFO USING 'WA-LAND1' ITAB1-LAND1.

PERFORM FLDINFO USING 'WA-ORT01' ITAB1-ORT01.

CALL TRANSACTION 'ZSTALINCT' USING JTAB MODE 'N' MESSAGES INTO KTAB.

ENDLOOP.

LOOP AT KTAB.

WRITE 😕 KTAB-TCODE, KTAB-DYNAME, KTAB-DYNUMB, KTAB-MSGTYP, KTAB-MSGNR, SY-SUBRC.

ENDLOOP.

FORM PROGINFO USING PROGNAME SCRNUM.

CLEAR JTAB.

REFRESH JTAB.

JTAB-PROGRAM = PROGNAME.

JTAB-DYNPRO = SCRNUM.

JTAB-DYNBEGIN = 'X'.

APPEND JTAB.

ENDFORM.

FORM FLDINFO USING FLDNAME FLDVAL.

CLEAR JTAB.

JTAB-FNAM = FLDNAME.

JTAB-FVAL = FLDVAL.

APPEND JTAB.

3. BDC SESSION METHOD.

TOOLS USED IN BDC:

LEGACY SYSTEM MIGRATION WORKBENCH (LSMW)

BDC RECORDING METHOD

BDC CALL TRANSACTION METHOD:

Since we cannot modify the error record using direct input method, we go for call transaction method. Here, we create a screen to populate error records in input fields and from the screen, we can modify the error records and then insert into database table.

Steps to be followed in Call Transaction MEthod:

1. Analyze the flat file.

2. Create a screen for database table fields using MPP. Create a Transaction code for the screen.

3. Write the following code in SE38 editor:

DATA : BEGIN OF ITAB OCCURS 0,

STR(255),

END OF ITAB.

CALL FUNCTION 'UPLOAD'

EXPORTING

FILENAME = 'C:\KNA.TXT'

FILETYPE = 'ASC'

TABLES

DATA_TAB = ITAB.

DATA ITAB1 LIKE KNA1 OCCURS 0 WITH HEADER LINE.

DATA JTAB LIKE BDCDATA OCCURS 0 WITH HEADER LINE.

LOOP AT ITAB.

SPLIT ITAB-STR AT ',' INTO ITAB1-KUNNR ITAB1-NAME1 ITAB1-ORT01

ITAB1-LAND1.

APPEND ITAB1.

ENDLOOP.

LOOP AT ITAB1.

PERFORM PROGINFO USING 'SAPMZCALLTRANSACTION' '100'.

PERFORM FLDINFO USING 'KARTHIK-KUNNR' ITAB1-KUNNR.

PERFORM FLDINFO USING 'KARTHIK-NAME1' ITAB1-NAME1.

PERFORM FLDINFO USING 'KARTHIK-ORT01' ITAB1-ORT01.

PERFORM FLDINFO USING 'KARTHIK-LAND1' ITAB1-LAND1.

CALL TRANSACTION 'ZCALLTRANS' USING JTAB.

ENDLOOP.

FORM PROGINFO USING PROGNAME SCRNUM.

CLEAR JTAB.

REFRESH JTAB.

JTAB-PROGRAM = PROGNAME.

JTAB-DYNPRO = SCRNUM.

JTAB-DYNBEGIN = 'X'.

APPEND JTAB.

ENDFORM.

FORM FLDINFO USING FLDNAME FLDVALUE.

CLEAR JTAB.

JTAB-FNAM = FLDNAME.

JTAB-FVAL = FLDVALUE.

APPEND JTAB.

ENDFORM.

Save -> Activate -> Execute.

In the above code,

BDCDATA is a structure used to populate the internal table records into the screen fields. The BDCDATA structure has following components:

PROGRAM - Holds the name of MPP program where the screen is created.

DYNPRO - Holds the screen number where the internal fields to be populated.

DYNBEGIN - Used to initiate the screen when the program is executed. The default value to be specified is 'X'.

FNAM - Specifies input field name in the screen where the data is to be populated.

FVAL - Specifies from which internal table field, the data should be passed to the screen field.

'CALL TRANSACTION' statement is used to call the screen created to populate error records.

SYNTAX:

CALL TRANSACTION <Tcode> USING <BDCDATA_itab> MODE <mode> UPDATE <update>.

MODE: This is used to specify which mode to be followed when calling transaction. The types of mode are:

A - Display the screen.

E - Display only error records from the flat file.

N - Background processing.

UPDATE: This is used to specify the update task of records in the database table. The types of update tasks are:

A - Asynchronous update

S - Synchronous update

L - Local update

Advantages of CALL TRANSACTION:

Error records can be modified.
This method can be used in support projects.

Hope this helps u,

Regards,

Arunsri

Re: bdc

Former Member — Tue, 26 Feb 2008 10:33:11 GMT

Hi ,

To create bdc first we have to identify

the transcation name to which ur going to create dbc.

Then u have to be ready with excel file ,with raw datas.

Then go to shdb and do a recording by entering sample

datas then .

generate the progam by giving program name in shdb t-code by

selecting the recording.

Re: bdc

Former Member — Tue, 26 Feb 2008 10:39:36 GMT

continuation....

After this with the system generated program code

create a bdc program .

using call transcation or session method

regards,