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 »
ABAP Table Maintenace Generator is a tool which generates program for table maintenance. This program is useful in maintaining entries of custom table, i.e. create, edit or delete entries of custom table. Note – to create table maintenance program for a custom table, ensure in Delivery and Maintenance tab, Data Browser/Table View Maintenance is selected
ABAP Table Maintenance Generator Read More »
Steps to create transparent tables in ABAP Dictionary For fields empid, firstname, lastname, gender, department, create custom data elements and domain. For fields salary, currency and country, we have used standard data elements. Define fields mandt and empid as key fields by selecting the checkbox in Key column. Also, select check box for Initial Values
ABAP Dictionary Create database Tables Read More »
Table type is a special type that can be used to define internal tables in ABAP programs. You use a table type to describe the structure and functional attributes of an internal table in ABAP. With table type we can define parameters to pass tabular data in functional modules and methods. A table type is
ABAP Dictionary Table types Read More »
