C_CntrbtScenCnsmrAssmtTP

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_CntrbtScenCnsmrAssmtTP.
-- 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_CntrbtScenCnsmrAssmtTP 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_CmplRqRsltPCESCnsmrAssmtTP
LEFT OUTER JOIN C_CntrbtScenCnsmrGenDataTP AS _CntrbtScenCnsmrGenData ON CmplRqRsltUUID = _CntrbtScenCnsmrGenData.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN C_CntrbtScenCnsmrExpsrEstnTP AS _CntrbtScenCnsmrExpsrEstn ON CmplRqRsltUUID = _CntrbtScenCnsmrExpsrEstn.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenCnsmrEstnDetTP AS _CntrbtScenCnsmrEstnDet ON CmplRqRsltUUID = _CntrbtScenCnsmrEstnDet.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenCnsmrAmtUsedTP AS _CntrbtScenCnsmrAmtUsed ON CmplRqRsltUUID = _CntrbtScenCnsmrAmtUsed.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenCnsmrOthFctrTP AS _CntrbtScenCnsmrOthFctr ON CmplRqRsltUUID = _CntrbtScenCnsmrOthFctr.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenCnsmrOplCndnTP AS _CntrbtScenCnsmrOplCndn ON CmplRqRsltUUID = _CntrbtScenCnsmrOplCndn.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN C_CntrbtScenCnsmrFrqcyDurnTP AS _CntrbtScenCnsmrFrqcyDurn ON CmplRqRsltUUID = _CntrbtScenCnsmrFrqcyDurn.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenCnsmrProtTP AS _CntrbtScenCnsmrProt ON CmplRqRsltUUID = _CntrbtScenCnsmrProt.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CntrbtScenCnsmrProdCharcTP AS _CntrbtScenCnsmrProdCharc ON CmplRqRsltUUID = _CntrbtScenCnsmrProdCharc.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]
;