topic Re: uplode problem in Application Development and Automation Discussions

uplode problem

Former Member — Thu, 02 Apr 2009 08:08:10 GMT

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.

Re: uplode problem

former_member203501 — Thu, 02 Apr 2009 08:12:26 GMT

hi go to this and see this...

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

Re: uplode problem

Former Member — Thu, 02 Apr 2009 08:13:03 GMT

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

Re: uplode problem

Former Member — Thu, 02 Apr 2009 08:14:00 GMT

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

Re: uplode problem

Former Member — Thu, 02 Apr 2009 08:20:32 GMT

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];

Re: uplode problem

Former Member — Thu, 02 Apr 2009 08:23:32 GMT

it is not open.