Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to check tables integrity

Former Member
0 Kudos

Hello all,

we have a big problem in CO area. Since last week we can't calculate production order costs and product costs.

We have check all the things we can, including notes, and the only thing we think that could solve the problem is to check the integrity of tables.

Is there any program, transaction, or anything to make it?.

thanks a lot.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

Please try this once more.

Go to SE11.

Enter the data dictionary table in the 'Database Table' field.

Click 'Display' and press 'Enter'.

The page 'Dictionary: Display Table' will open.

Please click on the 'Entry Help/Check' tab.

Observe the fields 'Foreign Key' and 'Check Table'.

Reward if this is of help.

4 REPLIES 4

Former Member
0 Kudos

open the table in SE11

go to ENTRY HELP / CHECK tab

u can find the related tables

Narendra

0 Kudos

I didn't find this option into SE11 t-code. Could you give me more details?.

And to check integrity between tables?

Former Member
0 Kudos

Hi,

Please try this once more.

Go to SE11.

Enter the data dictionary table in the 'Database Table' field.

Click 'Display' and press 'Enter'.

The page 'Dictionary: Display Table' will open.

Please click on the 'Entry Help/Check' tab.

Observe the fields 'Foreign Key' and 'Check Table'.

Reward if this is of help.

Former Member
0 Kudos

Hi you can use Tcode SQVI

enter your tables in that

and execute

Hope its Useful..