Views in ABAP

by | Apr 17, 2018 | ABAP Beginner

Home » SAP » ABAP » ABAP Beginner » Views in ABAP

Preface – This post is part of the ABAP Beginner series.

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 TYPEJOIN USED Description
Database ViewsInner JoinA View that integrate multiple Table into a single View.
Projection ViewsN.AA View that shows only few fields of single Table.
Help ViewsOuter JoinA 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 ViewsOuter JoinUnlike 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.

Author

0 Comments

Submit 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.

Author