topic Re: check tables in Application Development and Automation Discussions

check tables

Former Member — Tue, 20 Nov 2007 03:43:39 GMT

can any one tell me where check tables are used?

Thanks.

Re: check tables

naimesh_patel — Tue, 20 Nov 2007 03:46:42 GMT

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

Regards,

Naimesh Patel

Re: check tables

varma_narayana — Tue, 20 Nov 2007 03:52:45 GMT

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

Reward if helpful.

Re: check tables

Former Member — Tue, 20 Nov 2007 04:47:20 GMT

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.

For Example:

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 VBUK is a Check Table.

Re: check tables

Former Member — Tue, 20 Nov 2007 05:06:02 GMT

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.

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

Reward if usefull

Re: check tables

Former Member — Tue, 20 Nov 2007 05:07:02 GMT

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.