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 

Step1:  

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