how to create our own flat file to test table control in bdc

[Former Member]

thanks f but i need a help in flat file creation... in bdc table control

[former_member223537]

Hi,

Its very simple.

You know the file format required(i.e. the fields & their locations in the file).

Create a New Excel sheet

Enter all the data

File=>SAVEAS=> TAB DELIMITED & enter the filename with .TXT extension.

Your Flat file is ready!

Best regards,

Prashant

[Former Member]

if you are not using 'ALSM_EXCEL_TO_INTERNAL_TABLE' function module then make two excel sheets. In one excel get the header portion. In the second file get the item portion, make sure at least one field is common between the header and item files so that you can link them in table control. Then save the files as .txt limited.Else if you are using 'ALSM_EXCEL_TO_INTERNAL_TABLE' function module, you can use one excel file, the position of begin and end rows for header and details determine how to load them in separate internal tables.

regards,

mallick

[Former Member]

hi,

check this,

bmeng refers table control field.

matnr plant stlan bmeng

125 11p1 1 10

125 11p1 1 20

125 11p1 1 30

130 11p1 1 15

130 11p1 1 35

regards

siva