Show TOC

Control Locate this document in the navigation structure

 

Search and Analytics Model (Search and Analytics Model) Search and Analytics Model: 0GPC_CN

This search and analytics model is used to get the control data.

Technical Data

Model Usage

Application Model

Software Component for Search and Analytics

GRCFND_A

Root Node: GRC PC Control Attributes

Technical Name

0GPC_CN_ATTR

DataSource

0GPC_CN_ATTR

Operational Data Provider: GRC PC Control Attributes

Technical Name

0GPC_CN

ODP-Semantics

Master Data Attributes

View

Data Extraction

Direct Access Enabled

Yes

Operational Data Provider: GRC PC Control Texts

Technical Name

0GPC_CN

ODP-Semantics

Texts

View

Data Extraction

Direct Access Enabled

Yes

Authorization Checks

Check ID

ABAP Authorization Object

Description

CN

GRFN_ODP_C

GRC ODP authorization for complex ID

Node Relationship: GRC PC Control Texts

Node

0GPC_CN_TEXT2

Association

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

CN_ID

CN_ID

Equal

Node Relationship: GRC PC Control Category Texts

Node

0GPC_CNCATE.0GPC_CNCATE_TEXT

Association

0GPC_CN_ATTR20GPC_CNCATE_TEXT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_CATEOGRY

ATTR

Equal

Node Relationship: GRC PC Test Plan Attributes

Node

0GPC_TP.0GPC_TP_ATTR

Association

0GPC_CN_ATTR20GPC_TP_ATTR

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_TEST_PLAN

OBJID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC PC Control Automation Texts

Node

0GPC_CNAUTO.0GPC_CN_AUTOM_TEXT

Association

0GPC_CN_ATTR20GPC_CN_AUTOM_TEXT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_AUTOM

ATTR

Equal

Node Relationship: GRC PC Control - Level of Evidence Texts

Node

0GPC_CNEVID.0GPC_CN_EVIDENCE_TEX

Association

0GPC_CN_ATTR20GPC_CN_EVIDENCE_TE

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_EVIDENCE

ATTR

Equal

Node Relationship: GRC PC Control Group Texts

Node

0GPC_CNGRP.0GPC_CN_CNGROUP_TEXT

Association

0GPC_CN_ATTR20GPC_CN_CNGROUP_TEX

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_CNGROUP

ATTR

Equal

Node Relationship: GRC PC Control Nature Texts

Node

0GPC_CNNATU.0GPC_CN_NATURE_TEXT

Association

0GPC_CN_ATTR20GPC_CN_NATURE_TEXT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_NATURE

ATTR

Equal

Node Relationship: GRC PC Control Purpose Texts

Node

0GPC_CNPURP.0GPC_CN_PURP_TEXT

Association

0GPC_CN_ATTR20GPC_CN_PURP_TEXT1

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_PURP

ATTR

Equal

Node Relationship: GRC PC Control Testing Technique Texts

Node

0GPC_CNTTEC.0GPC_CN_TTECH_TEXT

Association

0GPC_CN_ATTR20GPC_CN_TTECH_TEXT1

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_TTECH

ATTR

Equal

Node Relationship: GRC PC Control Significance Texts

Node

0GPC_CN_SIG.0GPC_CN_SIG_TEXT

Association

0GPC_CN_ATTR20GPC_CN_SIG_TEXT1

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_SIG

ATTR

Equal

Node Relationship: GRC PC Control Test Automation Texts

Node

0GPC_CNTAUT.0GPC_CN_TSTAUT_TEXT

Association

0GPC_CN_ATTR20GPC_CN_TSTAUT_TEXT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_TSTAUT

ATTR

Equal

Node Relationship: GRC PC Control Date/Event Driven Texts

Node

0GPC_CNDTEV.0GPC_CN_DTEVT_TEXT

Association

0GPC_CN_ATTR20GPC_CN_DTEVT_TEXT1

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_DTEVT

ATTR

Equal

Node Relationship: GRC PC Subprocess Texts

Node

0GPC_SP.0GPC_SP_ATTR

Association

0GPC_CN_ATTR20GPC_SP_ATTR1

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

SP_ID

OBJID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC User Texts

Node

0GFN_USER_TEXT.0GFN_USER_TEXT

Association

CONTROL: OWNER NAME

Cardinality

Up to One

Reverse Cardinality

Arbitrary

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_RESP_USER

ATTR

Equal

Node Relationship: GRC PC Control Risk ID Texts

