C_ExpsrScenAssmtTP

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_ExpsrScenAssmtTP.
-- 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_ExpsrScenAssmtTP AS
SELECT
  CmplRqRsltUUID,
  _ExposureScenarioType.PCESExposureScenarioTypeTxt AS PCESExposureScenarioTypeTxt,
  _ExpsrScenShortTitle1VH._ProdCmplncPhrsText[1: Language = $session.system_language ].ProdCmplncPhrsText AS PCESShortTitlePhrs1Txt,
  _ExpsrScenShortTitle1VH.ProdCmplncPhrsCode AS PCESShortTitlePhrs1Code,
  _ExpsrScenShortTitle2VH._ProdCmplncPhrsText[1: Language = $session.system_language ].ProdCmplncPhrsText AS PCESShortTitlePhrs2Txt,
  _ExpsrScenShortTitle2VH.ProdCmplncPhrsCode AS PCESShortTitlePhrs2Code,
  _ExpsrScenShortTitle3VH._ProdCmplncPhrsText[1: Language = $session.system_language ].ProdCmplncPhrsText AS PCESShortTitlePhrs3Txt,
  _ExpsrScenShortTitle3VH.ProdCmplncPhrsCode AS PCESShortTitlePhrs3Code,
  _ExpsrScenShortTitle4VH._ProdCmplncPhrsText[1: Language = $session.system_language ].ProdCmplncPhrsText AS PCESShortTitlePhrs4Txt,
  _ExpsrScenShortTitle4VH.ProdCmplncPhrsCode AS PCESShortTitlePhrs4Code,
  _ExpsrScenShortTitle5VH._ProdCmplncPhrsText[1: Language = $session.system_language ].ProdCmplncPhrsText AS PCESShortTitlePhrs5Txt,
  _ExpsrScenShortTitle5VH.ProdCmplncPhrsCode AS PCESShortTitlePhrs5Code,
  _ExpsrScenShortTitle6VH._ProdCmplncPhrsText[1: Language = $session.system_language ].ProdCmplncPhrsText AS PCESShortTitlePhrs6Txt,
  _ExpsrScenShortTitle6VH.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,
  _ReleasedByUser.PersonFullName AS ReleasedByUserName,
  LastChangeDateTime,
  LastChangedByUser,
  CreationDateTime,
  CreatedByUser,
  CmplRqRsltPrelimCmplncSts
FROM I_CmplRqRsltPCESAssmtTP AS _ExpsrScenAssmtTP
LEFT OUTER JOIN C_ExpsrScenGenDataTP AS _ExpsrScenGenData ON CmplRqRsltUUID = _ExpsrScenGenData.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN C_ExpsrScenGuidanceTP AS _ExpsrScenGuidance ON CmplRqRsltUUID = _ExpsrScenGuidance.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_ExpsrScenScalingTP AS _ExpsrScenScaling ON CmplRqRsltUUID = _ExpsrScenScaling.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenAssgmtTP AS _CntrbtScenAssgmt ON CmplRqRsltUUID = _CntrbtScenAssgmt.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 I_ProdCmplncPhrs AS _ExpsrScenShortTitle1VH ON PCESShortTitlePhrs1UUID = _ExpsrScenShortTitle1VH.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _ExpsrScenShortTitle2VH ON PCESShortTitlePhrs2UUID = _ExpsrScenShortTitle2VH.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _ExpsrScenShortTitle3VH ON PCESShortTitlePhrs3UUID = _ExpsrScenShortTitle3VH.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _ExpsrScenShortTitle4VH ON PCESShortTitlePhrs4UUID = _ExpsrScenShortTitle4VH.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _ExpsrScenShortTitle5VH ON PCESShortTitlePhrs5UUID = _ExpsrScenShortTitle5VH.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _ExpsrScenShortTitle6VH ON PCESShortTitlePhrs6UUID = _ExpsrScenShortTitle6VH.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN R_ExposureScenarioTP AS _ExposureScenario ON PCESScenarioUUID = _ExposureScenario.PCESScenarioUUID  -- association [1..1]
LEFT OUTER JOIN C_PCESExposureScenarioTypeVH AS _ExposureScenarioType ON PCESExposureScenarioType = _ExposureScenarioType.PCESExposureScenarioType  -- association [1..1]
;