Finding Tables in which particular Table is used as Check table

[Former Member]

Hi all,

I wand to get the list of tables where a particular table is used as a check table at run time.

Who can i get this list at run time ?

Thanks in advance

Deval Bhatt.

Message was edited by:

Deval Bhatt

[amit_khare]

For finding check table -

Select from DD03L table,

where TABNAME = MARC

Fieldname = WERKS

and u will get CHECKTABLE = T001W.

You may also try FM CHECKTABLE_GET.

Regards,

Amit

Reward all helpful replies.

[Former Member]

I don't want the check table but I want a dependent tables. say for example

I want to know where KNA1 table is used as check table.i.e. dependent table of KNA1(A919,A920,A921,A922...)

How can i get this list run-time ? Is there any table where all dependent tables are stored?

Message was edited by:

Deval Bhatt

[varma_narayana]

Hi..

You can <b>find the Dependent Tables while creating a View</b> (Database view)

Enter your Table Name in the DB View (For Eg : MARA)

(in Tables / Join Relations Tab)

Then Select the Pushbutton <b>Relationships</b>

There it will show the Referenced Tables and <b>Dependent Tables</b> of MARA.

<b>Reward if Helpful.</b>

[Former Member]

Hi

Goto SE11 tcode

enter table name

use where used list

displays the window

select the programs

execute

displays lot of programs

in that you can search some needed program

but what for you need this?

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member]

Hi,

Try with Fm CHECKTABLE_GET

Regards