topic Re: xml format in Application Development and Automation Discussions

xml format

Former Member — Wed, 06 Aug 2008 18:41:27 GMT

Hello all,

I'm stuck at an output file, so I have my program generated the output file, I have everything in internal table itab. But I need to generate the output file in xml format. My question is do you know any function module doing the job? like export import everything from my internal table and create an xml file? Or that's something I have to hardcode in my program?

Any helpful idea will be highly appreciated. Thanks!

Re: xml format

raja_thangamani — Wed, 06 Aug 2008 18:55:59 GMT

Check out the FM SAP_CONVERT_TO_XML_FORMAT

Below are the useful threads:

[Generate XML|]

[Download XML|]

Raja

Re: xml format

Former Member — Wed, 06 Aug 2008 19:32:01 GMT

Hi Raja, thanks for your quick response, i followed this and it works

DATA : ITAB TYPE TABLE OF SPFLI,

L_XML TYPE REF TO CL_XML_DOCUMENT.

SELECT * FROM SPFLI INTO TABLE ITAB.

CREATE THE XML OBJECT

CREATE OBJECT L_XML.

CONVERT THE DATA TO XML

CALL METHOD L_XML->CREATE_WITH_DATA( DATAOBJECT = ITAB[] ).

DATA IS CONVERTED TO XML; DISPLAY THE XML-DOCUMENT

CALL METHOD L_XML->DISPLAY.

However, It just display the XML output file in SAP, how do I put it in an output internal table?

I think it should be CALL METHOD L_XML->"something here". Thanks!

Re: xml format

Former Member — Wed, 06 Aug 2008 19:35:43 GMT

A different approach:

https://forums.sdn.sap.com/click.jspa?searchID=14919169&messageID=2833592

Re: xml format

raja_thangamani — Wed, 06 Aug 2008 20:23:11 GMT

In the Class CL_XML_DOCUMENT, we have a method EXPORT_TO_FILE to download an XML file.

  
DATA:  l_subrc    TYPE sysubrc,
       l_lfile    TYPE localfile,
      l_file     TYPE string,
      l_title    TYPE string,
      l_path     TYPE string,
      l_fullpath TYPE string.

CALL METHOD cl_gui_frontend_services=>file_save_dialog
    EXPORTING
      window_title      = l_title
      default_extension = 'XML'
      file_filter       = 'XML'
    CHANGING
      filename          = l_file
      path              = l_path
      fullpath          = l_fullpath
    EXCEPTIONS
      OTHERS            = 1.
  IF sy-subrc = 0.
    l_lfile = l_fullpath.

    CALL METHOD l_xml->export_to_file
      EXPORTING
        filename = l_lfile
      RECEIVING
        retcode  = l_subrc.
  ENDIF.

Raja