Code snippet to show the usage of the ABAP Call Transformation to transform the data easily into the excel format by XML and download it.
This is one of my published blogs on the SAP Community Network. This blog show a way to generate the formatted excel files using the XML. From release 620, ABAP has provided us a way to transform our data using the XML transformation. We can very use the XML to generate the formatted Excel File….
When we download the data from the SAP using FMs like GUI_DOWNLOAD or WA_DOWNLOAD (absolute); or the method of class CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD and open that file in the Microsoft Excel, we loose some important information like leading zero, long numbers will come as exponents. Most of the times we don’t want this because we will use…