MARV

Transparent Table Customizing Table
22 Fields 18 CDS Views

Material Control Record

MARV is an SAP database table in S/4HANA. Material Control Record. It contains 22 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
fmlv_ckmlcr_compat view inner Compatibility View for CKMLCR
FMLV_F4_MARV view from Select relevant fiscal period
FMLV_F4_MARV view union Select relevant fiscal period
I_CompanyCodePeriod view_entity from BASIC Company Code Period
I_ProductValuation view inner COMPOSITE Product Valuation
I_ProductValuationBasic view inner BASIC Product Valuation
P_CompanyCodePeriods view from BASIC
P_Matval_Manage_13_Periods view inner BASIC
P_Matval_Manage_Max view inner BASIC
P_Matval_Manage_Md view inner BASIC
P_Matval_Manage_Pnv_Pre view inner BASIC
P_Ml_Prices_Hdcr_Max view inner COMPOSITE
P_MlPrice_Period_By_Periodtype view inner COMPOSITE
P_PeriodTypeByFiscalYearPeriod view from COMPOSITE
P_PhysIntryCurrentPeriod view from COMPOSITE
P_PhysInvtryKeyFiguresBase view inner COMPOSITE
v_ml_bcf_view view inner LOCAL: Material Ledger BCF
v_ml_inv_bcf_view view inner Material Valuation - Inventory Stock BCF

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
lfgja LFGJA Year Cur.Period
lfmon LFMON Current Period
vmgja VMGJA FY prev. period
vmmon VMMON Month prev.per.
vjgja VJGJA FYear last per.
vjmon VJMON Last mo. pr. yr
xruem XRUEM Post prev. per.
xruev XRUEV Disallow
aenam AENAM Changed By
laeda LAEDA Last Change
uzeit UZEIT Time
kzinv KZINV Initialize
vvmgj VVMGJ Fiscal year of period before last
vvmmo VVMMO Month of period before last
vvjgj VVJGJ Fiscal year of last period of year before last
vvjmo VVJMN Last period of year before last
gja_40c GJA_40C Fiscal year of 1st period with dynamic closing
mon_40c MON_40C 1st period with dynamic closing
gja_46c GJA_46C Fiscal Year of 1st Period After 4.6C Upgrade
mon_46c MON_46C 1st Period After 4.6C Upgrade

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 Control Record
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MARV (
    MANDT,    -- Client [MANDT]
    BUKRS,    -- Company Code [BUKRS]
    LFGJA,    -- Year Cur.Period [LFGJA]
    LFMON,    -- Current Period [LFMON]
    VMGJA,    -- FY prev. period [VMGJA]
    VMMON,    -- Month prev.per. [VMMON]
    VJGJA,    -- FYear last per. [VJGJA]
    VJMON,    -- Last mo. pr. yr [VJMON]
    XRUEM,    -- Post prev. per. [XRUEM]
    XRUEV,    -- Disallow [XRUEV]
    AENAM,    -- Changed By [AENAM]
    LAEDA,    -- Last Change [LAEDA]
    UZEIT,    -- Time [UZEIT]
    KZINV,    -- Initialize [KZINV]
    VVMGJ,    -- Fiscal year of period before last [VVMGJ]
    VVMMO,    -- Month of period before last [VVMMO]
    VVJGJ,    -- Fiscal year of last period of year before last [VVJGJ]
    VVJMO,    -- Last period of year before last [VVJMN]
    GJA_40C,  -- Fiscal year of 1st period with dynamic closing [GJA_40C]
    MON_40C,  -- 1st period with dynamic closing [MON_40C]
    GJA_46C,  -- Fiscal Year of 1st Period After 4.6C Upgrade [GJA_46C]
    MON_46C,  -- 1st Period After 4.6C Upgrade [MON_46C]
    PRIMARY KEY (MANDT, BUKRS)
);

Learn More