Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

uplode problem

Former Member
0 Kudos

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.

5 REPLIES 5

former_member203501
Active Contributor

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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

0 Kudos

it is not open.