PO creation from Excel file

[Former Member]

Hi,

is it possible to create a PO up-loading an Excel file (in the file I have material code, description, quantity, price, etc...).

Thanks

Fabio

[former_member182609 · Accepted solution]

It is possible .Try with BAPI_PO_CREATE or BDC .Check with ABAP team which one isbest option to develop the program.

[Former Member]

Hello Fabio,

You can create LSMW to record PO creation process and then upload rest of the POs using excel template. That is much faster and you do not need ABAPer for that.

With regards.

Sanjay

[Former Member]

Hello Sanjay,

Can you please provide a little more detail behind this process. It would be greatly appreciated.

Thanks so much!!

Cari

[pankaj_singh9]

Hi,

It is possible to upload PO data directly from excel. In my case, I am using PO BAPI to upload open POs and uploading data from excel file.

At the selection of screen, just call the function;

CALL FUNCTION 'WS_FILENAME_GET'        " To get the flat file to SAP
   EXPORTING
     def_filename           = '*'
     mask                   = '.xls'

Take help of ABAPer to do this.