V_MARD_MD

31 Fields 1 CDS Views

Generated Table for View

V_MARD_MD is an SAP database table in S/4HANA. Generated Table for View. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
NSDM_DDL_CHK_MAT_MASTER view left_outer Chk for miss mat mast vs. MATDOC_EXTRACT

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY lgort LGORT_D Location
pstat PSTAT_D Maint. Status
lvorm LVOLG DF stor.loc.lvl
sperr SPERR Phys. Inv. Blk
kzill KZILL Warehouse stock
kzilq KZILQ QualInspStock
kzile KZILE Restricted-use
kzils KZILS Blocked stock
kzvll KZVLL Warehouse stock
kzvlq KZVLQ QualInspStock
kzvle KZVLE Restricted use
kzvls KZVLS Blocked stock
diskz DISKZ MRP ind.
lsobs LSOBS Spec.proc.:SLoc
lminb LMINB Reorder point
lbstf LBSTF Replenishmt qty
herkl HERKL C/R of Origin
exppg EXPPG Preference ind.
exver EXVER Export ind.
lgpbe LGPBE Storage Bin
dlinl DLINL Last Count Date
prctl PRCTR Profit Center
ersda ERSDA Created On
lwmkb MARD_KOBER Picking area
bskrf BSKRF Inven.cor.fact.
mdjin GJINV Fiscal year of current physical inventory indicator
dummy_stl_incl_eew_ps STL_INCL_EEW MD PRODUCT Storage location
fsh_salloc_qty_s FSH_SALLOC_QTY Allocated Stock

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE V_MARD_MD (
    MANDT,                  -- Client [MANDT]
    MATNR,                  -- Material [MATNR]
    WERKS,                  -- Plant [WERKS_D]
    LGORT,                  -- Location [LGORT_D]
    PSTAT,                  -- Maint. Status [PSTAT_D]
    LVORM,                  -- DF stor.loc.lvl [LVOLG]
    SPERR,                  -- Phys. Inv. Blk [SPERR]
    KZILL,                  -- Warehouse stock [KZILL]
    KZILQ,                  -- QualInspStock [KZILQ]
    KZILE,                  -- Restricted-use [KZILE]
    KZILS,                  -- Blocked stock [KZILS]
    KZVLL,                  -- Warehouse stock [KZVLL]
    KZVLQ,                  -- QualInspStock [KZVLQ]
    KZVLE,                  -- Restricted use [KZVLE]
    KZVLS,                  -- Blocked stock [KZVLS]
    DISKZ,                  -- MRP ind. [DISKZ]
    LSOBS,                  -- Spec.proc.:SLoc [LSOBS]
    LMINB,                  -- Reorder point [LMINB]
    LBSTF,                  -- Replenishmt qty [LBSTF]
    HERKL,                  -- C/R of Origin [HERKL]
    EXPPG,                  -- Preference ind. [EXPPG]
    EXVER,                  -- Export ind. [EXVER]
    LGPBE,                  -- Storage Bin [LGPBE]
    DLINL,                  -- Last Count Date [DLINL]
    PRCTL,                  -- Profit Center [PRCTR]
    ERSDA,                  -- Created On [ERSDA]
    LWMKB,                  -- Picking area [MARD_KOBER]
    BSKRF,                  -- Inven.cor.fact. [BSKRF]
    MDJIN,                  -- Fiscal year of current physical inventory indicator [GJINV]
    DUMMY_STL_INCL_EEW_PS,  -- MD PRODUCT Storage location [STL_INCL_EEW]
    FSH_SALLOC_QTY_S,       -- Allocated Stock [FSH_SALLOC_QTY]
    PRIMARY KEY (MANDT, MATNR, WERKS, LGORT)
);

Learn More