topic Xml string to abap internal table in Application Development and Automation Discussions

Xml string to abap internal table

Former Member — Thu, 06 Aug 2009 06:57:17 GMT

HI Experts ,

I want to parse this XML file to abap internal table ,i read as usual the Help and i think

that something is missing on my code.

There is someone can help.

The fields is type string and the value is :

<Containers> <Container workitemid = "00000017" IsParent = "X"><Element name = "_WF" value = "USI029"/><Element name = "_WF_PRIOR" value = "5"/><Element name = "_WF_VERSION" value = "0000"/><Element name = "_WF_NESTING_LEVEL" value = ""/><Element name = "XUBNAME" value = ""/><Element name = "XUACCNT" value = ""/><Element name = "SHORTTEXT" value = ""/><Element name = 
.....

i use the call transformation code and there i put this code:

<?sap.transform simple?>
<tt:transform xmlns:tt="http://www.sap.com/transformation-templates">
<tt:root name="XML_TAB"/>
  <tt:template>
    <Containers>
      <tt:loop name="a" ref=".XML_TAB">
        <Container>
          <tt:attribute name="Element name" value-ref="$a.name"/>
          <tt:attribute name="value" value-ref="$a.value"/>
        </Container>
      </tt:loop>
    </Containers>
  </tt:template>
</tt:transform>

I think that i miss something with the line :<Container workitemid = "0000007" IsParent = "X">

the dump is:

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_ST_MATCH_ATTRIBUTE', was not

caught and

therefore caused a runtime error.

The reason for the exception is:

XML matching error

Expected was attribute: "Elementname" [ ] Read was element-start: "Container" [

Please help

Regards

Chris

Edited by: Chris Teb on Aug 6, 2009 9:57 AM

Re: Xml string to abap internal table

Former Member — Thu, 06 Aug 2009 08:03:47 GMT

Hi,

Check this link.

Thanks

Re: Xml string to abap internal table

sivasatyaprasad_yerra — Thu, 06 Aug 2009 08:14:55 GMT

Your transformation is wrong:

<Element> tag is occured multiple times. But Your transformation says <Container> tag wil occur multiple times.

Try with this transformation:

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

  <tt:template>
    <Containers>
    <Container>
        <tt:loop name="a" ref=".XML_TAB">
        <Element >
          <tt:attribute name="name" value-ref="$a.name"/>
          <tt:attribute name="value" value-ref="$a.value"/>
          </Element>
          </tt:loop>
        </Container>
    </Containers>
  </tt:template>
</tt:transform>

Re: Xml string to abap internal table

sivasatyaprasad_yerra — Thu, 06 Aug 2009 08:50:02 GMT

CHeck this link. There is a example for the same type of XML structure.

[http://help.sap.com/saphelp_nwpi71/helpdata/EN/3a/eefd3f0521c842e10000000a1550b0/content.htm]

Re: Xml string to abap internal table

Former Member — Thu, 06 Aug 2009 09:24:04 GMT

Hello Chris,

Try Identical transformation. It is easy and not required transformation template.

CALL TRANSFORMATION ID

SOURCE ...

RESULT...

So source and result are not going to change any ways only you have to remove transformation template and replace it with ID.

Also make sure the input XML is following the XSLT format.

Thanks,

Augustin.

Re: Xml string to abap internal table

Former Member — Thu, 06 Aug 2009 10:27:05 GMT

H Siva,

Thanks ,

I try exactly like u tell and i get this dump:

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_ST_MATCH_ELEMENT', was not caught

and

therefore caused a runtime error.

The reason for the exception is:

XML matching error

Expected was element-end: "Containers" [ ] Read was element-start: "Container"

[ ].

<Containers>
    <Container>
        <tt:loop name="a" ref=".XML_TAB">
        <Element >
          <tt:attribute name="name" value-ref="$a.name"/>
          <tt:attribute name="value" value-ref="$a.value"/>
          </Element>
          </tt:loop>
        </Container>
    </Containers> ->**the dump in the debugger is here .**
  </tt:template>
</tt:transform>

Any Idea?

Regards

Chris

Re: Xml string to abap internal table

sivasatyaprasad_yerra — Thu, 06 Aug 2009 10:31:17 GMT

Check XML input which is getting passed to transformation. This should end with

</Container>
</Containers>

I think it is not like that.

Re: Xml string to abap internal table

Former Member — Thu, 06 Aug 2009 10:36:29 GMT

HI Siva,

Thank you ,

since i upload the file from text file the string maybe is cutting somewhere ,

i check it and let u know.

Regards

Chris

Re: Xml string to abap internal table

sivasatyaprasad_yerra — Thu, 06 Aug 2009 10:39:08 GMT

Check if you have more than one <Container> tag in the XML input. If that is the case, then this transformation will not work as this transformation is considered only for one <Container> tag in <Containers> tag. Check this also