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.

 


 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s