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 […]
ABAP Dictionary Maintenance View Read More »
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.
ABAP Dictionary Database View Read More »
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.
ABAP Data Dictionary Views Read More »
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
ABAP database Table foreign key relationship Read More »
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
SAP ABAP Domain fixed values and value range Read More »
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
ABAP Database Table create secondary index Read More »