Node

0GPC_CNCNRS.0GPC_CN_CNTR_RISK_T

Association

CONTROL: RISK TEXT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_CNTR_RISK

ATTR

Equal

Node Relationship: GRC Organizations Attributes

Node

0GFN_OU.0GFN_OU_ATTR

Association

0GPC_CN_ATTR20GFN_OU_ATTR_1

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

OU_ID

OBJID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC PC Control Attributes

Node

0GPC_CN.0GPC_CN_ATTR

Association

0GPC_CN_ATTR20GPC_CN_ATTR

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

CN_SS_CN

CN_ID

Equal

Node Relationship: GRC Organizations Attributes

Node

0GFN_OU.0GFN_OU_ATTR

Association

0GPC_CN_ATTR20GFN_OU_ATTR_2

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_SS_OU

OBJID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC PC Control Maturity Target Texts

Node

0GPC_CNMATA.0GPC_CN_MATAR_TEXT

Association

0GPC_CN_ATTR20GPC_CN_MATAR_TEXT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_MATAR

ATTR

Equal

Node Relationship: GRC Entity Type Texts

Node

0GFN_ENTTYP.0GFN_ENTTYP_TEXT

Association

0GPC_CN_ATTR20GFN_ENTTYP_TEXT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

ENTITY_ID

ATTR

Equal

Node Relationship: GRC PC Control Origin Texts

Node

0GPC_CNORIG.0GPC_CN_ORIGIN_TEXT

Association

0GPC_CN_ATTR20GPC_CN_ORIGIN_TEXT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_ORIGIN

ATTR

Equal

Node Relationship: Control To Be Tested

Node

0GPC_CNTBTS.0GPC_CNTBTS_TEXT

Association

0GPC_CN_ATTR20GPC_CNTBTS_TEXT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_TEST

ATTR

Equal

Node Relationship: GRC Flag Texts

Node

0GPC_CNALREF.0GFN_CNALREF_TEXT

Association

0GPC_CN_ATTR20GFN_CNALREF_TEXT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_ALLOW_REFER

ATTR

Equal

Node Relationship: GRC Flag Texts

Node

0GPC_CNISCN.0GPC_CNISCN_TEXT

Association

0GPC_CN_ATTR20GPC_CNISCN_TEXT

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

Yes

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_IS_CONTROL

ATTR

Equal

Node Relationship: GRC Timeframe Year

Node

0GFN_TF_YEAR.0GFN_TF_YEAR

Association

0GPC_CN_ATTR20GFN_TF_YEAR_1

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TF_YEAR

TF_YEAR

Equal

Node Relationship: GRC Timeframe

Node

0GFN_TF.0GFN_TF_ATTR

Association

0GPC_CN_ATTR20GFN_TF_ATTR_1

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC Timeframe Year Frequency

Node

0GFN_TF_FREQ.0GFN_TF_FREQ

Association

0GPC_CN_ATTR20GFN_TF_FREQ_1

Cardinality

Exactly One

Reverse Cardinality

Arbitrary

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TF_FREQ

TF_FREQ

Equal

Node Relationship: GRC PC Risk Coverage from all sources

Node

0GPC_RSCN.0GPC_SP_RS_CN_ALL

Association

0GPC_SP_RS_CN_ALL20GPC_CN_ATTR

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_ID

CN_ID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC PC Control and Risk Matrix Attributes

Node

0GPC_CN_RS.0GPC_CN_RS_ATTR

Association

0GPC_CN_RS_ATTR20GPC_CN_ATTR

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_ID

CN_ID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC PC Cases

Node

0GPC_CASES.0GPC_CASES

Association

0GPC_CASES20GPC_CN_ATTR

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_ID

CN_ID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC PC Test Step Attributes

Node

0GPC_V0.0GPC_V0_ATTR

Association

0GPC_V0_ATTR20GPC_CN_ATTR

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

CN_ID

CN_ID

Equal

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

Node Relationship: GRC Job Steps Attribute

Node

0GFN_JP.0GFN_JP_ATTR

Association

0GFN_JP_ATTR20GPC_CN_ATTR

Cardinality

Arbitrary

Reverse Cardinality

Exactly One

Sub-query

No

Foreign Key

Attribute of Parent Node

Value

Attribute of Child Node

Value

Join-Operator

TF_YEAR

TF_YEAR

Equal

TIMEFRAME

TIMEFRAME

Equal

CN_ID

CN_ID

Equal