topic Re: SAP_CONVERT_TO_XML_FORMAT Function Module in Application Development and Automation Discussions

SAP_CONVERT_TO_XML_FORMAT Function Module

Former Member — Fri, 27 Dec 2013 12:06:32 GMT

Hello All,

I want to use the FM SAP_CONVERT_TO_XML_FORMAT to generate an xml file from an internal table. I am not sure what parameters to pass to do this, assistance please? I have looked at the following link but still don't understand http://sap.ittoolbox.com/groups/technical-functional/sap-dev/using-sap_convert_to_xml_format-281858

Can the FM be used to generate xml in a custom format?

Thanks,

Wilson.

Re: SAP_CONVERT_TO_XML_FORMAT Function Module

Former Member — Fri, 27 Dec 2013 12:27:02 GMT

Hi Wilson,

This demo program talks about how to convert internal table into XML and download to PC and upload the same to SAP.

*&---------------------------------------------------------------------*

*& Report ZTOXML

*&---------------------------------------------------------------------*

REPORT ZTOXML.

*-------------- DATA

DATA : t001 type TABLE OF t001 WITH HEADER LINE.

DATA : BEGIN OF itab OCCURS 0,

a(100) TYPE c,

END OF itab.

DATA: xml_out TYPE string .

DATA : BEGIN OF upl OCCURS 0,

f(255) TYPE c,

END OF upl.

DATA: xmlupl TYPE string .

******************************* FIRST PHASE

*------------------ Fetch Data

SELECT * FROM t001 INTO TABLE t001.

*------------------- XML

CALL TRANSFORMATION ('ID')

SOURCE tab = t001[]

RESULT XML xml_out.

*------------- Convert to TABLE

CALL FUNCTION 'HR_EFI_CONVERT_STRING_TO_TABLE'

EXPORTING

i_string = xml_out

i_tabline_length = 100

TABLES

et_table = itab.

*-------------- Download

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filetype = 'BIN'

filename = 'D:\vino\WD\first.xml'

TABLES

data_tab = itab.

******************************* SECOND PHASE

BREAK-POINT.

REFRESH t001.

CLEAR t001.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = 'D:\vino\WD\first.xml'

filetype = 'BIN'

TABLES

data_tab = upl.

LOOP AT upl.

CONCATENATE xmlupl upl-f INTO xmlupl.

ENDLOOP.

*------------------- XML

CALL TRANSFORMATION ('ID')

SOURCE XML xmlupl

RESULT tab = t001[]

Regards,

Jawaid Alam.

Re: SAP_CONVERT_TO_XML_FORMAT Function Module

RemiKaimal — Fri, 27 Dec 2013 12:49:32 GMT

Hi Wison,

Check out Sample code :

TABLES USR03.

DATA: BEGIN OF ISAPDAT OCCURS 0,

BNAME LIKE USR03-BNAME,

NAME1 LIKE USR03-NAME1,

NAME2 LIKE USR03

-NAME2,

END OF ISAPDAT.

PARAMETERS P_FNAME LIKE RLGRAP-FILENAME

DEFAULT 'd:\sapdata.xls' OBLIGATORY.

SELECT * FROM USR03 INTO CORRESPONDING FIELDS OF TABLE ISAPDAT.

SORT ISAPDAT.

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'

EXPORTING

I_FILENAME = P_FNAME

TABLES

I_TAB_SAP_DATA = ISAPDAT

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2.

IF SY-SUBRC EQ 0.

WRITE:/ 'Download to Excel complete'.

ELSE.

WRITE:/ 'Error with download'.

ENDIF.

Hope this helps...

Cheers,

Remi

Re: SAP_CONVERT_TO_XML_FORMAT Function Module

Former Member — Fri, 27 Dec 2013 13:31:37 GMT

Hi Remi,

Thanks for your quick answer. Might you know if it is possible to use this FM to generate xml in custom format?

Thanks,

Wilson.

Re: SAP_CONVERT_TO_XML_FORMAT Function Module

RemiKaimal — Mon, 30 Dec 2013 04:03:16 GMT

Yes - If your question is about the customised view of fields in the XML.

Take the case, of the sample code, above

The table : USR03 - this has 28 fields.

Now, the XML file, will have only 3 fields, based on the internal table, defined.

Hope this helps...

Re: SAP_CONVERT_TO_XML_FORMAT Function Module

Former Member — Thu, 19 Mar 2015 18:56:21 GMT

This message was moderated.