SAP Table CKMLMV001

Procurement alternatives

CKMLMV001 (Procurement alternatives) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CKMLMV001 to other SAP tables.

CKMLMV001 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
KALNR Procurement alternative/process CKML_ALPROCNR NUMC 12 0
OTYP Object Type CKML_OTYP CHAR 2 0
BA Procurement Alternative
PR Procurement Process
VA Consumption Alternative
ST Material (Summation Level)
MB Material (Valuation Level)
MK Material (Totals Record: Valuation Area)
LA Activity Type
EB Sales Order Stock
QB Project Stock
OB Vendor Stock
WM WIP Material
WL WIP Activity Type
BWKEY Valuation Area BWKEY CHAR 4 0
WERKS Plant WERKS_D CHAR 4 0
MATNR Material Number MATNR CHAR 18 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
KALNR_MAT Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
BTYP Process Category CKML_BTYP CHAR 4 0
FLG_PROCEQUAL Procurement Alternative Identical to Process CKML_FLG_PROCEQUAL CHAR 1 0
X TRUE
NULL FALSE
FLG_PLANOBJ Procurement alternative only for planning CKML_FLG_PLANOBJ CHAR 1 0
X TRUE
NULL FALSE
PROC_KALNR Procurement Process CKML_N_PROCNR NUMC 12 0
MAIN_PROCESS Procurement Process CKML_N_PROCNR NUMC 12 0
SORT_NAME Sort string for differentiating procurement alternatives CKML_SORT_NAME CHAR 10 0
NRULE Controlling Level Key CKML_NAME_RULE CHAR 4 0
LOEKZ Deletion indicator CKML_LOEKZ CHAR 1 0
PRWRK_ND Plant WERKS_D CHAR 4 0
PLWRK_ND Planning plant for the order CO_PWERK CHAR 4 0
PMATN_ND Material Number MATNR CHAR 18 0
VERID_ND Production Version VERID CHAR 4 0
STLAN_ND BOM Usage STLAN CHAR 1 0
STLAL_ND Alternative BOM STALT CHAR 2 0
PLNTY_ND Task List Type PLNTY CHAR 1 0
PLNNR_ND Key for Task List Group PLNNR CHAR 8 0
PLNAL_ND Group Counter PLNAL CHAR 2 0
EKORG_ND Purchasing Organization EKORG CHAR 4 0
LIFNR_ND Vendor Account Number ELIFN CHAR 10 0
UMLWK_ND Special Procurement Plant - Costing CK_SOWRK CHAR 4 0
UMLMA_ND Material Number MATNR CHAR 18 0
KDAUF_ND Sales and Distribution Document Number VBELN CHAR 10 0
KDPOS_ND Item Number in Sales Order KDPOS NUMC 6 0
KUNDE_ND Customer Number KUNNR CHAR 10 0
PSPNR_ND WBS Element PS_POSNR NUMC 8 0
SPEZ_NAME_ND User-defined name for procure.alternatives/consumpt.alternat CKML_SPEZ_NAME CHAR 30 0
STLAN_PC BOM Usage STLAN CHAR 1 0
STLAL_PC Alternative BOM STALT CHAR 2 0
LOSGR_PC Lot Size for Product Costing CK_LOSGR QUAN 13 3
MEINS_PC Valuation Unit of Measure CK_MEINH_BEW UNIT 3 0
CSPLIT_PC Apportionment Structure CSPLIT CHAR 4 0
ERNAM Created by CKML_ERNAM CHAR 12 0
ERDAT Created on CKML_ERDAT DATS 8 0