Data in XML format

Former Member — Mon, 22 Oct 2007 05:22:07 GMT

Hi,

How to upload master data which is provided in XML format. I have vendor master info in XML format.

Re: Data in XML format

Former Member — Mon, 22 Oct 2007 06:35:01 GMT

Hi Sourav,

You can use these FM's

<b>

FILE_READ_AND_CONVERT_SAP_DATA

TEXT_CONVERT_XML_TO_SAP</b>

Check this sample program.

REPORT ZSAMPLEXML.

*----

DATA

DATA : t001 LIKE TABLE OF t001 WITH HEADER LINE.

DATA : BEGIN OF itab OCCURS 0,

a(100) TYPE c,

END OF itab.

DATA: xml_out TYPE string .

DATA : BEGIN OF upl OCCURS 0,

f(255) TYPE c,

END OF upl.

DATA: xmlupl TYPE string .

FIRST PHASE

*----

Fetch Data

SELECT * FROM t001 INTO TABLE t001.

*----

XML

CALL TRANSFORMATION ('ID')

SOURCE tab = t001[]

RESULT XML xml_out.

*----

Convert to TABLE

CALL FUNCTION 'HR_EFI_CONVERT_STRING_TO_TABLE'

EXPORTING

i_string = xml_out

i_tabline_length = 100

TABLES

et_table = itab.

*----

Download

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filetype = 'BIN'

filename = 'd:\xx.xml'

TABLES

data_tab = itab.

SECOND PHASE

BREAK-POINT.

REFRESH t001.

CLEAR t001.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = 'D:\XX.XML'

filetype = 'BIN'

TABLES

data_tab = upl.

LOOP AT upl.

CONCATENATE xmlupl upl-f INTO xmlupl.

ENDLOOP.

*----

XML

CALL TRANSFORMATION ('ID')

SOURCE XML xmlupl

RESULT tab = t001[]

BREAK-POINT.

<b>Reward Points if Useful</b>

Regards

Gokul

topic Re: Data in XML format in Application Development and Automation Discussions

Data in XML format

Re: Data in XML format