Welcome to Amrit's World of SAP

 Welcome back everyone So basically we already have created database view and projection view in our previous blog and in this blog we will see about Maintenance view and help view. Maintenance View Creation :- Note :- We can only create help view, if not more than one record should exits in dependent/secondary tables. Step 1:- Go to se11 and select view radio button and give some name for maintenance view and click on create button. Step 2:- Select maintenance view radio button and press enter → give short description. Note:- Since in our order item table we have multiple data for same data in order header and since maintenance view does not allow presence of multiple data in secondary table. Therefore, we will be creating two more tables with the following data in them, and then we will start with the maintenance view.      So, basically create the two tables, I don’t think it will cause any problem to anyone because we already have discussed in details how to create a ta

 Hello everyone, we are back again and we will start with the practical implementation of database view and projection view. Creation of Database View :- Step 1:- Go to se11 and select view radio button and give a name { ZAR_DATABASE_VIU } and click on create button. Step 2 :- Select the database view radio button and press enter. Step 3 :- provide the short description. Requirement :- We have to create a database view which include our created Order header and order item table and it consists of following fields :-      Step 4:- In tables column pass the name order header table and click on relationship button { It will show the table which has relationship with order header table }. Step 5:- Select the radio button and click on copy, now the screen will look like this. Step 6:- Click on view fields where select table fields button, then the screen will look like this. Step 7:- Select the first table and select any number of fields that you want in your d