Multiple table insert using receiver jdbc adapter

[Former Member]

Hi,

I am trying to insert data in to two tables in a single structure using receiver jdbc adapter. I am not using any stored procedure to insert data instead directly inserting the data using PI. Please see the structure I am using.

SOURCE side:

DT_ABC_SENDER

--IT_HEADER_TEXT

  -- EBELN

  -- LINENO

  --TDTEXT

--IT_ITEM_TEXT

  -- EBELN

  -- LINENO

  --TDLINE

TARGET side:

DT_ABC_RECEIVER

--InsertStatement

     --HEADER_TEXT

            -- action                         (insert)

            -- Table                          (Table 1)

            --access

                 -- IDS_ENQ_NO

                 -- IDS_DESC

                 -- IDS_TEXT

   --ITEM_TEXT

            -- action                         (insert)

            -- Table                          (Table 2)

            --access

                 -- IIS_ENQ_NO

                 -- IIS_DESC

                 -- IIS_TEXT

Using the above structure I am able to successfully insert the data in Table 1 but data is not getting inserted in Table 2.

In sxmb_moni it is saying message successfully delivered but I but there is data insertion took place in Table 2.

Please help me urgently.

Thanks in advance.

Neeeraj

[Former Member]

Hi Neeraj,

Add --InsertStatement statement for the second table structure in the same level of first InsertStatement.

Target structure like this:

DT_ABC_RECEIVER

--InsertStatement

     --HEADER_TEXT

            -- action                         (insert)

            -- Table                          (Table 1)

            --access

                 -- IDS_ENQ_NO

                 -- IDS_DESC

                 -- IDS_TEXT

--InsertStatement

   --ITEM_TEXT

            -- action                         (insert)

            -- Table                          (Table 2)

            --access

                 -- IIS_ENQ_NO

                 -- IIS_DESC

                 -- IIS_TEXT

[Former Member]

Thanks Krupa for the reply. I will add and test it today.

[former_member184720]

Hi Neeraj - I'm not sure if your target strcture is in valid format.

Have a look at the below blogs and define the stcrture accordingly.

http://scn.sap.com/thread/1861790

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/09/05/jdbc-receiver-best-practices-scen...

http://www.ijunglee.com/entries/sap-pi/idoc-to-jdbc-%E2%80%93-multiple-table-insert-update

[Former Member]

Hi hareesh,

Thanks for your reply. Urls you suggested are very helpful.

Structure I have created is in valid format and is same as one of the urls you suggested.

Thanks

[former_member184720]

Hi Neeraj - I don't think so... You need to have multiple statements as explained the blogs..