MARD

Transparent Table Application Table
52 Fields 11 CDS Views

Storage Location Data for Material

MARD is an SAP database table in S/4HANA. Storage Location Data for Material. It contains 52 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
E_Productstoragelocation view from EXTENSION Extension view-product storage location
F_Mmim_Mard_Dval view_entity from Help View Null Values for Stock
I_MaterialDocumentForPrint view left_outer COMPOSITE View for Material Document Print
N_ProductStorageLocation view from Auxiliary view for Storage Location
nsdm_e_mard view from MARD Compatibility View
P_DRFEWMProduct view from BASIC
P_ProductStorageLocation view from BASIC
P_ProductStorageLocationBasic view from BASIC
PPH_DDL_STOCK_KF_2 view left_outer
PPH_E_STOCK view left_outer
SHSM_H_MARD view from CDS View for H_MARD (search help)

Fields (52)

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
lfgja LFGJA Year Cur.Period
lfmon LFMON Current Period
sperr SPERR Phys. Inv. Blk
labst LABST Unrestricted
umlme UMLMD Stock in tfr
insme INSME Quality Insp.
einme EINME Restricted-Use
speme SPEME Blocked Stock
retme RETME Returns
vmlab VMLAB Unrestr.-use
vmuml VMUML In transfer
vmins VMINS In qual. insp.
vmein VMEIN Restr.-use PP
vmspe VMSPE Blocked
vmret VMRET Returns
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
klabs KLABS Unrestr. Consgt
kinsm KINSM Cnsgt in QInsp.
keinm KEINM Restr. Consgt
kspem KSPEM Blocked Consgt
dlinl DLINL Last Count Date
prctl PRCTR Profit Center
ersda ERSDA Created On
vklab VKLAB SP stock value
vkuml VKUML Stk transfer SV
lwmkb MARD_KOBER Picking area
bskrf BSKRF Inven.cor.fact.
mdrue MDRUE MARDH rec. already exists for per. before last of MARD per.
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.

-- Storage Location Data for Material
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MARD (
    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]
    LFGJA,                  -- Year Cur.Period [LFGJA]
    LFMON,                  -- Current Period [LFMON]
    SPERR,                  -- Phys. Inv. Blk [SPERR]
    LABST,                  -- Unrestricted [LABST]
    UMLME,                  -- Stock in tfr [UMLMD]
    INSME,                  -- Quality Insp. [INSME]
    EINME,                  -- Restricted-Use [EINME]
    SPEME,                  -- Blocked Stock [SPEME]
    RETME,                  -- Returns [RETME]
    VMLAB,                  -- Unrestr.-use [VMLAB]
    VMUML,                  -- In transfer [VMUML]
    VMINS,                  -- In qual. insp. [VMINS]
    VMEIN,                  -- Restr.-use PP [VMEIN]
    VMSPE,                  -- Blocked [VMSPE]
    VMRET,                  -- Returns [VMRET]
    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]
    KLABS,                  -- Unrestr. Consgt [KLABS]
    KINSM,                  -- Cnsgt in QInsp. [KINSM]
    KEINM,                  -- Restr. Consgt [KEINM]
    KSPEM,                  -- Blocked Consgt [KSPEM]
    DLINL,                  -- Last Count Date [DLINL]
    PRCTL,                  -- Profit Center [PRCTR]
    ERSDA,                  -- Created On [ERSDA]
    VKLAB,                  -- SP stock value [VKLAB]
    VKUML,                  -- Stk transfer SV [VKUML]
    LWMKB,                  -- Picking area [MARD_KOBER]
    BSKRF,                  -- Inven.cor.fact. [BSKRF]
    MDRUE,                  -- MARDH rec. already exists for per. before last of MARD per. [MDRUE]
    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