IMPORTING FROM EXCEL SHEET

[Former Member]

HI SAPIANS,

Can any one give light in the matter of po creation .

we had paid in advance for fuel filling to our vehicles.the price is varing after advance paid .now after 90 days our advance amount is nullified. the fuel consumed for different departments(cost centers).there are around 500 entries by each day consumption and different departments at different rates.we prepared excel sheet for this .is there any option to upload the excel sheet without entering all details to made po.

thanks regards

srinivas kona

[Former Member · Accepted solution]

HAI

Do your aware about LSMW?

If so you can feed the data into SAP from EXCEL sheet by recording method.

Regards

Aribalakrishnan

[kunal_ingale]

hi u can use func module FM BAPI_CREATE_PO1

or u can use LSMW or CATT

regards

kunal

[krishnendu_laha]

Hi Friend,

There is no standard SAP way.

You can do with custom programs: Through ABAP, you can create a program where excel file will be uploaded and create a PO in background. You can use FM BAPI_CREATE_PO1.

Note: Header information should be avialable in that file othherwise you can take input through parameter of customer report.

Hope it will help to solve the problem.

Regards

Krishnendu