First we need to create two views: one for master data and one for texts.
Note:Views are ABAP dictionary objects. They are used to display data from multiple tables with specified table join conditions.
Step 1. To create a view for the master data,run transaction SE11,enter a name for the object,select the Views option in the Dictionary objects block,and then click.
Step 2. Select the Database view option,and then click.
Step 3. The view needs to be included in a development class in order to be transported to other R/3 systems. In our example,we create views as local objects. Enter $TMP as the development class name and click the,or simply click to assign the object to $TMP. Click to continue.
Note:A development class groups logically related objects,such as the objects that make up an accounting application. $TMP is a temporary local development class. Objects in $TMP cannot be transported into other systems.See ABAP documents for more information on $TMP and non-$TMP development classes.
Step 4. This view consists of only one table,LFM1 (Vendor master record purchasing organization data). Enter the names of the fields from which we will extract data.
Click to save the view definition.
Step 5. Click to check the view definition. If it is valid,click to generate the view.
Step 6. To display the data selected by this view,select the Display data option on the Utilities menu.
Step 7. Click to display the data.
The result,which is shown in Screen,has two entries.
We use the same procedure to create a view for the text data (see Screen). This view consists of data from two tables,LFM1 (Vendor master record purchasing organization data) and LFA1 (Vendor master – general section). The text data come from the LFA1 table.
the data selected by this view,which consists of two entries as well.
Now we have created two views,one for master data and one for texts. Next,we will create DataSources using these two views.
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.