Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

LSMW without an input spreadsheet?

Former Member
0 Likes
731

Hi,

I have to do a mass transfer of stocks between two storage locations. I decided to use LSMW with the BAPI for BUS2017 (method CREATEFROMDATA, “Post goods movement”). The input data is contained in SAP tables and I have an ABAP program to extract it.

My question is - do I need to extract the data first in to a spreadsheet or can I skip that step and have LSMW run the ABAP program directly?

3 REPLIES 3
Read only

christian_wohlfahrt
Active Contributor
0 Likes
605

Hi Slath,

you can even skip the whole part of LSMW.

You had already a look into it and have seen how to fill the BAPI structure.

Now add the BAPI into your extract report - ready.

Regards,

Christian

Read only

0 Likes
605

Yes that’s true – in the same way, if you migrating data by batch input, you don’t have to use the standard tools but instead simply code CALL TRANSACTION directly in an ABAP program. But I thought LSMW enables use to easily reprocess individual records without having to change a program and retransport, etc.

Read only

0 Likes
605

Hi Slath,

it is possible to make some programming at events in LSMW - but this would be a lot of work (and I don't know, if the whole program starts without any input file).

I would advise to use at leas one file - it is not necessarily a tabulator separated text file ('spreadsheet'). You can also enter one step later into LSMW and build a file in internal logic. This would correspond to the third(?) file in file location definitions.

Nevertheless, some manual steps are needed. One more or less might not be so important - and you can create an input file on application server with OPEN DATASET / TRANSFER quite easily.

For a permanent interface, BAPI in report still looks better.

Regards,

Christian