Skip to Content
0

Create Sales order with multiple items with single text file

Dec 16, 2016 at 10:21 AM

160

avatar image
Former Member

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 !

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jelena Perfiljeva
Dec 16, 2016 at 06:43 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Jan 26, 2017 at 10:20 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Ziv Markovich Feb 04, 2017 at 03:17 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded