From IDOC to Two Taget Tables

[Former Member]

Hi Guys,

Is any one worked on from 1 Source Idoc to Two Target Tables of Sql tables need to Map. IF any one worked please send me DOc for that. That would be Helpful to me.

thanks in advance

Raj

[bhavesh_kantilal]

Raj,

This is possible using the JDBC adapter.

But what are you trying? Are you trying to insert data into the tables Update? .. The target data type depends on what you are actually trying..

You can also do this with multimapping... The best way forward can be known if you give exact details.

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

I am useing udpate_insert same time.. IF you have Doc can you please forward

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Other than these doc can you forward with multimapping DOc if you have..

thanks

Raj

[bhavesh_kantilal]

Raj,

Create 2 separate datatype for each UPDATE_INSERT and then do a multimappping.

Take a look at this blog for multimapping,

/people/jin.shin/blog/2006/02/07/multi-mapping-without-bpm--yes-it146s-possible

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

if you have any Doc of creation of Data Types of Multitables can you please send me.

Thanks for responding me quickly

Regd's

Raj

[bhavesh_kantilal]

Raj,

The Online help is the best documentation on the datatype creation,

<i><root>

<StatementName1>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

</root></i>

<b>UPDATE dbTableName SET col1=’val1’, col2=’val2new’ WHERE ((col2=’val2old’ AND col4=’val4’) OR (col2=’val2old2’))</b>

Just read the content under UPDATE_INSERT and create the format on the basis of your requirements.

Regards,

Bhavesh

[Former Member]

HI Bhavesh,

while i am Mapping from idoc to two tables or sql. i got when i genrated idoc i got a problem in message Mapping in sxmb_moni. Can you please foward if you have any doc of BPM of Multimapping thread..

Once again thanks for Helping me..

Regd's

Raj

[Former Member]

Hi ,

Check this thread..

Sekhar

[bhavesh_kantilal]

Raj,

Can you confirm this is what you did,

1. Create 2 datatypes for each strucutre.

2. Created 2 message types for datatyepes of step 1

3. Created 2 message Interfaces of message types of step2

4. Message Mapping between IDOC and these 2 message types. <b>Make sure you changed the occurence of the target message types to 0 to Unbounded.</b>

5. Interface Mapping Between the Idoc and the Message Interfaces using mapping of step 4. <b>Make sure you changed the occurenece of target Message Interfaces to 0 to Unbounded</b>

In the Configuration, Interface Determination, you selected the option RB_SPLIT or EXTENDED and selected the mapping .

Check the blog in my previous replies. It has the same etps i have listed. You must have missed them.

Regards,

Bhavesh