Creation Of Maintenance View

Step 1. Provide the view name as given below and Click on Create Button.

 
Step 2. Select the Maintenance View Radio Button and Click on COPY button.

Step 3. Provide the short text and in the Tables section provide the table name 'SPFLI' and click on the Relationships Button.

 
Step 4. Select the combination as marked  and click on COPY Button.

 
Step 5. The Join condition is automatically field based on the two table matching fields. Now click on the View Flds Tab.

 
Step 6. Click on the Table Fields.

 
Step 7. Select the 'SPFLI' table and click on the Choose Button.

 
Step 8. Select the required fields From the table to add it in the View and click on the COPY Button.

 
Step 9. All the Selected fields From the Table are populated in the view and then click on the Table Fields Button to add some fields from SCARR Table.

 
Step 10. Select the SCARR table and click on the Choose Button.

 
Step 11. Select some fields and then click on the COPY Button.

 
Step 12. All the fields from two tables are added to the Maintenance View.

Step 13. Click on the Maint. Status Tab and select the appropriate Radio Button and activate the View.

Step 14. To Create the TMG , Click on Utilities and then click on Table Maintenance Generator.

Step 15.  Provide the details and click on the Find Scr. Number(s) Button.

Step 16. Select the First Button and then click on the Tick button.

Step 17. System automatically fills the Overview Screen Number and then click on the Create button.

Step 18. Now go to TCODE-SM30 and provide the Maintenance View name and clikc on Maintain button.

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

Creation of Projection View

Step 1. Go to TCODE- SE11, Select the View Radio button and provide the view name and then click on the Create button.

Step 2. Select the projection View Radio button and click on Copy Button.

Step 3. Provide the Short text. Provide the Basis table 'VBAK' on which we are going to create the Projection view. At last Click on the Table Fields Button.

 

Step 4. Select all the necessary fields from the table that we want in our projection view and then click on Copy button. Activate the Projection view and click on the Display Contents Button.

Step 5. Click on the EXECUTE/F8 button.

 
Step 6. It displays all the records with selected filled.

Creation Of Data Base View

Let's Create a data base view for the two demo tables : SCARR and SPFLI. 

Step 1. Go to TCODE-SE11, Select the iew button and Provide the view name

Step 2. Select the Database View button and click on the Copy button.

Step 3. Provide the Short text and click on the Table/Join Conditions Tab. In the Tables Section provide the table name as 'SPFLI' and click on the Relationships Button. ( First provide the Foreign key table or the dependent table name. In this case between 'SCARR' & 'SPFLI', Spfli is the foreign key table and Scarr is the Check table)

Step 4. Select the Suitable pair and click on the copy button.

Step 5.  Join Conditions are automatically filled based on the two table .

Step 6. Click on the View Flds Tab and then click on the Table Fields button.

Step 7. Select the SPFLI table and click on the CHOOSE button.

Step 8. Select the fields of the table to  include them in the data base view and click on Copy Button.

Step 9. All the selected fields are added to the data base view from the SPFLI  table and again click on the TABLE FIELDS button to add some fields from SCARR table.

Step 10.  Now select the SCARR table and click on the Choose button.

Step 11. Select the necessary fields for the SCARR table and click on the Copy button.

Step 12. Different fields from two  tables are added to the data base view and then click on the active button and then click on the Display contents button.

Step 13. Now Click on the Execute button.

Step 14. The data base view shows values fro two different tables.

----------------------------------------------------------------------------------------------------------------------------------