check table and value table

[Former Member]

frends please let me know ,what is acheck table and a value table?and how are we goin

to use them?(in detail)

[Former Member]

Hi rajareddy....

<b>CHECK TABLE:</b>

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

Table T1 is called the foreign key table (dependent table) and table T2 the check table (referenced table). The pair of fields for the two tables must have the same data type and length. One field of the foreign key table therefore corresponds to each key field of the check table. This field is called the foreign key field.

ALSE SEE:

http://help.sap.com/saphelp_nw04/helpdata/en/63/1b70bcc32111d1950600a0c929b3c3/frameset.htm

<b>VALUE TABLE:</b>

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.

Value table is used to generate praposal for a checktable

ALSO SEE:

http://help.sap.com/saphelp_erp2005vp/helpdata/en/e2/667092730811d2959500a0c929b3c3/frameset.htm

Reward points if useful......

Suresh......

[Former Member]

value tables are the tT tables ie T001n T001w etc these are the table contains all the possible entries for that particular fields,like company mastr will contain all the possible companies for that order,

now when you use those values as a foreign key for any db table like MARC for Plant we have a check table T001W which in itself is a value table for plant/branch

value tables solves the perpose of check tables but reverse is not true

[gastn_jareo]

A value table is a list of possible values that you can declarate for a domain. Each value can have an asociated description. The developer shold charge it and their remain fixed. Is typically for a field that can have few and fixed options.

Ex1:

Y Yes

N No

Ex2:

1 Monday

2 Tuesday

3 Wednesday

4 Thursday

5 Friday

6 Saturday

7 Sunday

A check table is a table validating declaration for de database. You can declarate a table relation an the database is going to check if that relation is accomplished. Is usefull for maintain database integrity. The check list is dinamical since is done to the cointain of a database table. The list of possible values could be really large. And you can declare a relation with more than only one field.

Ex1:

KNA1-MANDT --> T000-MANDT

Ex2:

KNA1-MANDT --> T005S-MANDT

KNA1-LAND1 --> T005S-LAND1

KNA1-REGIO --> T005S-BLAND

In this case note that the combination of all three fields should be in T005S to allow the insertion of each field on KNA1.

And note that on SE11, check table column, you see only the table. To see other options, like fields, click on the proper line and push Foreign Keys button (Key iccon).

Hope it helps.

[Former Member]

1. A check table will validate the screen entries while entering data whereas a value table does no such job.

2. A check table will give you F4 help in entering data whereas a value table will not.

3. A value table for a domain will be proposed when trying to establish a foreign key relationship.

Further reading:

http://help.sap.com/saphelp_erp2005vp/helpdata/en/e2/667092730811d2959500a0c929b3c3/frameset.htm

Reward if I was of helpful to you

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

regards,

keerthi

[Former Member]

check table is the condition that restrict the entries in the foreign key table . if we create the A as foreign key table having f1,f2,f3 as fields.B is another table with fields f3 ,f4,f5 then the foreign key relation ship is developed as follows

A is foreign key table

B as check table

that means the entries in field of f3 of table B is only allowed to enter in field of f3 in table A. but in case of value table it does not restrict the entries but propeses that contained in as f4 help. if u enter other than the entries in value table also it takes the entries.