topic Re: Regd: Report in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/regd-report/m-p/1222765#M136980 <HTML><HEAD></HEAD><BODY><P>HI ganesh,</P><P></P><P></P><P>1. i don't think we can save the report in xml format.</P><P></P><P>2. However can save the data </P><P> of internal table, into xml format.</P><P></P><P>3. Moreover,</P><P> since your program has to run in bakcgorund,</P><P> u have to save on application server (and not front-end pc)</P><P></P><P></P><P>4. just coyh paste this program</P><P> (it will give u idea about</P><P> itab----</P><HR originaltext="---" /><P>&gt;</P><P> and xml -</P><HR originaltext="-----" /><P>&gt; itab.</P><P></P><P>5.</P><P></P><P></P><P>REPORT abc.</P><P></P><P></P><P>*----</P><HR originaltext="---------" /><P> DATA</P><P>DATA : t001 LIKE TABLE OF t001 WITH HEADER LINE.</P><P>DATA : BEGIN OF itab OCCURS 0,</P><P>a(100) TYPE c,</P><P>END OF itab.</P><P></P><P>DATA: xml_out TYPE string .</P><P></P><P>DATA : BEGIN OF upl OCCURS 0,</P><P>f(255) TYPE c,</P><P>END OF upl.</P><P>DATA: xmlupl TYPE string .</P><P></P><P></P><P></P><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="31" type="ul"><P>FIRST PHASE</P></LI><LI level="31" type="ul"><P>FIRST PHASE</P></LI><LI level="31" type="ul"><P>FIRST PHASE</P></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><P></P><P>*----</P><HR originaltext="-------------" /><P> Fetch Data</P><P></P><P>SELECT * FROM t001 INTO TABLE t001.</P><P></P><P>*----</P><HR originaltext="--------------" /><P> XML</P><P>CALL TRANSFORMATION ('ID')</P><P>SOURCE tab = t001[]</P><P>RESULT XML xml_out.</P><P></P><P>*----</P><HR originaltext="--------" /><P> Convert to TABLE</P><P></P><P>CALL FUNCTION 'HR_EFI_CONVERT_STRING_TO_TABLE'</P><P>EXPORTING</P><P>i_string = xml_out</P><P>i_tabline_length = 100</P><P>TABLES</P><P>et_table = itab.</P><P></P><P></P><P>*----</P><HR originaltext="---------" /><P> Download</P><P></P><P>CALL FUNCTION 'GUI_DOWNLOAD'</P><P>EXPORTING</P><P>filetype = 'BIN'</P><P>filename = 'd:\xx.xml'</P><P>TABLES</P><P>data_tab = itab.</P><P></P><P></P><P></P><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="31" type="ul"><P>SECOND PHASE</P></LI><LI level="31" type="ul"><P>SECOND PHASE</P></LI><LI level="31" type="ul"><P>SECOND PHASE</P></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><P></P><P></P><P>BREAK-POINT.</P><P>REFRESH t001.</P><P>CLEAR t001.</P><P></P><P>CALL FUNCTION 'GUI_UPLOAD'</P><P>EXPORTING</P><P>filename = 'D:\XX.XML'</P><P>filetype = 'BIN'</P><P>TABLES</P><P>data_tab = upl.</P><P></P><P>LOOP AT upl.</P><P>CONCATENATE xmlupl upl-f INTO xmlupl.</P><P>ENDLOOP.</P><P></P><P>*----</P><HR originaltext="--------------" /><P> XML</P><P>CALL TRANSFORMATION ('ID')</P><P>SOURCE XML xmlupl</P><P>RESULT tab = t001[]</P><P>.</P><P>BREAK-POINT.</P><P></P><P></P><P>regards,</P><P>amit m.</P><P></P><P></P><P></P><P></P><P>regards,</P><P>amit m.</P></BODY></HTML> Thu, 30 Mar 2006 10:23:14 GMT Former Member 2006-03-30T10:23:14Z Regd: Report https://community.sap.com/t5/application-development-and-automation-discussions/regd-report/m-p/1222764#M136979 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Is it Psble to Run &amp; Save a Customized Report in a XML format Output.</P><P></P><P>It has to Scheduled in Background and it has to be run twice a day. the scenario is that the report should run and get saved in a folder in XML format.</P><P></P><P>If Psble is there any Function Modules avaliable for it, or any other Method avilable for it.</P><P></P><P>Help and Suggestions will be much apprieciated.</P><P></P><P>Thanks &amp; Regds.</P><P></P><P>Ganesh.</P></BODY></HTML> Thu, 30 Mar 2006 10:17:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/regd-report/m-p/1222764#M136979 Former Member 2006-03-30T10:17:14Z Re: Regd: Report https://community.sap.com/t5/application-development-and-automation-discussions/regd-report/m-p/1222765#M136980 <HTML><HEAD></HEAD><BODY><P>HI ganesh,</P><P></P><P></P><P>1. i don't think we can save the report in xml format.</P><P></P><P>2. However can save the data </P><P> of internal table, into xml format.</P><P></P><P>3. Moreover,</P><P> since your program has to run in bakcgorund,</P><P> u have to save on application server (and not front-end pc)</P><P></P><P></P><P>4. just coyh paste this program</P><P> (it will give u idea about</P><P> itab----</P><HR originaltext="---" /><P>&gt;</P><P> and xml -</P><HR originaltext="-----" /><P>&gt; itab.</P><P></P><P>5.</P><P></P><P></P><P>REPORT abc.</P><P></P><P></P><P>*----</P><HR originaltext="---------" /><P> DATA</P><P>DATA : t001 LIKE TABLE OF t001 WITH HEADER LINE.</P><P>DATA : BEGIN OF itab OCCURS 0,</P><P>a(100) TYPE c,</P><P>END OF itab.</P><P></P><P>DATA: xml_out TYPE string .</P><P></P><P>DATA : BEGIN OF upl OCCURS 0,</P><P>f(255) TYPE c,</P><P>END OF upl.</P><P>DATA: xmlupl TYPE string .</P><P></P><P></P><P></P><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="31" type="ul"><P>FIRST PHASE</P></LI><LI level="31" type="ul"><P>FIRST PHASE</P></LI><LI level="31" type="ul"><P>FIRST PHASE</P></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><P></P><P>*----</P><HR originaltext="-------------" /><P> Fetch Data</P><P></P><P>SELECT * FROM t001 INTO TABLE t001.</P><P></P><P>*----</P><HR originaltext="--------------" /><P> XML</P><P>CALL TRANSFORMATION ('ID')</P><P>SOURCE tab = t001[]</P><P>RESULT XML xml_out.</P><P></P><P>*----</P><HR originaltext="--------" /><P> Convert to TABLE</P><P></P><P>CALL FUNCTION 'HR_EFI_CONVERT_STRING_TO_TABLE'</P><P>EXPORTING</P><P>i_string = xml_out</P><P>i_tabline_length = 100</P><P>TABLES</P><P>et_table = itab.</P><P></P><P></P><P>*----</P><HR originaltext="---------" /><P> Download</P><P></P><P>CALL FUNCTION 'GUI_DOWNLOAD'</P><P>EXPORTING</P><P>filetype = 'BIN'</P><P>filename = 'd:\xx.xml'</P><P>TABLES</P><P>data_tab = itab.</P><P></P><P></P><P></P><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="31" type="ul"><P>SECOND PHASE</P></LI><LI level="31" type="ul"><P>SECOND PHASE</P></LI><LI level="31" type="ul"><P>SECOND PHASE</P></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><P></P><P></P><P>BREAK-POINT.</P><P>REFRESH t001.</P><P>CLEAR t001.</P><P></P><P>CALL FUNCTION 'GUI_UPLOAD'</P><P>EXPORTING</P><P>filename = 'D:\XX.XML'</P><P>filetype = 'BIN'</P><P>TABLES</P><P>data_tab = upl.</P><P></P><P>LOOP AT upl.</P><P>CONCATENATE xmlupl upl-f INTO xmlupl.</P><P>ENDLOOP.</P><P></P><P>*----</P><HR originaltext="--------------" /><P> XML</P><P>CALL TRANSFORMATION ('ID')</P><P>SOURCE XML xmlupl</P><P>RESULT tab = t001[]</P><P>.</P><P>BREAK-POINT.</P><P></P><P></P><P>regards,</P><P>amit m.</P><P></P><P></P><P></P><P></P><P>regards,</P><P>amit m.</P></BODY></HTML> Thu, 30 Mar 2006 10:23:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/regd-report/m-p/1222765#M136980 Former Member 2006-03-30T10:23:14Z