The COMM_SCEHASPRT table in SAP ERP or S/4HANA stores Components of Decomposition (BOM and so on) data. There are total 12 fields in COMM_SCEHASPRT table. The Components of Decomposition (BOM and so on) 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_SCEHASPRT table. It is in SCE Database (COM_SCE_DB) ABAP package and is part of the Product Configuration (CRM-BF-CFG) module.
SAP COMM_SCEHASPRT Table Fields
Following is the list of fields that are available in SAP COMM_SCEHASPRT table. The primary key fields of the table are MANDT (Client), KBID (Internal Number of SCE Knowledge Base), DECOMPID (BOM Number), POSID (Internal Counter for Objects in an SCE Knowledge Base).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| KBID | Internal Number of SCE Knowledge Base | COMT_SCED_KBID | INT4 (10) | |
| DECOMPID | BOM Number | COMT_SCED_DECOMPID | CHAR (8) | |
| POSID | Internal Counter for Objects in an SCE Knowledge Base | COMT_SCED_ID | INT4 (10) | |
| OBJID | Internal Counter for Objects in an SCE Knowledge Base | COMT_SCED_ID | INT4 (10) | |
| POSMIN | Minimum Number of Instances for BOM Item | COMT_SCED_POSMIN | INT2 (5) | |
| POSMAX | Maximum Number of Instances for BOM Item | COMT_SCED_POSMAX | INT2 (5) | |
| ALTGROUPID | Internal Counter for Objects in an SCE Knowledge Base | COMT_SCED_ID | INT4 (10) | |
| CONGROUPID | Internal Counter for Objects in an SCE Knowledge Base | COMT_SCED_ID | INT4 (10) | |
| POSNR | BOM Item Number | COMT_SCED_PARTPOS | CHAR (4) | |
| SALESRELEV | Boolean (T = True, F = False, Blank = Unknown) | COMT_SCED_BOOLEAN | CHAR (1) | |
| STATUSID | Internal Counter for Objects in an SCE Knowledge Base | COMT_SCED_SMALLID | INT2 (5) |
