SAP table CKMLMV003 (Process model: Receipts / mixing strategies)
SAP table CKMLMV003 has 7 primary key fields being MANDT,MGTYP,GJAHR,PERIO,KALNR_IN,KALNR_BAL,KALNR_OUT.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
MANDT
Quantity Structure Type
CHAR
5
0
CKMLMV006
CKML_MGTYP
Fiscal Year
NUMC
4
0
GJAHR
Posting period
NUMC
3
0
POPER
Procurement Process
NUMC
12
0
CKML_N_PROCNR
Procurement Alternative
NUMC
12
0
CKML_N_BALTNR
Cost Estimate Number - Product Costing
NUMC
12
0
CK_KALNR1
OTYP_IN
Object Type
CHAR
2
0
CKML_OTYP
Possible values
BA
Procurement Alternative
EB
Sales Order Stock
LA
Activity Type
MB
Material (Valuation Level)
MK
Material (Totals Record: Valuation Area)
OB
Vendor Stock
PR
Procurement Process
QB
Project Stock
ST
Material (Summation Level)
VA
Consumption Alternative
WL
WIP Activity Type
WM
WIP Material
OTYP_OUT
Object Type
CHAR
2
0
CKML_OTYP
Possible values
BA
Procurement Alternative
EB
Sales Order Stock
LA
Activity Type
MB
Material (Valuation Level)
MK
Material (Totals Record: Valuation Area)
OB
Vendor Stock
PR
Procurement Process
QB
Project Stock
ST
Material (Summation Level)
VA
Consumption Alternative
WL
WIP Activity Type
WM
WIP Material
MEINH
Unit of Measure for Display
UNIT
3
0
MEINH
OUT_MENGE
Quantity of Goods Received
QUAN
15
3
CKML_OUTMENGE
MISCH_VERH
Mixing Ratio
DEC
13
3
CK_CROSSR
BWKEY
Valuation area
CHAR
4
0
BWKEY
WERKS
Plant
CHAR
4
0
WERKS_D
MATNR
Material Number
CHAR
40
0
MATNR
BWTAR
Valuation Type
CHAR
10
0
BWTAR_D
LAST_PDAY
Last day of period
DATS
8
0
CKML_RUN_LAST_DAY_OF_PERIOD
STLAN_PC
BOM Usage
CHAR
1
0
*
STLAN
STLAL_PC
Alternative BOM
CHAR
2
0
STALT
LOSGR_PC
Lot Size for Product Costing
QUAN
13
3
CK_LOSGR
ALDAT_PC
Quantity Structure Date for Costing
DATS
8
0
CK_BRDAT
MEINS_PC
Unit of Measure for Display
UNIT
3
0
*
MEINH
BWVAR_PC
Valuation Variant in Costing
CHAR
3
0
*
CK_BWVAR
BWDAT_PC
Valuation Date of a Cost Estimate
DATS
8
0
CK_BWDAT
PLSCN_PC
Planning Scenario in Long-Term Planning
NUMC
3
0
*
PLSCN
STATISTIC_PC
Statistical Entry (Production Plan)
CHAR
1
0
CKML_FLG_STATISTIC_MIX
BAPI_MRCREATED_PC
Mixing Ratio Generated by BAPI
CHAR
1
0
CK_BAPIMR