To maintain data distributed across several tables, we need maintenance view. Data distributed across more than one table forms a logical unit, referred to as application object. Only tables linked with foreign key can be used in a maintenance view. It is required to create the maintenance user interface by using tool Table Maintenance Generator …
Database view are created to get an application-specific view of data distributed across several database tables. Steps to create Database view To create the database view, we will use the two tables employee and department tables.
In SAP ABAP Data Dictionary, we have 4 types of views. Generally, a view is created over one or more tables to provide application-specific views of data in multiple tables. A view gives an overview of data from several tables. A view does not store data physically but derives data from the underlying tables.
Foreign keys are required to ensure data consistency through input checks by checking the data against input checks. Foreign key is a Field in one Table that is connected to another table via foreign key relationship and the purpose is to validate the data being entered in one table ( Foreign key table ) with …
The value range tab of domain is used to restrict the values that a domain will take. We can assign fixed values and intervals to a domain. The fixed values serve as F4 help as well as performs input validation for the fields on the screen defined using that domain. Assign fixed values to domain …
Database table indexes Table indexes are required for speed selection of data records from a database table. Type of indexes in SAP ABAP database table There are three types of indexes: Primary index, Secondary index and Extension index. Every database table has a primary index. The primary index is created automatically by the system when …
