Upload header and item data from excel file

[Former Member]

Hello Friends,

I have to update FB01 TC code and for this i have Header and Item data in Excel flat file .

I am Uploading Excel file from function module 'ALSM_EXCEL_TO_INTERNAL_TABLE' my doubt is after uploading Header and Item data from Excel file how can i make sure item data related to Header data.

[Former Member · Accepted solution]

for this you need to put one identifier in header file and item file. based on IDENT you can split.

Header strcture.

INDENT| field1|field2|field3

10|field1|field2|field3

20|field1|field2|field3

30|field1|field2|field3

Item strcture.

INDENT| field1|field2|field3

10|field1|field2|field3

10|field1|field2|field3

10|field1|field2|field3

20|field1|field2|field3

20|field1|field2|field3

30|field1|field2|field3

[Former Member]

Thanku.