topic Re: check table and value table in Application Development and Automation Discussions

check table and value table

Former Member — Tue, 05 Sep 2006 14:41:31 GMT

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.

Re: check table and value table

Former Member — Tue, 05 Sep 2006 15:10:09 GMT

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

Re: check table and value table

Former Member — Tue, 05 Sep 2006 15:15:57 GMT

hi,

Check this out..

Regards,

Santosh

Re: check table and value table

abdul_hakim — Tue, 05 Sep 2006 15:23:09 GMT

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....