I_CmplRqRsltPCESWrkrAssmtTP

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_CmplRqRsltPCESWrkrAssmtTP.
-- 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_CmplRqRsltPCESWrkrAssmtTP AS
SELECT
  CmplRqRsltUUID,
  cast(CmplRqRsltUUID as ehfnd_crr_active_uuid preserving type ) AS ActiveCmplRqRsltUUID,
  ChmlCmplncInfoUUID,
  PCESScenarioUUID,
  _ExposureScenario.PCESExposureScenarioType AS PCESExposureScenarioType,
  _ExposureScenario.PCESScenarioType AS PCESScenarioType,
  _CntrbtScenWrkrGenData.PCESShortTitlePhrs1UUID AS PCESShortTitlePhrs1UUID,
  _CntrbtScenWrkrGenData.PCESShortTitlePhrs2UUID AS PCESShortTitlePhrs2UUID,
  _CntrbtScenWrkrGenData.PCESShortTitlePhrs3UUID AS PCESShortTitlePhrs3UUID,
  _CntrbtScenWrkrGenData.PCESShortTitlePhrs4UUID AS PCESShortTitlePhrs4UUID,
  _CntrbtScenWrkrGenData.PCESShortTitlePhrs5UUID AS PCESShortTitlePhrs5UUID,
  _CntrbtScenWrkrGenData.PCESShortTitlePhrs6UUID AS PCESShortTitlePhrs6UUID,
  ComplianceRequirement,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  CmplRqRsltProcessingStatus,
  Processor AS CmplRqRsltProcessor,
  ReleasedByUser,
  ValidityStartDateTime,
  ValidityEndDateTime,
  CmplRqRsltReldCmplncSts,
  CmplRqRsltCalculatedStatus,
  CmplRqRsltManualStatus,
  CmplRqRsltPrelimCmplncSts,
  CmplRqRsltStatusRemark
FROM I_CmplRqRslt
LEFT OUTER JOIN I_ExposureScenario AS _ExposureScenario ON PCESScenarioUUID = _ExposureScenario.PCESScenarioUUID  -- association [1..1]
LEFT OUTER JOIN I_CntrbtScenWrkrGenDataTP AS _CntrbtScenWrkrGenData ON CmplRqRsltUUID = _CntrbtScenWrkrGenData.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN I_CntrbtScenWrkrAmtUsedTP AS _CntrbtScenWrkrAmtUsed ON CmplRqRsltUUID = _CntrbtScenWrkrAmtUsed.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN I_CntrbtScenWrkrProdCharcTP AS _CntrbtScenWrkrProdCharc ON CmplRqRsltUUID = _CntrbtScenWrkrProdCharc.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN I_CntrbtScenWrkrOplCndnTP AS _CntrbtScenWrkrOplCndn ON CmplRqRsltUUID = _CntrbtScenWrkrOplCndn.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN I_CntrbtScenWrkrOthFctrTP AS _CntrbtScenWrkrOthFctr ON CmplRqRsltUUID = _CntrbtScenWrkrOthFctr.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN I_CntrbtScenWrkrPersRskMgmtTP AS _CntrbtScenWrkrPersRskMgmt ON CmplRqRsltUUID = _CntrbtScenWrkrPersRskMgmt.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN I_CntrbtScenWrkrExpsrEstnTP AS _CntrbtScenWrkrExpsrEstn ON CmplRqRsltUUID = _CntrbtScenWrkrExpsrEstn.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN I_CntrbtScenWrkrEstnDetTP AS _CntrbtScenWrkrEstnDet ON CmplRqRsltUUID = _CntrbtScenWrkrEstnDet.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN I_CntrbtScenWrkrTechRskMgmtTP AS _CntrbtScenTechOrglRskMgmt ON CmplRqRsltUUID = _CntrbtScenTechOrglRskMgmt.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN I_CntrbtScenWrkrAdvcTP AS _CntrbtScenWrkrAdvc ON CmplRqRsltUUID = _CntrbtScenWrkrAdvc.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN I_CntrbtScenWrkrFrqcyDurnTP AS _CntrbtScenWrkrFrqcyDurn ON CmplRqRsltUUID = _CntrbtScenWrkrFrqcyDurn.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;