Skip to Content
avatar image
Former Member

Create Sales order with multiple items with single text file

Hello all,

I have a question regarding LSMW and Batch input method. I have managed to create sales orders with multiple items with LSMW and batch input RVINVB10.

Thing is, I have managed by using 3 files (linked to the 3 structures of the Sales order): Header, Partners and Item files.

Here my header text file:

TYPE SONUM VKORG DISTRI DIV

TA test1 2200 10 00

TA test2 2200 10 00

My Partners text file:

SONUM TYPE SOLDTO SHIPTO

test1 AG T-L69A02 3895

test2 AG T-L69A02 3895

My Item text file:

SONUM ITEMNUM MATNR QTY

test1 00000010 M-06 001

test1 00000020 M-06 001

test2 00000010 M-06 001

I have assigned this in goods structures and it works fine (except the quantity but this is not the aim of my request of this request).

Now, I do not find anywhere how to do the same but only with one text file. I'm thinking about a text file like:

TYPE SONUM VKORG DISTRI DIV TYPE SOLDTO SHIPTO ITEMNUM MATNR QTY

TA test1 2200 10 00 AG T-L69A02 3895 00000010 M-06 001

TA test1 2200 10 00 AG T-L69A02 3895 00000020 M-10 004

This format may not be the good one, this is just an example of what I want to process.

I want to process only one text file in wich I will put all level of data (Header, partners and item).

If someone has an idea...?

Thank you !

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 16, 2016 at 06:43 PM

    Google -> lsmw single file site:sap.com -> 1890 results

    Not sure it's a good idea thought and might be more trouble than it's worth since LSMW is pretty much one-time activity.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 26, 2017 at 10:20 PM

    I agree with Jelena - LSMW is not the best use for an ongoing upload for sales orders

    Back in the day, I tackled your problem by using ABAP and the BAPI BAPI_SALESORDER_CREATEFROMDAT2 - if you Google that too, you will find more help.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 04, 2017 at 03:17 PM

    Hello ,

    It is possible with the Flat file Addin , see more information in this blog

    you can create template using excel and then upload the text file in SE38 program RVINVB10

    Regards

    Add comment
    10|10000 characters needed characters exceeded