GRPCQLIBRARY SAP table for – Question Library

Here we would like to draw your attention to GRPCQLIBRARY 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). GRPCQLIBRARY is a SAP standard transp table used for storing Question Library related data in SAP. It comes under the package GRPC_SURVEY.

SAP GRPCQLIBRARY table

Table GRPCQLIBRARY technical data

TableGRPCQLIBRARY
Data storingQuestion Library
ModuleGRC
Sub ModuleGRC-SPC
SAP PackageGRPC_SURVEY
Delivery ClassA – Application table (master and transaction data)
ComponentGRCFND_A
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • QUESTION_ID : Question ID
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • SURVEY_REF : Survey ID
    Its data type is CHAR (Character String) with field length 32
  • ISACTIVE : Is Active?
    Its data type is CHAR (Character String) with field length 1
  • QCATEGORY : Question Category
    Its data type is CHAR (Character String) with field length 2
  • ATYPE : Answer Type
    Its data type is CHAR (Character String) with field length 1
  • RTYPE : Question Rating Type
    Its data type is CHAR (Character String) with field length 2
  • ACOMMENT : Answer comment
    Its data type is CHAR (Character String) with field length 15
  • ACOMMENT1 : Answer comment
    Its data type is CHAR (Character String) with field length 255
  • .INCLUDE : User Info and Date and Time when the record is modified
  • CRTDBY : User Name in User Master Record
    Its data type is CHAR (Character String) with field length 12
  • CRTDDT : Field of type DATS
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRTDTM : Field of type TIMS
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • MDFDBY : User Name in User Master Record
    Its data type is CHAR (Character String) with field length 12
  • MDFDDT : Field of type DATS
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MDFDTM : Field of type TIMS
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes