CKMLMV005 SAP table for – Consumption alternatives

Here we would like to draw your attention to CKMLMV005 table in SAP. As we know it is being mainly used with the SAP CO-PC (Product Cost Controlling in CO) component which is coming under CO module (Controlling). CKMLMV005 is a SAP standard transparent table used for storing Consumption alternatives related data in SAP. It comes under the package CKMLMV.

SAP CKMLMV005 table

Table CKMLMV005 technical data

TableCKMLMV005
Data storingConsumption alternatives
ModuleCO
ComponentCO-PC
SAP PackageCKMLMV
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP CKMLMV005 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 CKMLMV005 table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • VTYP
    Its data type is C (Character String) with field length 4
  • SORT_NAME
    Its data type is C (Character String) with field length 10
  • NRULE
    Its data type is C (Character String) with field length 4
  • LOEKZ : CHAR01 data element for SYST
    Its data type is C (Character String) with field length 1
  • .INCLU-_ND
    Its include structure/component is is CKML_S_NDEF_VVERS
  • PWERK_ND
    Its data type is C (Character String) with field length 4
  • PMATN_ND
    Its data type is C (Character String) with field length 18
  • KOSTL_ND
    Its data type is C (Character String) with field length 10
  • KDAUF_ND
    Its data type is C (Character String) with field length 10
  • KDPOS_ND
    Its data type is N (Character String with Digits Only) with field length 6
  • KALNR : Cost Estimate Number for Cost Est. w/o Qty Structure
    Its a key field. Its data type is N (Character String with Digits Only) with field length 12
  • KUNDE_ND
    Its data type is C (Character String) with field length 10
  • PSPNR_ND
    Its data type is N (Character String with Digits Only) with field length 8
  • KSTRG_ND
    Its data type is C (Character String) with field length 12
  • SAKNR_ND
    Its data type is C (Character String) with field length 10
  • OBJNR_ND
    Its data type is C (Character String) with field length 22
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CKML_S_ADD_ACCOUNTS
  • PRCTR_ND
    Its data type is C (Character String) with field length 10
  • GSBER_ND
    Its data type is C (Character String) with field length 4
  • BUKRS_ND
    Its data type is C (Character String) with field length 4
  • VBUND_ND
    Its data type is C (Character String) with field length 6
  • OTYP
    Its data type is C (Character String) with field length 2
  • SPEZ_NAME_ND
    Its data type is C (Character String) with field length 30
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BWKEY : Valuation area
    Its data type is C (Character String) with field length 4
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • KALNR_MAT
    Its data type is N (Character String with Digits Only) with field length 12