CACS00_INV SAP table for – Commission Case Participants

Here we would like to draw your attention to CACS00_INV 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_INV is a SAP standard transp table used for storing Commission Case Participants related data in SAP. It comes under the package CACSCC.

SAP CACS00_INV table

Table CACS00_INV technical data

TableCACS00_INV
Data storingCommission Case Participants
ModuleICM
Sub ModuleICM
SAP PackageCACSCC
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP CACS00_INV 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_INV table.

  • .INCLUDE : Commission Case Participant (Key)
    Its a key field.
  • .INCLUDE : Commission Case Participation (Key)
    Its a key field.
  • .INCLUDE : Commission Case (Key)
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • IMPORT_YEAR : Year Commission Case Reported
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • CASE_ID : ID of Commission Case
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • CASE_VERS : Commission Case Version
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • PART_POS : Position of Participation in a Commission Case
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • INV_POS : Participant Position in a Participation
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Commission Case Participant (Data)
  • .INCLUDE : Version Management for Commission Case Items
  • FLG_CANCEL_OBJ : Indicator: Object is Invalid
    Its data type is CHAR (Character String) with field length 1
  • FLG_CANCEL_VERS : Indicator: Version is Invalid
    Its data type is CHAR (Character String) with field length 1
  • STATUS_VERSION : Object Version Status
    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
  • PD_OE_ID : Organizational Unit (Object Type O)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • GPART : Business Partner to Receive Commission
    Its data type is CHAR (Character String) with field length 10
  • ROLE : Participant Role
    Its data type is CHAR (Character String) with field length 3
  • ROLE_COMMSHAR : Share of Direct Remuneration (in Percent)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • ROLE_PRODSHAR : Share of Indirect Remuneration (in Percent)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • DISTRIBUTE : Distribution Key for the Activity Share
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • FLG_CONSTELL : Indicator: Ignore Commissions Contract in Constellation
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Commissions: Reversal Information for Document Row
  • FLG_REVERSED : Indicator: Row/Object/Subobject is Invalid or Reversed
    Its data type is CHAR (Character String) with field length 1