Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

XML to internal table

Hello guys

I'va an XML with this structure

<ECR>

<change_no>00BAPIECR014</change_no>

<status>01</status>

<valid_from>09012008</valid_from>

<descript>Descripcion</descript>

<reason_chg>Razon Cambio</reason_chg>

<rank>00</rank>

<release_key>00</release_key>

<header_status_list>

<status>

<stat>I0001</stat>

<inact></inact>

</status>

<status>

<stat>I0001</stat>

<inact>X</inact>

</status>

<status>

<stat>I0251</stat>

<inact>X</inact>

</status>

<status>

<stat>I0252</stat>

<inact></inact>

</status>

<status>

<stat>I0253</stat>

<inact></inact>

</status>

<status>

<stat>I0254</stat>

<inact></inact>

</status>

<status>

<stat>I0268</stat>

<inact></inact>

</status>

</header_status_list>

<WBS_BOM>

<material>PR-004</material>

<plant>0002</plant>

<psp_element>LV0081</psp_element>

<wbs_bom_status_list>

<status>

<stat>I0259</stat>

<inact>X</inact>

</status>

<status>

<stat>I0260</stat>

<inact></inact>

</status>

<status>

<stat>I0263</stat>

<inact></inact>

</status>

</wbs_bom_status_list>

</WBS_BOM>

<DIR>

<doc_type>ZEP</doc_type>

<doc_number>TEST_PROT_001</doc_number>

<doc_vers>00</doc_vers>

<doc_part>000</doc_part>

<dir_status_list>

<status>

<stat>I0259</stat>

<inact>X</inact>

</status>

<status>

<stat>I0260</stat>

<inact></inact>

</status>

<status>

<stat>I0263</stat>

<inact></inact>

</status>

</dir_status_list>

</DIR>

</ECR>

and i want to pass it to an internal table i tried to use SDIXML_XML_TO_DOM y SDIXML_DOM_TO_DATA but i don't know how to transform the document that returns SDIXML_XML_TO_DOM into a document that can be passed to SDIXML_DOM_TO_DATA

I've seen the instruction CALL TRANSFORMATION but i can't use it successfull and the only way that remains to me is to use TEXT_CONVERT_XML_TO_SAP but i,ve heard abaout it returns a spool order, can i convert this spool to an internal table?

Hope somebody bring some ligth to me

thanks

Former Member
Not what you were looking for? View more on this topic or Ask a question