0
Step by Step Maintenance View Creation
Maintenance View - This view is used to for data manipulation like insert, update, delete, modify etc. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is the data is entered via the view and then distributed to the underlying tables by the system

1) Go to TCode SE11. Select radio button view and enter name of view. Click on clip_image001 button.
clip_image002

2)  Choose the view type as Maintenance View and Press clip_image003 button.
clip_image004

3) Provide the short text and in the Tables section provide the table and click on the clip_image005 Button.
clip_image007
clip_image009

4) Select the combination and click on clip_image003[1] Button.
clip_image010
clip_image011

5)The Join condition is automatically field based on the two table matching fields.
clip_image013

6) Click on View Field tab.
clip_image015

7) Click on the Table Fields.
clip_image017

8) Select the first table and click on the clip_image018 Button.
clip_image020

9) Select the required fields from the table to add it in the View and click on the COPY Button.
clip_image022

10) All the fields from table are added to the Maintenance View.
clip_image024

11)Click on the Maintenance Status Tab and select the appropriate Radio Button and activate the View.
clip_image026

12)Now save the view by pressing clip_image027 button present in standard tool bar. Then activate the view with clip_image028 present in application tool bar.
clip_image029

13) To Create the Table Maintenance, Click on Utilities and then click on Table Maintenance Generator.
clip_image031

14 )Provide the details and click on the Find Scr. Number(s) Button.
clip_image033

15) Select the First Radio Button and then click on the clip_image034 button.
image

16) Now go to TCODE-SM30 and provide the Maintenance View name and click on Maintain button.
clip_image037

17) It shows the data from two tables and here you can create new entries, modify existing entries and delete Entries.
clip_image038

Article By
Mohammed Khalid Khan
ABAP Consultant

Post a Comment

 
Top