IDOC to Mutiple tables JDBC Receiver

[Former Member]

Hi

There is one IDOC to Multiple tables JDBC Receiver Scenario,

Can anyone show me the structure of IDOC getting mapped with mutiple table JDBC receiver having key fields.

Requires one example on this with end to end scenario both for IR and ID.

Please dont provide existing blogs as I have gone through them.

Points will be awarded waiting for reponse.

[Former Member]

Hi Ram,

Take the strucuture like this:

<root>

<StatementName1>

<dbTableName action=u201DINSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</StatementName1>

<StatementName2>

<dbTableName action=u201DINSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</StatementName2>

</root>

With this you should be able to insert data into two tables simultaneously.

Regards,

---Satish

[VijayKonam]

Hi Pappu,

Everyone is ready to help here. But one might not be able to do it completely for you. help.sap.com is the right place to look at for JDBC receiver mapping.

VJ