GRPCCTRLPROPOSAL SAP table for – GRPC:Control Proposal

Here we would like to draw your attention to GRPCCTRLPROPOSAL 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). GRPCCTRLPROPOSAL is a SAP standard transp table used for storing GRPC:Control Proposal related data in SAP. It comes under the package GRPC_ENTITY_API.

SAP GRPCCTRLPROPOSAL table

Table GRPCCTRLPROPOSAL technical data

TableGRPCCTRLPROPOSAL
Data storingGRPC:Control Proposal
ModuleGRC
Sub ModuleGRC-SPC
SAP PackageGRPC_ENTITY_API
Delivery ClassA – Application table (master and transaction data)
ComponentGRCFND_A
Table CategoryTRANSP

SAP GRPCCTRLPROPOSAL 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 GRPCCTRLPROPOSAL table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PROPOSAL_GUID : GUID in ‘CHAR’ Format in Uppercase
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • PROPOSAL : Proposal
    Its data type is CHAR (Character String) with field length 40
  • PROPOSAL_STATUS : Control Proposal Status
    Its data type is CHAR (Character String) with field length 3
  • RISK_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • CONTROL_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • SUBPROCESS_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • ORGUNIT_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • REGULATION_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • REQUIREMENT_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • LTEXT : String
    Its data type is STRG (Character String of Variable Length) with field length 0
  • NATURE : Nature of Control
    Its data type is CHAR (Character String) with field length 10
  • PURP : Control Purpose
    Its data type is CHAR (Character String) with field length 10
  • SIG : Control Significance
    Its data type is CHAR (Character String) with field length 10
  • FREQ : Frequency
    Its data type is CHAR (Character String) with field length 10
  • AUTOM : Automation
    Its data type is CHAR (Character String) with field length 10
  • DT_EVNT : Control Trigger: T: Date-Driven / E: Event-Driven
    Its data type is CHAR (Character String) with field length 1
  • EVENT_DESCR : String
    Its data type is STRG (Character String of Variable Length) with field length 0
  • CONTROL_REF : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • SORT : Sequence
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • TYP : Type of controls
    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
  • VALIDFROM : Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Common Include
  • CREATEDON : Date Created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREATETIME : Time Created
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CREATEDBY : Created By
    Its data type is CHAR (Character String) with field length 12
  • CHANGEDON : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHANGETIME : Last Change Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CHANGEDBY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes