value table?

[Former Member]

hi experts,

can anyone plz explain about value table.

Difference between value table and check table?

[RaymondGiuseppi]

Value table are used for search helps only (at last resort) where check table are used to check values entered.

Value Table
In some cases you can see when you define a domain that all the table fields or structure
components 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 the field or component. This proposal can be overridden.
A check is not implemented by simply entering a value table! The check against the value table
only takes effect when a foreign key has been defined.

Look at [BC - ABAP Dictionary|http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCDWBDIC/BCDWBDIC.pdf]

Regards

[Former Member]

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.

Check the link below:

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

Reward points if useful.

[Former Member]

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.

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.

[Former Member]

Value table is one which will be have a foreign key relationship with the check table or the table to which you have generated the foreign key propasal.

If a check table is present then it is know as dependent table.

If not then it is an independent table.

[Former Member]

Check table is one which is used as a reference table to get any search help in the form of foreign key relationship for a particular field element.

Value table is another form of reference table within check table for assigning field help with proposed value list for fields.

Value Table

1) This is maintained at Domain Level.

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

3) When ever you use this Domain, the system will forces you to enter only these values.

4) 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

1. For example you have Employee master table & Employee Transaction table.

2. When ever an employee Transacts we need to check whether that employee exists , so we can refer to the employee master table.

3. This is nothing but a Parent & Child relationship . Here data can be maintained at client level , no development involved.

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

[Former Member]

value table

Sometimes whe you define a domain, you already know that all fields that use the domain will need to be checked against a particular table. You can store this information in the domain definition by specifying a value table.

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

check table.

A foreign key links two tables T1 and T2 by assigning fields of table T1 to the primary key fields of table T2.

Table T2 is then known as the check table of the foreign key.

[Former Member]

hope this willl resolve ur query

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.

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.

DO REWARD IF HELPFUL

[Former Member]

Hi Friend,

VALUE TABLE:If the domain of the check field has a value table, this is proposed by the system as check table in the foreign field maintenance. The key fields of the value table are in this case assigned fields of the foreign key table with the same domain. These fields may assume only those values allowed by the value table.

The value range of the domain can be defined by specifying value table.All table fields referring to this domain can then be checked against the corresponding field of this value table.In order the check can be executed, a foreign key must be defined for the value table.

A foreign key provides a link between two tables, for eg.,T1 and T2 by including a reference in table T1 to the primary key of table T2. For this purpose, Foreign key fields assigned to the primary key fields of T2 are included in T1. Table T1, which is the one being checked, is called a foreign key table, and table T2 is called a check table. The terms dependent (foreign key) table and referenced (check) table are also used.

I hope, now you have clear idea.

Thanks,

Best Regards,

Nanbhava

Edited by: Velama Bhavani on Feb 11, 2008 10:09 AM

[Former Member]

Hi,

Value table is a table at domain level, The possible values which are entered in the domain of the field.

check table is a table which is foreign key relation with the foreign key table. check table is the primary table of foreign key.

regards,

kamala.

[Former Member]

Hi,

While creating a domain we can specify the value table for that domain. If we specify a value table, then at the time of setting a foreign key relationship for a field using that domain, a check table proposal will be automatically given with the value table name. We can accept it as our check table or we can choose our own check table to that particular field.

If we choose that particular value table as our check table, then only each entry in that field will be checked with the existence of that data in the check table.

So the value table is used to provide a default proposal for the check table, while creating a foreign key relationship for that particular field which uses the corresponding domain containing the value table.

If not clear just reply with your doubt.

Regards,

Harish.