apply check tables to database tables

[Karan_Chopra_]

how to apply check tables to database tables???

plz help

[Former Member]

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

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.

[former_member188829]

Hi..

http://help.sap.com/saphelp_erp2004/helpdata/en/cf/21eb95446011d189700000e8322d00/frameset.htm

[Former Member]

Hi

select the field in the table.click on key icon.there you can assign check table to the field

[Former Member]

Hi.

By setting the Foreign key..

Steps:

1,Goto to Tcode se11.

2,Give the Table name which u need to Connect with check table.

3,Select the particluar field and click the Foreign Keys(Button).

4,Give the short text.

5,Mention the Check Table name(Which table u need to refer).

6,Click Generate Proposal button.

7,If u need Cardinality means,(U may Set.. else no need).

8,Press copy button.

Now u link ur table with parent table by using Foreign key.

Regards

Bala..