Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Overview of master data tables with number of records + delete

Hi all,

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'?

Thx,

Ciao

Joke

replied

Ok,

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!

Diogo.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question