Creating Views in R/3 - SAP BW

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.

Work Instructions:
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 clickWork Instructions.
Dictionary initial screen

Step 2. Select the Database view option,and then clickchoose.
Choose view type

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 thesave,or simply click local-objectto assign the object to $TMP. Clicklocal-object to continue.
create Object directory entry

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 saveto save the view definition.
ABAP dictionary maintain view ZVendor ATTR

Step 5. Click Clickto check the view definition. If it is valid,click to generate the view.
ABAP dictionary maintain view ZVendor ATTR

Step 6. To display the data selected by this view,select the Display data option on the Utilities menu.
ABAP dictionary maintain view ZVendor ATTR

Step 7. ClickClick to display the data.
data browser table

Result:
The result,which is shown in Screen,has two entries.
data browser table

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.
ABAP dictionary maintain view ZVendor text

the data selected by this view,which consists of two entries as well.
data browser table

Now we have created two views,one for master data and one for texts. Next,we will create DataSources using these two views.


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

SAP BW Topics