C_CntrbtScenEnvrmtAssmtTP

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_CntrbtScenEnvrmtAssmtTP.
-- 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_CntrbtScenEnvrmtAssmtTP 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_CmplRqRsltPCESEnvrmtAssmtTP
LEFT OUTER JOIN C_CntrbtScenEnvrmtGenDataTP AS _CntrbtScenEnvrmtGenData ON CmplRqRsltUUID = _CntrbtScenEnvrmtGenData.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN C_CntrbtScenEnvrmtRelEstnTP AS _CntrbtScenEnvrmtRelEstn ON CmplRqRsltUUID = _CntrbtScenEnvrmtRelEstn.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenEnvrmtExpsrEstnTP AS _CntrbtScenEnvrmtExpsrEstn ON CmplRqRsltUUID = _CntrbtScenEnvrmtExpsrEstn.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenEnvrmtEstnDetTP AS _CntrbtScenEnvrmtEstnDet ON CmplRqRsltUUID = _CntrbtScenEnvrmtEstnDet.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenEnvrmtRelPrvtnTP AS _CntrbtScenEnvrmtRelPrvtn ON CmplRqRsltUUID = _CntrbtScenEnvrmtRelPrvtn.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenEnvrmtOplCndnTP AS _CntrbtScenEnvrmtOplCndn ON CmplRqRsltUUID = _CntrbtScenEnvrmtOplCndn.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenEnvrmtWasteMsrTP AS _CntrbtScenEnvrmtWasteMsr ON CmplRqRsltUUID = _CntrbtScenEnvrmtWasteMsr.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenEnvrmtFrqcyDurnTP AS _CntrbtScenEnvrmtFrqcyDurn ON CmplRqRsltUUID = _CntrbtScenEnvrmtFrqcyDurn.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenEnvrmtMsafeTP AS _CntrbtScenEnvrmtMsafe ON CmplRqRsltUUID = _CntrbtScenEnvrmtMsafe.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN C_CntrbtScenEnvrmtAmtUsedTP AS _CntrbtScenEnvrmtAmtUsed ON CmplRqRsltUUID = _CntrbtScenEnvrmtAmtUsed.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenEnvrmtProdCharcTP AS _CntrbtScenEnvrmtProdCharc ON CmplRqRsltUUID = _CntrbtScenEnvrmtProdCharc.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN C_CntrbtScenEnvrmtAdvcTP AS _CntrbtScenEnvrmtAdvc ON CmplRqRsltUUID = _CntrbtScenEnvrmtAdvc.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenEnvrmtOthFctrTP AS _CntrbtScenEnvrmtOthFctr ON CmplRqRsltUUID = _CntrbtScenEnvrmtOthFctr.CmplRqRsltUUID  -- association [0..1]
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]
;