The COMM_IL_STRPRP_H table in SAP ERP or S/4HANA stores History of Relationship “Prepack Products” data. There are total 15 fields in COMM_IL_STRPRP_H table. The History of Relationship “Prepack Products” 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_STRPRP_H table. It is in Product: Structured Products, Bills of Material (COM_PRODUCT_BOM) ABAP package and is part of the Products (CRM-MD-PRO) module.
SAP COMM_IL_STRPRP_H Table Fields
Following is the list of fields that are available in SAP COMM_IL_STRPRP_H table. The primary key fields of the table are CLIENT (Client), ILGUID (Internal, Unique ID of a Relationship), VALID_TO (Valid To (Time Stamp)).
| 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) | |
| VALID_TO | Valid To (Time Stamp) | COMT_IL_VALID_TO | DEC (15) | |
| 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) | |
| POSNR | BOM Item Number | COMT_SCED_PARTPOS | CHAR (4) | |
| MINQUAN | Component Quantity | COMT_IL_MINQUAN | QUAN (13) | |
| UNIT1 | Units of Measure of Product | COMT_UNIT | T006 | UNIT (3) |
| MAXQUAN | Maximum Component Quantity of Structured Product | COMT_IL_MAXQUAN | QUAN (13) | |
| UNIT2 | Units of Measure of Product | COMT_UNIT | T006 | UNIT (3) |
| CFGREL | Indicator: Component Is Relevant to Configuration | COMT_IL_CONFIGREL | CHAR (1) | |
| SDREL | Indicator: Component Is Relevant to Sales | COMT_IL_SALESREL | CHAR (1) | |
| 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) |
