How to create a Database View

Go to SE11 transaction and put some name in place of VIEW.

Press create button and select database view radio button.

Now put some description and add the table names in the table tab.

You have to enter only those tables which have some link/foreign key relationship. And only transparent tables allowed.

Now in the left side provide the join condition of both tables to connect them

Now go to View Fields tab and add all the fields of both tables, that you are interested to see.

In the first column you can put your choice field name. The you have to mention which table field it is referring.

Now save and activate the view.

Go back to SE11 screen and put the view name in place of table name and press display

Press the content button .

We can see our fields that we have added. Now press F8 .

We can see all the data combined in a single place for both the tables.

So database view actually replace a JOIN condition of a select query. Instead of writing a report, we can create a database view to get the required table entries.