cancel
Showing results for 
Search instead for 
Did you mean: 

Most commonly used tables in SAP GRC & SAP HR

Former Member
0 Kudos

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!!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

hkaur
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

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!

Former Member
0 Kudos

Hi Abdul,

For ERM you can find all the tables in J2EE database which starts from VT_RE_*. All the tables starting from this name corresponds to ERM or RE.

For FF, all the table starting from VIRSA_FF_* cooreposnds to Fire Fighter.

Regards,

Shweta