CC Rules and Risk Deletion

[Former Member]

Hi Gurus,

I have a situation to delete the existing rules and risks ...on CC and reload it..I cant delete all at a time..

Its not allowing me to delete ...connector..Rule sets Risks...Functions Etc.

I have looked at DB level there are lot of tables.Can any one help me what are the tables need the clean up for this.

Or is there any script that SAP provide to remove this data?

[Former Member]

first line start with M + fields within table

next lines relates to the table entries

M VIRSA_CC_BUSPRC BZPRCID

D VIRSA_CC_BUSPRC 05MD

D VIRSA_CC_BUSPRC 05TD

D VIRSA_CC_BUSPRC 06MD

D VIRSA_CC_BUSPRC 06TD

D VIRSA_CC_BUSPRC 07MD

D VIRSA_CC_BUSPRC 08MD

D VIRSA_CC_BUSPRC 50GN

I think you can do this with any table. However, be cautious with regard to consistency between tables.

regards,

sam

(i just posted a urgent post on alert generation --> do you know something about this ?)

[Former Member]

hi,

if you upload the following text file, the corresponding tables are emptied. Take backup first of course.

<your connectorID1<<TAB>>your connectorID2... >

M VIRSA_CC_BUSPRC BZPRCID

M VIRSA_CC_BUSPRCT BZPRCID LANG DESCN

M VIRSA_CC_FUNC FUNCTID SCOPE

M VIRSA_CC_FUNCT FUNCTID LANG DESCN

M VIRSA_CC_FUNCBP FUNCTID BZPRCID

M VIRSA_CC_FUNCACT FUNCTID ACTIONS VSYSKEY STATUS

M VIRSA_CC_FUNCPRM FUNCTID ACTIONS VSYSKEY AUTHTREE FROMVAL TOVAL SEARCHTYPE STATUS

M VIRSA_CC_RISK RISKID RISKLEVEL STATUS BZPRCID UPDDATE UPDTIME UPDUSER ACTGEN PRMGEN RISKTYPE

M VIRSA_CC_RISKT RISKID LANG DESCN

M VIRSA_CC_RISKOWN RISKID OWNUSER

M VIRSA_CC_DETDESC OBJECT_TYPE OBJECT_ID LANG DETAIL_DESCN

M VIRSA_CC_RISKFUNC RISKID FUNCTID

M VIRSA_CC_RISKOWN RISKID OWNUSER

M VIRSA_CC_ACTRULE ACTRISK ACTIONS VSYSKEY FUNCTID RISKID STATUS

M VIRSA_CC_AUTHMAP AUTHKEY SEQUENC VSYSKEY AUTHTREE

M VIRSA_CC_RTMAP ROOTELEM AUTHKEY

M VIRSA_CC_GSEQ SEQTYPE SEQVALUE

M VIRSA_CC_ORGRULE ORGRULEID PRMRISK ORGLEVEL FROMVAL TOVAL SEARCHTYPE STATUS

M VIRSA_CC_ORGRULET ORGRULEID LANG DESCN

M VIRSA_CC_CRROLE VSYSKEY ROLES RULESETID RISKLEVEL STATUS

M VIRSA_CC_CRROLET VSYSKEY ROLES RULESETID LANG DESCN

M VIRSA_CC_CRPROF VSYSKEY PROFILE RULESETID RISKLEVEL STATUS

M VIRSA_CC_CRPROFT VSYSKEY PROFILE RULESETID LANG DESCN

M VIRSA_CC_CRACT VSYSKEY TCODE RISKID RISKLEVEL STATUS

M VIRSA_CC_CRACTT VSYSKEY TCODE RISKID LANG DESCN

M VIRSA_CC_RULESET RULESETID

M VIRSA_CC_RULESETT RULESETID LANG DESCN

M VIRSA_CC_RISKRS RISKID RULESETID

M VIRSA_CC_CRPRM VSYSKEY TCODE RISKID AUTHKEY AUTHSEQ FROMVAL TOVAL SEARCHTYPE STATUS

[former_member184114]

Hi Sam,

Thanks alot for the script. Kindly correct me if I am wrong in the following explanation:

CONNECTION1
M VIRSA_CC_RISKFUNC RISKID FUNCTID

If I write this in notepad and upload this file in VCC, then the data from VIRSA_CC_RISKFUNC RISKID FUNCTID table would be removed only

But could you also tell me how to upload. I mean which is that option?

Rergards,

Faisal

[former_member184114]

I would strongly suggest you to kindly contact SAP and ask for script.

Regards,

Faisal

[former_member366047]

Guru-

Your DB guy can do it, provided you know the tables. Or you can get a script from SAP (recommended)...

Ankur