xml to sap

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.