How to transfer the Data from SAP-System to Non-SAP system without additional Cost/License
Can we Transfer the Reports/Data from SAP-System to Non-SAP system without additional Cost/License?.
Yes, we can transfer using with simple FTP/SFTP.
Is it required any additional License or additional Cost?
No.
Is there any complex Coding or Configuration required?.
No, it is very simple.
How Can I transfer the Report/Data?.
Here I'm considering SAP-BW system running in UNIX operating system and Windows XP as Non-SAP System.
Source : SAP-BW System running on UNIX.
Destination : SQL-Server running on Windows XP.
Scenario:
I have data in SAP-BW System, e.g. InfoCube 0SD_C03. And 0SD_C03 is having some reports and want to transfer the reports data to SQL-Server running on Windows XP.
Else
You may need to transfer ECC Data to SQL-Server running on Windows XP. For this also you can use the same logic.
Here are the steps...
- Set the Variable values using fixed restrictions or Using SAP/Customer Exits variables in BW Report. (If you have any variables.)
- Using RSCRM_BAPI TCode schedule the report based on your requirement i.e. daily, weekly...etc. And then dump the report result into one path (Directory) in Application Server. E.g.:
Directory: /usr/sap/BP1/DVEBMGS00/work/
You can see this path in AL11 Tcode. Open the port in BW Application server.
- Create FTP/SFTP User ID in Application server level in BW System.
Using Windows Script you call the Report in /usr/sap/BP1/DVEBMGS00/work/ path in BW system to SQL-Server running on Windows XP. This script you can save as a batch file and schedule it based on your requirement in Windows Server.
Sample Windows script:
Note: For better understanding or Changing of the above code, please contact your Windows system Administrator. This is just sample code only.
Here I’m using RSCRM_BAPI Tcode to dump the report result into Application Server. You can use your own method also. Our intension is how to transfer the data from SAP to Non-SAP System.
26 Comments
