What is a check table and what is a value table in SAP?
Page 1 of 1
What is a check table and what is a value table in SAP?
Check table specified in the foreign key for the field. A foreign key links two tables T1 and T2 by assigning fields of table T1 to the primary key fields of table T2.
The T1 is called foreign key table (dependent table) and table T2 the check table (referenced table).
In some cases you can see when you define a domain that all the table fields or structure components referring to this domain should be checked against a certain table. This information can be stored in the domain by entering a value table.
The system proposes the value table as check table when you try to define a foreign key for the field or component. This proposal can be overridden.
Example:
Domain S_CARR_ID (data type CHAR, length 3) in the flight Model describes the three-place code of the airlines. All the airlines are listed together with their codes in table SCARR. It is generally advisable to check fields referring to domain S_CARR_ID against table SCARR. SCARR is therefore entered as value table for domain S_CARR_ID. If you want to define a foreign key for a field referring to S_CARR_ID, SCARR is proposed as the check table.
A check is not implemented by simply entering a value table! The check against the value table only takes effect when a foreign key has been defined.
Similar topics
» How do you configure check deposit?
» What is the clearing basis for check deposit?
» Define "Check " statements, how it works?
» Where do you attach the check payment form?
» Describe the syntax and function of the AUTHORITY CHECK command?
» What is the clearing basis for check deposit?
» Define "Check " statements, how it works?
» Where do you attach the check payment form?
» Describe the syntax and function of the AUTHORITY CHECK command?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
Mon Aug 20, 2012 4:37 pm by Admin
» Difference between Type and Like
Thu Jun 07, 2012 2:40 pm by Admin
» How to handle table control fields in Module Pool program?
Wed May 09, 2012 2:41 am by govind
» Three tables inner join in SAP
Thu May 03, 2012 4:47 pm by Uma_ABAP
» Creating table type in ABAP
Sat Apr 28, 2012 9:03 pm by Uma_ABAP
» Creating user defined types and structures in ABAP
Sat Apr 28, 2012 8:55 pm by Uma_ABAP
» Creating Dynamic Internal Table and Dynamic Field catalog in SAP-ABAP
Fri Apr 27, 2012 11:00 am by Admin
» Copy Custom PF-Status from Standard program to Custom Program in ALV
Thu Apr 26, 2012 9:52 pm by Uma_ABAP
» Calculate/find number of working days between two dates in SAP
Tue Apr 24, 2012 2:06 pm by Uma_ABAP