2006 Nov 29 12:51 PM
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.
2006 Nov 29 1:24 PM
You can download the report output into XML file. Check this demo program :SXSLTDEMO_FLIGHTS. Hope this helps!
Krishna
2006 Nov 30 4:22 AM
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.
2006 Nov 30 4:27 AM
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.
2006 Nov 30 4:29 AM
Hi Bhagat,
If u hold the data in a Internal Table,
try this FM,
SMUM_XML_CREATE
Regards,
~Sri.
2006 Nov 30 5:05 AM
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?
use this XML file for the above program:
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
2006 Nov 30 6:32 AM
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.