SAP SE11 can show you per table the consistency of the runtime and database obejects. If you want to do this for all tables, you should have a look at report RUTMSJOB - for sure run it in background (DDIC Check, nametab).
This report - takes some time - but reports in the end on all inconsistencies in your database. This is espcially interesting to check before upgrades, migrations or similar things.
After that the several marked batch jobs are run successful, you can restart this report RUTMSJOB and hit on the button "results". There you find in detail all problems and can then fix them one by one. So, it might be useful, to run these checks on a regular basis.
If you want to increase the performance of this report, you should have a look at note 482519 as it is possible to run with several parallel jobs.
(DDIC Check, nametab)