The CACS00_ACT table in SAP ERP or S/4HANA stores Commission Case Activities data. There are total 15 fields in CACS00_ACT table. The Commission Case Activities 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_ACT 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_ACT Table Fields
Following is the list of fields that are available in SAP CACS00_ACT table. The primary key fields of Commission Case Activities table in SAP are MANDT (Client), IMPORT_YEAR (Year Commission Case Reported), CASE_ID (ID of Commission Case), CASE_VERS (Commission Case Version), ACT_POS (Identification of an Activity Line).
| 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) | |
| ACT_POS | Identification of an Activity Line | CACSACTPOS | CHAR (4) | |
| FLG_CANCEL_OBJ | Indicator: Object is Invalid | CACSCANCOBJ | CHAR (1) | |
| FLG_CANCEL_VERS | Indicator: Version is Invalid | CACSCANCVERS | CHAR (1) | |
| STATUS_VERSION | Object Version Status | CACSSTATUSVERS | TCACS_VALSTAT1 | CHAR (1) |
| STATUS_WORK | Object Processing Status (Replica) | CACSSTATUSWORKP | TCACS_VALSTAT1 | CHAR (1) |
| TRI_OBJ_TYPE | Triggering Subobject Type | CACSTRIOBJ | * | CHAR (5) |
| TRI_OBJ_ID | Identification of Triggering Subobject | CACSTRIOBJID | CHAR (12) | |
| TRI_OBJ_ID_EXT | External Identification of Triggering Subobject | CACSTRIOBJIDEXT | CHAR (36) | |
| TRI_OBJ_METH | Triggering Method | CACSTRIMETH | * | CHAR (3) |
| PART_POS | Reference to a Participation in a Commission Case | CACSPARTID_REF | CHAR (4) | |
| FLG_REVERSED | Indicator: Row/Object/Subobject is Invalid or Reversed | CACSFLGREV | CHAR (1) |
