topic Re: xml to sap in Application Development and Automation Discussions

xml to sap

Former Member — Mon, 26 May 2008 13:51:07 GMT

Hi,

I converted xml file to sap using some PARSE FM's.

But internal table data is stored in the format like:

filedname value

kunnr afFff

name1 afafa

land1 us

. .

so on.

instead of this format I want my internal table in the format

kunnr name1 land1

aagag dgagg us.

Can any one give me some idea on this.

thanks inadvance.

Re: xml to sap

Former Member — Mon, 26 May 2008 15:43:42 GMT

Hi,

Internal table which would have the same structure as in the excel file,so change the header(column wise) into rowwise.Then use FM.

Hope t vl work.f u hav any further help let me know.

Warm Regards,

Mohandoss P.

Re: xml to sap

Former Member — Mon, 26 May 2008 16:31:51 GMT

Hi try the following program to convert form xml to sap rather u r FM :


data :response TYPE string.
Response is where u pass the xml file to it.

*FM converting the XML format to abap
CALL FUNCTION 'SCMS_STRING_TO_XSTRING'
EXPORTING
text = response
IMPORTING
buffer = xml.

*FM converting XMl to readable format to a internal table.
CALL FUNCTION 'SMUM_XML_PARSE'
EXPORTING
xml_input = xml
TABLES
xml_table = t_xml
return = return.

Reward If Found Helpful.