on 10-02-2008 3:30 PM
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
Hi there,
You can use the program RSDMD_DEL_MASTER_DATA to delete all the master data of an InfoObject.
Diogo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok,
So try this...
Create a program that reads all objects (field CHABASNM) from table RSDBCHATR where OBJVERS = A.
This will give you a list of all InfoObjects that have attributes (master data). For each of them call the function module named RSDMD_DEL_MASTER_DATA (I was referring before a function module not a program, sorry) that will delete all the master data for an InfoObject.
Diogo.
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.
Don't know about a standard program, but how about an ABAP that does a count of the n° of records in the P/Q tables and write it to the screen?
The mass deletion: I remember another topic with the same question, and the answer was: no
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.