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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

upload excel contents with multi-sheets

Go to solution
Former Member

‎2009 Sep 08 3:49 PM

0 Kudos
155

Hi experts,

At present I encounter such requirement:

the customers have a excel template,this excel has two sheets,one includes PR data,and the other has the PO data.They want to upload these data into SAP system at once.And I check the FMs SAP offers,they only support to upload one sheet data into SAP at once.Has any FM can support this??

So What can I do??Could you please help to give some adivce or solutions?!

Thanks a lot & best regards,

Villy.Lv

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎2009 Sep 09 5:03 AM

0 Kudos
99

Yes what you said is absolutely correct. You can upload only 1 worksheet of an excel and SAP doesn't support to upload multiple worksheet of a excel workbook. Tell the users to put the PR and PO data into different workbooks rather than putting them into multiple worksheets in the same workbook.

2 REPLIES 2

Go to solution
Former Member

‎2009 Sep 09 4:26 AM

0 Kudos
99

Hi,

Check with this function module.

ZJNC_GET_RANGE.

Regards,

Shamma

Go to solution
Former Member

‎2009 Sep 09 5:03 AM

0 Kudos
100

Yes what you said is absolutely correct. You can upload only 1 worksheet of an excel and SAP doesn't support to upload multiple worksheet of a excel workbook. Tell the users to put the PR and PO data into different workbooks rather than putting them into multiple worksheets in the same workbook.