1. SAP Tutorial
  2. SAP GRC

GRPCJOBLOG SAP table for – Job Log from Scheduler

Here we would like to draw your attention to GRPCJOBLOG 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). GRPCJOBLOG is a SAP standard transp table used for storing Job Log from Scheduler related data in SAP. It comes under the package GRPC_RULE_ENGINE.

SAP GRPCJOBLOG table

Table GRPCJOBLOG technical data

TableGRPCJOBLOG
Data storingJob Log from Scheduler
ModuleGRC
Sub ModuleGRC-SPC
SAP PackageGRPC_RULE_ENGINE
Delivery ClassA – Application table (master and transaction data)
ComponentGRCFND_A
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • JOBID : GUID in ‘CHAR’ Format in Uppercase
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • JOB_STEP : Periodic Job in GRPC Scheduler
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • .INCLUDE : Job plan from Scheduler
  • BTC_JOBCOUNT : Job ID
    Its data type is CHAR (Character String) with field length 8
  • CONTROL_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • 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
  • RULE_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • CONNECTOR : Target Connector
    Its data type is CHAR (Character String) with field length 32
  • RETURN_CONNECTOR : Target Connector
    Its data type is CHAR (Character String) with field length 32
  • ORG_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • DATE_BEGIN : Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATE_END : End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EXEC_DATE : Job send to RTA
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EXEC_TIME : Execution Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • SCRIPT : Script
    Its data type is CHAR (Character String) with field length 40
  • PROGRAM_NAME : GRPC Program Name
    Its data type is CHAR (Character String) with field length 130
  • SCRIPTTYPE : Script Type
    Its data type is CHAR (Character String) with field length 20
  • SCRIPTCATG : Script Category
    Its data type is CHAR (Character String) with field length 30
  • SCRIPTVARIANT : Variant Name
    Its data type is CHAR (Character String) with field length 14
  • SYSTEMTYPE : System Type
    Its data type is CHAR (Character String) with field length 8
  • DEST_JOB_ID : Job ID
    Its data type is CHAR (Character String) with field length 50
  • OLSP_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • .INCLUDE : Job result
  • UPDATEDON : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • DEST_STATUS : Destination Job Status
    Its data type is CHAR (Character String) with field length 1
  • DEFICIENCY : Deficiency Type
    Its data type is CHAR (Character String) with field length 5
  • DEFICIENCY_TOTAL : Total number of deficiency
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DEFICIENCY_HIGH : Total Deficiency High
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DEFICIENCY_MED : Total Deficiency Medium
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DEFICIENCY_LOW : Total Deficiciency Low
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • ISSUE_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50
  • 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 : Case Info
  • CASE_ID : GRPC ID of the individual object
    Its data type is CHAR (Character String) with field length 50

    • GRPCJOBLOG related tables

    • GRPCRULEGROUP : Rule Group
    • GRPCRULEGROUPT : Rule Group
    • GRPCRULET : Rule Description
    • GRPCRULET_SNP : Rule Description
    • GRPCFREQUENCY : Frequency Table
    • GRPC_BATCH_TEST : Test
    • GRPCSCRIPTGRP : Script Group
    • GRPCSCRIPT : Script
    • GRPCORGUGRLCR : Assign Organization unit value to Organization Unit Group
    • GRPCRLSETT : Rule Parameters Description
    • GRPCRLSETT_SNP : Rule Parameters Description
    • GRPCRULE_SNP : Rule for Snapshot
    • GRPCRLCRT : Rule Criteria Description
    • GRPCSTRTABLE : String Table – temporary table
    • GRPCJOBCASE : Case Data for Job
    • GRPCSCRIPTCONN : Rule Script Connector Assignment
    • GRPCSYSTEM : System Type
    • GRPCDEFTYPET : Deficiency Type Description
    • GRPCSCHEDULER : Scheduler
    • GRPCRLSTEPT : Rule Parameters Description – obsolete

    GRPCJOBLOG related transaction codes under SAP package GRPC_RULE_ENGINE

    • GRPC_AC_RLCR_REPORT : Script Rule Criteria list
    • GRPC_AC_RESTORE_CONN : Post Installation Connector
    • GRPC_AC_INIT_CONN : Pre-Installation Connector
    • GRPC_CONNECTOR_REPT : Connector Assignment details report

    Related References

    Related Tutorials

    GRPCSCHEDULER SAP table for – Scheduler

    GRPCSCHEDULER table in SAP GRC (Process Controls in GRC) module. This table is used for storing data of Scheduler. See...

    GRPCSCHEDULELIST SAP table for – Scheduler Watch List

    GRPCSCHEDULELIST table in SAP GRC (Process Controls in GRC) module. This table is used for storing data of Scheduler Watch...

    GRPCJOBCASE SAP table for – Case Data for Job

    GRPCJOBCASE table in SAP GRC (Process Controls in GRC) module. This table is used for storing data of Case Data...

    GRPCSETTINGS SAP table for – GRPC Settings

    GRPCSETTINGS table in SAP GRC (Process Controls in GRC) module. This table is used for storing data of GRPC Settings....

    GRPCRTA_TJOBS SAP table for – Scheduler Watch List

    GRPCRTA_TJOBS table in SAP GRC (Process Controls -Automated Controls in GRC) module. This table is used for storing data of...

    GRPCSCRIPT_TEMP SAP table for – Script – Temporary table for installation

    GRPCSCRIPT_TEMP table in SAP GRC (Process Controls in GRC) module. This table is used for storing data of Script -...

    GRACROLEJOB SAP table for – Role Mangement Job Log

    GRACROLEJOB table in SAP GRC (Access Control in GRC) module. This table is used for storing data of Role Mangement...

    «
    »