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

uploading xml to internal table

Former Member — Thu, 16 Jun 2011 12:47:38 GMT

Hello all,

I was trying to upload xml to internal table but failed i ma getting the value but in junk way.

How to upload xml to internal table.

the data in xml is like

<?xml version="1.0" standalone="yes" ?>

- <NewDataSet>

- <status xmlns="sap">

<Maktx>Classification test</Maktx>

</status>

- <status xmlns="sap">

<Maktx>Component Full Repair Service</Maktx>

</status>

- <status xmlns="sap">

<Maktx>AS-100 T-shirt</Maktx>

</status>

- <status xmlns="sap">

<Maktx>AS-100 T-shirt</Maktx>

</status>

- <status xmlns="sap">

<Maktx>Maxitec-R 375 Personal computer</Maktx>

</status>

- <status xmlns="sap">

<Matnr>WHEEL</Matnr>

<Maktx>auto wheel</Maktx>

</status>

</NewDataSet>

how to upload this to internal table??

Pls help me out....

Re: uploading xml to internal table

Former Member — Thu, 16 Jun 2011 13:33:52 GMT

Hi,

Research classes that begin with CL_XML*. I used CL_XML_DOCUMENT & CL_XML_DOCUMENT_BASE and its methods to create an XML string from an internal table, parsed the string per business requirements and then using the string, build an internal table of the XML output. The internal table to hold hte XML output was defined as a table with one field that is 255 characters in length.

check methods:

create_with_data

render_2_string

parse_string

render_2_table

Hope this helps.

Re: uploading xml to internal table

Former Member — Thu, 16 Jun 2011 14:04:42 GMT

what is it you are trying to acheive in the end? an internal table containing the XML, or an internal table containing the fields mapped from the XML elements.

For the former, look at CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD

For the latter, look at the XML objects as stated above, or at the CALL TRANSFORMATION ABAP statement

You could use a simple transformation. There are several examples of the code.

Re: uploading xml to internal table

MarcinPciak — Thu, 16 Jun 2011 14:20:04 GMT

As mentioned above both approaches will lead you to the result. A snippet how this could be achieved by simple transformation

- create ST using STRANS tcode


<?sap.transform simple?>
<tt:transform xmlns:tt="http://www.sap.com/transformation-templates">

<tt:root name="data_tab" />
    
<tt:template>  
  <NewDataSet>
      <tt:loop ref="data_tab" name="line">
      <status xmlns="sap">
          <Mandt><tt:value ref="$line.Mandt"/></Mandt>
          <Matnr><tt:value ref="$line.Matnr"/></Matnr>
          <Werks><tt:value ref="$line.Werks"/></Werks> 
          <Maktx><tt:value ref="$line.Maktx"/></Maktx> 
          <Type><tt:value ref="$line.Type"/></Type> 
          <Stat><tt:value ref="$line.Stat"/></Stat>           
     </status>
     </tt:loop>
  </NewDataSet> 
</tt:template>

</tt:transform>

- and ABAP program to deserialize your xml file


DATA xmlbin_tab TYPE TABLE OF x255.
DATA xml_xstr TYPE xstring.
DATA len TYPE i.

CALL FUNCTION 'GUI_UPLOAD'
  EXPORTING
    filename   = 'C:\Temp\test.xml'
    filetype   = 'BIN'
  IMPORTING
    filelength = len
  TABLES
    data_tab   = xmlbin_tab.

CALL FUNCTION 'SCMS_BINARY_TO_XSTRING'
  EXPORTING
    input_length = len
  IMPORTING
    buffer       = xml_xstr
  TABLES
    binary_tab   = xmlbin_tab.

DATA: BEGIN OF itab OCCURS 0,
        mandt TYPE mandt,
        matnr TYPE matnr,
        werks TYPE persa,
        maktx TYPE maktx,
        type  TYPE i,
        stat  TYPE i,
      END OF itab.


CALL TRANSFORMATION zpmi_st
  SOURCE XML xml_xstr
  RESULT data_tab = itab[].

Regards

Marcin