How to transfer the Data from SAP-System to Non-SAP system without additional Cost/License

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...
  1. Set the Variable values using fixed restrictions or Using SAP/Customer Exits variables in BW Report. (If you have any variables.)
  2. 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.
  3. Open the port in BW Application server.
  4. Create FTP/SFTP User ID in Application server level in BW System.
  5. 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
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.

Comments

julicasr said…
Hola,
is it possible the opposite way? transfer data using SFTP to BI without additional Cost/licence?
May 3, 2011 at 11:01 PM
Quran Transliteration said…
Hi Julicasr,

Hope it wouldn't cost/license for Opposite way of transfer.

I have never done it, we may need to setup RFC config/connection.

Hope it helps!

Thank you,
Subani Shaik.
July 14, 2011 at 11:56 AM
Post a Comment

Popular posts from this blog

COPA Extraction Step By Step in SAP BW

Image
COPA Extraction Step by Step: SAP R/3 or SAP ECC: 1. SAP R/3 or ECC goto T.Code KEB0 , In Function: Select Create  Control Parameters: Provide a New CO-PA DataSource Name:1_CO_PA%CL%ERK 2. Select your O perating C oncern, e.g.,IDES. 3. Select radio button Costing-based or Account-based as OC . 4.Select field names for partitioning.e.g. BUKRS (Company Code), Check 5.Click on Info Catalog (F7) 6. Select the Characteristics & Value fields & Keyfigures 7. Select the Package/Development Class for Workbench request 8. Edit your DataSource to select/Hide fields, Save. Datasource created successfully. 9. Extractor Checker or RSA3, extraction. SAP BW:   1. Replicate DataSource 2. Assign InfoSource 3. Transfer all the datasource elements to an InfoSource 4. Activate InfoSource 5. Create a InfoCube (Copy Str from InfoSource) 6. Create Dimension & Define and Assign it. 7. Check & Activate. 8. Create Transformati...
Read more

Types of SAP HANA Editions (HANA Versions)

Image
1) Platform Edition: SAP HANA Database SAP HANA Studio SAP HANA Client  SAP Host Agent SAP HANA Information Composer 2) Enterprise Edition: SAP HANA Database SAP HANA Studio SAP HANA Client  SAP Host Agent SAP HANA Information Composer LT Replication Add-on (SLT) LT Replication Server (SLT) SAP BO Data Services 4.0 3) Enterprise Extended Edition: SAP HANA Database SAP HANA Studio SAP HANA Client  SAP Host Agent SAP HANA Information Composer LT Replication Add-on (SLT) LT Replication Server (SLT) SAP BO Data Services 4.0 Sybase Adaptive Server Enterprise (ASE) Sybase Replication Server (ECDA) Sybase Replication Server Agent SAP HANA Load Controller (Includes R/3 Load, RepServer De-cluster Add-On) It depends on what licenses you already have and how do you intends to use SAP HANA. Platform Edition = ETL via BO Data Services (If the client already have li...
Read more

One stage stop to know all about BW Extractors-Part1

Image
Types of Extractors:               Application specific BW content extractors: Lo Extraction: Logistics refers to the process of getting a product or service to its desired location upon request which involves transportation, purchasing, warehousing etc. Main areas in logistics are: Sales and Distribution (SD) : application 11, 13, 08 (in LBWE T-code) Materials Management (MM) : application 03, 02 Logistics Execution (LE) : application 12 Quality Management : application 05 Plant Maintenance (PM) : application 04, 17 Customer Service (CS) : application 18 Project System (PS) : application 20 SAP Retail : application 40,43,44,45 How the data extraction happens? Extraction can be done using either Full update/delta update. Full load: Incase of l...
Read more