Many a times it is required to extract data from several tables this can be a time consuming process. To simplify the process and to increase the efficiency of the code, you can define a VIEW. Data is not stored in a VIEW physically. Here data is combined from several tables, but the data is stored in their respective tables. As the name goes a VIEW is just a VIEW of the selected/desired fields from a number of tables. Fields that are not required are hidden. For example if data needs to be extracted from 5 tables with desired fields, then you can create a VIEW of the required fields.
In SAP ABAP a VIEW can be defined in the following ways.
1) By masking one or more fields from a Table.
2) By Linking tables with a Rational Join Operation
3) By defining join condition from a foreign key defined between the tables
There are 4 types of view in ABAP
1) Database Views
2) Projection Views
3) Help Views
4) Maintenance Views
No comments:
Post a Comment