Upload sales order(Header,Item) to Excel mutiple work sheets in to SAP

[Former Member]

Hi Everyone,

I have a requirement like below,

At first we have to create Sales order using BAPI and then the created sales order values must be populate from Excel sheet( multiple work sheets like header,item,schedule) in to SAP system. can any one please suggest me how to resolve this.

Thank you.

[madhu_vadlamani]

Hi Krishnaveni,

+I have a requirement like below,

At first we have to create Sales order using BAPI and then the created sales order values must be populate from Excel sheet( multiple work sheets like header,item,schedule) in to SAP system. can any one please suggest me how to resolve this.+

Yes it is possible. Use bapi method to create sales order with lsmw method. Make different sheets for header,item and upload. This will be the eaiest and fast process. Post if need help.

Regards,

Madhu.

[Former Member]

Hi,

You may ask your ABAPer to create a BDC for this purpose. There are different function modules in ABAP using which you can upload the Excel workbook (including different sheets) into internal tables. Once done, the internal tables can be used in BDC to upload the data in sales order.