Database View SAP ABAP Web Dynpro

By using a view, we can combine the data distributed in several tables. For a better understanding, we create a view on the tables YPERSON and YEU_COUNTRIES.When we create a view, we can choose one of the four view types.

View types

View  types

We choose to create a database view named YVIEW_CMPETITION. At the beginning of the “view definition”, we have to select the view base table (in ourcase, the table YPERSON.After the base table definition, we link this table by defining the joining conditions. To create this link, we use the button “Relationships”.

Creating a view

Creating a view

Joining conditions

Joining conditions

In the next step, we have to select the fields we need in our view. We can enter each field manually or we can use the Button “Table fields”.

View fields

View fields

After activation, we can see our view content using the “Contents Button”.

View content

View content

In this way, we have created a database view on the tables YPERSON and YEU_COMPETITION.

View definition on the database

View definition on the database

By using this view, we can create the context node structure for our Web Dynpro application and so we simultaneously select the logically connected data, from two tables.


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

SAP ABAP Web Dynpro Topics