CKMLMV001 SAP table for – Procurement alternatives

Here we would like to draw your attention to CKMLMV001 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). CKMLMV001 is a SAP standard transparent table used for storing Procurement alternatives related data in SAP. It comes under the package CKMLMV.

SAP CKMLMV001 table

Table CKMLMV001 technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • BTYP
    Its data type is C (Character String) with field length 4
  • FLG_PROCEQUAL
    Its data type is C (Character String) with field length 1
  • FLG_PLANOBJ
    Its data type is C (Character String) with field length 1
  • PROC_KALNR
    Its data type is N (Character String with Digits Only) with field length 12
  • MAIN_PROCESS
    Its data type is N (Character String with Digits Only) with field length 12
  • 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 CKMLI_NDEF_FELDER
  • PRWRK_ND
    Its data type is C (Character String) with field length 4
  • 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
  • PLWRK_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
  • VERID_ND
    Its data type is C (Character String) with field length 4
  • STLAN_ND
    Its data type is C (Character String) with field length 1
  • STLAL_ND
    Its data type is C (Character String) with field length 2
  • PLNTY_ND
    Its data type is C (Character String) with field length 1
  • PLNNR_ND
    Its data type is C (Character String) with field length 8
  • PLNAL_ND
    Its data type is C (Character String) with field length 2
  • EKORG_ND
    Its data type is C (Character String) with field length 4
  • LIFNR_ND
    Its data type is C (Character String) with field length 10
  • OTYP
    Its data type is C (Character String) with field length 2
  • UMLWK_ND
    Its data type is C (Character String) with field length 4
  • UMLMA_ND
    Its data type is C (Character String) with field length 18
  • 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
  • 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
  • SPEZ_NAME_ND
    Its data type is C (Character String) with field length 30
  • .INCLU-_PC
    Its include structure/component is is CKMLMV_PCP001
  • STLAN_PC
    Its data type is C (Character String) with field length 1
  • STLAL_PC
    Its data type is C (Character String) with field length 2
  • BWKEY : Valuation area
    Its data type is C (Character String) with field length 4
  • LOSGR_PC
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MEINS_PC
    Its data type is C (Character String) with field length 3
  • CSPLIT_PC
    Its data type is C (Character String) with field length 4
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CKML_S_ADMIN
  • 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
  • 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