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