CACS00_DOCSE SAP table for – Commission Document, Settlement

Here we would like to draw your attention to CACS00_DOCSE 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). CACS00_DOCSE is a SAP standard transp table used for storing Commission Document, Settlement related data in SAP. It comes under the package CACSDO.

SAP CACS00_DOCSE table

Table CACS00_DOCSE technical data

TableCACS00_DOCSE
Data storingCommission Document, Settlement
ModuleICM
Sub ModuleICM
SAP PackageCACSDO
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

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

  • .INCLUDE : Commission Document, Settlement (Key)
    Its a key field.
  • .INCLUDE : Commission Document Header (Key)
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • POST_YEAR : Assignment Year of Commission Case/Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • DOC_ID : Document Identification
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • SETTL_POS : Identification of a Settlement Item
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Commission Document, Settlement (Data)
  • .INCLUDE : Status Management for Document Data Items
  • FLG_REVERSED : Indicator: Row/Object/Subobject is Invalid or Reversed
    Its data type is CHAR (Character String) with field length 1
  • STATUS_POS : Status of Object/Subobject
    Its data type is CHAR (Character String) with field length 1
  • STATUS_WORK : Object Processing Status (Replica)
    Its data type is CHAR (Character String) with field length 1
  • CTRTBU_ID : Commission Contract Number
    Its data type is CHAR (Character String) with field length 20
  • GPART : Business Partner to Receive Commission
    Its data type is CHAR (Character String) with field length 10
  • DUE_DATE : Due Date of Line Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DUE_YEAR : Year Due: Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DUE_MONTH : Period in Year Due
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • STMTYPE_ID : Identification of Settlement Type
    Its data type is CHAR (Character String) with field length 4
  • REMUNERATION : Remuneration Type
    Its data type is CHAR (Character String) with field length 4
  • SETTLE_GROUP : Settlement Item Grouping in Document
    Its data type is CHAR (Character String) with field length 4
  • FLG_INTSETTLE : Settlement Item Serves Immediate Clearing
    Its data type is CHAR (Character String) with field length 1
  • DET_GRP : Grouping of Due Line Item Detail in Document
    Its data type is CHAR (Character String) with field length 4
  • CON_CURR : Contract Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DUE_CONAMNT : Remuneration Amount Ready for Disbursement in Contr Currency
    Its data type is CURR (Currency Field) with field length 15
  • LED_CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DUE_LEDAMNT : Disbursable Partial Remuner.Amount in Comm. Model Currency
    Its data type is CURR (Currency Field) with field length 15
  • REM_UNIT : Remuneration Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DUE_QUAN : Remuneration Quantity Ready for Disbursement
    Its data type is QUAN (Quantity field) with field length 11
  • SETTLE_DATE : Settlement Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SETTLE_POST_YEAR : Posting Year of Settlement Document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SETTLE_DOC_ID : Settlement Document Number
    Its data type is CHAR (Character String) with field length 10
  • PMNT_BLOCK : Payment Block Key
    Its data type is CHAR (Character String) with field length 1
  • REM_CASE_TXT : Short Text for Settlement Item
    Its data type is CHAR (Character String) with field length 40
  • REV_POS : Reversing Row of Related Reversal Document
    Its data type is CHAR (Character String) with field length 4
  • SETT_LOCK : Indicator: Item Waiting for Subsequent Process
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Last Changes to Objects
  • UPD_TIMESTAMP : Last Change of Objects
    Its data type is NUMC (Character String with Digits Only) with field length 14