- Projection Views can be created only on single tables.
- Selection conditions cannot be specified for a Projection View.
- The relational operator projection is used to remove fields from a cross product table created by join and selection. Information that is of no interest for the particular view can thus be masked out i.e, the data that is actually required is displayed when the database is accessed.
- It also possible to access Pooled and Cluster tables using Projection View.
- The remaining fields are the fields of the views defined by join selection and projection.
- In a projection, fields, which are used to formulate the selection condition, can also be masked out.
Ex :
Steps :
- Go to Transaction Code SE11.
- Enter the View name Start's with Y or Z<View name > and click on create.
- Select Projection View and click on copy Button.
- Enter the short description.
- Enter the Basic Table name . Ex: VBRP (Billing Document: Item Data ) and press Enter.
- Select the fields by clicking the Table fields button.
- Click on Maintenance status Tab.
- Click on Execute.
Output
To Edit a record
- Select a record and Click on Edit.
To insert a record
- Click on create button.
No comments:
Post a Comment