ScmPrd_Mdma_Mdlv

DDL: SCMPRD_MDMA_MDLV SQL: SCMPRDMDMAMDLV Type: view
57 Fields 1 Data Sources

Join of MDMA and MDLV

ScmPrd_Mdma_Mdlv is a CDS View that provides data about "Join of MDMA and MDLV" in SAP S/4HANA. It reads from 1 data source (mdma) and exposes 57 fields.

Data Sources (1)

SourceAliasJoin Type
mdma mdma from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SCMPRDMDMAMDLV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label Join of MDMA and MDLV view

Fields (57)

KeyFieldSource TableSource FieldDescription
matnr mdma matnr Vehicle Model
berid mdma berid Single-Character Flag
werks mdma werks Receiving Plant
werzg mdlv werzg Plant
dispr mdma dispr MRP profile
dismm mdma dismm MRP Type
dispo mdma dispo MRP Controller
disgr mdma disgr MRP Group
minbe mdma minbe Reorder Point
lfrhy mdma lfrhy Planning Cycle
fxhor mdma fxhor Plng time fence
disls mdma disls Lot Sizing Procedure
rdprf mdma rdprf Rounding Prfl.
bstrf mdma bstrf Rounding value
bstmi mdma bstmi Min. Lot Size
bstma mdma bstma To Lot Size
mabst mdma mabst Max.Stock Level
takzt mdma takzt Takt time
ausss mdma ausss Assembly scrap
sobsl mdma sobsl SpecProcuremKey
lgpro mdma lgpro Storage Location
lgfsb mdma lgfsb Storage Location
mrppp mdma mrppp Planning cal.
eisbe mdma eisbe Safety Stock
rwpro mdma rwpro Coverage Prof.
shzet mdma shzet Safety Time
bstfe mdma bstfe Fixed lot size
losfx mdma losfx LSI Costs
lagpr mdma lagpr Storage Costs
lgrad mdma lgrad Target Service Level
propr mdma propr Forecast Prof.
vrbmt mdma vrbmt Ref.matl: cons.
vrbdb mdma vrbdb Ref. MRPa. cons
vrbdt mdma vrbdt Date to
vrbfk mdma vrbfk Multiplier
loekz mdma loekz Status
shpro mdma shpro Time Profile
ahdis mdma ahdis MRP Relevant
autru mdma autru Autom.reset
pstat mdma pstat Processing Status
kzkfk mdma kzkfk Corr. factors
shflg mdma shflg Safety Time Ind
apokz mdma apokz Relevant to APO
plifz mdma plifz Plnd Deliv.Time
plifzx mdma plifzx Consider PlDelTime
scm_lsuom mdma scm_lsuom Lot Size Unit
scm_tstrid mdma scm_tstrid Per.LS Plng Cal
scm_grprt mdma scm_grprt GR Processng Time
scm_giprt mdma scm_giprt GI Processng Time
scm_tpop mdma scm_tpop TPOP
scm_safty_v mdma scm_safty_v Safety Stock for VCL
scm_repsafty mdma scm_repsafty Rep. Safety St.
scm_reord_v mdma scm_reord_v Reord. Point (VCL)
scm_ndcostwe mdma scm_ndcostwe GR Costs
scm_ndcostwa mdma scm_ndcostwa GI Costs
scm_scost mdma scm_scost Prod.Stor. Costs
scm_sspen mdma scm_sspen Safety Stk Pen.

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 ScmPrd_Mdma_Mdlv.
-- 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: SCMPRDMDMAMDLV

CREATE VIEW ScmPrd_Mdma_Mdlv AS
SELECT
  mdma.matnr AS matnr,
  mdma.berid AS berid,
  mdma.werks AS werks,
  mdlv.werzg AS werzg,
  mdma.dispr AS dispr,
  mdma.dismm AS dismm,
  mdma.dispo AS dispo,
  mdma.disgr AS disgr,
  mdma.minbe AS minbe,
  mdma.lfrhy AS lfrhy,
  mdma.fxhor AS fxhor,
  mdma.disls AS disls,
  mdma.rdprf AS rdprf,
  mdma.bstrf AS bstrf,
  mdma.bstmi AS bstmi,
  mdma.bstma AS bstma,
  mdma.mabst AS mabst,
  mdma.takzt AS takzt,
  mdma.ausss AS ausss,
  mdma.sobsl AS sobsl,
  mdma.lgpro AS lgpro,
  mdma.lgfsb AS lgfsb,
  mdma.mrppp AS mrppp,
  mdma.eisbe AS eisbe,
  mdma.rwpro AS rwpro,
  mdma.shzet AS shzet,
  mdma.bstfe AS bstfe,
  mdma.losfx AS losfx,
  mdma.lagpr AS lagpr,
  mdma.lgrad AS lgrad,
  mdma.propr AS propr,
  mdma.vrbmt AS vrbmt,
  mdma.vrbdb AS vrbdb,
  mdma.vrbdt AS vrbdt,
  mdma.vrbfk AS vrbfk,
  mdma.loekz AS loekz,
  mdma.shpro AS shpro,
  mdma.ahdis AS ahdis,
  mdma.autru AS autru,
  mdma.pstat AS pstat,
  mdma.kzkfk AS kzkfk,
  mdma.shflg AS shflg,
  mdma.apokz AS apokz,
  mdma.plifz AS plifz,
  mdma.plifzx AS plifzx,
  mdma.scm_lsuom AS scm_lsuom,
  mdma.scm_tstrid AS scm_tstrid,
  mdma.scm_grprt AS scm_grprt,
  mdma.scm_giprt AS scm_giprt,
  mdma.scm_tpop AS scm_tpop,
  mdma.scm_safty_v AS scm_safty_v,
  mdma.scm_repsafty AS scm_repsafty,
  mdma.scm_reord_v AS scm_reord_v,
  mdma.scm_ndcostwe AS scm_ndcostwe,
  mdma.scm_ndcostwa AS scm_ndcostwa,
  mdma.scm_scost AS scm_scost,
  mdma.scm_sspen AS scm_sspen
FROM mdma
;

Learn More