uplode problem

[Former Member]

hi,

I have two excel sheets. First excel have header data and second have item details.

I want up lode two excel sheets at a time.

Pono vendor doc.type

450000000 1000 nb.

Item.no material plant

10 100-100 1000

20 100-101 2000.

[former_member203501]

hi go to this and see this...

http://abap-explorer.blogspot.com/2008/12/upload-data-from-multiple-worksheets-of.html

[Former Member]

hi,

in the selection screen provide two filepaths..then upload and when clicked on upload make sure that u upload data from both file paths..

Rgds.,

subash

[Former Member]

Hi anitha,

You have 1 file having po number in header file.

U add that po number column in item file also .

eg.

Pono vendor doc.type

450000000 1000 nb.

Pono Item.no material plant

450000000 10 100-100 1000

450000000 20 100-101 2000.

so that wen u read item file u will identify that item is of which po.

then u loop on header file and in that loop u loop on item file matching hearder po no with item po no

regards,

Yog

[Former Member]

HI,

Check this Blog it gives you the better approch of uploading the data from different tabs of Excel sheet.

[Upload data from Multiple Worksheets within a single Excel File into internal table from ABAP|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/3046] [original link is broken] [original link is broken] [original link is broken];

[Former Member]

it is not open.