The CACS00_CAS table in SAP ERP or S/4HANA stores Commission Case data. There are total 55 fields in CACS00_CAS table. The Commission Case table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CACS00_CAS table. It is in ICM: Commission Case ‘Light’ (CACSCC) ABAP package and is part of the Incentive and Commission Management (ICM) (ICM) module.
SAP CACS00_CAS Table Fields
Following is the list of fields that are available in SAP CACS00_CAS table. The primary key fields of Commission Case table in SAP are MANDT (Client), IMPORT_YEAR (Year Commission Case Reported), CASE_ID (ID of Commission Case), CASE_VERS (Commission Case Version).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| IMPORT_YEAR | Year Commission Case Reported | CACSIMPYEAR | NUMC (4) | |
| CASE_ID | ID of Commission Case | CACSCASEID | CHAR (10) | |
| CASE_VERS | Commission Case Version | CACSCASEVERS | NUMC (6) | |
| KNW_TIMESTAMP | Calculation Time Stamp | CACSKNOWTSTMP | NUMC (14) | |
| CLC_TIMESTAMP | Effective Time Stamp (Effective Status) | CACSCALCTSTMP | NUMC (14) | |
| FLG_CANCEL_OBJ | Indicator: Object is Invalid | CACSCANCOBJ | CHAR (1) | |
| FLG_CANCEL_VERS | Indicator: Version is Invalid | CACSCANCVERS | CHAR (1) | |
| CHG_TIMESTAMP | Creation Time Stamp of Object | CACSCHGTSTMP | NUMC (14) | |
| CHG_TCODE | Transaction in Which the Change Was Made | CACSCDTC | * | CHAR (20) |
| CHG_USR | Last user to change object | CACSCHUSR | CHAR (12) | |
| TRI_METH_TYP | Triggering Method | CACSTRIMETHTYP | CHAR (1) | |
| TRI_METH_TARGET | Processing Target of Triggering Method | CACSTRIMETHTAR | TCACS_VALTARG1 | CHAR (1) |
| STATUS_VERSION | Object Version Status | CACSSTATUSVERS | TCACS_VALSTAT1 | CHAR (1) |
| STATUS_WORK | Object Version Processing Status | CACSSTATUSWORK | TCACS_VALSTAT1 | CHAR (1) |
| POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | CACSPSTDAT | DATS (8) | |
| RESP_DATE | Liability Selection Date for Viewing Liability | CACSRESPDAT | DATS (8) | |
| IMPORT_DATE | Date Commission Case Entered in Commission System | CACSIMPDAT | DATS (8) | |
| RELEASE_DATE | Release Date of Operational Sys. for Commission Notification | CACSRELDAT | DATS (8) | |
| FLG_NOSETTLEMENT | Ind.: Remuneration Determined Already Paid Out | CACSNOSETTLEMENT | CHAR (1) | |
| FLG_NORESETTLE | Ind.: Remuneration Cancellation Found is Already Settled | CACSNORESETTLEMENT | CHAR (1) | |
| FLG_FUTURECHECK | Indicator: Carry Out Check for Future Objects | CACSFUTURECHECK | CHAR (1) | |
| BUSOBJ_TYPE | Business Object Category that Triggers Commission | CACSBUSOBJTYP | TCACS_BUSOBJ | CHAR (3) |
| BUSOBJ_ID | Identification of Triggering Business Object | CACSBUSOBJID | CHAR (30) | |
| BUSOBJ_VERS | Business Object Version | CACSBUSOBJVERS | NUMC (14) | |
| BUSOBJ_VERSDATE | Date Business Object Version Starts | CACSVERSDATE | NUMC (14) | |
| REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | CACSREMBUSCASTYP | TCACS_BUSCAS | CHAR (3) |
| REM_BUSCASE_ID | Identification of Triggering Bus. Transaction in Op. System | CACSREMBUSCASEID | CHAR (36) | |
| REM_BUSCASE_VERS | Business Transaction Version | CACSREMBUSCASEVERS | NUMC (14) | |
| LED_CURR | Currency Key for the Transaction | CACSTRACURR | TCURC | CUKY (5) |
| CASE_TXT | Short Text for Commission Case | CACSTRICASETXT | CHAR (40) | |
| TRIGGER_SYS | Logical Operational System | CACSLOGSYSTEM | * | CHAR (10) |
| TRIGGER_DATE | Trigger Date of Commission Case in Operational System | CACSTRIDAT | DATS (8) | |
| TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | CACSTRIBUSCASTYP | TCACS_BUSCAS | CHAR (3) |
| TRI_BUSCASE_ID | Identification of Triggering Bus. Transaction in Op. System | CACSTRIBUSCASEID | CHAR (36) | |
| TRI_BUSCASE_VERS | Version of Master Data or Customizing Object | CACSVERSIONLONG | NUMC (14) | |
| TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | CACS_TRGCAS_TYPE | * | CHAR (4) |
| TRGCASAGR_ID | Identification of Additional Commission Case Agreement | CACS_TRGCASAGR_ID | NUMC (12) | |
| TRGCASRU_ID | Rule Identification for Additional Commission Cases | CACS_TRGCASRU_ID | NUMC (12) | |
| PERIODRULE_ID | Period Rule | CACSPRDRULE | CHAR (7) | |
| PERIOD_NO | Period Number | CACSPERIOD | NUMC (6) | |
| RUN_ID | Identification Number of Processing Run | CACSBATCHID | CHAR (10) | |
| EXT_RUN_ID | Identification Number of External Processing Run | CACSBATCHEXT | CHAR (10) | |
| COPY_OBJ_TYPE | Type of Business Object That Triggered Commission | CACSBUSOBJTYPCOPY | * | CHAR (3) |
| COPY_OBJ_ID | Identification of a Triggering Business Object | CACSBUSOBJIDCOPY | CHAR (30) | |
| COPY_OBJ_VERS | Version of Master Data or Customizing Object | CACSVERSIONLONG | NUMC (14) | |
| COPY_CASE_TYPE | Remunerating Business Transaction in Operational System | CACSBUSCASTYPCOPY | * | CHAR (3) |
| COPY_CASE_ID | Identif. of a Triggering Bus. Trans. in Operational System | CACSBUSCASEIDCOPY | CHAR (36) | |
| FLG_COPY_PAR | Indicator: Participation Construction Copy | CACSCOPYPAR | CHAR (1) | |
| FLG_COPY_ACT | Not Currently Used: Indicator for Copying Activities | CACSCOPYACT | CHAR (1) | |
| FLG_COPY_OBJ | Not Currently Used: Indicator for Copying Subobjects | CACSCOPYOBJ | CHAR (1) | |
| LOG_HANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR (22) | |
| REV_TIMESTAMP | Release Time Stamp of Object on Principle of Dual Control | CACSREVTSTMP | NUMC (14) | |
| REV_TCODE | Transaction in Which the Change Was Made | CACSCDTC | * | CHAR (20) |
| REV_USR | User Who Released Object After Dual Checks | CACSREVUSR | CHAR (12) |
