Creating DataSources in R/3 and Replicating Them to BW - SAP BW

DataSources consist of structures and objects that BW uses to extract data from source systems. Generic R/3 data extraction in Business Content allows us to create DataSources for the views created in Section. The procedure follows.

Work Instructions:
Step 1. Run transaction SBIW and click Maintain Generic DataSources,or run transaction RSO2.
Work Instructions

Step 2. Because our BW system is 2.0B,click the BW Release 2.0 button. Enter a name as the Master data attributes,and then clickcreate.
Maintaining a generic data source BW Rel

Note:Here ZVENDOR_ATTR is a DataSource name,not the name of the view ZVENDOR_ATTR created.

Step 3. Enter ZVENDOR_ATTR as the View/table and other information as shown,and then click bmwto generate the DataSource.
Create Generic data source

Note:Besides DB view,we can use ABAP queries to select R/3 data. ABAP queries are now called InfoSet queries.
An InfoSet works much like a view but allows outer joins between tables. InfoSet queries are ABAP programs generated by SAP (either R/3 or BW),based on the output specifications given by a user. When you use InfoSet in data extraction,Plug-In will create a query for the DataSource automatically.

Step 4. Create the DataSource as a local object. ClickLocal object.
Create Object Directory Entry

Step 5. In the new window,check two selection fields and clicksave to save the DataSource.
Selection Field Selection

You have created the DataSource ZVENDOR_ATTR.Repeating the preceding steps,we create DataSource ZVENDOR_TEXT for the view ZVENDOR_TEXT.Now we need to replicate the DataSources so that identical structures of the DataSources will appear in the BW system.
Administrator Work bench Modelling

Next,we will create a characteristic in the BW system to receive and store the R/3 data.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

SAP BW Topics