CACS_STMTJO SAP table for – Settlement run log

Here we would like to draw your attention to CACS_STMTJO table in SAP. As we know it is being mainly used with the SAP ICM (Incentive and Commission Management) component which is coming under HR (HCM) ICM module (Incentive and Commission Management). CACS_STMTJO is a SAP standard transp table used for storing Settlement run log related data in SAP. It comes under the package CACSPY.

SAP CACS_STMTJO table

Table CACS_STMTJO technical data

TableCACS_STMTJO
Data storingSettlement run log
ModuleICM
Sub ModuleICM
SAP PackageCACSPY
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • APPL : Commission Application (ICM)
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • CTRTBU_ID : Commission Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • STMRU_ID : Number of Individual Settlement Rule
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 12
  • STARTDATEP : Date in Log
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RUNID : Commissions: Log Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • RUN_VERS : Run Log Version
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • ENDDATEP : End Date of Settlement Run
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • STMTYPE_ID : Identification of Settlement Type
    Its data type is CHAR (Character String) with field length 4
  • RULE_ID : Period Rule
    Its data type is CHAR (Character String) with field length 7
  • PERIOD_NO : Period Number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • FLG_REVERSED : Indicator: Row/Object/Subobject is Invalid or Reversed
    Its data type is CHAR (Character String) with field length 1
  • FLG_OPEN : Indicator: Period is Temporary/Closed
    Its data type is CHAR (Character String) with field length 1