NSDM_E_MARD
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA