The CACS00_B_VAR_ACT table in SAP ERP or S/4HANA stores Variants for Commission Case Activities data. There are total 18 fields in CACS00_B_VAR_ACT table. The Variants for 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_B_VAR_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_B_VAR_ACT Table Fields
Following is the list of fields that are available in SAP CACS00_B_VAR_ACT table. The primary key fields of Variants for Commission Case Activities table in SAP are CLIENT (Client), ENAME (User Name), VAR (Variant Name).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| ENAME | User Name | UNAME | CHAR (12) | |
| VAR | Variant Name | RALDB_VARI | CHAR (14) | |
| 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) |
