Mapping issue

[Former Member]

Hi All,

In my message mapping i map the RFC response structure(Source Structure) map to JDBC insert structures(target) in target JDBC structure i took two Statement insert tags. Because i need to insert two tables.

My RFC response structure
*********************************
_-PG-_1E_SCMDB.response     1..1
    DOC_DATA                            0..1
      item                                       0..Unbounded
        VBELN                                0..1
        ITEMS                                  0..1
           item                                  0..Unbounded     
             POSNR                           0..1
             DOCFLOW                      0..1
                item                              0..Unbounded
                  POSNN                       0..1
             CONDITION                      0..1
                 item                              0..unbounded
                   KAWRT                     0..1
             PURCH_ITEM                   0..1
                 item                              0...Unbounded
                    IDNLF                         0..1
                       item                         0...unbounded
                           EINDT                  0..1

Continution....

Thank you very much

Sateesh

Edited by: sateesh kumar .N on May 26, 2010 8:05 AM

[madhusudana_reddy2]

Hi,

As you are going to insert single RFC Response to 2 tables, develop single structure which contains 2 statements as given below

Statement1

Table1

action

table

access

field1

field2

Statement2

Table2

action

table

access

field1

fieldn

Note: follow your second mapping approach.

thanks,

madhu

[Former Member]

Hi Madhu,

Thank you for your reply

I created same way, What you suggested me.But my problem is in RFC Response structure there is nearly 5 to 6 'Item' tags specified. every Item tag occurence is 0 to Unbounded

When Real data shows in RFC, All "item tags are repeated.

In First "Item" it maps first Statement1 tag fields in Target side.

and from Second item tags fields onwards it map to Statment2 tag fields.

while repeating the "item" tags in all areas of the structure, I am not getting proper result in Target side in Message mapping.

So please suggest which mapping is better for this critical structure

Thank you

[former_member200962]

In First "Item" it maps first Statement1 tag fields in Target side.

and from Second item tags fields onwards it map to Statment2 tag fields.

Item fields for one table should be mapped to the Access nodes of the same Statement....if you have two different tables then you can have two Statement Nodes and then multiple Access nodes within them....hope I did not miss anything here.

[madhusudana_reddy2]

Statement tag at target will be 1..1 so you no need to map any thing. You map your source tag item which is 0 to unbounded to Access at target side.

thanks,

madhu

[Former Member]

Hi Abshiek & Madhu,

I done that way only, You will please see the my target message structure in second reply of this thread.

My problem is:

for example XML SOURCE data for example:
******************************************
<_-PG-_1E_SCMDB.response>
 <DOC_DATA>
    <item>
       <VBELN>001</VBELN>
       <ITEMS>
           <item>
                <POSNR>AAA</POSNR>
           </item>
           <item>
                <POSNR>BBB</POSNR>
           </item>
           <DOCFLOW>
               <item>
                 <POSNN>IN</POSNN>
               </item>
           </DOCFLOW>
           <CONDITION>
              <item>
                  <KAWRT>OPEN</KAWRT>
              </item>
           </CONDITION>
           <PURCH_ITEM>
              <item>
                  <IDNLF>
                       <item> 
                            <EINDT>12/10/2009</EINDT>
                       </item>
                        <item> 
                            <EINDT>20/01/2010</EINDT>
                        </item>
                  </IDNLF>
              </item>
           </PURCH_ITEM>
         </ITEMS>
     </DOC_DATA>
   </_-PG-_1E_SCMDB.response>

[Former Member]

My problem is solved by XSLT mapping

[Former Member]

Continution...

Target JDBC structure
***********************************
RESPONSE_MT                         1..1
  StatementName1                     1..1
    dbTableName                         1..1
       action                                 optional ( attribute)---INSERT
       table                                    1..1                       --- XI_SAP_HEDEARDATA
       access                                0.. unbounded
          VBELN                              0..1
          BSTNK                              0..1
  StatementName2                      1..1
    dbTableName                          1..1
       action                                   optional (attribute)--INSERT
       table                                     1..1                       -- XI_SAP_ITEMDATA
       access                                 0..unbounded
          VBELN                               0..1
          POSNR                               0..1
          POSNN                               0..1
          KAWRT                               0..1
          EINDT                                   0..1

can you please suggest me which mapping is better?

Thank you ,Sateesh

Edited by: sateesh kumar .N on May 26, 2010 8:07 AM