With ever changing world of integration one language that has stood the test of time is XML. Due to capabilities of XML and large number of system integration requirments, its impertinent for technical consultants to understand the XML transformation capabilities in SAP. SAP transformations are used to filter and recognize XML data.
SAP transformations can be used for,
Deserialization: Process of transforming XML documents to other XML, HTML, Text or ABAP data structures.
Serialization: Conversion of ABAP data structures to XML, HTML or text files.
There are several methods to create XML transformations in SAP.
Just like any other ABAP program, transformations are also repository objects which could be accessed via SE80. SAP has now provided a graphical tool to create transformations. Graphical transformation program creation wizard could be accessed through transaction XSLT_TOOL.
In this serialization example and we are creating a XML file in the application server with sales order information. XML file holds multiple sales order information with sales order number, sales order type and customer information.
Output file format:
You require access to these transaction codes to generate this XML transformation.
SE11 – ABAP Dictionary
SE38 – ABAP Editor
XSLT_TOOL – Transformation Editor
Step by Step Guide on XML Serialization Using XSLT_TOOL.
1. Create table type.
Depending on the XML file format, matching ABAP table type should be created.
Go to transaction SE11.
Create underline data type (structure) which match XML “customer” segment.
Create data type which correspond to “Order” segment in XML.
Create table type.
2. Create transformation in XSLT_TOOL.
Go to transformation XSLT_TOOL.
Provide name and click create. Set description and transformation type.
Hi, I am Isuru Fernando, Senior SAP Integration Consultant with 10 years of SAP full-cycle implementation and support project experience.From the early days, I had a passion for coding, software development, and everything tech-related. I started my carrier as an ABAP developer and soon found my love for system integration when I learned SAP XI 3.0 in 2008. Playing a variety of roles from an offshore technical consultant (ABAP, PI/PO, BW, BOBJ) at the beginning of my career to a technical lead managing a team of consultants in different countries, I have gained immense experience in SAP project implementation life cycle.Having the opportunity to work on SAP implementation projects in USA, EU, and Asia, I learned valuable ins and outs of global business processors in Sales and Distribution (SD), Material Management, Retail, Customer Relationship Management (CRM), and Finance and Controlling (FICO).Through this blog, I want to share my expertise in SAP technical areas such as SAP ABAP, PI/PO, AIF, and Basis. I also want to provide a platform for others with similar ambitions who would like to share their SAP technical expertise with the world!