Posts

Showing posts with the label views

Maintenance view

  Maintenance view      *  Maintenance  view is defined to maintain multiple tables data using the transaction code SM30.

Help view

 Help View     *  Help view pick the data from left hand side table. Even though there is no match in the right-hand side table.     *  Help view always involve in two data base tables.     *  Help view is used as a selection method in an elementary search help to provide the possible entries from multiple tables. Steps to create the help view: -          *  Execute SE11.           *  Select the radio button view.           *  Provide the help view name.  Click on create.           *  Select the radio button help view.           *  Enter. Provide short description.           *  Provide the initial table.           *  Click on relationships button.           *...

Database view

Image
 Database view *  If you want to display the data from more than one table then we pick the data from        each table & merge its & display it.   Then it's  better to create database view.  *  Database view is always involved with more than one table. Steps to create database view: -          *  Execute SE11.           *  Select the radio button view.           *  Provide the data base view name.           *  Click on create. Enter.           *  Provide short description.           *  Provide the related tables in left table. Select all tables. Click on relationships.           * Select the check box. Enter.           *  Click on view fields tab.  ...

Projection view

Image
     1.  Projection view          *   If you want to display the part of data from single database table, it's better to create projection view.          *   Projection view is always involving single database table.          *   Fetching the data from view is faster than fetching the data from database table.          Steps to create projection  view.               *  Execute SE11.               *   Select the radio button view.                *  Provide the projection view name.                *  Click on create.                *  Select the radio button projection view.   ...

Views and its types in abap

Views      *   Views are logical databases. It doesn't contain the data permanently.       *  At run time only view contains the data.     *  There are 4 types of views.           1. Projection view           2. Data base view           3. Help view           4. Maintenance view