Conversion - Doc with multiple line items - LSMW

[former_member1330001]

Hi Friends,

I have got a flat file that holds all the open sales orders from a legacy system. I need to upload these data into R/3. If i use LSMW it creates a separate sales order for each line item of a single sales order. That is i am unable to get all the line items for a sales order.How to go about it?.

Quick replies would be rewarded.

Regards,

Tamilarasan.

[former_member214131 · Accepted solution]

Hello,

First of all, I assume that you have NOT created a recording. Either DI/BI, BAPI or IDoc method is applied.

You need <b>two files</b> in this case.

The First one will have Header Details. The second one will have Item details.

You need Key fields linking both the files.

The files are then mapped to corresponding structures.

Please read thro' the LSMW online documentation which explains in detail.

If you are creating a document by recording, you may have to adopt slightly different approach. The creation of the document with first line item in first step. this is done in CREATE mode. In the second step you add the line items in CHANGE mode.

Hope this helps you.

Best Regards

• Christian, there are 2 files to be supplied to LSMW in the above solution. But I tried to explain that data in both the files have to be linked with a common key field ( usually document number ).Hope I have not confused you.

First File: (HEAD)

1000014 20050706

1000015 20050707

Second File: (LINE)

1000014 00010 5334667 15 ST 23,15 EUR

1000014 00020 5334669 20 ST 15,89 EUR

1000015 00010 5334661 30 ST 50,15 EUR

1000015 00030 5334669 20 ST 15,89 EUR

Message was edited by: Murugesh Arcot