abam dictionary

[Former Member]

what is check table and value table?

[Former Member]

Hi,

Difference between a check table and a value table:

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.

Check Table : Master Table

Value Table: Table Across Which All the Values Are Selected

Regards,

Satish

[Former Member]

Hi,

Welcome to SDN.

The relationship between check table & value table is maintained by Foreign key. The check table has the possible values, where in when u enter some values in the value table,it checks for the existence of data in check table,if availble accepts it,else wont accept the entered values.

Rewards if useful..

Kavitha

[Former Member]

Sridhar,

Difference between a check table and a value table

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.

Don't forget to reward if useful.

[Former Member]

Check Table - Table Which consists of all possible values for a domain.

Value Table - Whe we create a foreign key relationship with another table the system will look a value table field which is there at domain level. The system proposes that table as a check table for that foreign key.

awrd opints if useful

Bhupal

[Former Member]

hi sridhar,

Check table: An input check for the field can be defined with a foreign key. This input check appears on all the screens in which the field is used.

,or first you must know the concept of foreign keys

foreign key is a field in the table that is connected to another table via a foreign key relationship. the purpose of the foreign key is to validate the data being entered in one table by checking against the valid set of values in another table.the table that contains the foreign key is called the foreign key table.the table that contains the valid set of values is called the 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.

Value Table[/code]

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.

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 Only entries that are contained in the key fields of the check table can be contained in the foreign key fields.

The check table is used to check whether the input values are valid and for the input help (F4 help).

Foreign keyA foreign key creates a link between two tables T1 and T2. Every primary key field from T1 (check table) is assigned a field from table T2 (foreign key field). The fields from T2 assigned to primary key fields are marked as foreign key fields.

regards

Nagesh.Paruchuri

The most important function of the foreign key is the support of data integrity. The foreign key fields can only accept values which appear in the primary key of the check table. During input the values of the foreign key fields can thus be checked against the entries of the assigned key fields of the check table.

Foreign keys are also the foundation for defining lock objects, maintenance views and help views. These objects contain fields from several tables. All the tables used in such an object must be linked with foreign keys

check the below links

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

http://www.geekinterview.com/question_details/16920

Reward if helpful.

thanks and regards

suma sailaja pvn