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

Result:
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 DMCA.com Protection Status

SAP BW Topics