topic Uploading XML file from application server into SAP internal table in Application Development and Automation Discussions

Uploading XML file from application server into SAP internal table

Former Member — Mon, 21 Apr 2008 04:57:15 GMT

Hello Experts,

I need to convert the data from XML file which is on application server into an internal table and upload this data using BDC.

Since the file is on application server I can't use GUI_UPLOAD.

I have read the XML file into an internal table having char type field using the READ DATASET statement. But I'm not able to parse the file.

Can anybody please suggest me an alternative way so that I can directly get the values in an internal table.

I have tried using function modules SMUM_XML_PARSE and TEXT_CONVERT_XML_TO_SAP, but I'm not able to pass proper parameters to them

Please help !!! This is urgent.

Thanks in Advance.

Re: Uploading XML file from application server into SAP internal table

athavanraja — Mon, 21 Apr 2008 06:10:54 GMT

read the XML using open data set into a variable of type string. and then use FM SCMS_STRING_TO_XSTRING to convert the string to xstring. pass the xstring to SMUM_XML_PARSE

Raja

Re: Uploading XML file from application server into SAP internal table

Former Member — Mon, 21 Apr 2008 07:03:05 GMT

Hi Raja,

I tried the same. But it not populating the table and giving an error message in the return table "line 1 col 1-unexpected symbol; expected '<', '</', entity reference, charac".

I can't find any ' ; ' in the XML file. What could be the possible reason of error?

Re: Uploading XML file from application server into SAP internal table

Former Member — Tue, 22 Apr 2008 09:15:43 GMT

Hi Raja,

My problem is solved with ur suggestion. Thanks a lot !!!

Regards

Radhika

Re: Uploading XML file from application server into SAP internal table

Former Member — Wed, 21 May 2008 10:56:34 GMT

Hi ,

How did u solve your problem can any one give me the idia.

thanks