Skip to Content

idoc to jdbc-Multiple Segments into database

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 16, 2017 at 12:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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