SAP ABAP Table GRACROLE (Role)

Hierarchy

☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC-AC (Application Component) Access Control
     ⤷ GRAC_ROLE_MANAGEMENT (Package) GRC ERM Support

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	GRACROLE	Table Relationship Diagram
Short Description	Role

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ROLEID	☑	GRAC_ROLEID	GRFN_GUID	CHAR	32	0	Role ID
3	ROLE_NAME	☐	GRAC_ROLE_NAME	GRAC_ROLE_NAME	CHAR	300	0	Role Name	*
4	CONNECTOR_GRP	☐	GRFN_CONNECTORGRP	GRFN_CONNECTORGRP	CHAR	10	0	Connector Group	GRFNCONNGRP
5	ROLE_TYPE	☐	GRAC_ROLE_TYPE	GRAC_ROLE_TYPE	CHAR	3	0	Role Type	GRACROLETYPE
6	BPROC	☐	GRAC_BPROC	GRACBPROC	CHAR	10	0	Business Process	GRACBPROC
7	BSUBPROC	☐	GRAC_BSUBPROC	GRAC_BSUBPROC	CHAR	10	0	Subprocess	GRACBSUBPROC
8	PRJREL	☐	GRAC_PRJ_REL	GRAC_PRJ_REL	CHAR	10	0	Project Release	GRACPROJREL
9	CRITLVL	☐	GRAC_CRITLVL	GRAC_CRITLVL	CHAR	3	0	Critical Level	GRACCRITILVL
10	PROFILE	☐	GRAC_PROFILE	GRAC_PROFILE	CHAR	20	0	Profile Name
11	ROLE_STATUS	☐	GRAC_ROLE_STATUS	GRAC_ROLE_STATUS	CHAR	3	0	Role Status	GRACROLESTATUS
12	NMCNV	☐	GRAC_NMCNV	GRAC_NMCNV	NUMC	4	0	Naming Convention	GRACNAMECONV
13	METHODOLOGY	☐	GRAC_METHODOLOGY	GRAC_METHODOLOGY	NUMC	3	0	Methodology process	GRACMTH
14	LOCKED	☐	GRFN_BOOLEAN	GRFN_BOOLEAN	CHAR	1	0	Indicator
15	CURRENT_STEP	☐	GRAC_SEQUENCE	GRAC_SEQUENCE	NUMC	4	0	Sequence
16	MAX_STEP	☐	GRAC_SEQUENCE	GRAC_SEQUENCE	NUMC	4	0	Sequence
17	BACKEND_MODE	☐	GRFN_BOOLEAN	GRFN_BOOLEAN	CHAR	1	0	Indicator
18	CERTIFY_PERIOD	☐	GRAC_CERTIFY_PERIOD	GRAC_NUMBER	NUMC	5	0	Certification period
19	CERTIFY_DATE	☐	GRAC_CERTIFY_DATE	GRFN_DATUM	DATS	8	0	Cerfified Date
20	CERTIFY_DUE	☐	GRAC_CERTIFY_DATE	GRFN_DATUM	DATS	8	0	Cerfified Date
21	CERTIFY_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
22	REAFFIRM_PERIOD	☐	GRAC_REAF_PERIOD	GRAC_NUMBER	NUMC	5	0	Reaffirm Period
23	LAST_REAFFIRM_DT	☐	GRAC_REAFF_DATE	GRFN_DATUM	DATS	8	0	Reaffirm Date
24	REAFFIRM_DUE	☐	GRAC_REAFF_DATE	GRFN_DATUM	DATS	8	0	Reaffirm Date
25	LAST_REAFFIRM_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
26	COMM_MAND	☐	GRFN_BOOLEAN	GRFN_BOOLEAN	CHAR	1	0	Indicator
27	CHANGE_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
28	CHANGE_ON	☐	GRFN_TIMESTAMP	GRFN_TIMESTAMP	DEC	15	0	Time Stamp
29	CREATE_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
30	CREATE_ON	☐	GRFN_TIMESTAMP	GRFN_TIMESTAMP	DEC	15	0	Time Stamp
31	ROLE_SOURCE	☐	GRAC_ROLE_SOURCE	GRAC_ROLE_SOURCE	NUMC	3	0	Role Source
32	SENSITIVITY	☐	GRAC_SENSITIVITY	GRAC_SENSITIVITY	NUMC	3	0	Role Sensitivity	GRACRLSENS
33	ALLOW_DERIVATION	☐	GRFN_BOOLEAN	GRFN_BOOLEAN	CHAR	1	0	Indicator
34	IDENTIFIER	☐	GRAC_IDENTIFIER	GRAC_IDENTIFIER	CHAR	100	0	Role Identifier
35	PROV_COMM_MAND	☐	GRAC_COMM_MAND	GRFN_BOOLEAN	CHAR	1	0	Comments Mandatory for provisioning
36	CONS_PARENT_APVR	☐	GRAC_CONS_PARENT_APPRV	GRFN_BOOLEAN	CHAR	1	0	Consider parent role approvers for child roles
37	LAST_AUTH_SYNC	☐	GRFN_TIMESTAMP	GRFN_TIMESTAMP	DEC	15	0	Time Stamp
38	LAST_AUTH_UPDATE	☐	GRFN_TIMESTAMP	GRFN_TIMESTAMP	DEC	15	0	Time Stamp
39	CAN_BE_FF_ROLE	☐	GRAC_CAN_BE_FF	GRFN_BOOLEAN	CHAR	1	0	Can be Firefighter Role
40	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	GRACROLE	BPROC	GRACBPROC	BPROC	KEY	1	1
2	GRACROLE	BSUBPROC	GRACBSUBPROC	BSUBPROC	KEY
3	GRACROLE	CONNECTOR_GRP	GRFNCONNGRP	CONNECTOR_GRP	KEY	1	CN
4	GRACROLE	CRITLVL	GRACCRITILVL	CRITLVL	KEY	1	1
5	GRACROLE	MANDT	T000	MANDT
6	GRACROLE	METHODOLOGY	GRACMTH	METHODOLOGY	KEY	1	1
7	GRACROLE	NMCNV	GRACNAMECONV	NMCNV	KEY	1	1
8	GRACROLE	PRJREL	GRACPROJREL	PRJREL	KEY	1	1
9	GRACROLE	ROLE_STATUS	GRACROLESTATUS	ROLE_STATUS	REF	1	CN
10	GRACROLE	ROLE_TYPE	GRACROLETYPE	ROLE_TYPE	KEY	1	CN
11	GRACROLE	SENSITIVITY	GRACRLSENS	SENSITIVITY	KEY	1	CN

History

Last changed by/on	SAP	20141106
SAP Release Created in	600