Skip to Content
avatar image
Former Member

RFC to JDBC Scenario: Multiple Records insertion

Hi All,

I am working with RFC->XI->JDBC to update a single table on an Oracle db.

When I import RFC I get multiple Records.

Here is the sender XML Structure:

<?xml version="1.0" encoding="UTF-8" ?>

- <rfc:Z_I2_SAP2MDM_VM xmlns:rfc="urn:sap-com:document:sap:rfc:functions">

+ <I_LFA1>

</I_LFA1>

<T_XLFAT />

- <T_XWYT3>

- <item>

<MANDT>800</MANDT>

<LIFNR>0000009962</LIFNR>

<EKORG>1000</EKORG>

<LTSNR />

<WERKS />

<PARVW>LF</PARVW>

<PARZA>000</PARZA>

<ERNAM>ARUCHI</ERNAM>

<ERDAT>2006-05-26</ERDAT>

<LIFN2>0000009962</LIFN2>

<DEFPA />

<PERNR>00000000</PERNR>

<PARNR>0000000000</PARNR>

<KZ>I</KZ>

</item>

- <item>

<MANDT>800</MANDT>

<LIFNR>0000009962</LIFNR>

<EKORG>1000</EKORG>

<LTSNR />

<WERKS />

<PARVW>RS</PARVW>

<PARZA>001</PARZA>

<ERNAM>ARUCHI</ERNAM>

<ERDAT>2006-05-26</ERDAT>

<LIFN2>0000009962</LIFN2>

<DEFPA />

<PERNR>00000000</PERNR>

<PARNR>0000000000</PARNR>

<KZ>I</KZ>

</item>

</T_XWYT3>

</rfc:Z_I2_SAP2MDM_VM>

It takes only the first <item> record. How do i take the second record and insert in the oracel DB.

Seems to me this should be a pretty simple process.

Regards,

Ruchi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 26, 2006 at 01:12 PM

    Hi ,

    You need to handle this with the occurence of the Target Structure of the JDBC Adapter..

    Check this help-

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

    DB Datatype structure ?

    Hope this helps,

    Regards,

    Moorthy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 26, 2006 at 01:40 PM

    Hi Moorthy,

    I changed the Statement occurrence to 1 to UB, still its not working.

    Is it bcoz,out of so many tables on the sender side , only one of the structure has got multiple records.

    Regards,

    Ruchi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I tried changing the Access as multiline..still not working..

      I am not being able to change the context of the item on the sender side, its the structure name <WYT3> right now...

      Regards,

      Ruchi