R_MaintNotifEventPrioznTP

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 R_MaintNotifEventPrioznTP.
-- 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: RWRKREQCNSQN

CREATE VIEW R_MaintNotifEventPrioznTP AS
SELECT
  MaintenanceNotification,
  MaintEventCnsqncCategoryCode,
  MaintEventConsequenceCode,
  MaintEventLikelihoodCode,
  MaintEvtPrioritizationProfile,
  MaintEventConsequenceGroup,
  MaintEventConsequenceIsLeading
FROM I_MaintNotificationConsequence
LEFT OUTER JOIN I_MaintEventPrioznProfileText AS _MaintEventPrioznProfileText ON MaintEvtPrioritizationProfile = _MaintEventPrioznProfileText.MaintEvtPrioritizationProfile  -- association [0..*]
LEFT OUTER JOIN I_MaintEventCnsqncCategoryText AS _MaintEventCnsqncCategoryText ON MaintEventCnsqncCategoryCode = _MaintEventCnsqncCategoryText.MaintEventCnsqncCategoryCode  -- association [0..*]
LEFT OUTER JOIN I_MaintEventConsequenceText AS _MaintEventConsequenceText ON MaintEventCnsqncCategoryCode = _MaintEventConsequenceText.MaintEventCnsqncCategoryCode AND MaintEventConsequenceCode = _MaintEventConsequenceText.MaintEventConsequenceCode  -- association [0..*]
LEFT OUTER JOIN I_MaintEventLikelihoodText AS _MaintEventLikelihoodText ON MaintEventLikelihoodCode = _MaintEventLikelihoodText.MaintEventLikelihoodCode  -- association [0..*]
;