check tables

[Former Member]

can any one tell me where check tables are used?

Thanks.

[naimesh_patel]

Check table contains the foreign key relationship for that perticular field.

Regards,

Naimesh Patel

[varma_narayana]

Hi

Check Table: means the Table that contains the Primary key in the Foreign key definition.

It has 2 important uses:

1. To validate the inputs in the foriegn key field (For Eg: MARC-MATNR) with the values existing in the check table - Primary key field (Eg: MARA-MATNR)

Here MARA is the Check table for the MARC-MATNR

2. To provide the input help(F4) for foreign key field

<b>Reward if helpful.</b>

[Former Member]

Hi SRINIVAS ,

Check table :

Check table is for Field level checking, that is check table most important role in Forgien key relationship, Foreign key relationship is validate the data being entered into one table by checking against valid set of values in another table .

the table contains valid set of values called check table.

<b>

For Example:</b>

VBAP(Sales Document Item Data) table contains VBELN(Sales Document no)field, Here by checking against valid set of VBELN Values in VBUK Table(Sales Document: Header Status and Administrative Data), VBAP is Foriegn Key Table ,

and <b>VBUK is a Check Table</b>.

[Former Member]

HI

Check table

Table whose key fields are used to check the foreign key fields (see Foreign Keys). Only entries that are contained in the key fields of the check table can be contained in the foreign key fields.

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

<b>Reward if usefull</b>

[Former Member]

check table is the field level checking. we can use the Cardinality based on ur requirment.

see the example.

if ur using two tables like ekko and ekpo.

ekko tables having the fields ebeln , bukrs and lifnr.

here primery key is ebeln.

ebeln bukrs lifnr

101 1000 1000

102 1000 1000

103 2000 1001(this is entry for ekko).

we want to insert the entry based on ekko tables.so ekko table is the ckeck table.

ekpo table is the itam table.

ekpo tables having the fields ebeln , matnr , menge .

here forign key is ebeln.

ebeln matnr menge

101 m-1 10

101 m-2 2

101 m-4 18

102 m-8 7

103 m-5 8

in ekpo table we can't enter other than ekko-ebeln value.

so we can enter only based on ekko-ebeln table entries.