check tables

[Former Member]

Hi all!

How to create check tables ?

regards

Praneet

[Former Member · Accepted solution]

Hi

The check table is a std table, you assign a check table to a field when you assign a foreign key.

Max

[Former Member]

hi praneeth,

check table is a standard table which is mainly used for referential integrity purpose.check tables are used with foreign keys for data integrity(for checking values of key fields).

if useful reward some points.

regards,

suresh babu.

[Former Member]

hai ,

Check table is a table which has a primary key .When U give the relationship between two tables

for ex: in transaction table when u select a row and assign it as foreign key and click on foreign key symbol present next to search help key in the dictonary ,then it will ask for check table name ,we have to give the parent table name .

Check table is mainly used to validate the entries in the transaction table.

Go to se11-Create two tables Sflight and Tflight

-both the tables have the flight no field,

-in sflight ,the primary key is flightno,

-inTflight,the foreign key is flightno,

In Tflight table select the flightno row and assign it as foreign key by Clicking on the foreign key symbol which is present next to search help key .

After clicking that symbol,it will ask for the check table name ,enter the Sflight here.(Since it is the parent table ).Now the check table is created.

Regards,

Lakshman

[Former Member]

Hi Praneeth,

<b>Suppose you have two tables A and B.

B has a field which is a foreign key referring to a field in A.The filed in B may or may not be a primary key.

Then A is said to be a check table for B.</b>

So as soon as you create a foreign key for a table,say, 'B' referring to another table,say, 'A'; A automatically becomes the check table.

To create a foreign key for a table , follow the following steps:

<b>Go to SE11.

Write the database table name.

Select the field you want to make as foreign key.

Click on the foreign key tab.

Give the check table name.

Generate proposal.

Copy.</b>

Then your foreign key ( autimatically the check table) is created.

<b>Note:</b> The data type of the foreign key feild must be the same as that of the field , it is referring in the check table.

Hope this solves yor problem.

do reward with the points if satisfied .In case of doubt , do let me know.

Thanks and regards,

kunal.

[Former Member]

Hi all!

I have to create a check table ZTVM6 based on the functionality of standard check table TVM1.I am creating custom field ZZMVGR6 to be added to MVKE table.

Please advise

Points rewarded

Praneeth

[hymavathi_oruganti]

COPY TABLE TVM1 TO ZTVM1 AND make the changes u needed.

now assign this check table to the field

[Former Member]

Create your check table based on the standard table.

now assign this check table(ZTVM6) to the field (ZZMVGR6)

[Former Member]

Hi all!

You mean i shall create it as a normal SAP table and attach it to the field through foreign key relationship?

Am i right?

regards

Praneeth

Points rewarded

[Former Member]

Hi Praneeth,

You can copy the table TVM1 to the custom table ZTVM6.

Then after go to the table MVKE where you have added the field ZZMVGR6.

After that you can follow the <b>steps</b> which i have written in earlier reply.

It solves your problem.

[Former Member]

Yes. ofcourse.

now you are getting the solution.

[Former Member]

Hi Kunal

Thank you very much !

My issue is resolved.

Points rewarded.

Regards

Kumar

[former_member188685]

Hi,

Check tables help..

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

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

regards

vijay

Message was edited by: Vijay Babu Dudla

[hymavathi_oruganti]

create a foriegn key relation ship for the field in another table.

then it will ask for check table.

suppose A is a table. B ia a table.

i want to build foriegn key relation ship for a common field in both the tables.

go to B, click on foriegn key relation icon for the particular field, it will ask for check table.

<b>NOTE: if, for the common field , if there ia value table defined already in table A, THEN check table FIRST PROPOSES THE NAME OF THE value table as the CHECK TABLE.</b>