How to create XSLT Mapping in SAP PI / PO

This blog will complement other blogs on ‘XSLT Mapping’ in SCN.

Direct link: How to create XSLT Mapping in SAP PI / PO – YouTube

     I recommend, practicing how to use XSL elements like xsl:template, xsl:if, xsl:choose, xsl:for-each, xsl:output, xsl:sort and xsl:namespace-alias in SAP NWDS or Eclipse or NetBeans. Please search internet for more examples.

Sample XSLT used in the video.

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output encoding="cp1252" />
  <xsl:template match="/">
  <xsl:copy-of select="." />
  </xsl:template>
</xsl:stylesheet>

Sample XML used in the video.

<?xml version="1.0" encoding="utf-8"?>
<hr>
   <Resources>
      <EmployeesRecords>
         <Record>
            <Name>AAA € </Name>
            <ID>111</ID>
            <Phone>1111111111</Phone>
         </Record>
         <Record>
            <Name>BBB</Name>
            <ID>222</ID>
            <Phone>2222222222</Phone>
         </Record>
      </EmployeesRecords>
      <ContractorsRecords>
         <Record>
            <Name>ZZZ</Name>
            <ID>999</ID>
            <Phone>9999999999</Phone>
         </Record>
      </ContractorsRecords>
   </Resources>
</hr>

Helpful Links: –

XML Path Language (XPath)

XSL Transformations (XSLT)

XSLT Mapping – SAP Library

Parameterized XSLT Mappings – SAP Library

Using the Lookup API in an XSLT Program – SAP Library

How to.. Import and use XSLT 2.0 mappings in SAP PI/PO

XSLT Mapping in Exchange Infrastructure (download the mwv file).