The COMM_IPRODUCT table in SAP ERP or S/4HANA stores Inactive Product data. There are total 14 fields in COMM_IPRODUCT table. The Inactive Product 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_IPRODUCT table. It is in Product: General Tables and Programs (COM_PRODUCT) ABAP package and is part of the Central Part of Product Master (AP-MD-PRO) module.
SAP COMM_IPRODUCT Table Fields
Following is the list of fields that are available in SAP COMM_IPRODUCT table. The primary key fields of the table are CLIENT (Client), PRODUCT_GUID (Internal Unique ID of Product).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| PRODUCT_GUID | Internal Unique ID of Product | COMT_PRODUCT_GUID | COMM_PRODUCT | RAW (16) |
| PRODUCT_ID | Product ID | COMT_PRODUCT_ID | CHAR (40) | |
| PRODUCT_TYPE | Product Type | COMT_PRODUCT_TYPE | * | CHAR (2) |
| CONFIG | Determines Whether a Product Is Configurable | COMT_PRODUCT_CONFIGURABLE | * | CHAR (1) |
| XNOSEARCH | Product Is Not Relevant for Search Help | COMT_PRODUCT_XNOSEARCH | CHAR (1) | |
| OBJECT_FAMILY | Object Family | COMT_PRODUCT_OBJECT_FAMILY | COMC_PR_OBJ_FAM | CHAR (4) |
| BATCH_DEDICATED | Are batches defined for the product? | COMT_BATCH_DEDICATED | CHAR (1) | |
| COMPETITOR_PROD | Indicates Product Is a Competitor Product | COMT_PR_COMP | CHAR (1) | |
| VALID_FROM | Valid From (Time Stamp) | COMT_VALID_FROM | DEC (15) | |
| VALID_TO | Valid To (Time Stamp) | COMT_VALID_TO | DEC (15) | |
| UPNAME | Name of the User Who Last Changed the Set | COMT_UPNAME | CHAR (12) | |
| HISTEX | History Exists | COMT_HISTEX | CHAR (1) | |
| LOGSYS | Original System | COMT_LOGSYS | * | CHAR (10) |
