P_PRODUCTPLANTMRP

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 P_PRODUCTPLANTMRP.
-- 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: PPRDPLNTMRP

CREATE VIEW P_PRODUCTPLANTMRP AS
SELECT
  matnr AS Product,
  berid AS MRPArea,
  werks AS Plant,
  _MRPArea.MRPAreaCategory AS MRPAreaCategory,
  dismm AS MRPType,
  dispo AS MRPResponsible,
  disgr AS MRPGroup,
  minbe AS ReorderThresholdQuantity,
  lfrhy AS PlanAndOrderDayDetermination,
  fxhor AS PlanningTimeFence,
  disls AS LotSizingProcedure,
  rdprf AS RoundingProfile,
  bstrf AS LotSizeRoundingQuantity,
  bstmi AS MinimumLotSizeQuantity,
  bstma AS MaximumLotSizeQuantity,
  mabst AS MaximumStockQuantity,
  ausss AS AssemblyScrapPercent,
  sobsl AS ProcurementSubType,
  lgpro AS StorageLocation,
  lgfsb AS DfltStorageLocationExtProcmt,
  mrppp AS MRPPlanningCalendar,
  eisbe AS SafetyStockQuantity,
  rwpro AS RangeOfCvrgPrflCode,
  shzet AS SafetyDuration,
  bstfe AS FixedLotSizeQuantity,
  losfx AS LotSizeIndependentCosts,
  lagpr AS IsStorageCosts,
  lgrad AS SrvcLvl,
  vrbdt AS CreationDate,
  loekz AS IsMarkedForDeletion,
  shpro AS PerdPrflForSftyTme,
  ahdis AS IsMRPDependentRqmt,
  pstat AS MaintenanceStatusName,
  shflg AS IsSafetyTime,
  plifz AS PlannedDeliveryDurationInDays,
  cast(plifzx as boole_d) AS IsPlannedDeliveryTime,
  takzt AS TaktTime
FROM mdma AS MRPAreaData
LEFT OUTER JOIN I_MRPType AS _MRPType ON MRPType = _MRPType.MRPType  -- association [0..1]
LEFT OUTER JOIN I_MRPTypeText AS _MRPTypeName ON MRPType = _MRPTypeName.MRPType  -- association [0..*]
LEFT OUTER JOIN I_MRPLotSizingProcedure AS _LotSizingProcedure ON LotSizingProcedure = _LotSizingProcedure.MaterialLotSizingProcedure  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _PlantInvtryManagedLoc ON StorageLocation = _PlantInvtryManagedLoc.StorageLocation AND Plant = _PlantInvtryManagedLoc.Plant  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_MRPController AS _MRPResponsible ON MRPResponsible = _MRPResponsible.MRPController AND Plant = _MRPResponsible.Plant  -- association [0..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON MRPArea = _MRPArea.MRPArea  -- association [0..1]
;