topic Re: Down loading SAP R/3 Data to XML file in Application Development and Automation Discussions

Down loading SAP R/3 Data to XML file

Former Member — Wed, 29 Nov 2006 12:51:45 GMT

Hi all,

How can I download the SAP R/3 Data to an XML file so that later on i can upload it to Sql Sever ?Thanks in advance.

Best regards,

Bhagat.

Re: Down loading SAP R/3 Data to XML file

Former Member — Wed, 29 Nov 2006 13:24:55 GMT

You can download the report output into XML file. Check this demo program :SXSLTDEMO_FLIGHTS. Hope this helps!

Krishna

Re: Down loading SAP R/3 Data to XML file

Former Member — Thu, 30 Nov 2006 04:22:00 GMT

Hi Krishna,

Thanks for ur response.

Is there any way of doing this without using the object oriented approach ?

Pls let me know ASAP.

Best Regards

Bhagat.

Re: Down loading SAP R/3 Data to XML file

Former Member — Thu, 30 Nov 2006 04:27:30 GMT

Hi Bhagat,

Please check these threads for sample codes.

https://forums.sdn.sap.com/click.jspa?searchID=233062&messageID=2701893

Hope this will help.

Regards,

Ferry Lianto

Please reward points if helpful.

Re: Down loading SAP R/3 Data to XML file

Former Member — Thu, 30 Nov 2006 04:29:49 GMT

Hi Bhagat,

If u hold the data in a Internal Table,

try this FM,

SMUM_XML_CREATE

Regards,

~Sri.

Re: Down loading SAP R/3 Data to XML file

Former Member — Thu, 30 Nov 2006 05:05:55 GMT

HI Bhagat,

See the below link for program which is uploading the XML file in to SAP, this will work in 4.6C

http://www.geocities.com/rmtiwari/main.html?

http://www.geocities.com/rmtiwari/Resources/MySolutions/Dev/Codes/Report/Z_RMTIWARI_XML_TO_ABAP_46C.html

use this XML file for the above program:

http://www.geocities.com/rmtiwari/main.html?http://www.geocities.com/rmtiwari/Resources/MySolutions/Dev/UtilityCode.html

See the below link for one more program

http://wiki.ittoolbox.com/index.php/Code:Download_and_upload_OO_ABAP_class_in_XML_format

Message was edited by:

Susmitha Thomas

Re: Down loading SAP R/3 Data to XML file

Former Member — Thu, 30 Nov 2006 06:32:45 GMT

Hi ABAP Gurus,

Thanks for your reply and it was really helpful.

But that was my initial requirement.

I will explain the scenario.

Whenever there is an updation or change in the HR Master data like insertion of new personnel number or deletion of personnel number then I need to dump the data to XML file . That means I need to make it event driven.

Will it be possible programmatically ?

Pleass give me your inputs.

Best Regards

Bhagat.