BAPI_SALESORDER_CREATEFROMDAT2

[Former Member]

Dear Frined,

Regarding this BAPI of Customer Order creation , BAPI_SALESORDER_CREATEFROMDAT2

How do I create the input Excel file with the respective feilds to be uploaded into the system.

Is there any standard process to get the input feilds which are used in the BAPI Program.

Please explain..Full point to correct explanation.

regards,

Amlan Sarkar

[Former Member · Accepted solution]

Dear alman,

Better to avoid XL file updation for SO creation through BAPI . If unavoidable , then minimise your input.

This can be done in the following way ,

1. Maintain one Ztable where order type + sales area + plant + material + sold to party listing is maintained for control purpose , keeping sold to party + plant as a key field .

2. Now , go for executable prog and in the selection screen , keep input field for sold to party , plant and quantity .

rest of the header data like incoterms , payment terms , and others , fetch from customer master tables KNA1 , KNVV and populate in the bapi header .

If it is going to be multiple order , then ,go for table control and ask the user to give the input sold to pary and plant , quantity and process in bulk .

saravanan

[former_member183879]

Amlan,

You can give this job safely to the technical consultant.

Before that,

Talk to the user and get informations like

1. What fields will be stored in the excel sheet and why

2. Find out the respective fields in the database tables VBAK, VBAP, VBEP, VBEH etc

3. Now evaluate the missing fields which are mandatory for running the transactions and find out how those fields need to be filled.

4. Once these things are done, give the requirement to ABAPer, provide him the template of teh excel sheet and the field mapping of the xls fields to the database fields.

5. ABAPer will do the rest of the job to you.

Hope this helps you