1. SAP Tutorial
  2. SAP GRC

GRPCSNPSHTCNTL SAP table for – Controll Planner SnapShot Controll Details

Here we would like to draw your attention to GRPCSNPSHTCNTL table in SAP. As we know it is being mainly used with the SAP GRC-SPC (Process Controls in GRC) component which is coming under GRC module (Governance, Risk and Compliance). GRPCSNPSHTCNTL is a SAP standard transp table used for storing Controll Planner SnapShot Controll Details related data in SAP. It comes under the package GRPC_PLANNER.

SAP GRPCSNPSHTCNTL table

Table GRPCSNPSHTCNTL technical data

TableGRPCSNPSHTCNTL
Data storingControll Planner SnapShot Controll Details
ModuleGRC
Sub ModuleGRC-SPC
SAP PackageGRPC_PLANNER
Delivery ClassS – System table, data changes have the status of program changes
ComponentGRCFND_A
Table CategoryTRANSP

SAP GRPCSNPSHTCNTL Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in GRPCSNPSHTCNTL table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • CASE_ID : Technical Case Key (Case GUID)
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : Process UI General Structure
  • VAL_RETEST : Retest Flag for Manual Test
    Its data type is CHAR (Character String) with field length 1
  • ROW_KEY : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • PARENT_KEY : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • LEAF : Indicator
    Its data type is CHAR (Character String) with field length 1
  • EXPANDED : Single-Character Flag
    Its data type is CHAR (Character String) with field length 1
  • SUBPROCESS_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • SUBPROCESS_DESCR : Description of the entity
    Its data type is CHAR (Character String) with field length 80
  • SUBPROCESS_ASSIGN : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • VALIDFROM : Valid from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : Valid to
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDFROM_ASSIGN : Assignment Valid from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO_ASSIGN : Assignment Valid to
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DESCR : Text, 40 Characters Long
    Its data type is CHAR (Character String) with field length 40
  • PRIOX : Priority
    Its data type is CHAR (Character String) with field length 2
  • LTEXT : Long Text Exists
    Its data type is STRG (Character String of Variable Length) with field length 0
  • INDUSTRY_SPECIFIC : To Be Tested
    Its data type is CHAR (Character String) with field length 1
  • INDUSTRY_SPEC_DESCR
    Its data type is CHAR (Character String) with field length 100
  • INDUSTRY : Industry
    Its data type is CHAR (Character String) with field length 10
  • INDUSTRY_DESCR
    Its data type is CHAR (Character String) with field length 100
  • VAL_PST_DESIGN : Review Control Design Assessment
    Its data type is CHAR (Character String) with field length 1
  • VAL_PST_EFF : Review Self-Assessment
    Its data type is CHAR (Character String) with field length 1
  • VAL_PST_TEST : Review Test of Control Effectiveness
    Its data type is CHAR (Character String) with field length 1
  • VAL_CHDOC : Approval of Process and Control Changes
    Its data type is CHAR (Character String) with field length 1
  • VAL_P_REMED : Review Remediation Plan
    Its data type is CHAR (Character String) with field length 1
  • TR_TYPE : Attribute
    Its data type is CHAR (Character String) with field length 20
  • TR_TYPE_DESCR
    Its data type is CHAR (Character String) with field length 100
  • TR_TYPE_ASSIGN : Attribute
    Its data type is CHAR (Character String) with field length 20
  • FLAG : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • TF : Timeframe
    Its data type is CHAR (Character String) with field length 10
  • Y : Year
    Its data type is CHAR (Character String) with field length 4
  • REASON : Reason for Change
    Its data type is STRG (Character String of Variable Length) with field length 0
  • PROCESS_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • PROCESS_PARENT : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • PROCESS_ASSIGN : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • VAL_P_DESIGN : Review Subprocess Design Assessment
    Its data type is CHAR (Character String) with field length 1
  • VAL_PG_REMED : Review Remediation Plan
    Its data type is CHAR (Character String) with field length 1
  • OBJ_TYPE : Object Type ID
    Its data type is CHAR (Character String) with field length 10
  • OBJ_TYPEDESC
    Its data type is STRG (Character String of Variable Length) with field length 0
  • CONTROL_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • TYP : Type of PC Object
    Its data type is CHAR (Character String) with field length 1
  • ORGUNIT_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • CONTROL_REF : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • IS_REFSTEP_DIFFERENT : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • REFERENCE : Referenced Object (Type + ID)
    Its data type is CHAR (Character String) with field length 10
  • IS_CONTROL : Process Step Is a Control
    Its data type is CHAR (Character String) with field length 1
  • IS_CONTROL_DESCR
    Its data type is CHAR (Character String) with field length 100
  • CATEGORY : Control Category
    Its data type is CHAR (Character String) with field length 10
  • CATEGORY_DESCR : Text
    Its data type is CHAR (Character String) with field length 100
  • LVL_OF_EVIDENCE : Level of Evidence
    Its data type is CHAR (Character String) with field length 10
  • LVL_OF_EVIDENCE_DESCR : Text
    Its data type is CHAR (Character String) with field length 100
  • LVL_OF_EVI_SS : Level of Evidence
    Its data type is CHAR (Character String) with field length 10
  • LVL_OF_EVI_USS : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • CONTROL_RISK : Control Risk
    Its data type is CHAR (Character String) with field length 10
  • CONTROL_RISK_DESCR : Text
    Its data type is CHAR (Character String) with field length 100
  • CONTROL_RISK_SS : Control Risk
    Its data type is CHAR (Character String) with field length 10
  • CONTROL_RISK_USS : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • CN_GROUP : Control Group
    Its data type is CHAR (Character String) with field length 10
  • IN_PUT
    Its data type is STRG (Character String of Variable Length) with field length 0
  • OUT_PUT
    Its data type is STRG (Character String of Variable Length) with field length 0
  • AUTOM : Automation
    Its data type is CHAR (Character String) with field length 10
  • AUTOM_DESCR
    Its data type is CHAR (Character String) with field length 100
  • MAT_TAR : Control Maturity
    Its data type is CHAR (Character String) with field length 10
  • MAT_TAR_DESCR
    Its data type is CHAR (Character String) with field length 100
  • NATURE : Nature of Control
    Its data type is CHAR (Character String) with field length 10
  • NATURE_DESCR
    Its data type is CHAR (Character String) with field length 100
  • PURP : Control Purpose
    Its data type is CHAR (Character String) with field length 10
  • PURP_DESCR
    Its data type is CHAR (Character String) with field length 100
  • SIG : Control Significance
    Its data type is CHAR (Character String) with field length 10
  • SIG_DESCR
    Its data type is CHAR (Character String) with field length 100
  • FREQ : Frequency
    Its data type is CHAR (Character String) with field length 10
  • FREQ_DESCR
    Its data type is CHAR (Character String) with field length 100
  • TEST_AUTOM
    Its data type is CHAR (Character String) with field length 10
  • TEST_AUTOM_DESCR
    Its data type is CHAR (Character String) with field length 100
  • DT_EVNT : Control Trigger: T: Date-Driven / E: Event-Driven
    Its data type is CHAR (Character String) with field length 1
  • DT_EVNT_DESCR
    Its data type is CHAR (Character String) with field length 100
  • EVENT_DESCR : Description Field
    Its data type is STRG (Character String of Variable Length) with field length 0
  • TEST : To Be Tested
    Its data type is CHAR (Character String) with field length 1
  • TEST_DESCR : Test description
    Its data type is CHAR (Character String) with field length 100
  • TTECHNQ : Testing Technique
    Its data type is CHAR (Character String) with field length 10
  • TTECHNQ_DESCR
    Its data type is CHAR (Character String) with field length 100
  • TESTPROC
    Its data type is STRG (Character String of Variable Length) with field length 0
  • CHANGED_ON : Changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHANGED_BY : Person Performing the Change
    Its data type is CHAR (Character String) with field length 100
  • TESTPLAN_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • TESTPLAN_DESCR
    Its data type is STRG (Character String of Variable Length) with field length 0
  • SS_ORGUNIT_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • P_METHOD_ASS : Status of Assignment Method
    Its data type is CHAR (Character String) with field length 1
  • DOC_COUNT : Natural number
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • ALLOW_REFER : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • IS_PROVIDER : Shared service provider
    Its data type is CHAR (Character String) with field length 1
  • IN_SCOPE : In Scope
    Its data type is CHAR (Character String) with field length 1
  • RTST_P_DESIGN : Repeat the subprocess design assessment
    Its data type is CHAR (Character String) with field length 1
  • RTST_PST_DESIGN : Repeat Control Design Assessment
    Its data type is CHAR (Character String) with field length 1
  • RTST_PST_EFF : Repeat Test of Control Effectiveness
    Its data type is CHAR (Character String) with field length 1
  • RTST_PST_TEST : Repeat Self-Assessment
    Its data type is CHAR (Character String) with field length 1
  • AC_BPROC : Business Process
    Its data type is CHAR (Character String) with field length 10
  • AC_BSUBPROC : Subprocess
    Its data type is CHAR (Character String) with field length 10

    • GRPCSNPSHTCNTL related tables

    • GRPCSNPSHTREL : Controll Planner SnapShot Controll Relevance
    • GRPC_SNP_SHT_ON : Switch on/off Snap Shot
    • GRPCSNPSHTCNTL : Controll Planner SnapShot Controll Details
    • GRPCSNPSHTBUSGRP : Controll Planner SnapShot Sub Group

    Related References

    Related Tutorials

    GRPCSNPSHTREL SAP table for – Controll Planner SnapShot Controll Relevance

    GRPCSNPSHTREL table in SAP GRC (Process Controls in GRC) module. This table is used for storing data of Controll Planner...

    GRPCSNPSHTBUSGRP SAP table for – Controll Planner SnapShot Sub Group

    GRPCSNPSHTBUSGRP table in SAP GRC (Process Controls in GRC) module. This table is used for storing data of Controll Planner...

    GRPCRULE_SNP SAP table for – Rule for Snapshot

    GRPCRULE_SNP table in SAP GRC (Process Controls in GRC) module. This table is used for storing data of Rule for...

    GRPC_SNP_SHT_ON SAP table for – Switch on/off Snap Shot

    GRPC_SNP_SHT_ON table in SAP GRC (Process Controls in GRC) module. This table is used for storing data of Switch on/off...

    GRPCCTRLPROPOSAL SAP table for – GRPC:Control Proposal

    GRPCCTRLPROPOSAL table in SAP GRC (Process Controls in GRC) module. This table is used for storing data of GRPC:Control Proposal....

    GRPC_EXCP_DETLS SAP table for – Details of exception list

    GRPC_EXCP_DETLS table in SAP GRC (Process Controls in GRC) module. This table is used for storing data of Details of...

    GRPC_MCF_REF_TST SAP table for – Referenced test results for controls

    GRPC_MCF_REF_TST table in SAP GRC (Process Controls in GRC) module. This table is used for storing data of Referenced test...

    «
    »