The CMM_D_IDX table in SAP ERP or S/4HANA stores Commodity Management: Index Table data. There are total 38 fields in CMM_D_IDX table. The Commodity Management: Index Table 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 CMM_D_IDX table. It is in (LOG_CMM_INDEX) ABAP package and is part of the Basic Functions (LO-CMM-BF) module.
SAP CMM_D_IDX Table Fields
Following is the list of fields that are available in SAP CMM_D_IDX table. The primary key fields of the table are MANDT (Client), CONSUMER (Index: Consumer), OBJ_TYPE (Index: Object Type), OBJ_ID (Index: Object ID), OBJ_ITEM (Index: Object Item Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| CONSUMER | Index: Consumer | CMM_IDX_CONSUMER | CHAR (4) | |
| OBJ_TYPE | Index: Object Type | CMM_IDX_OBJ_TYPE | * | CHAR (10) |
| OBJ_ID | Index: Object ID | CMM_IDX_OBJ_ID | CHAR (35) | |
| OBJ_ITEM | Index: Object Item Number | CMM_IDX_OBJ_ITEM | NUMC (6) | |
| OBJ_DOC_CAT | Index: Document Category | CMM_IDX_OBJ_DOC_CAT | CHAR (4) | |
| OBJ_DOC_TYPE | Index: Document Type | CMM_IDX_OBJ_DOC_TYPE | CHAR (4) | |
| OBJ_ITEM_HL | Commodity Management: High Level Number of Object Item | CMM_OBJ_ITEM_HIGH_LEVEL | NUMC (6) | |
| BUKRS | Company Code | BUKRS | CHAR (4) | |
| EKORG | Purchasing organization | EKORG | * | CHAR (4) |
| EKGRP | Purchasing Group | EKGRP | * | CHAR (3) |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR (10) | |
| VKORG | Sales Organization | VKORG | CHAR (4) | |
| VTWEG | Distribution Channel | VTWEG | CHAR (2) | |
| SPART | Division | SPART | CHAR (2) | |
| VKGRP | Sales group | VKGRP | * | CHAR (3) |
| VKBUR | Sales office | VKBUR | * | CHAR (4) |
| KUNNR | Customer Number | KUNNR | CHAR (10) | |
| RUN_FAILED | Index: Run Failure Indicator | CMM_IDX_RUN_FAILED | CHAR (1) | |
| RUN_ID | Index: Run ID | CMM_IDX_RUN_ID | DEC (15) | |
| EXPIRATION_DATE | Index: Expiration Date | CMM_IDX_EXPIRATION_DATE | DATS (8) | |
| VALIDITY_DATE | Index: Validity Date (from) | CMM_IDX_VALIDITY_DATE | DATS (8) | |
| PRE_OBJ_TYPE | Index: Object Type | CMM_IDX_OBJ_TYPE | * | CHAR (10) |
| PRE_OBJ_ID | Index: Object ID | CMM_IDX_OBJ_ID | CHAR (35) | |
| PRE_OBJ_ITEM | Index: Object Item Number | CMM_IDX_OBJ_ITEM | NUMC (6) | |
| PRE_OBJ_DOC_TYPE | Index: Document Type | CMM_IDX_OBJ_DOC_TYPE | CHAR (4) | |
| PRE_OBJ_DOC_CAT | Index: Document Category | CMM_IDX_OBJ_DOC_CAT | CHAR (4) | |
| START_OBJ_TYPE | Index: Object Type | CMM_IDX_OBJ_TYPE | * | CHAR (10) |
| START_OBJ_ID | Index: Object ID | CMM_IDX_OBJ_ID | CHAR (35) | |
| START_OBJ_ITEM | Index: Object Item Number | CMM_IDX_OBJ_ITEM | NUMC (6) | |
| START_OBJ_DOC_TYPE | Index: Document Type | CMM_IDX_OBJ_DOC_TYPE | CHAR (4) | |
| START_OBJ_DOC_CAT | Index: Document Category | CMM_IDX_OBJ_DOC_CAT | CHAR (4) | |
| START_OBJ_EXT_ID | Index: External ID | CMM_IDX_EXT_ID | CHAR (35) | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR (12) | |
| CRTSP | Index: UTC Time Stamp when Object was Added | CMM_IDX_CRTSP | DEC (15) | |
| AENAM | Name of person who changed object | AENAM | CHAR (12) | |
| CHTSP | Index: UTC Time Stamp when Object was Changed | CMM_IDX_CHTSP | DEC (15) | |
| KEY | NodeID | /BOBF/CONF_KEY | RAW (16) |
