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