To upload Sales Order data from SAP R/3 to BI using generic DataSources

By Sandhya Punuru, Perot Systems

Steps to be followed in R/3 

Step 1: Goto T-code RSO2. Give the DataSource name in Transactional data (as we are uploading transactional data) and click on Create  


Step 2:

  1. Specify the Application Component name
  2. Fill in the text column with meaningful description
  3. In “Extraction from DB view” give the table/View name from which you want to extract data.
  4. SAVE  

Note: Click on F4 to chose Application Component name 


Step 3: Clicking on SAVE will lead to the below screen.  

Note: We can do “Selection”, “Hide” the fields etc as shown in the below screen shot


Step 4: Go to T-code RSA6 to know if the DataSource is successfully activated 


Note: Only Datasources which are activated will be displayed in RSA6 transaction  

Steps to be followed in BI 

Note: The RFC connection should be configured before you replicate data to BI system 


  1. Goto RSA1 => DataSources
  2. Rtclk on Sales and Distribution tree => Replicate Metadata
  3. Activate

Step 2: Once the DataSource is replicated, you get a below popup, we need to choose “as DataSource” as we are using BI 7.0  


Click here to continue...

Please send us your feedback/suggestions at webmaster@SAPTechnical.COM 

HomeContribute About Us Privacy Terms Of Use • Disclaimer • SafeCompanies: Advertise on SAPTechnical.COM | Post JobContact Us  

Graphic Design by Round the Bend Wizards

footer image footer image