View Cluster


 View Cluster: is generally a hierarchical arrangement of data the is distributed across multiple tables with foreign key relationship.

 Step1. Go to SE11 and create a maintenance view. Provide the name and click on create button.

 Step2. Select the Maintenance view radio button and click on Copy button.

 Step3. Provide the description and in the Tables tab provide ‘SCARR’ as table name and click on View Fields.

 Step4. All the key fields are automatically added to the view. To add more fields click on the button Table fields.

 Step5. Select some fields and click on Copy button to add.

 Step6. All the selected fields of the table are added to the view. now activate the view.

 Step7. Creating the Table maintenance generator. Navigate along the highlighted path.

 Step8. Provide the function group name, screen number and click on the create button to complete the TMG and then Go BACK.

 Step9. Now click on the Contents button.

 Step10. It shows all the records.

Step11.  Go to SE11 and create a maintenance view. Provide the name and click on create button.

 Step12. Select the Maintenance view radio button and click on Copy button.

 Step13.  Provide the description and in the Tables tab provide ‘SPFLI’ as table name and click on View Fields.

 Step14.  All the key fields are automatically added to the view. To add more fields click on the button Table fields.

 Step15. Select some fields and click on Copy button to add.

 Step16. All the selected fields of the table are added to the view. Now activate the view. Now Under the COLUMN ‘P’ provide value ‘S’ for MANDT and CARRID.  S- as a subset. The records are displayed based on these two fields.

 Step17.  Creating the Table maintenance generator. Navigate along the highlighted path.

 Step18. Provide the function group name, screen number and click on the create button to complete the TMG and then go BACK.

 Step19. Now click on the Contents button.

 Step20. As these fields are defined as ‘S’ under the column ‘P’, when clicked on the contents button a popup is called based on which the records are populated.

 Step21. The records are displayed as shown below.

 Step22.  Go to SE11 and create a maintenance view. Provide the name and click on create button.

Step23. Select the Maintenance view radio button and click on Copy button.

Step24. Provide the description and in the Tables tab provide ‘SFLIGHT’ as table name and click on View Fields.

Step25.  All the key fields are automatically added to the view. To add more fields click on the button Table fields.

 Step26. Select some fields and click on Copy button to add.

 Step27. All the selected fields of the table are added to the view. Now activate the view.

 Step28. Creating the Table maintenance generator. Navigate along the highlighted path.

 Step29. Provide the function group name, screen number and click on the create button to complete the TMG and then go BACK.

 Step30. Now click on the Contents button.

 Step31. As these fields are defined as ‘S’ under the column ‘P’, when clicked on the contents button a popup is called based on which the records are populated.

 Step32. The records are displayed as shown below.

 Step33. All the maintenance view are created to create a View Cluster. Now go to TCODE-SE54.

 Step34. Click on the Edit View Cluster Button.

 Step35. Provide the View Cluster Name and click on the Create button.

 Step36. Under the Header Entry, provide short text and double click on Object Structure.

 Step37. Under Object Structure Click on New Entries Button.

 Step38.  Now provide the three above created maintenance view in hierarchical manner. Provide the short text for all. Set the position. Select the view ‘ZMV_SCARR’ as the start. 

Step39. Now select the first line and click on Field-dependence button.

Step40. A success message is displayed for the same.

 Step41. Now select the second line and click on Field-dependence button.

 Step42. A success message is displayed for the same.

Step43. Now select the third line and click on Field-dependence button.

 Step44.  A success message is displayed for the same. at last click on the BACK button .

 Step45.  In the Header Entry section, click on the Activate button.

 Step46. Click on the YES button and Go BACK.

Step47. Click on the TEST button to test the View Cluster.

 Step48. Now the records from ‘ZMV_SCARR’ is displayed.

 Step49. Select a particular line and double click on the ‘SPFLI’ line.

 Step50. All the records based on the CARRID is displayed.

 Step51. Now select a particular line under ‘SPFLI’ and double click on SFLIGHT .

 Step52. Based on that all records form ZMV_SFLIGHT is displayed.


 

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 )

w

Connecting to %s