Replicating R/3 DataSources

Table of contents:

Replicating R 3 DataSources

First, we will demonstrate how to activate InfoObject 0PLANT's DataSources in the R/3 source system SND_250. Then, we will replicate those DataSources into BW2.


In the rest of this book, we will use SND_250 as the R/3 source system and BW2 as the BW system.

The following steps show how to activate DataSources.


The R/3 Plug-In (PI) must be installed in the source system. The Plug-In interface enables the exchange of data between SAP systems. Technically, the Plug-In contains ABAP objects, such as tables and programs, used for data extraction.


The Plug-In cannot be "plugged out" after its installation. Use the database backup to restore the system to its previous state if needed.


Work Instructions

Step 1. Check whether the DataSources have been activated. Log on to the R/3 source system, execute transaction RSA6, and then click graphics/clock.gif to list the active DataSources.



SCREEN 10.31



DataSources in an R/3 source system come in two versions:

  • D – SAP delivery version
  • A – active version

The D version is the original definition from the Plug-In. The A version is used in data extraction.

Step 2. Click graphics/search.gif to search for 0PLANT's DataSources.


In Business Content, DataSources are named in the following format:

  • _ATTR for master data
  • _TEXT for texts
  • __HIER for hierarchies

SCREEN 10.32


Step 3. Enter 0PLANT, and then click graphics/search.gif again.



SCREEN 10.33


Step 4. The displayed message indicates that there are no active 0PLANT DataSources. Click graphics/continue.gif to continue.



SCREEN 10.34


Step 5. To activate the 0PLANT DataSources, execute transaction RSA5, and then click graphics/clock.gif to list the D version DataSources.



SCREEN 10.35


Step 6. Click graphics/search.gif to search for the 0PLANT DataSources.



SCREEN 10.36


Step 7. Enter 0PLANT, and then click graphics/search.gif again.



SCREEN 10.37


Step 8. Four DataSources are found. Select 0PLANT_ATTR, and then click graphics/positioncursor.gif.



SCREEN 10.38


Step 9. To see the definition of 0PLANT_ATTR, select it and then click graphics/display.gif to display the detail.



SCREEN 10.39


Step 10. Now we see a list of DataSource fields.




Fields selected in the Selection column, such as WERKS in this case, will be used as the selection conditions when creating an InfoPackage to load 0PLANT master data.

Double-click BIW_T001WS in the ExtractStruktur text field to see the definition of the extract structure for this DataSource.

SCREEN 10.40


Step 11. Screen 10.41 shows an ABAP structure named BIW_T001WS.



SCREEN 10.41


Step 12. To activate the DataSource 0PLANT_ATTR, select 0PLANT_ATTR and then click graphics/transferdatasources.gif.



SCREEN 10.42



The DataSource 0PLANT_ATTR has been activated.

After activating the DataSources on the R/3 source system side, next we need to replicate them on the BW side.

Step 13. From the Administrator Workbench, right-click the source system SND_250, and then select Replicate DataSources.



SCREEN 10.43



When the procedure is finished, the status message Tree data refreshed: Source system tree appears at the bottom of Screen 10.44.

SCREEN 10.44



Replicating DataSources from a source system will create identical DataSource structures in the BW system.

Part I. Guided Tours

Business Scenario and SAP BW

Creating an InfoCube

Loading Data into the InfoCube

Checking Data Quality

Creating Queries and Workbooks

Managing User Authorization

Part II. Advanced Topics

InfoCube Design

Aggregates and Multi-Cubes

Operational Data Store (ODS)

Business Content

Generic R/3 Data Extraction

Data Maintenance

Performance Tuning

Object Transport

Appendix A. BW Implementation Methodology

Object Transport

Appendix B. SAP Basis Overview

Object Transport

Appendix C. Glossary

Appendix D. Bibliography

SAP Bw. A Step-By-Step Guide
Sap Bw: a Step By Step Guide for Bw 2.0
Year: 2002
Pages: 106 © 2008-2020.
If you may any questions please contact us: