JDBC to IDoc mapping

[former_member312864]

Hi,

I have a requirement for JDBC to IDOC scenario in which I need to map XMLdata coming as a field of stored procedure output . In sender side through stored procedure I am getting complete xml data in a single field and that needs to be mapped to target IDoc structure.

How to tackle above scenario in graphical mapping ?

Thanks

Sarojkanta Parida

[rodrigoalejandro_pertierr]

go for XSLT mapping.

here you have an example of an XSLT used for a similar case of you

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

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ns0="urn:company.com:smallworld:prefact">

          <xsl:template match="stmn_response">

                    <ns0:MT_ListaRuta>

                              <RESPUESTA>

                                        <RUTA>

                                                  <xsl:value-of select="SALIDARUTA" disable-output-escaping="yes"/>

                                                  <RutaId><xsl:value-of select="position()"/></RutaId>

                                        </RUTA>

                              </RESPUESTA>

                    </ns0:MT_ListaRuta>

          </xsl:template>

</xsl:stylesheet>

[ambrish_mishra]

Hi,

Can you share an example of XML string being retrieved through the stored procedure to see how it will be possible by graphical mapping.

You can use a Java or XSLT mapping to strip it off in the first mapping step and map to IDoc in a graphical mapping.

cheers

Ambrish

[Former Member]

Hello,

Using XSLT mapping convert xml string into XML and then do message mapping between converted XML and Idoc

http://scn.sap.com/message/7960778#7960778

Thanks

Amit Srivastava