CMM_D_IDX SAP table for – Commodity Management: Index Table

Here we would like to draw your attention to CMM_D_IDX table in SAP. As we know it is being mainly used with the SAP LO-CM (Configuration management in LO) component which is coming under LO module (Logistics). CMM_D_IDX is a SAP standard transparent table used for storing Commodity Management: Index Table related data in SAP. It comes under the package LOG_CMM_INDEX.

SAP CMM_D_IDX table

Table CMM_D_IDX technical data

TableCMM_D_IDX
Data storingCommodity Management: Index Table
ModuleLO
ComponentLO-CM
SAP PackageLOG_CMM_INDEX
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP CMM_D_IDX Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in CMM_D_IDX table.

  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is CMM_S_IDX_PK
  • OBJ_DOC_TYPE
    Its data type is C (Character String) with field length 4
  • OBJ_ITEM_HL
    Its data type is N (Character String with Digits Only) with field length 6
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • EKORG : Purchasing organization
    Its data type is C (Character String) with field length 4
  • EKGRP : Purchasing group for external processing
    Its data type is C (Character String) with field length 3
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • VKORG : Sales Organization
    Its data type is C (Character String) with field length 4
  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • VTWEG : Distribution Channel
    Its data type is C (Character String) with field length 2
  • SPART : Division
    Its data type is C (Character String) with field length 2
  • VKGRP : Sales group
    Its data type is C (Character String) with field length 3
  • VKBUR : Sales office
    Its data type is C (Character String) with field length 4
  • KUNNR : Customer number
    Its data type is C (Character String) with field length 10
  • RUN_FAILED
    Its data type is C (Character String) with field length 1
  • RUN_ID
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • EXPIRATION_DATE : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VALIDITY_DATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PRE_OBJ_TYPE
    Its data type is C (Character String) with field length 10
  • PRE_OBJ_ID
    Its data type is C (Character String) with field length 35
  • PRE_OBJ_ITEM
    Its data type is N (Character String with Digits Only) with field length 6
  • PRE_OBJ_DOC_TYPE
    Its data type is C (Character String) with field length 4
  • PRE_OBJ_DOC_CAT
    Its data type is C (Character String) with field length 2
  • START_OBJ_TYPE
    Its data type is C (Character String) with field length 10
  • START_OBJ_ID
    Its data type is C (Character String) with field length 35
  • CONSUMER : Alert configuration: dataelement for mea utilization
    Its a key field. Its data type is C (Character String) with field length 4
  • START_OBJ_ITEM
    Its data type is N (Character String with Digits Only) with field length 6
  • START_OBJ_DOC_TYPE
    Its data type is C (Character String) with field length 4
  • START_OBJ_DOC_CAT
    Its data type is C (Character String) with field length 2
  • START_OBJ_EXT_ID
    Its data type is C (Character String) with field length 35
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • CRTSP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • CHTSP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • OBJ_TYPE : Repository Object Type
    Its a key field. Its data type is C (Character String) with field length 10
  • OBJ_ID : Character 100
    Its a key field. Its data type is C (Character String) with field length 35
  • OBJ_ITEM
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • OBJ_DOC_CAT
    Its data type is C (Character String) with field length 2