SAP ABAP Table GRFN_S_BI_OU_PR_ATTR (Organization and Process Structure)

Hierarchy

☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC (Application Component) Governance, Risk and Compliance
     ⤷ GRFN_EXTRACTION (Package) PC-RM BI Extraction

Basic Data

Table Category	INTTAB	Structure
Structure	GRFN_S_BI_OU_PR_ATTR	Table Relationship Diagram
Short Description	Organization and Process Structure

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Common part of data source structures
2	.INCLUDE	☐				0	0	Details about extraction
3	SNAPSHOT_ID	☐	GRFN_DM_SNAPSHOT_ID	SYSUUID_C	CHAR	32	0	Datamart - Snapshot ID
4	TIMESTAMP	☐	GRFN_TIMESTAMP	GRFN_TIMESTAMP	DEC	15	0	Time Stamp
5	DB_TABLE	☐	GRFN_TABNAME		CHAR	30	0	Table name
6	.INCLUDE	☐				0	0	Timeframe info for extraction
7	TF_YEAR	☐	GRFN_TF_YEAR	GRFN_TF_YEAR	CHAR	4	0	Timeframe Year
8	TIMEFRAME	☐	GRFN_TIMEFRAME	GRFN_TIMEFRAME	CHAR	10	0	Timeframe	*
9	TF_FREQ	☐	GRFN_TF_FREQUENCY	GRFN_TF_FREQUENCY	CHAR	10	0	Timeframe Frequency	*
10	DATEFROM	☐	GRFN_DATE_FROM	GRFN_DATE_FROM	DATS	8	0	Valid from Date
11	DATETO	☐	GRFN_DATE_TO	GRFN_DATE_TO	DATS	8	0	Valid to Date
12	TF_ID	☐	GRFN_BI_TF_ID	GRFN_BI_TF_ID	CHAR	32	0	Compounded timeframe ID
13	.INCLUDE	☐				0	0	Object info for extraction
14	OBJECT_ID	☐	GRFN_API_OBJECT_ID	CHAR50	CHAR	50	0	Object ID
15	ENTITY_ID	☐	GRFN_API_ENTITY_ID	GRFN_API_ENTITY_ID	CHAR	20	0	Entity ID	*
16	OBJECT_KEY	☐	GRFN_API_TECHNAME_ID	GRFN_API_TECHNAME_ID	CHAR	50	0	Object's technical name
17	SHORT_ENTITY_ID	☐	GRFN_SHORT_ENTITY_ID	CHAR2	CHAR	2	0	Shor Entity ID (used in DM)
18	OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
19	GUID	☐	GRFN_GUID	GRFN_GUID	CHAR	32	0	UUID of the GRC object (char32)
20	RE_ID	☐	GRFN_REP_REGULATION	NUMC08	NUMC	8	0	Regulation ID
21	OU_ID	☐	GRFN_REP_ORGUNIT_ID	NUMC08	NUMC	8	0	Organization ID
22	PR_ID	☐	GRFN_REP_PROCESS_ID	NUMC08	NUMC	8	0	Process ID
23	SP_ID	☐	GRFN_REP_SUBPROCESS_ID	NUMC08	NUMC	8	0	Subprocess ID
24	CN_HR_ID	☐	GRFN_BI_CN_HR_ID	HROBJID	NUMC	8	0	Control ID	*
25	CN_ID	☐	GRFN_REP_CONTROL_ID		CHAR	9	0	Control ID
26	.INCLUDE	☐				0	0	Control reporting attributes
27	CN_CENTRAL	☐	GRFN_REP_CONTROL_CENTRAL	NUMC08	NUMC	8	0	Central control id
28	CN_SIG	☐	GRFN_REP_CONTROL_SIG	GRFN_ATTRVALUE	CHAR	10	0	Significance ID
29	CN_IS_CONTROL	☐	GRFN_REP_CONTROL_IS_CONTROL	GRFN_XFELD	CHAR	1	0	Is Control ID
30	CN_PURP	☐	GRFN_REP_CONTROL_PURP	GRFN_ATTRVALUE	CHAR	10	0	Control Purpose ID
31	CN_MATAR	☐	GRFN_REP_CONTROL_MATAR	GRFN_ATTRVALUE	CHAR	10	0	Control Maturity Target ID
32	CN_AUTOM	☐	GRFN_REP_CONTROL_AUTOM	GRFN_ATTRVALUE	CHAR	10	0	Automation ID
33	CN_FREQ	☐	GRFN_REP_CONTROL_FREQ	GRFN_ATTRVALUE	CHAR	10	0	Frequency ID
34	CN_NATURE	☐	GRFN_REP_CONTROL_NATURE	GRFN_ATTRVALUE	CHAR	10	0	Nature ID
35	CN_TEST	☐	GRFN_REP_CONTROL_TEST	GRFN_XFELD	CHAR	1	0	Control To Be Tested ID
36	CN_TTECH	☐	GRFN_REP_CONTROL_TTECHNQ	GRFN_ATTRVALUE	CHAR	10	0	Testing Technique ID
37	CN_TSTAUT	☐	GRFN_REP_CONTROL_TEST_AUTOM	GRFN_ATTRVALUE	CHAR	10	0	Test Automation ID
38	CN_DTEVT	☐	GRFN_REP_CONTROL_DATE_EVENT	GRFN_REP_CONTROL_DATE_EVENT	CHAR	1	0	Trigger ID
39	CN_VALID_FROM	☐	GRFN_REP_CONTROL_VALID_FROM	DATUM	DATS	8	0	Valid From
40	CN_VALID_TO	☐	GRFN_REP_CONTROL_VALID_TO	DATUM	DATS	8	0	Valid to
41	CN_TEST_PLAN	☐	GRFN_REP_CONTROL_TEST_PLAN	NUMC08	NUMC	8	0	Control test plan
42	CN_ALLOW_REFER	☐	GRFN_REP_CONTROL_ALLOW_REFER	GRFN_XFELD	CHAR	1	0	Allow reference ID
43	CN_RESP_USER	☐	GRFN_REP_CONTROL_RESP_USER	GRFN_REP_RESP_USER	CHAR	12	0	Owner ID
44	CN_CATEGORY	☐	GRFN_REP_CONTROL_CATEGORY		CHAR	10	0	Control Category ID
45	CN_EVIDENCE	☐	GRFN_REP_CONTROL_EVIDENCE	GRFN_ATTRVALUE	CHAR	10	0	Level of Evidence ID
46	CN_EVIDENCE_SS	☐	GRFN_REP_CONTROL_EVIDENCE_SS	GRFN_REP_YES_NO	CHAR	1	0	Level of Evidence - System Suggested ID
47	CN_CNTR_RISK	☐	GRFN_REP_CONTROL_RISK	GRFN_ATTRVALUE	CHAR	10	0	Control Risk ID
48	CN_CNTR_RISK_SS	☐	GRFN_REP_CONTROL_RISK_SS	GRFN_REP_YES_NO	CHAR	1	0	Control Risk - System Sugested ID
49	CN_CNGROUP	☐	GRFN_REP_CONTROL_CNGROUP	GRFN_ATTRVALUE	CHAR	10	0	Control Group ID
50	CN_ORIGIN	☐	GRFN_REP_CONTROL_ORIGIN	GRFN_REP_CONTROL_ORIGIN	CHAR	1	0	Control origin ID
51	CN_SS_OU	☐	GRFN_REP_CONTROL_SS_OU	NUMC08	NUMC	8	0	Shared Service Organization ID
52	CN_SS_CN	☐	GRFN_REP_CONTROL_SS_CN		CHAR	9	0	Shared Service Control ID
53	CN_IS_MONITOR	☐	GRFN_REP_CONTROL_IS_MONITOR	GRFN_XFELD	CHAR	1	0	Is relevant for monitoring (ID)
54	CN_IS_COMPLIENC	☐	GRFN_REP_CONTROL_IS_COMPL	XFELD	CHAR	1	0	Is control relevant for compliance (ID)
55	CN_REG_SPECIFIC	☐	GRFN_REP_CONTROL_REG_SPEC	GRFN_XFELD	CHAR	1	0	Regulation Specific ID
56	.INCLUDE	☐				0	0
57	.INCLUDE	☐				0	0	Sub process attributes for reporting
58	SP_CENTRAL	☐	GRFN_REP_SUBPROCESS_ASSIGNED	NUMC08	NUMC	8	0	Assigned subprocess
59	SP_REGULATION	☐	GRFN_REP_REGULATION	NUMC08	NUMC	8	0	Regulation ID
60	SP_TRTYPE	☐	GRFN_REP_SUBPROCESS_TRTYPE	GRPC_ATTRVALUE	CHAR	10	0	Transaction type (central) ID
61	SP_TRTYPE_O	☐	GRFN_REP_SUBPROCESS_TRTYPE_O	GRPC_ATTRVALUE	CHAR	10	0	Transaction Type ID
62	SP_INDUSTRY	☐	GRFN_REP_SUBPROCESS_INDUSTRY	GRPC_ATTRVALUE	CHAR	10	0	Subprocess Industry
63	SP_VAL_ASS_CD	☐	GRFN_REP_SUBPROCESS_VAL_ASS_CD	GRFN_FLAG	CHAR	1	0	Control Design Assessment Validation
64	SP_VAL_ASS_CE	☐	GRFN_REP_SUBPROCESS_VAL_ASS_CE	GRFN_FLAG	CHAR	1	0	Control Self-Assessment Validation
65	SP_VAL_TEST	☐	GRFN_REP_SUBPROCESS_VAL_TEST	GRFN_FLAG	CHAR	1	0	Control Effectiveness Test Validation
66	SP_VAL_RMPLAN	☐	GRFN_REP_SUBPROCESS_VAL_RMPLAN	GRFN_FLAG	CHAR	1	0	Remediation Plan Validation
67	SP_RTST_CE	☐	GRFN_REP_SUBPROCESS_RTST_CE	GRFN_REP_SUBPROCESS_RTST	CHAR	1	0	Retest Control Self-Assessment
68	SP_RTST_CD	☐	GRFN_REP_SUBPROCESS_RTST_CD	GRFN_REP_SUBPROCESS_RTST	CHAR	1	0	Retest Control Design Assessment
69	SP_RTST_TE	☐	GRFN_REP_SUBPROCESS_RTST_TE	GRFN_REP_SUBPROCESS_RTST	CHAR	1	0	Retest Control Effectiveness Test
70	SP_VALID_FROM	☐	GRFN_REP_SUBPROCESS_VALID_FROM	DATUM	DATS	8	0	Subprocess start date
71	SP_VALID_TO	☐	GRFN_REP_SUBPROCESS_VALID_TO	DATUM	DATS	8	0	Subprocess end date
72	SP_IS_PROVIDER	☐	GRFN_REP_SUBPROCESS_IS_PROVID		CHAR	1	0	Subprocess: shared servicess is provider
73	SP_IS_CONSUMER	☐	GRFN_REP_SUBPROCESS_IS_CONSUM		CHAR	1	0	Subprocess: shared services is consumer
74	SP_SS_ORGUNIT	☐	GRFN_REP_SUBPROCESS_SS_ORGUNIT	NUMC08	NUMC	8	0	Subprocess: shared services shared orgunit
75	SP_SS_ASGN_METH	☐	GRFN_REP_SUBPROCESS_SS_METHOD	GRPC_METHOD_ASSIGN_STATUS	CHAR	1	0	Subprocess: shared services assign method ID
76	SP_RESP_USER	☐	GRFN_REP_SUBPROCESS_RESP_USER	GRFN_REP_RESP_USER	CHAR	12	0	Subprocess responsible person
77	SP_IN_SCOPE	☐	GRFN_REP_SUBPROCESS_IN_SCOPE	GRFN_REP_YES_NO	CHAR	1	0	In Scope (Subprocess) ID
78	SP_REG_SPECIFIC	☐	GRFN_REP_SUBPROCESS_REG_SPEC	GRFN_XFELD	CHAR	1	0	Regulation Specific ID
79	SP_INDUSTRY_SPEC	☐	GRFN_REP_SUBPROCESS_INDS_SPC	GRFN_XFELD	CHAR	1	0	Subprocess Industry Specific
80	.INCLUDE	☐				0	0
81	.INCLUDE	☐				0	0	Process attributes for reporting
82	PR_CENTRAL	☐	GRFN_REP_PROCESS_CENTRAL_ID	NUMC08	NUMC	8	0	Process central id
83	PR_REGULATION	☐	GRFN_REP_REGULATION	NUMC08	NUMC	8	0	Regulation ID
84	PR_VALID_FROM	☐	GRFN_REP_PROCESS_VALID_FROM	DATUM	DATS	8	0	Process start date
85	PR_VALID_TO	☐	GRFN_REP_PROCESS_VALID_TO	DATUM	DATS	8	0	Process end date
86	PR_VAL_PD	☐	GRFN_REP_PROCESS_VAL_ASS_PD	GRFN_FLAG	CHAR	1	0	Validate Subprocess Design Assessment
87	PR_VAL_PLAN	☐	GRFN_REP_PROCESS_VAL_RMPLAN	GRFN_FLAG	CHAR	1	0	Remediation Plan Validation
88	PR_RTST_PD	☐	GRFN_REP_PROCESS_RTST_PD	GRFN_FLAG	CHAR	1	0	Repeat Subprcess Design Assessment
89	PR_RESP_USER	☐	GRFN_REP_PROCESS_RESP_USER	GRFN_REP_RESP_USER	CHAR	12	0	Process responsible person
90	.INCLUDE	☐				0	0
91	.INCLUDE	☐				0	0	Organization attributes for reporting
92	OU_VALID_FROM	☐	GRFN_REP_ORGUNIT_VALID_FROM	DATUM	DATS	8	0	Organization Valid from
93	OU_VALID_TO	☐	GRFN_REP_ORGUNIT_VALID_TO	DATUM	DATS	8	0	Organization Valid to
94	OU_OLSP	☐	GRFN_REP_ORGUNIT_OLSP	GRFN_REP_TEXT_40	CHAR	40	0	Organization Level System Parameter ID
95	OU_RESP_USER	☐	GRFN_REP_ORGUNIT_RESP_USER	GRFN_REP_RESP_USER	CHAR	12	0	Organization Owner ID
96	OU_PARENT	☐	GRFN_REP_ORGUNIT_PARENT	NUMC08	NUMC	8	0	Organization parent ID
97	OU_SPROVIDER	☐	GRFN_REP_ORGUNIT_SERV_PROVIDER	XFELD	CHAR	1	0	Organizational unit service provider
98	OU_VAL_EC_TEST	☐	GRFN_VAL_ELC_TEST	GRFN_FLAG	CHAR	1	0	Review iELC Test
99	OU_VAL_EC_ASS	☐	GRFN_VAL_ELC_ASS	GRFN_FLAG	CHAR	1	0	Review iELC Assessment
100	OU_RTS_EC_TEST	☐	GRFN_ELC_RETEST	GRFN_FLAG	CHAR	1	0	Repeat iELC Test
101	OU_RTS_EC_ASS	☐	GRFN_ELC_REASS	GRFN_FLAG	CHAR	1	0	Repeat iELC Assessment
102	OU_CURRENCY	☐	GRFN_REP_OU_CURRENCY	WAERS	CUKY	5	0	Currency (Organization)	*
103	OU_QUANT_APP	☐	GRFN_REP_ORGUNIT_QUAN_APPETITE	GRFN_AMOUNT	CURR	15	2	Quantitative Appetite
104	OU_QUALITY_APP	☐	GRFN_REP_ORGUNIT_QUAL_APPETITE	GRFN_RISK_APPETITE	CHAR	10	0	Qualitative Appetite	*
105	OU_COUNTRY	☐	GRFN_REP_COUNTRY	LAND1	CHAR	3	0	Country ID	*
106	OU_REGION	☐	GRFN_REP_REGION	REGIO	CHAR	3	0	Region ID	*
107	OU_COST_PER_CNT	☐	GRFN_REP_ORGUNIT_COST_PER_CNT	GRFN_AMOUNT	CURR	15	2	Cost per Control
108	OU_SIGNOFF	☐	GRFN_REP_ORGUNIT_SIGNOFF	GRFN_REP_YES_NO	CHAR	1	0	Subject to Sign-off
109	OU_AOD	☐	GRFN_REP_ORGUNIT_AOD	GRFN_REP_YES_NO	CHAR	1	0	Subject to AoD (ID)
110	OU_IN_SCOPE	☐	GRFN_REP_ORGUNIT_IN_SCOPE	GRFN_REP_YES_NO	CHAR	1	0	In Scope (Organization) ID
111	.INCLUDE	☐				0	0

History

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