GRPCDEFICANA SAP table for – PC: Deficiency Analysis

Here we would like to draw your attention to GRPCDEFICANA 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). GRPCDEFICANA is a SAP standard transp table used for storing PC: Deficiency Analysis related data in SAP. It comes under the package GRPC_REPORTING.

SAP GRPCDEFICANA table

Table GRPCDEFICANA technical data

TableGRPCDEFICANA
Data storingPC: Deficiency Analysis
ModuleGRC
Sub ModuleGRC-SPC
SAP PackageGRPC_REPORTING
Delivery ClassA – Application table (master and transaction data)
ComponentGRCFND_A
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ANALYSIS_ID : Analysis GUID
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • CASE_GUID : Technical Case Key (Case GUID)
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • ACCTGRP_SLOT : Slot for Account Group
    Its a key field. Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • ANALYSIS_BY_ORG : Organization ID
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • ACCTGRP : Account Groups
    Its data type is CHAR (Character String) with field length 8
  • EXT_REF : External reference
    Its data type is CHAR (Character String) with field length 30
  • CASE_TITLE : Name of Issue
    Its data type is CHAR (Character String) with field length 80
  • STATUS : Issue Status
    Its data type is CHAR (Character String) with field length 5
  • ISSUE_PRIORITY : Issue Priority
    Its data type is CHAR (Character String) with field length 1
  • CATEGORY : Category
    Its data type is CHAR (Character String) with field length 4
  • TIMEFRAME : Timeframe
    Its data type is CHAR (Character String) with field length 10
  • TF_YEAR : Year
    Its data type is CHAR (Character String) with field length 4
  • DEFIC_TYPE : Deficiency Type
    Its data type is CHAR (Character String) with field length 10
  • CURRENCY : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • IMPACT_POTENTIAL : Impact Potential of a Deficiency
    Its data type is CURR (Currency Field) with field length 15
  • LIKELIHOOD : Likelihood of a Deficiency
    Its data type is CHAR (Character String) with field length 10
  • MITIGATION : Mitigation of Deficiency
    Its data type is CHAR (Character String) with field length 1
  • MAGNITUDE : Deficiency Magnitude
    Its data type is CHAR (Character String) with field length 10
  • MAGNITUDE_MAP : Deficiency Analysis: Assignment Magnitude to Classification
    Its data type is CHAR (Character String) with field length 10
  • CLASS : Classification of Deficiency
    Its data type is CHAR (Character String) with field length 10
  • AGGREG_CODE : Aggregation Type
    Its data type is CHAR (Character String) with field length 40
  • DEFIC_COMMENT : Comment
    Its data type is STRG (Character String of Variable Length) with field length 0
  • ANALYSIS_TIME : Last Changed On
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • ANALYSIS_BY : Analysis By (User ID)
    Its data type is CHAR (Character String) with field length 12
  • ANA_STATUS : Status of Deficiency Analysis
    Its data type is CHAR (Character String) with field length 1