Skip to Content

SAP BODS IDOC Mapping for Header and Line item data

Hi All,

Could you please throw some light on my scenario:

Scenario:

I am working on DI project, here we load SQL source data into SQP ECC using IDOC interface.

I have worked on above scenario for multiple flows where we have generated one incoming record one IDOC.

In the current scenario:

SQL table contain records per line item including header information in the same record.

Now we have to split header and item data and map to IDOC structure to generate one IDOC per one document each document may contain any no of line items.

Ex:

Doc.No Item PostingDate Document Date PC CC Amount Currency Product

110 1 01.02.2016 01.02.2016 pc1 cc1 200 usd M01

110 2 01.02.2016 02.02.2016 pc1 cc1 250 usd M01

201 1 05.02.2016 05.02.2016 pc2 cc2 300 EUR M02

201 2 05.02.2016 06.02.2015 pc2 cc2 400 EUR M02

for the above 4 line item of two document I need to create two IDOCs one for 110 and other 201 each idoc with two line items.

I have gone through the forum links and the documents sending IDOC from BODS to ECC which I did not find helpful for this scenario.

Your valuable inputs are appreciable.

Thanks

Anand

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 19, 2016 at 07:57 PM

    Refer to this discussion

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Anand Tiragati

      Hello Experts,


      I am also new comer and interested in this scenario - can any one help how can we convert the txt file in to IDOC on the above example???

      Coping from above post :-

      Ex:

      Doc.No Item PostingDate Document Date PC CC Amount Currency Product

      110 1 01.02.2016 01.02.2016 pc1 cc1 200 usd M01

      110 2 01.02.2016 02.02.2016 pc1 cc1 250 usd M01

      201 1 05.02.2016 05.02.2016 pc2 cc2 300 EUR M02

      201 2 05.02.2016 06.02.2015 pc2 cc2 400 EUR M02

      for the above 4 line item of two document I need to create two IDOCs one for 110 and other 201 each idoc with two line items.

      Thanks

      Rajeev.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.