V_WRF_MARD_MRP

DDL: V_WRF_MARD_MRP SQL: VWRFMARDMRP Type: view
64 Fields 1 Data Sources

Replace MARD-DISKZ with MRP-Area

V_WRF_MARD_MRP is a CDS View that provides data about "Replace MARD-DISKZ with MRP-Area" in SAP S/4HANA. It reads from 1 data source (V_WRF_STORLOC_CLASS) and exposes 64 fields with key fields matnr, werks, lgort.

Data Sources (1)

SourceAliasJoin Type
V_WRF_STORLOC_CLASS stock_class left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName VWRFMARDMRP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.type #CLIENT_DEPENDENT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Replace MARD-DISKZ with MRP-Area view

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY matnr mard matnr Vehicle Model
KEY werks mard werks Receiving Plant
KEY lgort mard lgort Sublocation
cwmeinme mard /cwm/einme
cwminsme mard /cwm/insme
cwmkeinm mard /cwm/keinm
cwmkinsm mard /cwm/kinsm
cwmklabs mard /cwm/klabs
cwmkspem mard /cwm/kspem
cwmlabst mard /cwm/labst
cwmretme mard /cwm/retme
cwmspeme mard /cwm/speme
cwmumlme mard /cwm/umlme
cwmvmein mard /cwm/vmein
cwmvmins mard /cwm/vmins
cwmvmlab mard /cwm/vmlab
cwmvmret mard /cwm/vmret
cwmvmspe mard /cwm/vmspe
cwmvmuml mard /cwm/vmuml
bskrf mard bskrf Inven.cor.fact.
dlinl mard dlinl Last Count Date
einme mard einme Restricted-Use
ersda mard ersda Entry Date
exppg mard exppg Preference ind.
exver mard exver Export ind.
herkl mard herkl C/R of Origin
insme mard insme Quality Insp.
keinm mard keinm Restr. Consgt
kinsm mard kinsm Cnsgt in QInsp.
klabs mard klabs Unrestr. Consgt
kspem mard kspem Blocked Consgt
kzile mard kzile Restricted-use
kzill mard kzill Warehouse stock
kzilq mard kzilq QualInspStock
kzils mard kzils Blocked stock
kzvle mard kzvle Restricted use
kzvll mard kzvll Warehouse stock
kzvlq mard kzvlq QualInspStock
kzvls mard kzvls Blocked stock
labst mard labst Unrestricted
lbstf mard lbstf Replenishmt qty
lfgja mard lfgja Year Cur.Period
lfmon mard lfmon Current Period
lgpbe mard lgpbe Storage Bin
lminb mard lminb Reorder point
lsobs mard lsobs Spec.proc.:SLoc
lwmkb mard lwmkb Picking area
mandt mard mandt Editing Client
mdjin mard mdjin Fiscal year of current physical inventory indicator
mdrue mard mdrue MARDH rec. already exists for per. before last of MARD per.
prctl mard prctl Profit Center
pstat mard pstat Processing Status
retme mard retme Returns
speme mard speme Blocked Stock
sperr mard sperr Posting Block
umlme mard umlme Stock in tfr
vklab mard vklab SP stock value
vkuml mard vkuml Stk transfer SV
vmein mard vmein Restr.-use PP
vmins mard vmins In qual. insp.
vmlab mard vmlab Unrestr.-use
vmret mard vmret Returns
vmspe mard vmspe Blocked
vmuml mard vmuml In transfer

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view V_WRF_MARD_MRP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: VWRFMARDMRP

CREATE VIEW V_WRF_MARD_MRP AS
SELECT
  mard.matnr AS matnr,
  mard.werks AS werks,
  mard.lgort AS lgort,
  mard./cwm/einme AS cwmeinme,
  mard./cwm/insme AS cwminsme,
  mard./cwm/keinm AS cwmkeinm,
  mard./cwm/kinsm AS cwmkinsm,
  mard./cwm/klabs AS cwmklabs,
  mard./cwm/kspem AS cwmkspem,
  mard./cwm/labst AS cwmlabst,
  mard./cwm/retme AS cwmretme,
  mard./cwm/speme AS cwmspeme,
  mard./cwm/umlme AS cwmumlme,
  mard./cwm/vmein AS cwmvmein,
  mard./cwm/vmins AS cwmvmins,
  mard./cwm/vmlab AS cwmvmlab,
  mard./cwm/vmret AS cwmvmret,
  mard./cwm/vmspe AS cwmvmspe,
  mard./cwm/vmuml AS cwmvmuml,
  mard.bskrf AS bskrf,
  mard.dlinl AS dlinl,
  mard.einme AS einme,
  mard.ersda AS ersda,
  mard.exppg AS exppg,
  mard.exver AS exver,
  mard.herkl AS herkl,
  mard.insme AS insme,
  mard.keinm AS keinm,
  mard.kinsm AS kinsm,
  mard.klabs AS klabs,
  mard.kspem AS kspem,
  mard.kzile AS kzile,
  mard.kzill AS kzill,
  mard.kzilq AS kzilq,
  mard.kzils AS kzils,
  mard.kzvle AS kzvle,
  mard.kzvll AS kzvll,
  mard.kzvlq AS kzvlq,
  mard.kzvls AS kzvls,
  mard.labst AS labst,
  mard.lbstf AS lbstf,
  mard.lfgja AS lfgja,
  mard.lfmon AS lfmon,
  mard.lgpbe AS lgpbe,
  mard.lminb AS lminb,
  mard.lsobs AS lsobs,
  mard.lwmkb AS lwmkb,
  mard.mandt AS mandt,
  mard.mdjin AS mdjin,
  mard.mdrue AS mdrue,
  mard.prctl AS prctl,
  mard.pstat AS pstat,
  mard.retme AS retme,
  mard.speme AS speme,
  mard.sperr AS sperr,
  mard.umlme AS umlme,
  mard.vklab AS vklab,
  mard.vkuml AS vkuml,
  mard.vmein AS vmein,
  mard.vmins AS vmins,
  mard.vmlab AS vmlab,
  mard.vmret AS vmret,
  mard.vmspe AS vmspe,
  mard.vmuml AS vmuml
LEFT OUTER JOIN V_WRF_STORLOC_CLASS AS stock_class ON /* join condition not captured in parsed metadata */
;

Learn More