The CACS00_OBJHIST table in SAP ERP or S/4HANA stores Change History of Subobjects That Trigger Commission data. There are total 21 fields in CACS00_OBJHIST table. The Change History of Subobjects That Trigger Commission 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_OBJHIST 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_OBJHIST Table Fields
Following is the list of fields that are available in SAP CACS00_OBJHIST table. The primary key fields of Change History of Subobjects That Trigger Commission table in SAP are MANDT (Client), TRI_OBJ_ID (Identification of Triggering Subobject), VERSION (Version of Master Data or Customizing Object).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| TRI_OBJ_ID | Identification of Triggering Subobject | CACSTRIOBJID | CHAR (12) | |
| VERSION | Version of Master Data or Customizing Object | CACSVERSION | NUMC (6) | |
| TRI_OBJ_TYPE | Triggering Subobject Type | CACSTRIOBJ | TCACS_OBJTYPES | CHAR (5) |
| TRI_OBJ_ID_EXT | External Identification of Triggering Subobject | CACSTRIOBJIDEXT | CHAR (36) | |
| BUSOBJ_TYPE | Business Object Category that Triggers Commission | CACSBUSOBJTYP | TCACS_BUSOBJ | CHAR (3) |
| BUSOBJ_ID | Identification of Triggering Business Object | CACSBUSOBJID | CHAR (30) | |
| IMPORT_YEAR | Year Commission Case Reported | CACSIMPYEAR | NUMC (4) | |
| CASE_ID | ID of Commission Case | CACSCASEID | CHAR (10) | |
| BUSI_BEGIN | Effective from | CACS_BUSITIME_B | NUMC (14) | |
| BUSI_END | Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss) | CACS_BUSITIME_E | NUMC (14) | |
| TECH_BEGIN | Technically Valid From | CACS_TECHTIME_B | NUMC (14) | |
| TECH_END | Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss) | CACS_TECHTIME_E | NUMC (14) | |
| FLG_CANCEL_OBJ | Indicator: Object is Invalid | CACSCANCOBJ | CHAR (1) | |
| FLG_CANCEL_VERS | Indicator: Version is Invalid | CACSCANCVERS | CHAR (1) | |
| 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 | CHAR (1) | |
| STATUS_VERSION | Object Version Status | CACSSTATUSVERS | TCACS_VALSTAT1 | CHAR (1) |
| STATUS_WORK | Object Version Processing Status | CACSSTATUSWORK | TCACS_VALSTAT1 | CHAR (1) |
