Excel sheet

[Former Member]

Dear all,

when iam going to enter sale order...it might be more than 100 line items...so Firest user wants to enter in Excel sheet ,then they need to copy Excel sheet to SAP.

All line items should copy from Excel to SAP as line items.

Is thr any solution...

Please need helpful..

Thanks in Advance

Regards

Luckky

[Former Member · Accepted solution]

1. call function BAPI_SALESORDER_CREATEFROMDAT2

2. it can import excel file to create new sales order

[Former Member]

Dear lucky,

Contact your ABAPer and write a prog to upload xl file to get a data into a internal table ,then

Go to trxn : SHDB and create one dummy sales order and record and give it to ABAPer for writting prog for BDC which is a easy method , in this case you can identify if any problem is there while populating the data on the screen , means in 100 items which item number has got the problem can be identified ,if required by taking into forground operation.

Reward if useful.

saravanan

[former_member184555]

Hi

This can be done by scheduling jobs(background creation of orders). It takes the file (FTP) and creates the orders.

Thanks,

Ravi