Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

split messages into different DataBase

Hi Experts,

I have the next scenario Proxy to JDBC, I´m using PO 7.4 (only javastack), the proxy send a record with multiple values like this:

<Record>

   <ANIO>2015</ANIO>

   <MES>006</MES>

   <IDLIQ>01</IDLIQ>

   <CONSE>71053952</CONSE>

   <DEPTO>015</DEPTO>

   <MATNR>2177463</MATNR>

   <WERKS>S107</WERKS>

   <EAN11>2500000014390</EAN11>

   <MAKTX>NA051415063 BOLSA GRANDE CON 2 BOLSAS AL</MAKTX>

   <INVPV>199.90</INVPV>

   <KBETR>0.40</KBETR>

   <FEINI>20150630</FEINI>

   <FEFIN>20150730</FEFIN>

   <LABST>16.000</LABST>

   <KSCHL/>

  </Record>

  <Record>

   <ANIO>2015</ANIO>

   <MES>006</MES>

   <IDLIQ>01</IDLIQ>

   <CONSE>71053955</CONSE>

   <DEPTO>015</DEPTO>

   <MATNR>2177469</MATNR>

   <WERKS>S107</WERKS>

   <EAN11>2500000014451</EAN11>

   <MAKTX>NA051415069 BOLSA JAQUARD CON FRANJA EN</MAKTX>

   <INVPV>249.90</INVPV>

   <KBETR>0.40</KBETR>

   <FEINI>20150630</FEINI>

   <FEFIN>20150730</FEFIN>

   <LABST>0.000</LABST>

   <KSCHL/>

  </Record>

  <Record>

   <ANIO>2015</ANIO>

   <MES>006</MES>

   <IDLIQ>01</IDLIQ>

   <CONSE>71053954</CONSE>

   <DEPTO>015</DEPTO>

   <MATNR>2177477</MATNR>

   <WERKS>S107</WERKS>

   <EAN11>2500000014512</EAN11>

   <MAKTX>NA051415075 BOLSA JAQUARD CON FRANJA EN</MAKTX>

   <INVPV>249.90</INVPV>

   <KBETR>0.40</KBETR>

   <FEINI>20150630</FEINI>

   <FEFIN>20150730</FEFIN>

   <LABST>0.000</LABST>

   <KSCHL/>

  </Record>

  <Record>

   <ANIO>2015</ANIO>

   <MES>006</MES>

   <IDLIQ>01</IDLIQ>

   <CONSE>71053956</CONSE>

   <DEPTO>015</DEPTO>

   <MATNR>2177463</MATNR>

   <WERKS>S108</WERKS>

   <EAN11>2500000014390</EAN11>

   <MAKTX>NA051415063 BOLSA GRANDE CON 2 BOLSAS AL</MAKTX>

   <INVPV>199.90</INVPV>

   <KBETR>0.40</KBETR>

   <FEINI>20150630</FEINI>

   <FEFIN>20150730</FEFIN>

   <LABST>0.000</LABST>

   <KSCHL/>

  </Record>

  <Record>

   <ANIO>2015</ANIO>

   <MES>006</MES>

   <IDLIQ>01</IDLIQ>

   <CONSE>71053958</CONSE>

   <DEPTO>015</DEPTO>

   <MATNR>2177469</MATNR>

   <WERKS>S108</WERKS>

   <EAN11>2500000014451</EAN11>

   <MAKTX>NA051415069 BOLSA JAQUARD CON FRANJA EN</MAKTX>

   <INVPV>249.90</INVPV>

   <KBETR>0.40</KBETR>

   <FEINI>20150630</FEINI>

   <FEFIN>20150730</FEFIN>

   <LABST>0.000</LABST>

   <KSCHL/>

  </Record>

so I need to split each record into their corresponding database for example if WERKS = S107 it has to go through database "107" but only the records with this parameter, and if WERKS = S108 it has to go through database "108" but only the records with this parameter and so on..

today it goes all the records to all the tables

This is my integrated configuration

Thank you for your help.

Regards.

replied

adding the xpath condition under receiver determination help us only to certain extent i.e. when the proxy message contains the records specific to WERKS.

When you receive the mixed records within one message then you also need to apply simillar filter in your mappings.

In your message mapping, for the access tag you should apply the below logic.

werks -> equalS -> s107 -> create if -> access

similarly for second mapping

werks -> equalS -> s108 -> create if -> access


Please note that this is in addition to the xpath condition in receiver determination

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question