0

Getting Started with ABAP: How to Create Projection View

 3 months ago
source link: https://blogs.sap.com/2022/06/24/getting-started-with-abap-how-to-create-projection-view/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
June 24, 2022 3 minute read

Getting Started with ABAP: How to Create Projection View

This is the next blog post in this series. Here is the previous blog post Getting Started with ABAP: How to Create Database View Part 2

In the previous blog post, we learned how to create database view on more than one table.

In this blog post we will learn how to create projection view.

What is Projection View?

Projection view can be created on only single table. In this view only required fields are selected from a table.

Using Projection View, we can read data and maintain data of single database table.

How to create Projection View

Step 1: Go to SE11. Select view and enter the name of the view. Click on Create.

1-101.png

Step 2: Select Projection View and press Enter.

2-38.png

Step 3: Enter short description.

3-33.png

Step 4: As Basis table you can enter only one table name. Enter the table name.

4-36.png

Step 5: Click on Table Fields.

If you want to maintain data into database table through Projection View then you need to select all key fields of the table.

Here I selected 4 fields from the table.

5-30.png

Step 6: All selected fields will get added in projection view.

6-34.png

Step 7: Select Maintenance Status tab. You can see there are two options in Access.

I want to maintain table hence I selected read and change.

7-32.png

Step 8: Save and Activate it. Click on Contents and Execute.

8-29.png

Step 9: Data is present in the database will be display through projection view.

9-30.png

Step 10: You can add entries by clicking on Create.

10-23.png

Step 11: Enter data and save.

11-22.png

Step 12: Here you can see entry is added. You can check your database table.

12-20.png

Step 13: If you want to edit entries just select that entry and click on Change.

13-20.png

Step 14: You will be able to edit field value except key fields. Save it.

14-15.png

Step 15: You can check your database table whether value is changed or not.

15-14.png

Step 16: If you want to delete entry select that entry and right click on it. Select Delete.

16-11.png

Step 17: Click on Delete Entry.

17-10.png

Step 18: Check your database table.

18-8.png

Here we have created projection view. Also, we learned how to maintain data through Projection View into database table.

Follow my profile to be notified of the next blog post. Please feel free to ask any questions you have in the comments section below.


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK