XML file

Former Member — Thu, 17 Sep 2009 10:52:55 GMT

Hello guys,

I ve a XML file, can I upload it into SAP and get all the tags present in the XML file into one single line.

Eg: If i have 10 tags in 10 different lines, can I do something in SAP to get all the 10 tags into a single line?

Regards,

Greg

Re: XML file

Former Member — Thu, 17 Sep 2009 11:00:00 GMT

hi,

try this,

DATA: xml_data TYPE xstring,

lt_xml_data TYPE STANDARD TABLE OF xstring.

APPEND xml_data TO lt_xml_data.

lo_pdfobj->get_data(

IMPORTING

formdata = xml_data ).

Convert XML data from XSTRING format to STRING format

DATA: lv_xml_data_string TYPE string.

CALL FUNCTION 'ECATT_CONV_XSTRING_TO_STRING'

EXPORTING

im_xstring = xml_data

IMPORTING

ex_string = lv_xml_data_string.

Remove NEW-LINE character from XML data in STRING format

CLASS cl_abap_char_utilities DEFINITION LOAD.

REPLACE ALL OCCURENCES OF cl_abap_char_utilities=>newline IN

lv_xml_data_string WITH ''.

Make the XML envelope compliant with identity transform

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

IN lv_xml_data_string

WITH '<?xml version="1.0" encoding="iso-8859-1"?><asx:abap xmlns

:asx="http://www.sap.com/abapxml" version="1.0"><asx:values>'.

REPLACE '</data>'

IN lv_xml_data_string

WITH '</asx:values></asx:abap>'.

Apply the identity transform and convert XML into ABAP in one step

DATA: wa_VNDBNK type ZVK_VNDBNK VALUE IS INITIAL,

wa_VENDOR type ZHD_VENDOR value is initial,

lv_subrc TYPE sysubrc VALUE IS INITIAL,

lt_messtab TYPE STANDARD TABLE OF bdcmsgcoll,

l_key type SWR_STRUCT-OBJECT_KEY,

l_pack type zhd_vendor-lifnr.

CALL TRANSFORMATION id

SOURCE XML lv_xml_data_string

RESULT Z_VNDBNK = wa_vndbnk.

Regards,

Arunsri

Edited by: Arunsri on Sep 17, 2009 1:00 PM

Re: XML file

Former Member — Thu, 17 Sep 2009 12:20:11 GMT

HeY Arun,

Thanks for your reply. Unfortunately this doesnot seem to work. I getting error 'lo_pdfobj Un´known'

regards,

greg

topic XML file in Application Development and Automation Discussions

XML file

Re: XML file

Re: XML file