SAP BODS IDOC Mapping for Header and Line item data

[former_member210724]

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

[mageshwaran_subramanian]

Refer to this discussion

[former_member210724]

Hi Magesh,

Thank you very much for the replay.

Here I am not looking for the tables at SAP side for line item and header.

I have gone through most of the knowledge articles on SDN .

here my exact requirement is at BODS side while mapping the Table structure to IDOC structure I got facing challenges

1.I have executed this process by making Header and line item as two separate table and taking this two in separate query transform and an extra key generation transform to map the IDOC structure. here I am getting NRDM issue even though the sub structures were un nested.

   a. Taken care in identifying From clause for each query input to IDOC structure.

       -->for control node took Query as From clause.

      --->for Header and item nodes Row generation as From and tried in reverse also in the reverse case system taking lot of system resources and getting struck entire server going down due to occupied resources.

   b. In the line item table where clause I have used doc.no in line item table = doc.no in header table.

2.I took header and line item in single line it used query transform to segregate header and item node at query transform by adding sub query like header and in the sub query item level info using row generation transform and in the next query transform I used one more row generation to map to IDOC, in this scenario also getting NRDM issue.

I prefer if I get the mapping in BODS from table to IDOC structure.

Below is the IDOC structure I am using:

+EDI_DC40

+YHEADER

+YITEM

under header and item node we have sub structures like date, amount etc. .

I could able to generate IDOCs one per each line item, but my requirement is to generate one IDOC per one header and all line items under the same document.

Thanks

Anand

[Former Member]

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.