The CACS_STSESRU table in SAP ERP or S/4HANA stores Standard Settlement Schedule Agreement data. There are total 19 fields in CACS_STSESRU table. The Standard Settlement Schedule Agreement 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_STSESRU table. It is in ICM Settlement Scheduling: Database Tables (CACSS5) ABAP package and is part of the Incentive and Commission Management (ICM) (ICM) module.
SAP CACS_STSESRU Table Fields
Following is the list of fields that are available in SAP CACS_STSESRU table. The primary key fields of Standard Settlement Schedule Agreement table in SAP are MANDT (Client), APPL (Commission Application (ICM)), STCAGR_ID (Standard Agreement Number), AGR_TYP (Agreement Type), SESRU_ID (Scheduling Rule), 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) |
| STCAGR_ID | Standard Agreement Number | CACS_STCAGR_ID | CACS_STCAGR | CHAR (12) |
| AGR_TYP | Agreement Type | CACS_AGR_TYP | TCACS_AGR | CHAR (2) |
| SESRU_ID | Scheduling Rule | CACSSESRUID | TCACS_SESRU | CHAR (4) |
| VERSION | Version of Master Data or Customizing Object | CACSVERSION | NUMC (6) | |
| PRIORITY | Sequential Number | CACSPRIORITY | NUMC (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) |
