CACS00_DOCRE SAP table for – Commission Document, Remuneration and Liability

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

SAP CACS00_DOCRE table

Table CACS00_DOCRE technical data

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

SAP CACS00_DOCRE 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_DOCRE table.

  • .INCLUDE : Commission Document, Remuneration and Liability (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
  • REMUN_POS : ID of Remuneration Row for Referenced Document
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Commission Document, Remuneration and Liability (Data)
  • FLG_COMPL : Indicator: Document Part Created by Complete Update
    Its data type is CHAR (Character String) with field length 1
  • .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
  • PART_POS : Position of Participation in a Commission Case
    Its data type is CHAR (Character String) with field length 4
  • INV_POS : Participant Position in a Participation
    Its data type is CHAR (Character String) with field length 4
  • CTRTBU_ID : Commission Contract Number
    Its data type is CHAR (Character String) with field length 20
  • BUCAGR_ID : Agreement Number
    Its data type is CHAR (Character String) with field length 12
  • CLAIM_OBJTYPE : Entitlement Object Type
    Its data type is CHAR (Character String) with field length 1
  • CLAIM_OBJID : ID of Entitlement Object Acc. to Entitlement Object Type
    Its data type is CHAR (Character String) with field length 30
  • REM_IMP_YEAR : Year Commission Case Reported
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REM_CASE_ID : Identification of a Case Resulting in Remuneration
    Its data type is CHAR (Character String) with field length 10
  • REM_CASE_VERS : Commission Case Version
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • POW_OBJ_TYPE : Subobject Type Where Activity Originates
    Its data type is CHAR (Character String) with field length 5
  • POW_OBJ_ID : Identification of Subobject of Activity Provided
    Its data type is CHAR (Character String) with field length 12
  • ACTIVITY : Activity Type
    Its data type is CHAR (Character String) with field length 4
  • ACT_POS : Identification of an Activity Line
    Its data type is CHAR (Character String) with field length 4
  • ACTGRP : Role
    Its data type is CHAR (Character String) with field length 4
  • REM_OBJ_TYPE : Remunerating Subobject Type
    Its data type is CHAR (Character String) with field length 5
  • REM_OBJ_ID : Identification of Subobject Resulting in Remuneration
    Its data type is CHAR (Character String) with field length 12
  • VALUE : Valuation Type
    Its data type is CHAR (Character String) with field length 4
  • VALUE_TYPE : Valuation Result Category
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • VALUE_POS : Valuation Row Identification
    Its data type is CHAR (Character String) with field length 4
  • REMVAL_LEDAMNT : Remuneration Value in Commission Model Currency
    Its data type is CURR (Currency Field) with field length 15
  • REMVAL_QUAN : Remuneration Value (Volume)
    Its data type is QUAN (Quantity field) with field length 11
  • VALUE_UNIT : Valuation Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ROLE : Participant Role
    Its data type is CHAR (Character String) with field length 3
  • ROLE_REMUSHAR : Share of Remuneration (in Percent)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • CONSTELL : Constellation of Participants
    Its data type is CHAR (Character String) with field length 4
  • DIST_TYPE : Remuneration Participation Category
    Its data type is CHAR (Character String) with field length 1
  • CON_CURR : Contract Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • LED_CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ALLOCATION : Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances)
    Its data type is CHAR (Character String) with field length 1
  • REMUNERATION : Remuneration Type
    Its data type is CHAR (Character String) with field length 4
  • REM_VERSION : Version of Master Data or Customizing Object
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • REM_RATE : Remuneration Record (For Example, Percentage)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • REM_CONAMNT : Remuneration Entitlement, Amount in Contract Currency
    Its data type is CURR (Currency Field) with field length 15
  • DUE_CONAMNT : Remuneration Amount Ready for Disbursement in Contr Currency
    Its data type is CURR (Currency Field) with field length 15
  • REM_LEDAMNT : Remunerat. Entitlement, Amount in Commission Model Currency
    Its data type is CURR (Currency Field) with field length 15
  • 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
  • REM_QUAN : Remuneration Entitlement as Quantity
    Its data type is QUAN (Quantity field) with field length 11
  • DUE_QUAN : Remuneration Quantity Ready for Disbursement
    Its data type is QUAN (Quantity field) with field length 11
  • OFFSET_END_DATE : End of Offsetting
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OFFSET_RULE_ID : Offsetting Type
    Its data type is CHAR (Character String) with field length 4
  • OFFSET_CONAMNT : Remaining Offset Amount in Contract Currency
    Its data type is CURR (Currency Field) with field length 15
  • OFFSET_LEDAMNT : Offsetting/Secondary Liability Amt Remaining in ComModCurr.
    Its data type is CURR (Currency Field) with field length 15
  • OFFSET_QUAN : Offsetting/Remaining Secondary Liability Quantity
    Its data type is QUAN (Quantity field) with field length 11
  • CORRBY_DOC_ID : Document Used to Correct This Row
    Its data type is CHAR (Character String) with field length 10
  • CORRBY_PST_YEAR : Assignment Year Document Used for Correcting Row
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CORRBY_PST_DATE : Posting Date in Commission Case/Comm Doc. (Acknowledgement)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CORRTO_DOC_ID : ID of Corrected Document
    Its data type is CHAR (Character String) with field length 10
  • CORRTO_PST_YEAR : Assignment Year Document That Corrected This Row
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CORRTO_REMUN_POS : ID of Remuneration Row in Corrected Document
    Its data type is CHAR (Character String) with field length 4
  • FLG_CORR : Indicator: Document Part Created by a Correction
    Its data type is CHAR (Character String) with field length 1
  • SETTLE_GROUP : Settlement Item Grouping in Document
    Its data type is CHAR (Character String) with field length 4
  • .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