P_MPEMaterial

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_MPEMaterial.
-- 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.
-- Parameters: P_Language : sylangu

CREATE VIEW P_MPEMaterial AS
SELECT
  _ProductPlant.Product AS Material,
  _ProductPlant.Plant AS Plant,
  _StgLoc.StorageLocation AS StorageLocation,
  _StgLoc.StorageLocationName AS StorageLocationName,
  _Plant.PlantName AS ProductionPlant,
  _ProductPlant.Plant AS MRPPlant,
  _ProductDS.ProductDescription AS ProductDescription,
  _MRPController.MRPController AS MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  _MRPController.MRPControllerPhoneNumber AS MRPControllerPhoneNumber,
  _ProductPlant.ProductionSupervisor AS ProductionSupervisor,
  _ProductionSup.ProductionSupervisorName AS ProductionSupervisorName,
  _ProductPlant.MRPType AS MRPType,
  _MRPText.MRPTypeName AS MRPTypeName,
  case when _StgLoc.StorageLocation = '' then _PlantStock.BlockedStock else _ProductStock.BlockedStock end as BlockedStockQuantity AS BlockedStockendasBlockedStockQuantity,
  _ProductPlant.ProductionSchedulingProfile AS ProductionSchedulingProfile,
  _ProductPlant.SerialNumberProfile AS SerialNumberProfile,
  _SerialNumberText.SerialNumberProfileName AS SerialNumberProfileName,
  _Product.IsApprovedBatchRecordReqd AS IsApprovedBatchRecordReqd,
  _ProductPlant.UnderDelivToleranceLimit AS UnderDelivToleranceLimit,
  _ProductPlant.OverDelivToleranceLimit AS OverDelivToleranceLimit,
  _ProcurementText.MaterialProcurementCatName AS MaterialProcurementCatName,
  _ProductPlant.SpecialProcurementType AS SpecialProcurementType,
  _ProductPlant.SafetyStockQuantity AS SafetyStockQuantity,
  cast('%' as unit) AS DeliveryToleranceUnit,
  _Product.BaseUnit AS BaseUnit,
  _ProductPlant.MRPResponsible AS MRPResponsible,
  _ProductPlant.ProcurementType AS ProcurementType
FROM I_ProductPlant AS _ProductPlant
LEFT OUTER JOIN P_MPE_MaterialStorageLocation AS _StgLoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductDescription AS _ProductDS ON _ProductDS.Product = Material AND _ProductDS.Language = $parameters.P_Language  -- association [1..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON _MRPController.Plant = Plant AND _MRPController.MRPController = _ProductPlant.MRPResponsible  -- association [1..1]
LEFT OUTER JOIN I_MatlProcurementCategoryText AS _ProcurementText ON _ProcurementText.MaterialProcurementCategory = _ProductPlant.ProcurementType AND _ProcurementText.Language = $parameters.P_Language  -- association [1..1]
LEFT OUTER JOIN P_MPE_MaterialStockQuantity AS _ProductStock ON _ProductStock.Material = Material AND _ProductStock.Plant = Plant AND _ProductStock.StorageLocation = StorageLocation  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [1..1]
LEFT OUTER JOIN I_MPESrlNmbPrfText AS _SerialNumberText ON _SerialNumberText.SerialNumberProfile = _ProductPlant.SerialNumberProfile AND _SerialNumberText.Language = $parameters.P_Language  -- association [1..1]
LEFT OUTER JOIN I_MRPTypeText AS _MRPText ON _MRPText.MRPType = _ProductPlant.MRPType AND _MRPText.Language = $parameters.P_Language  -- association [1..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSup ON _ProductionSup.Plant = Plant AND _ProductionSup.ProductionSupervisor = _ProductPlant.ProductionSupervisor association[1..1] to P_MPE_MaterialPlantStkQty as _PlantStock on Material = _PlantStock.Material AND Plant = _PlantStock.Plant AND StorageLocation = '' association[1..1] to P_MPE_MaterialPlantSalesStkQty as _PlantSalesStock on Material = _PlantSalesStock.Material AND Plant = _PlantSalesStock.Plant AND StorageLocation = '' association[1..1] to P_MPE_MaterialPlantWBSStkQty as _PlantWBSSTock on Material = _PlantWBSSTock.Material AND Plant = _PlantWBSSTock.Plant AND StorageLocation = ''  -- association [1..1]
;