topic Re: Tranfer internal table to xml format in Application Development and Automation Discussions

Tranfer internal table to xml format

Former Member — Wed, 10 Oct 2012 21:13:59 GMT

Hi guys,

I have converted the internal table into xml format....and the out of xml format is display the data in the horizontal way:

I have use this logic:

CALL TRANSFORMATION ZFQMR_QAL_DATMAP_MES

SOURCE table = it_final

RESULT XML xmlstr.

APPEND xmlstr TO xml_tab.

MOVE '.XLS' TO default_extension.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

* BIN_FILESIZE =

FILENAME = 'C:\TEST'

FILETYPE = 'ASC'

TABLES

DATA_TAB = xml_tab

IF SY-SUBRC <> 0.

* Implement suitable error handling here

ENDIF.

output of xml:I want the the data to display in the vertical nt horizontal

how can i achieve this?

<Column ss:Span="1" ss:Width="47.25"/><Row ss:Height="60"><Cell ss:StyleID="s151"><Data ss:Type="String">Sample ID</Data></Cell><Cell ss:StyleID="s152"><Data ss:Type="String">Current or Last Inspection Lot for the Sample</Data></Cell></Row><Row><Cell><Data ss:Type="String">000100000000</Data></Cell><Cell><Data ss:Type="String">000000000000</Data></Cell></Row><Row><Cell><Data ss:Type="String">000100000001</Data></Cell><Cell><Data ss:Type="String">000000000000</Data></Cell></Row><Row><Cell><Data ss:Type="String">000100000002</Data></Cell><Cell><Data ss:Type="String">000000000000</Data></Cell></Row><Row><Cell><Data ss:Type="String">000100000003</Data></Cell><Cell><Data ss:Type="String">000000000000</Data></Cell></Row><Row><Cell><Data

Re: Tranfer internal table to xml format

Former Member — Thu, 11 Oct 2012 07:00:37 GMT

Drag your XML to browser (eg: IE), then you will see the XML in vertical hierarchy format.

Regards,

Xavier

Re: Tranfer internal table to xml format

Former Member — Thu, 11 Oct 2012 09:22:01 GMT

Hi,

If you are opening the document in notepad, wordpad or word, then this does not take the XML formating and takes as the string of characters. Hence you will see the data in horizontal way.

Try opening the document with IE, or XML tools or Notepad++, you will see the same in the XML format.

Regards,

Hardik Mehta

Re: Tranfer internal table to xml format

Former Member — Thu, 11 Oct 2012 09:27:23 GMT

Hi,

use this

CALL METHOD document->append_child

EXPORTING

new_child = xml_schema

RECEIVING

rval = rc.

CHECK rc = 0.

* --> creation of the body

LOOP AT elements ASSIGNING <element>.

IF NOT <element> IS INITIAL.

CALL METHOD xml_schema->append_child

EXPORTING

new_child = <element>

RECEIVING

rval = rc.

IF rc NE 0.

EXIT.

ENDIF.

ENDLOOP.

Re: Tranfer internal table to xml format

Former Member — Fri, 12 Oct 2012 10:20:12 GMT

make filename as C:\TEST.xml.