Welcome to Amrit's World of SAP

 Welcome back everyone, So we have discussed how to create a transaction code in last blog and we will continue with database utility in this blog. Database Utility :- The database Utility acts as a interface between ABAP dictionary and the database. The purpose of database utility is that, it allows you to edit database objects. You can call the database utility from the initial screen of the ABAP Dictionary with Utilities → Database Utility or we can use the transaction code SE14. Requirements :- We have to change the length of the domain order number. Suppose, we have to increase the length to 12. As soon as, I will try to activate the domain, a pop up screen will appear showing where our domain is being used. Click on continue, we will get 2 errors, because our domain is being used in 2 tables as shown above. So, for this kind of purpose we use database utility. Step 1 :- Go to se14 Step 2 :- give the header table name and click on edit. S

 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

 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 key