NSDM_E_MARD

CDS View

MARD Compatibility View

NSDM_E_MARD is a CDS View in S/4HANA. MARD Compatibility View. It contains 28 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
I_FieldLogisticsStockInventory view_entity from COMPOSITE Field Logistics Stock Inventory
I_ProductStorageLocation view from BASIC Product Storage Location
NSDM_E_V_MMIM_EN view inner V_MMIM_EN Compatibility View
NSDM_E_V_MMIM_KN view inner V_MMIM_KN Compatibility View
NSDM_E_V_MMIM_LB view inner V_MMIM_LB Compatibility View
NSDM_E_V_MMIM_LC view inner V_MMIM_LC Compatibility View
NSDM_E_V_MMIM_LC_MB5M view inner V_MMIM_LC_MB5M Compatibility View
NSDM_E_V_MMIM_LN view from V_MMIM_LN Compatibility View
NSDM_E_V_MMIM_QN view inner V_MMIM_QN Compatibility View
NSDM_e_V_SLGH_1 view inner V_SLGH_1 Compatibility View
P_MSPWProductStock view from BASIC

Fields (28)

KeyField CDS FieldsUsed in Views
KEY einme einme 2
KEY insme insme 2
KEY kzill InvtryCurrentYearStockInd,kzill 3
KEY kzilq InvtryQualInspCurrentYrStkInd,kzilq 3
KEY labst labst 2
KEY lgort lgort,StorageLocation 3
KEY lgpbe lgpbe,WarehouseStorageBin 8
KEY mandt mandt 1
KEY matnr Material,matnr,Product 4
KEY werks Plant,werks 3
bskrf InventoryCorrectionFactor 1
dlinl DateOfLastPostedCntUnRstrcdStk,dlinl 2
ersda CreationDate 1
kzile InvtryRestrictedUseStockInd 1
kzils InventoryBlockStockInd,kzils 2
kzvle InvtryRestStockPrevPeriodInd 1
kzvll InventoryStockPrevPeriod,kzvll 2
kzvlq InvtryStockQltyInspPrevPeriod,kzvlq 2
kzvls HasInvtryBlockStockPrevPeriod,kzvls 2
lfgja FiscalYearCurrentPeriod,lfgja 2
lfmon FiscalMonthCurrentPeriod,lfmon 2
lvorm IsMarkedForDeletion,lvorm,lvorm_d 6
lwmkb LeanWrhsManagementPickingArea 1
mdjin FiscalYearCurrentInvtryPeriod,mdjin 2
pstat MaintenanceStatus 1
speme speme 1
sperr PhysicalInventoryBlockInd 1
vklab vklab 1

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.

-- MARD Compatibility View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NSDM_E_MARD (
    EINME,
    INSME,
    KZILL,
    KZILQ,
    LABST,
    LGORT,
    LGPBE,
    MANDT,
    MATNR,
    WERKS,
    BSKRF,
    DLINL,
    ERSDA,
    KZILE,
    KZILS,
    KZVLE,
    KZVLL,
    KZVLQ,
    KZVLS,
    LFGJA,
    LFMON,
    LVORM,
    LWMKB,
    MDJIN,
    PSTAT,
    SPEME,
    SPERR,
    VKLAB,
    PRIMARY KEY (EINME, INSME, KZILL, KZILQ, LABST, LGORT, LGPBE, MANDT, MATNR, WERKS)
);