check and value table

[Former Member]

what is the difference between check and value table ? explain in detail.

[former_member181995]

Pavan,

by the way this question has been asked zillien of time before.

refer link:

http://www.sap-img.com/abap/difference-between-a-check-table-and-a-value-table.htm

Amit.

[Former Member]

Check Table

If a foreign key links two tables T1 and T2 by assigning fields of tableT1 to the primary key fields of table T2, T2 is known as the check table for the foreign key.

Value table.

Table that is specified in the definition of a domain and is to be checked against all fields pointing to the domain.

If you try to define a foreign key for a field that points to this domain, the value table of the domain is proposed as the check table for the foreign key.

Reward if useful.

[Former Member]

Hi..

Fixed values are only checked in screens. No check is made when data records are inserted in a table by an ABAP program.

If you enter a value table, the system can make a proposal for the foreign key definition.

A value table only becomes a check table when a foreign key is defined.

If you refer to a domain with a value table in a field, but no foreign key was defined at field level, there is no check.

[alpesh_saparia3]

Hi,

Check table is related to foreign key concept. where as value table is just to give the default value box called as drop down list.

You assign check table while defning the data base table and Value table is specified in Domain.

[Former Member]

Hi Pavan,

I think this will help you.

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.

[Former Member]

Hi Pavan,

A simple answer is that a check table validates the field at dataelement level where as a value table validates the field at domain level.

Thanks,

Surya

[Former Member]

Hi Pavan.

The major advantage is that:

The fields of the check table will be applicable for F4 help that is input help.

This is not possible for a value table.

Value table is a field in a domain that helps in domain level data validation.

Check table is Unlike the value table it helps in field level data validation.

Also known as referenced table.

Here validation means nothing but checking.

Reward points if usefull.

Regards

Harsh

[Former Member]

Hi,

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.

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.

The Value table is the table attached to a field at the domain level, where the entry to the field can be only from the value table. They are not used in the Input Help.

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.

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.

The Heirarchy which decides from where to used the Input Help is:

1. Input help defined explicitly in ABAP Program or Dialog Module.

2. Input Help Attached to the referenced Database Table field.

3. Using the contents of Check Table as an input help if neither (1) or (2) help are there.

4. Input help from Fixed value or Value range given in Domain.

Plz award me points if u like.

thx & regards,

Prashant.

[Former Member]

Hi,

Check tables are usually meant for currency and quantity fields.

For example you have a data say -- '12' now as per Indian Standards if it is in KGs then it will be displayed as 12.000 kg.

Similarly if it is in inches then it will be displayed as

12.0 inch.

Similarly if it is in meters then it will be displayed as

12.00 m.

The other use is to make a key as a Foreign Key.(Using the primary key of the check table).

The value table is used for attaching a search help to a field i.e. while making entries into the table the user while get an F4 help attached to that field (The values present in the Value table for that field will appear if the user presses F4 help), then the user can select any value which is required.

[bpawanchand]

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.

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.

Regards

Pavan

[Former Member]

Hi

Go through the link given below :

http://www.sap-img.com/abap/difference-between-a-check-table-and-a-value-table.htm

Thanks & Regards

Nikunj Shah

[Former Member]

www.sap-img.com/abap/difference-between-a-check-table-and-a-value-table.htm

www.saptechies.com/difference-between-value-table-and-check-table

chk this

[Former Member]

Hello pavan,

This is a common question in sdn.Please check these links:-

Regards,

Bhumika

[Former Member]

Hi pavan,

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

The Heirarchy which decides from where to used the Input Help is:

1. Input help defined explicitly in ABAP Program or Dialog Module.

2. Input Help Attached to the referenced Database Table field.

3. Using the contents of Check Table as an input help if neither (1) or (2) help are there.

4. Input help from Fixed value or Value range given in Domain.

Regards,

Sravanthi

Edited by: Sravanthi Balabhadrapatruni on Jul 8, 2008 11:04 AM

[suredarreddy_pulimamidi]

Hi pavan,

refer the fallowing link,

[https://www.sdn.sap.com/irj/sdn/wiki]

warm regards,

surendar reddy

[Former Member]

hi,

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

The Hierarchy which decides from where to used the Input Help is:

1. Input help defined explicitly in ABAP Program or Dialog Module.

2. Input Help Attached to the referenced Database Table field.

3. Using the contents of Check Table as an input help if neither (1) or (2) help are there.

4. Input help from Fixed value or Value range given in Domain.

[Former Member]

thanks a lot

[Former Member]

check it

[Former Member]

k