ABAP proxy to jdbc

[Former Member]

Hello

i have a scenario where abap proxy has a header and multiple line items.

header record needs to go to a separate table and multiple line items have to go to a separate table. how can this be achieved ?

so basically source structure is one but with header and detail items but header record has to go to a separate database table and detail record to a separate table.

Please advise.

thanks

[former_member181985 · Accepted solution]

You can create structure like this

<MT>
 <STMT1>
 <dbTableName action=u201DINSERTu201D>
 <table>HeaderTable</table>
 <access>
 <col1>val1</col1>
 <col2>val2</col2>
 </access>
</dbTableName>  
</STMT1>
 <STMT2>
 <dbTableName action=u201DINSERTu201D>
 <table>LINETable</table>
 <access>
 <col1>val1</col1>
 <col2>val2</col2>
 </access>
</dbTableName>  
</STMT2>
</MT>

Check help@[Document Formats for the Receiver JDBC Adapter|http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm]

Edited by: Praveen Gujjeti on Sep 2, 2010 5:52 PM

[Former Member · Accepted solution]

so basically access node will be mapped to repeating node from line item level..

2) if there can be updates to already inserted records : action would be update_insert

[Shabarish_Nair · Accepted solution]

yes. By creating multiple statement nodes, it acts as individual SQL queries

[former_member181985 · Accepted solution]

>so basically access node will be mapped to repeating node from line item level..

Even for STMT2 for each line item.

[Former Member]

Best option is to use Stored Procedure. Since it is the same DB, one receiver channel should be sufficient.

[Former Member]

we want to avoid stored procedure route as there are not many dbas. can we not achieve this without stored procedures?

Thanks

[Former Member]

try multimapping.

Edited by: pi_question on Sep 2, 2010 1:31 PM