The CACS_REMSTM table in SAP ERP or S/4HANA stores Remuneration settlement data. There are total 20 fields in CACS_REMSTM table. The Remuneration settlement 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 CACS_REMSTM table. It is in ICM: DDIC for ICM Basis Framework (CACS2D) ABAP package and is part of the Incentive and Commission Management (ICM) (ICM) module.
SAP CACS_REMSTM Table Fields
Following is the list of fields that are available in SAP CACS_REMSTM table. The primary key fields of Remuneration settlement table in SAP are MANDT (Client), APPL (Commission Application (ICM)), REMSTM_ID (Identification of Remuneration Settlement), STSTMRU_ID (Settlement Rule Number), STCAGR_ID (Standard Agreement Number), AGR_TYP (Agreement Type), VERSION (Version of Master Data or Customizing Object).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| APPL | Commission Application (ICM) | CACSAPPL | TCACS_APPLDEF | CHAR (6) |
| REMSTM_ID | Identification of Remuneration Settlement | CACS_REMASTM_ID | NUMC (12) | |
| STSTMRU_ID | Settlement Rule Number | CACS_STSTMRU_ID | CACS_STSTMRU | NUMC (12) |
| STCAGR_ID | Standard Agreement Number | CACS_STCAGR_ID | CACS_STCAGR | CHAR (12) |
| AGR_TYP | Agreement Type | CACS_AGR_TYP | TCACS_AGR | CHAR (2) |
| VERSION | Version of Master Data or Customizing Object | CACSVERSION | NUMC (6) | |
| REMUNERATION | Remuneration Type | CACSREM | TCACS_REM | CHAR (4) |
| 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) |
