I_CollateralAgreementRelshp

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_CollateralAgreementRelshp.
-- 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_CollateralAgreementRelshp AS
SELECT
  rel_guid AS AgreementRelationshipUUID,
  rel_typ AS AgreementRelationshipType,
  source_guid AS AgreementRelationshipSrceUUID,
  src_sec_guid AS AgrmtRelshpSrceSecdryUUID,
  destination_guid AS AgreementRelationshipDestUUID,
  cast( substring(valid_from, 2, 8 ) as cms_dte_date ) AS AgrmtRelshpValidFromDate,
  cast( substring(valid_to, 2, 8 ) as cms_dte_date ) AS AgrmtRelshpValidToDate,
  rel_rank AS AgrmtRelshpRankValue,
  rel_priority AS AgrmtRelshpPriorityValue,
  calc_typ AS AgreementRelationshipCalcType,
  rel_obj AS AgreementRelationshipObject
FROM cms_rel
LEFT OUTER JOIN I_CollateralAgreementData AS _CollateralAgreementData ON AgreementRelationshipSrceUUID = _CollateralAgreementData.CollateralAgreementUUID OR AgreementRelationshipDestUUID = _CollateralAgreementData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementPortion AS _AgreementPortion ON AgreementRelationshipSrceUUID = _AgreementPortion.CollateralAgreementUUID OR AgreementRelationshipDestUUID = _AgreementPortion.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementPartner AS _AgreementPartner ON AgreementRelationshipSrceUUID = _AgreementPartner.CollateralAgreementUUID OR AgreementRelationshipDestUUID = _AgreementPartner.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementSpecialArrangement AS _AgreementSpecialArrangement ON AgreementRelationshipSrceUUID = _AgreementSpecialArrangement.AgrmtSpecialArrangementRefUUID OR AgreementRelationshipDestUUID = _AgreementSpecialArrangement.AgrmtSpecialArrangementRefUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementTerminationAndCost AS _AgreementTerminationAndCost ON AgreementRelationshipSrceUUID = _AgreementTerminationAndCost.AgreementTermnAndCostLinkUUID OR AgreementRelationshipDestUUID = _AgreementTerminationAndCost.AgreementTermnAndCostLinkUUID  -- association [0..*]
LEFT OUTER JOIN I_AssetAgreementLinkData AS _AssetAgreementLinkData ON AgreementRelationshipSrceUUID = _AssetAgreementLinkData.CollateralAgreementUUID OR AgreementRelationshipDestUUID = _AssetAgreementLinkData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralObjectCalcData AS _CollateralObjectCalcData ON ( AgreementRelationshipSrceUUID = _CollateralObjectCalcData.CollateralObjectUUID OR AgreementRelationshipDestUUID = _CollateralObjectCalcData.CollateralObjectUUID ) AND _CollateralObjectCalcData.CollateralObjectType = 'CAG'  -- association [0..*]
LEFT OUTER JOIN I_AgreementAssetCalcData AS _AgreementAssetCalcData ON AgreementRelationshipSrceUUID = _AgreementAssetCalcData.CollateralAgreementUUID OR AgreementRelationshipDestUUID = _AgreementAssetCalcData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementRelshpCalcData AS _AgreementRelshpCalcData ON AgreementRelationshipUUID = _AgreementRelshpCalcData.AgreementRelationshipUUID  -- association [0..1]
LEFT OUTER JOIN I_AgreementPortionCalcData AS _AgreementPortionCalcData ON AgreementRelationshipSrceUUID = _AgreementPortionCalcData.CollateralAgreementUUID OR AgreementRelationshipDestUUID = _AgreementPortionCalcData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementReceivableCalcData AS _AgreementReceivableCalcData ON AgreementRelationshipSrceUUID = _AgreementReceivableCalcData.CollateralAgreementUUID OR AgreementRelationshipDestUUID = _AgreementReceivableCalcData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementRelationshipType AS _AgreementRelationshipType ON AgreementRelationshipType = _AgreementRelationshipType.AgreementRelationshipType  -- association [0..1]
;