Skip to Content
0

idoc to jdbc-Multiple Segments into database

Aug 16, 2017 at 12:42 PM

39

avatar image

Hi Experts,

My scenario is IDOC to JDBC

In my standard LOIWCS-work-center idoc there are multiple segments from ECC end coming into PO system

i need to insert these segments into single table as multiple rows

each segment -each row

How can achieve this in Message mapping

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Manoj K Aug 16, 2017 at 12:49 PM
0

Hi Guru,

In this case you need to repeat the node "access" in your jdbc structure multiple times hence map this node to your source segment which is repeating multiple times .

Br,

Manoj

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Manoj,

Do i have to map Idoc segment to Statement? OR IDoc segment to Access

which of the above works?

There are More than 50-60 segments

Thanks,

Guru

0

Hi Guru,

Don't repeat the Statement repeat the access node , map this to the node whichever is repeating multiple times.

Techinacaly speaking both case will work i.e either you repeat statement or access node but repeating statement node will create multiple insert statements but where as repeating access node will create one insert statement with multiple records. so go for repeating the access node.

Br,

Manoj

0