Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Down loading SAP R/3 Data to XML file

Former Member
0 Kudos
182

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.

6 REPLIES 6

Former Member
0 Kudos
80

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

Krishna

0 Kudos
80

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.

ferry_lianto
Active Contributor
0 Kudos
80

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.

Former Member
0 Kudos
80

Hi Bhagat,

If u hold the data in a Internal Table,

try this FM,

SMUM_XML_CREATE

Regards,

~Sri.

former_member184569
Active Contributor
0 Kudos
80

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....

use this XML file for the above program:

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

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

Former Member
0 Kudos
80

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.