Hi Learners, Today i am going to explain what is check table and value table, what are the difference between the check and value table and steps to create basic check table and value table. Note: Here i am explaining basic level explanation in check table and value table, if you are fresher in A. Value table contain all the possible value assigned to the field of the table at domain level.
When we press the F4 help button it shows all the possible values for that particular field. In simple words value table means domain level checking. Check table on the other hand means Field level checking, For example we have two tables one Product table and other Order table.
When an order is. As per DBMS what we call foreign key table, is called as check table in SAP. There is 1 more important Difference in Value Table and Check Table is that: 1.
The contents of the check will be used as an input help (F4 Help) for a particular field on which a check table is assigned. But the contents of Value Table are never used in Input Help. Value table It is maintained at the Domain level and value table used to provide f4 help.
Value table provides only suggested values. we can put the suggested value and other values also. Check Table It is maintained at the Table level.
In this article we will discuss the Difference between Check Table and Value Table based upon Field level validation and domain level validation. The Check Table is the dependent table to which the relationship is defined using foreign keys. The contents of the check table field are shown in the input help for the referenced field.
Check Table: 1. It contains valid entries of a particular foreign key. 2.
Check table is validation at field level. 3. It is part of table definition.
Value Table: 1. It is part of domain definition. 2.
Value table is validation at domain level. 3. It is used to provide values on F4 help for all the fields which refer to that domain.
In SAP, check tables and value tables are used within the Data Dictionary to enforce data integrity and provide valid value sets for table fields. They are important concepts in database design. Check tables and value tables are both used for validation in ABAP.
Value tables define allowed values at the domain level and must be maintained through a transport request. Check tables validate values at the field level by checking if a value exists in a referenced table. While value tables restrict input values, check tables can also be used to provide input help by displaying the values.
Hi Jagadish, check table: it is a field level validation, whenever we provide check table name (parent table name), after executing automatically f4 help will show in output for that field, system will force you to provide what are the values showing in f4 help. value table: its is a domain level validation. while creating domain we can provide value table i.e header table name, when we are.