FINS_ML_ACCOUNT

Transparent Table Application Table
27 Fields 5 CDS Views

Material Ledger: Header Record

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

CDS Views using this table (5)

ViewTypeJoinVDMDescription
v_ml_acc_delta_view view left_outer LOCAL: Material Ledger Periods
v_ml_account_d_view view left_outer ML accounts: difference since last update of FINS_ML_ACCOUNT
v_ml_account_dz_view view inner ML accounts: FINS_ML_ACCOUNT records to be updated
v_ml_check1_l4_view view inner Material Ledger check migrated data vs. CKMCLCR
v_ml_check2_l4_view view inner Material Ledger check migrated data vs. CKMCLPP

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kalnr ck_kalnr Cost EstimateNo
kokrs kokrs CO Area
bukrs bukrs Company Code
bwkey bwkey Valuation Area
matnr matnr Material
bwtar bwtar_d Valuation Type
kzbws kzbws Valuation
sobkz sobkz Special Stock
xobew xobew Vendor stk val.
mat_kdauf kdauf Sales Order
mat_kdpos kdpos Sales Ord. Item
mat_pspnr ps_psp_pnr WBS Element
mat_lifnr lifnr Supplier
racct racct Account Number
ktopl ktopl Chart of Accts
mlast ck_ml_abst Price Determ.
first_gjahr gjahr Fiscal Year
first_perio poper Posting Period
periv periv FY Variant
erkrs erkrs Operating concern
mat_ps_posid ps_posid WBS Element
werks werks_d Plant
prctr prctr Profit Center
segment fb_segment Segment
max_gjahr gjahr Fiscal Year
max_poper poper Posting Period

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 FINS_ML_ACCOUNT (
    MANDT,         -- Client [mandt]
    KALNR,         -- Cost EstimateNo [ck_kalnr]
    KOKRS,         -- CO Area [kokrs]
    BUKRS,         -- Company Code [bukrs]
    BWKEY,         -- Valuation Area [bwkey]
    MATNR,         -- Material [matnr]
    BWTAR,         -- Valuation Type [bwtar_d]
    KZBWS,         -- Valuation [kzbws]
    SOBKZ,         -- Special Stock [sobkz]
    XOBEW,         -- Vendor stk val. [xobew]
    MAT_KDAUF,     -- Sales Order [kdauf]
    MAT_KDPOS,     -- Sales Ord. Item [kdpos]
    MAT_PSPNR,     -- WBS Element [ps_psp_pnr]
    MAT_LIFNR,     -- Supplier [lifnr]
    RACCT,         -- Account Number [racct]
    KTOPL,         -- Chart of Accts [ktopl]
    MLAST,         -- Price Determ. [ck_ml_abst]
    FIRST_GJAHR,   -- Fiscal Year [gjahr]
    FIRST_PERIO,   -- Posting Period [poper]
    PERIV,         -- FY Variant [periv]
    ERKRS,         -- Operating concern [erkrs]
    MAT_PS_POSID,  -- WBS Element [ps_posid]
    WERKS,         -- Plant [werks_d]
    PRCTR,         -- Profit Center [prctr]
    SEGMENT,       -- Segment [fb_segment]
    MAX_GJAHR,     -- Fiscal Year [gjahr]
    MAX_POPER,     -- Posting Period [poper]
    PRIMARY KEY (MANDT, KALNR)
);

Learn More