I_PMRPSimlnOutputNodeByProduct

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 I_PMRPSimlnOutputNodeByProduct.
-- 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.

CREATE VIEW I_PMRPSimlnOutputNodeByProduct AS
SELECT
  PMRPSimulation,
  Product,
  Plant,
  MRPArea,
  PMRPSupplyGroup,
  PMRPSupplyGroupCategory,
  PMRPSourceOfSupplyInternalID,
  PMRPFlexibleConstraint,
  cast( '0000000000' as pmrp_flexcon_id ) AS PMRPFlxblCstrtProductGroup,
  cast('' as pmrp_supply_grp) AS PMRPParentSupplyGroup,
  PMRPReferencePlan,
  PMRPSupplyGroupSourceOfSupply,
  _ReferencePlan.BucketCategory AS BucketCategory,
  case when _PMRPProduct.MRPProcedure = 'C' then 'X' else '' end as MRPProcedure AS MRPProcedureCthenXelseendasMRPProcedure,
  _PMRPProduct.UnitOfMeasure AS UnitOfMeasure,
  _PMRPProduct.MRPController AS MRPController,
  _PMRPProduct._PMRPController.MRPControllerName AS MRPControllerName,
  _PMRPProduct._PMRPProcurementType.ProcurementType AS ProcurementType,
  _PMRPProduct._PMRPProcurementType.ProcurementTypeDescription AS ProcurementTypeDescription,
  _SourceOfSupply.PMRPSourceOfSupplyName AS PMRPSourceOfSupplyName,
  _Plant.PlantName AS PlantName,
  _MRPArea.MRPAreaText AS MRPAreaText,
  case when ParentPMRPSourceOfSupply = '99999998' then _Product._Text[Language=$session.system_language].ProductName else _SourceOfSupply.PMRPSourceOfSupplyName end as ProductName AS PMRPSourceOfSupplyNameendasProductName,
  _Product.LowLevelCode AS LowLevelCode,
  case when ParentPMRPSourceOfSupply = '99999998' then Product else _SourceOfSupply.PMRPSourceOfSupplyName end as MaterialName AS PMRPSourceOfSupplyNameendasMaterialName
FROM P_PMRPSimlnOutputNodeByProduct
LEFT OUTER JOIN I_Product AS _Product ON _Product.Product = Product  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [1..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON _MRPArea.MRPArea = MRPArea  -- association [1..1]
LEFT OUTER JOIN I_PMRPSimulation AS _Simulation ON _Simulation.PMRPSimulation = PMRPSimulation  -- association [1..1]
LEFT OUTER JOIN I_PMRPReferencePlan AS _ReferencePlan ON _ReferencePlan.PMRPReferencePlan = PMRPReferencePlan  -- association [1..1]
LEFT OUTER JOIN I_PMRPProduct AS _PMRPProduct ON _PMRPProduct.PMRPReferencePlan = PMRPReferencePlan AND _PMRPProduct.Product = Product AND _PMRPProduct.MRPArea = MRPArea AND _PMRPProduct.Plant = Plant  -- association [1..1]
LEFT OUTER JOIN I_PMRPSourceOfSupply AS _SourceOfSupply ON _SourceOfSupply.PMRPReferencePlan = PMRPReferencePlan AND _SourceOfSupply.PMRPSourceOfSupplyInternalID = PMRPSupplyGroupSourceOfSupply  -- association [0..1]
LEFT OUTER JOIN I_PMRPFlexibleConstraint AS _Constraint ON _Constraint.PMRPSimulation = PMRPSimulation AND _Constraint.PMRPFlexibleConstraint = PMRPFlexibleConstraint  -- association [0..1]
LEFT OUTER JOIN I_PMRPSimlnOutputNodeByProduct AS _ParentOutpNodeByProduct ON _ParentOutpNodeByProduct.PMRPSimulation = PMRPSimulation AND _ParentOutpNodeByProduct.Product = Product AND _ParentOutpNodeByProduct.MRPArea = MRPArea AND _ParentOutpNodeByProduct.Plant = Plant AND _ParentOutpNodeByProduct.PMRPSupplyGroup = PMRPParentSupplyGroup AND _ParentOutpNodeByProduct.PMRPSupplyGroupCategory = PMRPParentSupplyGroupCategory AND _ParentOutpNodeByProduct.PMRPSourceOfSupplyInternalID = ParentPMRPSourceOfSupply  -- association [0..1]
LEFT OUTER JOIN R_PMRPSimlnOutputByBucket AS _Output ON _Output.PMRPSimulation = PMRPSimulation AND _Output.Product = Product AND _Output.Plant = Plant AND _Output.MRPArea = MRPArea AND _Output.PMRPFlxblCstrtProductGroup = PMRPFlxblCstrtProductGroup AND _Output.PMRPSupplyGroup = PMRPSupplyGroup AND _Output.PMRPSupplyGroupCategory = PMRPSupplyGroupCategory AND _Output.PMRPSourceOfSupplyInternalID = PMRPSourceOfSupplyInternalID  -- association [0..*]
;