C_PMRPSimulation

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 C_PMRPSimulation.
-- 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: CPMRPSIM

CREATE VIEW C_PMRPSimulation AS
SELECT
  PMRPSimulation,
  _SimulationText[Language=$session.system_language].PMRPSimulationDescription AS PMRPSimulationDescription,
  PMRPReferencePlan,
  _ReferencePlan._PMRPReferencePlanText[Language=$session.system_language].PMRPReferencePlanDescription AS PMRPReferencePlanDescription,
  I_PMRPSimulationTP._ReferencePlan.PMRPCostCtrPlanIsToBePubd AS PMRPCostCtrPlanIsToBePubd,
  PMRPSimulationStatus,
  _SimulationStatusText.PMRPSimulationStatusName AS PMRPSimulationStatusName,
  CreatedByUser,
  _CreatedBy.UserDescription AS CreatedByUserName,
  tstmp_to_dats( CreationDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as CreationDateTime AS clientNULLasCreationDateTime,
  LastChangedByUser,
  _ChangedBy.UserDescription AS ChangedByUserName,
  tstmp_to_dats( LastChangeDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as LastChangeDateTime AS clientNULLasLastChangeDateTime,
  NumberOfCapacityIssues,
  PreviousNumberOfCapacityIssues,
  concat_with_space(cast (TopLvlDmndUndrdelivRatioInPct as abap.char(6)), '%', 1) AS TopLvlDmndUndrdelivRatioInPct,
  PreviousUndrdelivRatioInPct,
  cast ('%' as meins) AS DeliveryPerformanceUnit,
  _RefBucketCount.PMRPNumberOfBuckets AS PMRPNumberOfBuckets,
  _RefBucketCount.PMRPBucketCategory AS PMRPBucketCategory,
  PMRPRsceOverloadTolerancePct,
  PMRPSimulationVersionCode,
  PMRPSimulationIsObsolete,
  NumberOfProductsWithMissingSOS,
  PrevNmbrOfProdsWithMissingSOS,
  PMRPNumberOfConstraintIssues,
  PMRPPrevNmbrOfConstraintIssues,
  I_PMRPSimulationTP._ReferencePlan.PMRPStockDeterminationRule AS PMRPStockDeterminationRule
FROM I_PMRPSimulationTP
LEFT OUTER JOIN I_User AS _CreatedBy ON CreatedByUser = _CreatedBy.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _ChangedBy ON LastChangedByUser = _ChangedBy.UserID  -- association [1..1]
LEFT OUTER JOIN I_PMRPSimulationStatusText AS _SimulationStatusText ON PMRPSimulationStatus = _SimulationStatusText.PMRPSimulationStatus AND _SimulationStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_PMRPSimulationCreatedByVH AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID AND CreatedByUserName = _CreatedByUser.UserDescription  -- association [1..1]
LEFT OUTER JOIN C_PMRPReferencePlanVH AS _ReferenceVH ON PMRPReferencePlan = _ReferenceVH.PMRPReferencePlan AND pmrpreferenceplandescription = _ReferenceVH.PMRPReferencePlanDescription  -- association [1..1]
LEFT OUTER JOIN C_PMRPSimulationVH AS _SimulationVH ON PMRPSimulation = _SimulationVH.PMRPSimulation AND PMRPSimulationDescription = _SimulationVH.PMRPSimulationDescription  -- association [1..1]
LEFT OUTER JOIN C_PMRPChangeInDemand AS _ChangeInDemand ON PMRPSimulation = _ChangeInDemand.PMRPSimulation  -- association [1..*]
LEFT OUTER JOIN C_PMRPChangeInCapacity AS _ChangeInCapacity ON PMRPSimulation = _ChangeInCapacity.PMRPSimulation  -- association [1..*]
LEFT OUTER JOIN C_PMRPUnresolvedIssue AS _UnresolvedIssue ON PMRPSimulation = _UnresolvedIssue.PMRPSimulation  -- association [1..*]
LEFT OUTER JOIN C_PMRPRsceDisregardedIssues AS _DisregardedIssues ON PMRPSimulation = _DisregardedIssues.PMRPSimulation  -- association [1..*]
LEFT OUTER JOIN C_PMRPChangeInSOS AS _PMRPChangeInSOS ON PMRPSimulation = _PMRPChangeInSOS.PMRPSimulation  -- association [1..*]
LEFT OUTER JOIN C_PMRPReallocation AS _Reallocation ON PMRPSimulation = _Reallocation.PMRPSimulation  -- association [1..*]
LEFT OUTER JOIN I_PMRPBucketCount AS _RefBucketCount ON PMRPReferencePlan = _RefBucketCount.PMRPReferencePlan  -- association [1..1]
LEFT OUTER JOIN C_PMRPIssueByCause AS _IssueByCause ON PMRPSimulation = _IssueByCause.PMRPSimulation  -- association [1..*]
LEFT OUTER JOIN C_PMRPChangeInDemandKey AS _ChangeInDemandKey ON /* condition not available in parsed metadata */  -- association [1..*]
;