A single maintenance view can be used to modify the content of multiple related database table consistently.
All database tables grouped in maintenance view must be joined using foreign key relationship. The first table included in the maintenance view is known as the primary table of the maintenance view. The tables added to this primary table using foreign keys are known as secondary tables.
While selecting secondary table make sure
- If secondary table is check table then no more than one dependent data record exists in each of the secondary tables for a specific data record in the primary table
- If secondary table is Foreign key table then the foreign key fields must be key fields of a secondary table
How to Create Maintenance View
Step 1: Go to SE11. Select view and enter name of maintenance view.
Step 2: Click on Create. Select Maintenance View.
Step 3: Enter short description.
Step 4: I have two tables. One is Employee table and another one is department table.
ZAKTABLE
ZAK_DEP
Employee_id field is foreign key in ZAK_DEP table.
Enter ZAK_DEP name in table column first.
Step 5: Click on Relationships. Here we can see that ZAK_Dep table is connected using foreign key. Select that table.
Step 6: Join condition will be added.
Step 7: Click on View Fields.
Step 8: Click on Table fields and select first table.
Step 9: select fields from table.
Step 10: Click on Table fields and select second table.
Step 11: select fields name.
Step 12: In selection condition, you can put condition if you want.
Step 13: Here you can see that 4 options are there.
1.Read Only
That means you will be able to read data through maintenance view.
2.Read, change, Delete, and Insert
If you select this option then you will be able to read, change, delete and insert the data into the table through maintenance view.
3.Read and Change
If you select this option then you will be able to read and edit data into database table through this view.
4.read and change (time-specific Views)
If you select this option then you will be able to read and change the data if it is time-specific view. That means key of maintenance view contain data field and time field.
No responses yet