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

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

 Welcome back everyone. So basically, we have created our ZAR_HEADER table yesterday, So we will learn how to maintain { insert, update, delete } data in the table. Open the table in change mode → go to utilities → table contents → create Entries. We can see the client number automatically appears. Enter the following details and click on save. You will get the message, database records successfully created. Similarly put some more records and click on save. If, I want to see the records in the button, there is a content button {Ctrl + Shift + f10}→ click on this button and press f8 {execute button }. OR You can click on utilities → table contents and display Changing data in table :- Note :- We can change, only non primary key data in our table. Display the entries, select the row where you want to change the data and click on change pencil button. Click on save and data will be changed, Again note we can only change data in non primary...