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.
Step 1. Run transaction SBIW and click Maintain Generic DataSources,or run transaction RSO2.
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 click.
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 to generate the DataSource.
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. Click.
Step 5. In the new window,check two selection fields and click to save the DataSource.
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.
Next,we will create a characteristic in the BW system to receive and store the R/3 data.
SAP BW Related Interview Questions
|SAP BI Interview Questions||SAP WM Interview Questions|
|SAP BO Interview Questions||SAP Netweaver Interview Questions|
|SAP BODS Interview Questions||SAP Webi Interview Questions|
|SAP Web Dynpro Interview Questions||SAP BDC Interview Questions|
|SAP BW on HANA Interview Questions|
Sap Bw Tutorial
Business Scenario And Sap Bw
Creating An Infocube
Loading Data Into The Infocube
Checking Data Quality
Creating Queries And Workbooks
Managing User Authorization
Aggregates And Multi-cubes
Operational Data Store (ods)
Generic R/3 Data Extraction
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.