CKMLHD

Transparent Table Application Table
20 Fields 46 CDS Views

Material Ledger: Header Record

CKMLHD is an SAP database table in S/4HANA. Material Ledger: Header Record. It contains 20 fields. 46 CDS views read from this table.

CDS Views using this table (46)

ViewTypeJoinVDMDescription
FCML_FIND_MLDOC_WRONG_BUDAT_V view inner CDS View to detect wrong BUDAT in MLDOC
FCML_MAT_DDL view from CDS View with structure of table FCML_MAT
FCML_MAT_DDL view union_all CDS View with structure of table FCML_MAT
FCML_MLDOC_EMPTY_BUDAT_DDL view inner CDS View to detect empty BUDAT in MLDOC
fcml4h_cds_mldochd view from CKMLHD x MLDOC
FCMLCCS_EX_MAT_DDL view inner Materials from MLDOC_CCS_EXTRACT
FCMLDOC_EX_MAT_DDL view inner Materials from MLDOC_EXTRACT
fmlv_ckmlcr_compat view inner Compatibility View for CKMLCR
fmlv_ckmlpr_compat view from Compatibility View for CKMLPR
FMLV_CKMLPR_COMPAT_DB view inner Compatibility View for CKMLPR
I_MaterialLedgerInventory view from BASIC select data from CKMLHD
I_MLPricePersistedPeriod view inner COMPOSITE Periods for ML Prices per Currency
ML4H_CDS_MLDOCCCSHD view from CKMLHD x MLDOC x MLDOCCCS
Ml4h_Cds_Mldochd view from CKMLHD x MLDOC
ml4h_cds_mv003 view inner Mapping MLDOC at MV003
ml4h_cds_mv004 view left_outer Mapping MLDOC at MV004
ML4H_CDS_VMV view left_outer Value Flow Monitor
ml4h_cds_wipred_help view left_outer Read WIP Reduction
P_CURRENTMATLVALNPRICE view left_outer BASIC
P_CURRENTMATLVALNPRICE view inner BASIC
P_CURRENTMATLVALNPRICEDEX view inner BASIC
P_DACRMaterialHeaderExtract view inner COMPOSITE DACR Material Extract with Material Header
P_InventoryPriceByKeydate view inner BASIC
P_InvPrice_Manage_Max_Fiscal view inner BASIC
P_InvPrice_Union_Old view from BASIC
P_InvPricesMaxFis view inner COMPOSITE
P_Matval_Manage_13_Periods view from BASIC
P_MATVAL_MANAGE_CKML view left_outer BASIC
P_Matval_Manage_Max view inner BASIC
P_Matval_Manage_Max_Hdpp view from BASIC
P_Matval_Manage_Pnv_Pre view inner BASIC
P_Matval_Manage_Val_Chart view inner BASIC
P_Ml_Prices_Ckml view left_outer BASIC
P_ML_Prices_Hdcr view inner BASIC
P_MLMaterialHeader view from BASIC
P_MlPrice_By_Periodtype view inner COMPOSITE
P_MLPricePersistedPeriod view inner BASIC
R_MatlPriceSpclStockValnStrgy view inner COMPOSITE Mat Price Spec Stock Valuation Strategy
V_MATERIALLEDGERPRICE view inner Material Ledger Price
V_MaterialLedgerPriceBasic1 view from Basic view 1 for material price
v_ml_check1b_view view inner Material Ledger check migrated data vs. CKMCLCR
v_ml_check2b_view view inner Material Ledger check migrated data vs. CKMCLPP
v_ml_mig_mlpack_view view inner Migration: Material Ledger - Packages
v_ml_p_gap_l1_view view inner LOCAL: Material Ledger Gap in Periods
v_ml_p_gap_l1b_view view inner LOCAL: Material Ledger Gap in Periods
v_ml_perio_l1_view view inner LOCAL: Material Ledger Periods

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kalnr CK_KALNR Cost EstimateNo
mlast CK_ML_ABST Price Determ.
xabrech CK_XABRECH Determine Price
abrechdat CK_ABRDAT PrDeterm. Date
xabrerr CKML_D_NOTUSED_CHAR1 Obsolete
abrechuhr CK_ABRUHR Time of Pr. Determ
matnr MATNR Material
bwkey BWKEY Valuation Area
bwtar BWTAR_D Valuation Type
kzbws KZBWS Valuation
xobew XOBEW Vendor stk val.
sobkz SOBKZ Special Stock
vbeln VBELN SD Document
posnr POSNR Item
pspnr PS_PSP_PNR WBS Element
lifnr LIFNR Supplier
aexterrind CKML_AEXTERRIND AEXT error
matdoc_aexterrind CKML_MATDOC_AEXTERRIND MATDOC/AEXT error
price_sdm_yearper FML_PRICE_SDM_YEARPER Price SDM YearPeriod

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Material Ledger: Header Record
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CKMLHD (
    MANDT,              -- Client [MANDT]
    KALNR,              -- Cost EstimateNo [CK_KALNR]
    MLAST,              -- Price Determ. [CK_ML_ABST]
    XABRECH,            -- Determine Price [CK_XABRECH]
    ABRECHDAT,          -- PrDeterm. Date [CK_ABRDAT]
    XABRERR,            -- Obsolete [CKML_D_NOTUSED_CHAR1]
    ABRECHUHR,          -- Time of Pr. Determ [CK_ABRUHR]
    MATNR,              -- Material [MATNR]
    BWKEY,              -- Valuation Area [BWKEY]
    BWTAR,              -- Valuation Type [BWTAR_D]
    KZBWS,              -- Valuation [KZBWS]
    XOBEW,              -- Vendor stk val. [XOBEW]
    SOBKZ,              -- Special Stock [SOBKZ]
    VBELN,              -- SD Document [VBELN]
    POSNR,              -- Item [POSNR]
    PSPNR,              -- WBS Element [PS_PSP_PNR]
    LIFNR,              -- Supplier [LIFNR]
    AEXTERRIND,         -- AEXT error [CKML_AEXTERRIND]
    MATDOC_AEXTERRIND,  -- MATDOC/AEXT error [CKML_MATDOC_AEXTERRIND]
    PRICE_SDM_YEARPER,  -- Price SDM YearPeriod [FML_PRICE_SDM_YEARPER]
    PRIMARY KEY (MANDT, KALNR)
);

Learn More