The CACS_STWARRU table in SAP ERP or S/4HANA stores Rule Characteristics for Guarantee Agreement data. There are total 33 fields in CACS_STWARRU table. The Rule Characteristics for Guarantee 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_STWARRU table. It is in ICM: Guarantees: DDIC + APIs for DDIC (CACSGU5) ABAP package and is part of the Incentive and Commission Management (ICM) (ICM) module.
SAP CACS_STWARRU Table Fields
Following is the list of fields that are available in SAP CACS_STWARRU table. The primary key fields of Rule Characteristics for Guarantee Agreement table in SAP are MANDT (Client), APPL (Commission Application (ICM)), STCAGR_ID (Standard Agreement Number), AGR_TYP (Agreement Type), STWARRU_ID (Identification of Standard Guarantee Agreement 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) |
| STWARRU_ID | Identification of Standard Guarantee Agreement Rule | CACS_STWARRU_ID | NUMC (12) | |
| VERSION | Version of Master Data or Customizing Object | CACSVERSION | NUMC (6) | |
| REMUNERATION | Remuneration Type | CACSREM | TCACS_REM | CHAR (4) |
| DURATION | Duration of Guarantee Agreement | CACS_REMA_DUR | CHAR (2) | |
| WAR_AMNT | Guarantee Amount | CACS_WARR_AMNT | CURR (15) | |
| MIN_WAR_AMNT | Minimum Guarantee Amount | CACS_WAR_MINAMNT | CURR (15) | |
| MAX_WAR_AMNT | Maximum Guarantee Amount | CACS_WAR_MAXAMNT | CURR (15) | |
| EXCESS_REM | Remuneration Type Excess | CACSEXCESSREM | TCACS_REM | CHAR (4) |
| RECALL_REM | Remuneration Type Recall | CACSRECALLREM | TCACS_REM | CHAR (4) |
| RETAINED_REM | Remuneration Type for Retained Excess Remuneration | CACSRETAINREM | TCACS_REM | CHAR (4) |
| RETRU_ID | Identification of Retention Rule | CACSRETRUID | TCACS_RETRU | CHAR (4) |
| EXCESS_OFFSET | Guarantee: Offsetting of Excess with Subthreshold Earnings | CACSGUEXCOFF | CHAR (1) | |
| EXCESS_RETAIN | Guarantee: Retain Remaining Excess Earnings | CACSGUEXCRET | CHAR (1) | |
| RULE_ID | Period Rule | CACSPRDRULE | CHAR (7) | |
| ALLOCATION | Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances) | CACSALLOC | CHAR (1) | |
| REASSIGNMENT | Reassignment | CACSREASSIGN | CHAR (1) | |
| DUE_DATEMARK | Indicator: Due Date at Start or End of Period | CACSDUEDATEM | CHAR (1) | |
| 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) |
