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.
Showing results for 
Search instead for 
Did you mean: 

Sales Order From Excel sheet

Former Member
0 Kudos

Upload Data From Excel sheet to VA01(Creating Sales ORder).I m using BDC for tat......but after putting all the data & when i press enter button it shows me Partner List(in the form of ALV screen),from which i have to chose the m not able to do tat while using bdc......please help me in this matter......its vry urgent.Or if thr is any other technique by which it becomes vry easy,thn plz tell me OR can i know from which table this ALV is taking data.


Active Contributor
0 Kudos

Use the bapi: BAPI_SALESORDER_CREATEFROMDAT2 instead of bdc.

Search the forum with the bapi name. You would also find so many code examples.



0 Kudos

can u tell me frm which table Partner list is fetching and 'KWMENG' field is used as cumulative order quantity in creatin sales order,which is having some checks against which we fill particular quantity of any material while we create Sales Order.I want to know from which table it is checking qty when we create SAles order.

If any one is havin any working example for this BAPI,thn plz give me

Active Contributor
0 Kudos

Hi Dheeraj,

Pls. refer this thread for example of BAPI BAPI_SALESORDER_CREATEFROMDAT2 :

Best regards,


Pls. mark points for helpful answers