Turn Csv File Into Xml Editor' title='Turn Csv File Into Xml Editor' />Power of the Core Using XSD for XML Transformation in ABAP Passionate about SAPIve already written a few posts on how to use the graphical editor to create Simple Transformations but I guess thats not good enough for lazy developers like me. So now we are going to try a different approach assuming we already have the XSD file that describes the structure of the required XML. Lets say you have an XSD file for which you want to generatetransform XML lt ABAP. Of course you dont want to create the corresponding ABAP Structures or Simple Transformations manually neither you are interested in hearing about capability of another SAP Product in this field e. Turn Csv File Into Xml Editor' title='Turn Csv File Into Xml Editor' />SAP PICE etc. That said. Now SAP already has this web service Wizard in ECC6. WSDL XSD files to create ABAP structures, generate related simple transformation code and a Proxy classmethod for the purpose of SOAP Payload. So in a sense, a framework already exists which solves a problem that is almost a superset of what we are trying to achieve. In short, well create a dummy WSDL that will just help in importing the XSD file through this SAP web service wizard. Though we are not interested in SOAP Web service here but well use it to cheat the wizard. And so the experiment begins Ignore details below for this step and move on to next step to upload the wsdl and xsd. You can copy the template WSDL code in notepad and save it as dummy. PC where you have your XSD file. So Now we have our WSDL and XSD files ready to be uploaded in SAP. Step 2 Upload the WSDL and XSD files through SAP Web Service Wizard. This is pretty much standard in Transaction SE8. Enter Package Name or TMP Start the Web Service Wizard. The wizard will take you through the steps to upload the WSDL file which in turn will automatically find the XSD file in the same directory and upload that as well. Ive used TMP but you should use a suitable package if you want to transport it later. So once uploaded, youll have the proxy class and related ABAP structures as well as underlying simple transformations generated for you. Dont forget to activate the proxystructures. Actually you dont really needs proxies for our purpose but just the structures. It wont do any harm to keep the proxy as well. Step 3 Write your ABAP program to generate XML Note that you need the message type structure name e. ZTESTRAMACCESSREQUESTMESSAGE that was generated in last step to use it in your own program. Also Ive used an optional step to remove the namespace information from the generated XML. For that youll need to create an XSLT in XSLTTOOL. Ive got this XSLT from here http wiki. Remove Namespaces. XSLT Code ZRAMREMOVENAMESPACEEXSLT to remove the namespace from final xml is as below and its called from the ABAP program. XSLTransform. Finally the ABAP Program is as below. REPORT zramtestxsdxml. By www. rmtiwari. DATA lvdatatype TYPE prxr. DATA lvxml TYPE xstring. TYPE ZTESTRAMACCESSREQUESTMESSAGE. Which root data type MindFusions XML Viewer is a free software that lets you open and read XML files. It provides an intuitive environment to let you conveniently analyze the file. Fit File Repair Tool enables a new installation, requires MS Access 2010 or MS Access 2010 runtime Installation Please download and open this zip file. You want to run a query or two against an Oracle database. You want to get the data back into a userfriendly and consumable format, such as a comma separated values. Turn Csv File Into Xml Editor' title='Turn Csv File Into Xml Editor' />ZTESTRAMACCESSREQUESTMESSAGE. Populate abap Data structure. This will generate the Simple Transformation from information. XML with namespace In case you need to strip the namespace information from tags. ZRAMREMOVENAMESPACEEXSLT. XSLTTOOL use the statement below. CALL TRANSFORMATION zramremovenamespaceexslt. SOURCE XML lvxml. RESULT XML lvxml. Just to show the xml. X. CATCH cxtransformationerror. CATCH cxroot. EC CATCHALL. And now if you run your program, then may be youll have your XML like I did Not to mention that Ive not verified this approach or tested it thoroughly yet. However, conceptually, I dont see much problem with it. So if you have a really big XMLXSD to operate on then this could be really useful. Further, looks like we can also upload multiple XSD files in one upload by changing the wsdl to RPC style with multiple imports parts. Warning Please dont use above approach for any productive program without proper testing. Also, just wanted to mention that Bloggers comment section does not accept XMLHTML code hence you may need to escape any code before posting it in comments. Hint search for escape html tool online in Google. XPath Editor Create, Test, Evaluate XPath Expression. Practice Driving Test Ontario G2 here. Online XPath Editor Create, Test, Evaluate or Query XPath Expression Against XML. How to execute an XPath expression against the XML data Step 1 load XML data. You can copy and paste your XML data to the XML Data box, then click Load button. After you have done so, the Source Data box will turn into a graphical XML viewer and your XML data will be displayed as a node tree. Step 2 enter your XPath expression in the XPath box and Click the Execute XPath button. The result XML data will be displayed in the Output box. You can repeat Step 2 many times by entering different XPath expressions of your XML document. Demo http xmlgrid. Demo Demo. http xmlgrid. XML Editor XML Editor. Xml. To. Text http xmlgrid. Convert XML document to plain text file XML To Text. Xsd. 2Xml http xmlgrid. Puffin Browser For Windows Vista Free Download. Xml. html Generate XML document from a schema xsd file XSD To XML. XPath. Tester http xmlgrid. XPath expression XPath. Forum http xmlgrid. Thread. List2. 6cid9. Xml. Grid Users Forum Forum. FAQ http xmlgrid. FAQ FAQ. XMLViewer http view. A read only version of XML editor XML Viewer. To. Xml http xmlgrid. To. Xml. html Convert comma separated value text file to XML document CSV To XML. Xml. To. Xsd http xmlgrid. XSD from XML XML To XSD. Excel. To. XML http xmlgrid. Excel file to XML Excel To XML. About http xmlgrid.