C_CntrbtScenWrkrAssmtTP

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_CntrbtScenWrkrAssmtTP.
-- 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 C_CntrbtScenWrkrAssmtTP AS
SELECT
  CmplRqRsltUUID,
  ActiveCmplRqRsltUUID,
  _ExpsrScenShortTitleVH1._ProdCmplncPhrsText[1: Language = $session.system_language ].ProdCmplncPhrsText AS PCESShortTitlePhrs1Txt,
  _ExpsrScenShortTitleVH1.ProdCmplncPhrsCode AS PCESShortTitlePhrs1Code,
  _ExpsrScenShortTitleVH2._ProdCmplncPhrsText[1: Language = $session.system_language ].ProdCmplncPhrsText AS PCESShortTitlePhrs2Txt,
  _ExpsrScenShortTitleVH2.ProdCmplncPhrsCode AS PCESShortTitlePhrs2Code,
  _ExpsrScenShortTitleVH3._ProdCmplncPhrsText[1: Language = $session.system_language ].ProdCmplncPhrsText AS PCESShortTitlePhrs3Txt,
  _ExpsrScenShortTitleVH3.ProdCmplncPhrsCode AS PCESShortTitlePhrs3Code,
  _ExpsrScenShortTitleVH4._ProdCmplncPhrsText[1: Language = $session.system_language ].ProdCmplncPhrsText AS PCESShortTitlePhrs4Txt,
  _ExpsrScenShortTitleVH4.ProdCmplncPhrsCode AS PCESShortTitlePhrs4Code,
  _ExpsrScenShortTitleVH5._ProdCmplncPhrsText[1: Language = $session.system_language ].ProdCmplncPhrsText AS PCESShortTitlePhrs5Txt,
  _ExpsrScenShortTitleVH5.ProdCmplncPhrsCode AS PCESShortTitlePhrs5Code,
  _ExpsrScenShortTitleVH6._ProdCmplncPhrsText[1: Language = $session.system_language ].ProdCmplncPhrsText AS PCESShortTitlePhrs6Txt,
  _ExpsrScenShortTitleVH6.ProdCmplncPhrsCode AS PCESShortTitlePhrs6Code,
  cast(_CmplRqVers.CmplRqVers as ehpma_crv_mkt_id preserving type ) AS CmplRqVers,
  cast(_CmplRqVers.CmplRqVersName as ehpma_crr_crv_mkt_name preserving type ) AS CmplRqVersName,
  cast ( _ProcessingStatus.ProcessingStatusText as ehsds_es_status ) AS CmplRqRsltProcessingStatusName,
  cast( '' as ad_namtext ) AS CmplRqRsltProcessorName,
  _ReleasedByUser.PersonFullName AS ReleasedByUserName,
  PCESScenarioUUID,
  LastChangeDateTime,
  LastChangedByUser,
  CreationDateTime,
  CreatedByUser,
  CmplRqRsltPrelimCmplncSts
FROM I_CmplRqRsltPCESWrkrAssmtTP
LEFT OUTER JOIN C_CntrbtScenWrkrAmtUsedTP AS _CntrbtScenWrkrAmtUsed ON CmplRqRsltUUID = _CntrbtScenWrkrAmtUsed.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenWrkrGenDataTP AS _CntrbtScenWrkrGenData ON CmplRqRsltUUID = _CntrbtScenWrkrGenData.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN C_CntrbtScenWrkrProdCharcTP AS _CntrbtScenWrkrProdCharc ON CmplRqRsltUUID = _CntrbtScenWrkrProdCharc.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN C_CntrbtScenWrkrOplCndnTP AS _CntrbtScenWrkrOplCndn ON CmplRqRsltUUID = _CntrbtScenWrkrOplCndn.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN C_CntrbtScenWrkrOthFctrTP AS _CntrbtScenWrkrOthFctr ON CmplRqRsltUUID = _CntrbtScenWrkrOthFctr.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenWrkrExpsrEstnTP AS _CntrbtScenWrkrExpsrEstn ON CmplRqRsltUUID = _CntrbtScenWrkrExpsrEstn.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenWrkrEstnDetTP AS _CntrbtScenWrkrEstnDet ON CmplRqRsltUUID = _CntrbtScenWrkrEstnDet.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenWrkrTechRskMgmtTP AS _CntrbtScenTechOrglRskMgmt ON CmplRqRsltUUID = _CntrbtScenTechOrglRskMgmt.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenWrkrPersRskMgmtTP AS _CntrbtScenWrkrPersRskMgmt ON CmplRqRsltUUID = _CntrbtScenWrkrPersRskMgmt.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenWrkrAdvcTP AS _CntrbtScenWrkrAdvc ON CmplRqRsltUUID = _CntrbtScenWrkrAdvc.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenWrkrFrqcyDurnTP AS _CntrbtScenWrkrFrqcyDurn ON CmplRqRsltUUID = _CntrbtScenWrkrFrqcyDurn.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN I_CmplRqVersEnhanced AS _CmplRqVers ON CmplRqVersUUID = _CmplRqVers.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _ReleasedByUser ON ReleasedByUser = _ReleasedByUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ExpsrScenProcgStsVH AS _ProcessingStatus ON CmplRqRsltProcessingStatus = _ProcessingStatus.CmplRqRsltProcessingStatus  -- association [0..1]
LEFT OUTER JOIN C_CntrbtScenTypeVH AS _ScenTypeVH ON PCESScenarioType = _ScenTypeVH.PCESScenarioType  -- association [1..1]
LEFT OUTER JOIN C_PCESExposureScenarioTypeVH AS _ExpsrScenTypeVH ON PCESExposureScenarioType = _ExpsrScenTypeVH.PCESExposureScenarioType  -- association [1..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _ExpsrScenShortTitleVH1 ON PCESShortTitlePhrs1UUID = _ExpsrScenShortTitleVH1.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _ExpsrScenShortTitleVH2 ON PCESShortTitlePhrs2UUID = _ExpsrScenShortTitleVH2.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _ExpsrScenShortTitleVH3 ON PCESShortTitlePhrs3UUID = _ExpsrScenShortTitleVH3.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _ExpsrScenShortTitleVH4 ON PCESShortTitlePhrs4UUID = _ExpsrScenShortTitleVH4.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _ExpsrScenShortTitleVH5 ON PCESShortTitlePhrs5UUID = _ExpsrScenShortTitleVH5.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _ExpsrScenShortTitleVH6 ON PCESShortTitlePhrs6UUID = _ExpsrScenShortTitleVH6.ProdCmplncPhrsUUID  -- association [0..1]
;