Convert XML file to Internal DAta

Former Member — Thu, 18 Aug 2011 15:59:50 GMT

Hi gurus,

I have following XML file.

<?xml version="1.0" encoding="UTF-8"?>

-<msvauth:Servicegate-Authorization DocVersion="1.0" xsi:schemaLocation="http://servicegate.infolock.com/ns/sv/v1.0/auth http://servicegate.beta.infolock.com/public/auth/sv/v1.0/request.xsd"; Id="A1" xmlns:trx="http://servicegate.infolock.com/ns/sv/v1.0/transaction" xmlns:auth="http://servicegate.infolock.com/ns/sv/v1.0/auth" xmlns:msvtrx="http://servicegate.infolock.com/ns/sv/v1.0/transaction" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:msvauth="http://servicegate.infolock.com/ns/sv/v1.0/auth">

-<msvtrx:SoftwareInfo>

<msvtrx:Name>Legend</msvtrx:Name>

<msvtrx:Version>6.1</msvtrx:Version> </msvtrx:SoftwareInfo>

-<msvtrx:Transaction Id="T000001">

<msvtrx:Number>000001</msvtrx:Number>

<trx:PurchaseType>Part</trx:PurchaseType>

<msvtrx:AuthorizationType>Auth</msvtrx:AuthorizationType>

<msvtrx:Description>Counter Ticket</msvtrx:Description>

<msvtrx:MerchantNumber>112233</msvtrx:MerchantNumber>

<trx:Currency>USD</trx:Currency>

<msvtrx:Time TimeZone="US-CHICAGO">2010-11-11T00:00:00</msvtrx:Time>

-<msvtrx:CardInfo Expiry="2049-12" Type="PACCAR">

<msvtrx:CardNumber>1234560000003675</msvtrx:CardNumber>

</msvtrx:CardInfo>

<msvtrx:Amount>16.52</msvtrx:Amount>

<msvtrx:PurchaseOrderNumber>052610PN3521</msvtrx:PurchaseOrderNumber>

</msvtrx:Transaction>

</msvauth:Servicegate-Authorization>

want to convert this into internal table , I tried FM 'TEXT_CONVERT_XML_TO_SAP' but not got the output...

if have any sample code, plz provide ....

thanks....

Re: Convert XML file to Internal DAta

Former Member — Thu, 18 Aug 2011 20:32:56 GMT


  GET REFERENCE OF gt_offpos INTO ls_offpos_xml-value.
  ls_offpos_xml-name = c_xml_tagname.
  APPEND ls_offpos_xml TO lt_offpos_xml.

  TRY .
      CALL TRANSFORMATION ztrlm_offpos_dtl
      SOURCE XML gt_offpos_xml
      RESULT (lt_offpos_xml).
    CATCH cx_root INTO l_ref_rif_ex.
      l_var_text = l_ref_rif_ex->get_text( ).
      CONCATENATE l_var_text ' Please check xml file.' INTO l_var_text.
      MESSAGE l_var_text TYPE 'E'.
  ENDTRY.

Re: Convert XML file to Internal DAta

Former Member — Thu, 18 Aug 2011 23:40:48 GMT

Below link might help..

topic Convert XML file to Internal DAta in Application Development and Automation Discussions

Convert XML file to Internal DAta

Re: Convert XML file to Internal DAta

Re: Convert XML file to Internal DAta