Overview of master data tables with number of records + delete
we took a copy of our BI system and now we are deleting all the data. For the cubes and ODS's it's not that difficult to see if we have deleted everything... but for master data it's something else!
Is there somewhere a function/program/transaction/... to see in which (master data) tables we still have entries? because checking more dan 10000 objects is just crazy...
And is there a way to do 'mass deletion of data'?
You can look for both master data and texts in another table at te same time:
This table RSDCHABAS search for all InfoObjects (field CHABASNM) in version active (OBJVERS = A). If you want to see if you have master data look for the field ATTRIBFL = X (Have attributes), and if you want to see if you have texts look for the field TXTTABFL = 1 (Have texts).
There you go!