check table and value table

[Former Member]

Hi

what is the main diff b/w?

and if specify both check table and value table and if i press F4 which values are populated and what is the sequence of population values for f4.

thanks,

sap-abap.

[ferry_lianto]

Hi,

Value Table - This is maintained at Domain Level.

When ever you create a domain , you can entered allowed values. For example you go to Domain SHKZG - Debit/credit indicator. Here only allowed values is H or S. When ever you use this Domain, the system will forces you to enter only these values. This is a sort of master check . To be maintained as a customization object. This mean that if you want to enter values to this table you have to create a development request & transport the same.

Check table - For example you have Employee master table & Employee Transaction table. When ever an employee Transacts we need to check whether that employee exists , so we can refer to the employee master table. This is nothing but a Parent & Child relationship . Here data can be maintained at client level , no development involved. As per DBMS what we call foregin key table, is called as check table in SAP.

Hope this will help.

Regards,

Ferry Lianto

[Former Member]

hi,

Check this out..

Regards,

Santosh

[abdul_hakim]

check table contains set of allowed values for the primary key fields of the foreign key table.

value table contains set of allowed values for the domain....