I_AgreementRelshpCalcData

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_AgreementRelshpCalcData.
-- 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_AgreementRelshpCalcData AS
SELECT
  rel_guid AS AgreementRelationshipUUID,
  source_guid AS AgreementRelationshipSrceUUID,
  src_sec_guid AS AgrmtRelshpSrceSecdryUUID,
  destination_guid AS AgreementRelationshipDestUUID,
  con_guid AS CollateralConstellationUUID,
  result_curr AS AgreementRelationshipCurrency,
  dist_col_val_c AS AgrRelDistrdColltrlCurRskAmt,
  dist_col_val_m AS AgrRelDistrdColltrlMaxRskAmt,
  dist_cv_pct_c AS AgrRelDistrdColltrlCurRskPct,
  dist_cv_pct_m AS AgrRelDistrdColltrlMaxRskPct,
  last_chg_by AS AgrmtRelshpCalcLastChgdBy,
  last_chg_date AS AgrmtRelshpCalcLastChgdDate,
  last_chg_time AS AgrmtRelshpCalcLastChgdTime
FROM cms_calc_rel
LEFT OUTER JOIN I_CollateralObjectCalcData AS _CollateralObjectCalcData ON AgreementRelationshipSrceUUID = _CollateralObjectCalcData.CollateralObjectUUID OR AgreementRelationshipDestUUID = _CollateralObjectCalcData.CollateralObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementAssetCalcData AS _AgreementAssetCalcData ON AgreementRelationshipSrceUUID = _AgreementAssetCalcData.CollateralAgreementUUID OR AgreementRelationshipDestUUID = _AgreementAssetCalcData.CollateralAgreementUUID  -- association [0..*]
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_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_CollateralAgreementRelshp AS _CollateralAgreementRelshp ON AgreementRelationshipUUID = _CollateralAgreementRelshp.AgreementRelationshipUUID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AgreementRelationshipCurrency ON AgreementRelationshipCurrency = _AgreementRelationshipCurrency.Currency  -- association [0..1]
;