The CACS_CTRTPAR table in SAP ERP or S/4HANA stores Individual Contract Participation data. There are total 24 fields in CACS_CTRTPAR table. The Individual Contract Participation 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_CTRTPAR 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_CTRTPAR Table Fields
Following is the list of fields that are available in SAP CACS_CTRTPAR table. The primary key fields of Individual Contract Participation table in SAP are MANDT (Client), APPL (Commission Application (ICM)), LOWPARCTRTBU (Contract Number of the Lower-Level Participant), CTRTPAR_ID (Identification of the Ind. Contract Participation), SUPPARCTRTBU (Contract Number of Higher-Level Participant), ROLETYPE (Entitlement Category), 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) |
| LOWPARCTRTBU | Contract Number of the Lower-Level Participant | CACSLOWPARTCTRTBU | CACS_CONTR | CHAR (20) |
| CTRTPAR_ID | Identification of the Ind. Contract Participation | CACSCTRTPAR_ID | NUMC (12) | |
| SUPPARCTRTBU | Contract Number of Higher-Level Participant | CACSSUPWPARTCTRTBU | CACS_CONTR | CHAR (20) |
| ROLETYPE | Entitlement Category | CACSCLAIMTYPE | TCACS_CLT | CHAR (1) |
| VERSION | Version of Master Data or Customizing Object | CACSVERSION | NUMC (6) | |
| ROLE | Participant Role | CACSROLE | TCACS_ROLE | CHAR (3) |
| ROLECOMMSHAR | Share of Direct Remuneration (in Percent) | CACSCOMMSHARE | DEC (10) | |
| COMDISTTYPE | Distribution Category for Direct Remuneration | CACSCOMDISTTYPE | CHAR (1) | |
| ROLEPRODSHAR | Share of Indirect Remuneration (in Percent) | CACSPRODSHARE | DEC (10) | |
| PRODDISTTYPE | Distribution category for indirect remuneration | CACSPRODDISTTYPE | 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) |
