Monday 13 February 2012

SAP ABAP - Difference between Check Table and Value Table


Many ABAPers gets confused initially with these tables. The difference lies in there Implementation and Behavior. Lets have a closer look at each to understand them better.

Value Table
 This is maintained at Domain Level.

Defining Value Table
In some cases you already know when you define a domain that all the fields 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 this field. You can override this proposal.
 Entering a value table does not implement a check. The check against the value table only takes place when a foreign key is defined.

 Check table
 Table whose key fields are used to check the foreign key fields (see Foreign Keys). Only entries that are contained in the key fields of the check table can be contained in the foreign key fields. 

1 comment: