Friday 17 June 2016

Projection View


  • 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.

  • Click the view radio button.

  • 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.

  • Select required fields and Click on Copy Button.


  • Selected fields,

  • Click on Maintenance status Tab.
  • Click on read and change Radio button.
  • Save -> Check -> Activate.
  • Click on Contents .

  • Click on Execute.






Output




To Edit a record


  • Select a record and Click on Edit.
  • Existing record's value.
  • Modify a record.
  • Click on save button.

  • Click on Back Button.

To insert a record


  • Click on create button.


  • Before entering record,

  • Enter a record and Click and Save.


To delete a record

  • Select a record.
  • Click on Table Entry.

  • Click on Delete option.

  • Click on Delete Entry.
  • Check the status bar.

                                         more information ........

No comments:

Post a Comment