Skip to Content
avatar image
Former Member

IDOC to Mutiple tables JDBC Receiver

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 02, 2008 at 08:57 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 11:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded