Views in ABAP

Have you ever seen the views outside your window? Let’s suppose that a beautiful girl leaves just in front of your house with her parents. Now suppose you have a big window in your room from where you can see windows of both the girl and her parents. If you just want to see the girl, then you can use curtains to hide one part of the window, if you want to check her parents’ activity you can move the curtains again. That is Views in ABAP.

Views in ABAP helps us to see what we want to see from one table or many.

 

Definition

A View is a reusable object which doesn’t stores any data physically but is derived from one or more tables.

Mandatory steps to make Views in ABAP

 

Step 01: Open SE11 and choose Views Radio Button. Enter the name and Type of the View

Step 02: Select the tables for view.

Step 03: Link tables using Join Conditions.

Step 04: Select the fields from tables; these will be only visible in the views.

Step 05: Define the selection conditions which will restrict the records in the view.

 

Types of Views

 

VIEWS TYPE JOIN USED Description
Database Views Inner Join A View that integrate multiple Table into a single View.
Projection Views N.A A View that shows only few fields of single Table.
Help Views Outer Join A Search Help can show data from Table or Structure. But if you need data from multiple tables then we create a Help View for Search Help.
Maintenance Views Outer Join Unlike Database View where you can only View Data, if you want to maintain multiple Table @ a single place using View then we create Maintenance Views.

 

*NOTE: To know more about Joins click here.

 

Example

Requirement: You have three tables of Employee:

  1. ZEMP_DETAILS that have Employee Details like Employee ID, USERNAME, PASSWORD, NAME, and Date of Birth.
  2. ZEMP_ADDRESS that have Employee Details like Employee ID, Employee Address, Town, State, and Country.
  3. ZEMP_SALARY that have Employee Details like Employee ID, Employee Basic Salary, Allowance and Tax.

Now you want to view all the details of an employee altogether. What will you do?

 

Proposed Solution:  We will create a view which will be based on Employee ID.

Views in ABAP

From above View we can see how we can project multiple tables altogether.

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Translate »