on 07-20-2009 8:33 AM
Hello,
Can anyone give me the list of most common (famous) tables/ Frequently accessed tables used in SAP GRC eg. /VIRSA/INT_TRIG, VIRSA/DATA table.
Also can anyone give me the list of most common (famous) tables / Frequently accessed tables used in SAP HR/ HCM.
Thank!!
Hello Abdul,
Here are the names of some of the tables:
VIRSA_CC_GENOBJ
VIRSA_CC_SYSUSR
VIRSA_CC_MGRISKS
VIRSA_CC_BUSPRC
VIRSA_CC_BUSPRCT
VIRSA_CC_FUNC
VIRSA_CC_FUNCT
VIRSA_CC_RISK
VIRSA_CC_RISK
VIRSA_CC_RISKRS
VIRSA_CC_RULESET
VIRSA_CC_ACTRULE
VIRSA_CC_ALLASTRUN
VIRSA_CC_ALTCDLOG
virsa_cc_cract
virsa_cc_cractt
virsa_cc_crprm
virsa_cc_crprof
virsa_cc_crproft
virsa_cc_crrole
virsa_cc_crrolet
virsa_cc_funcprm
VIRSA_CC_lastrun
virsa_cc_prmrule
virsa_cc_systemc
VIRSA_CC_ACTVL
VIRSA_CC_PRMVL
VIRSA_CC_CRACTVL
VIRSA_CC_CRPRMVL
VIRSA_CC_ROLEVL
VIRSA_CC_CRROLEVL
virsa_cc_MGALERTS
virsa_cc_MGCRTR
All the above mentioned tables are related to RAR application.
Regards,
Varun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Abdul,
Here are some of the important tables of CUP :
VIRSA_AE_REQD_HDR
VIRSA_AE_REQ_ARCH
VIRSA_AE_REQ_DTL
VIRSA_AE_RQD_FWD
VIRSA_AE_RQD_MTGTN
VIRSA_AE_RQD_RLAPV
VIRSA_AE_RQD_RLCF
VIRSA_AE_RQD_RLPRL
VIRSA_AE_RQD_SODCF
VIRSA_AE_RQD_SUACC
VIRSA_AE_RQD_SUAPR
VT_AE_REQD_HDR1
VT_AE_REQD_HDR2
VT_AE_REQD_HDR_AR
VT_AE_RQD_FWD_AR
VT_AE_RQD_RLAPV_AR
VT_AE_RQD_RLCF_AR
VT_AE_RQD_RLPRL_AR
VT_AE_RQD_RLPRL_AR
VT_AE_RQD_RVW_CRD
VT_AE_RQD_RW
VT_AE_RQD_SODCF_AR
VT_AE_RQD_SOD_FUNC
VT_AE_RQD_SOD_RISK
VT_AE_RQD_SUACC_AR
VT_AE_RQD_SUAPR_AR
VT_AE_RQD_UAR_ROLE
VT_AE_RQD_UAR_RW
VT_AE_RQD_UPFL_AR
VT_AE_RQD_USERS_AR
VIRSA_AE_INT_TRIG
Please have you DBA perform any operation on the database. Also, if the script is not provided by SAP then SAP will not be repsonsible for any data loss. So, make sure you have back up of data before performing any operation.
For the SAP HR tables, you may have to post that query in some other forum.
Thanks
Harleen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for providing the list of tables for GRC modules RAR and CUP.
Can anyone provide me the list of tables for other 2 modules of GRC i.e. SPM (Super user priviledge management) previously known as Access Enforcer and ERM (Enterprise Role Management), previously known as Role Expert too.
Thank you very much!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.