The COMM_IL_CS_11 table in SAP ERP or S/4HANA stores Source Product-Target Product-Association Rule data. There are total 15 fields in COMM_IL_CS_11 table. The Source Product-Target Product-Association Rule 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 COMM_IL_CS_11 table. It is in CRM Marketing: Product Association Rules (CRM_MKTPR) ABAP package and is part of the Cross-Selling (CRM-MKT-PRP-CRS) module.
SAP COMM_IL_CS_11 Table Fields
Following is the list of fields that are available in SAP COMM_IL_CS_11 table. The primary key fields of the table are CLIENT (Client), ILGUID (Internal, Unique ID of a Relationship).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| ILGUID | Internal, Unique ID of a Relationship | COMT_IL_ILGUID | RAW (16) | |
| SOURCEGUID | Internal ID for Source in a Relationship | COMT_IL_SOURCEGUID | RAW (16) | |
| DESTINGUID | Internal ID for Destination in a Relationship | COMT_IL_DESTINGUID | RAW (16) | |
| OBJTYPE | Usage of Association Rule | CRMT_MKTPR_OBJTYPE | CHAR (2) | |
| STATE | CRM Marketing: Status of an Association Rule | CRMT_MKTPR_STATE | CHAR (1) | |
| OBJGUID | Internal Unique ID for a Reference Object | CRMT_MKTPR_OBJGUID | RAW (16) | |
| ORIGIN | Origin of an Association Rule | CRMT_MKTPR_AR_ORIGIN | CHAR (1) | |
| SHTEXT | Short Description for a Rule (Comment) | CRMT_MKTPR_AR_SHTEXT | CHAR (40) | |
| SUPPORT | CRM Marketing: Key Figure Support | CRMT_MKTPR_SUPPORT | DEC (5) | |
| CONFIDENCE | CRM Marketing: Confidence Key Figure | CRMT_MKTPR_CONFIDENCE | DEC (5) | |
| MODEL_ID | Analytical Model | RSDMEM_MODEL | CHAR (30) | |
| LOGSYS | Logical System in Which the Relationship Was Created | COMT_IL_LOGSYS | * | CHAR (10) |
| UPNAME | Relationship Last Changed By | COMT_IL_UPNAME | CHAR (12) | |
| VALID_FROM | Valid From (Time Stamp) | COMT_IL_VALID_FROM | DEC (15) |
