Views and its types

 Types of views


1) database view

*  A view created on two or more tables by clubbing the fields using inner join is called             database view

*  We can only read the data.

*  We cannot do any maintenance operation.

*  A database view can include an entire table.


business reqs->develop a db view on mara ,makt tables to display                                                                     matnr,mtart,mbrsh,meins,spars,maktx.


Steps

       *  Go se11.

        *   Select view and give name as : zdbview1

        *  Click create button.

        * Select the db view.


Projection view

*  A view is created on single table is called pview. 

*  Filter out fields.

* We can read and maintain the data.

*  Projection view improve the performance [because minimize the fields].


business reqs-> develop a projection view on mara tables to display                                                                    matnr,mtart,mbrsh,meins.

Steps

        *  Go se11.

        *  Select view and give name as : zprojectionview1

        *  Click create button.

        * Select the projection view.


Help view 

    *  A view created on two or more tables for search helps is called  help view.

    *  Help view uses outer join concept.

    *   Read data but cannot maintain the data.


Steps

        *  Go se11.

        *  Select view and give name as : zhelpview1

        *  Click create button.

        *  Select the help view.

                

Maintenace view 

        * A view create don two or more tables using inner join concept.

        *  We can read the data and maintain the data.

        * Maintenance view can be create don custom tables.


Steps

        *  Go se11.

        *  Select view and give name as : zmainview1

        *  Click create button.

        *  Select the maintenance view.


Comments

Post a Comment

Popular posts from this blog

bapi introduction

 45 video ([bapi  introduction]) ---------------------------------- --> se84 --> business application programing interface. BOR--> business object repository | |__> business object type | |__>    interfaces  key fields attributes methods events 
Read more

amdp

13 video [amdp procedure -1] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CLASS zajay_class_amdp_procedure DEFINITION PUBLIC.   PUBLIC SECTION.   INTERFACES if_amdp_marker_hdb.   TYPES: begin of typ_sales,          vbeln type vbeln,          auart type auart,          end of TYP_SALES.   TYPES:  begin of typ_mat,           matnr type matnr,           mtart type mtart,           END OF TYP_MAT.    TYPES: tt_sales_details type table of typ_sales,           tt_mat_details type table of typ_mat.   class-METHODS get_sales_details IMPORTING value(im_auart) type auart                                     EXPORTING value(ex_sales_details) type tt_sales_details .   CLASS-METHODS get_materail_details EXPORTI...
Read more

ABAP for all

   1) INTRODUCTION TO ABAP ~~~~~~~~~~~~~~~~~~~~~~ sap --> System application and products functional ---------- > sales > finance > material management > quality > production > hr > logistics > plant maintanace technical ---------- > abap abap--> advanced business application programming. 2) DATA TYPES ,DATA , PARAMETERS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -> simple english to make the program statements. -> every statement must end with period(.). -> space between abap keywords , variables are mandatory. -> alll literals are enclosed with single codes. -> abap key word is not case sensitive. -> three steps--> saved-checked-activated. DATA TYPES ~~~~~~~~~~ --> elementary types --> referance types --> complex data types C -character N- numeric D- date T- time X- hexadecimal String I- integer F -float P- packed declarative keywords -------------------- > data > parameters ...
Read more