I_CollateralObjectCalcData

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_CollateralObjectCalcData.
-- 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_CollateralObjectCalcData AS
SELECT
  obj_guid AS CollateralObjectUUID,
  obj_typ AS CollateralObjectType,
  con_guid AS CollateralConstellationUUID,
  ast_typ AS ObjectAssetType,
  parent_guid AS ObjectAssetParentUUID,
  result_curr AS CollateralObjectCurrency,
  asset_value AS ObjectAssetAmount,
  lending_value AS ObjectAssetLendingAmt,
  lending_limit1 AS ObjectAssetLendingLimit1Amt,
  lending_limit2 AS ObjectAssetLendingLimit2Amt,
  lending_limit3 AS ObjectAssetLendingLimit3Amt,
  lending_limit4 AS ObjectAssetLendingLimit4Amt,
  lending_limit5 AS ObjectAssetLendingLimit5Amt,
  lending_range1 AS ObjectAssetLendingRange1Amt,
  lending_range2 AS ObjectAssetLendingRange2Amt,
  lending_range3 AS ObjectAssetLendingRange3Amt,
  lending_range4 AS ObjectAssetLendingRange4Amt,
  lending_range5 AS ObjectAssetLendingRange5Amt,
  prt_len_val AS ObjectAssetPrtLendingAmt,
  prt_len_lim1 AS ObjectAssetPrtLendingLimit1Amt,
  prt_len_lim2 AS ObjectAssetPrtLendingLimit2Amt,
  prt_len_lim3 AS ObjectAssetPrtLendingLimit3Amt,
  prt_len_lim4 AS ObjectAssetPrtLendingLimit4Amt,
  prt_len_lim5 AS ObjectAssetPrtLendingLimit5Amt,
  prt_len_rng1 AS ObjectAssetPrtLendingRange1Amt,
  prt_len_rng2 AS ObjectAssetPrtLendingRange2Amt,
  prt_len_rng3 AS ObjectAssetPrtLendingRange3Amt,
  prt_len_rng4 AS ObjectAssetPrtLendingRange4Amt,
  prt_len_rng5 AS ObjectAssetPrtLendingRange5Amt,
  free_lending_limit_c AS ObjAstFreeLendgLmtCurRskAmt,
  free_lending_limit_m AS ObjAstFreeLendgLmtMaxRskAmt,
  free_lending_limit_pct_c AS ObjAstFreeLendgLmtCurRskPct,
  free_lending_limit_pct_m AS ObjAstFreeLendgLmtMaxRskPct,
  credit_system AS CollateralRblCreditSystem,
  rbl_id AS CollateralReceivableID,
  coverage_gap_c AS RblCoverageGapCurRiskAmt,
  coverage_gap_m AS RblCoverageGapMaxRiskAmt,
  cov_gap_pct_c AS RblCoverageGapCurRiskPct,
  cov_gap_pct_m AS RblCoverageGapMaxRiskPct,
  coll_ratio_pct_c AS RblCollateralRatioCurRiskPct,
  coll_ratio_pct_m AS RblCollateralRatioMaxRiskPct,
  coll_value_c AS AgreementCollateralCurRiskAmt,
  coll_value_m AS AgreementCollateralMaxRiskAmt,
  coll_value_pct_c AS AgreementCollateralCurRiskPct,
  coll_value_pct_m AS AgreementCollateralMaxRiskPct,
  lend_val_grt_c AS AgreementGuarLendingCurRiskAmt,
  lend_val_grt_m AS AgreementGuarLendingMaxRiskAmt,
  lnd_vl_grt_pct_c AS AgreementGuarLendingCurRiskPct,
  lnd_vl_grt_pct_m AS AgreementGuarLendingMaxRiskPct,
  lend_lmt_grt_c AS AgreementGuarLendgLmtCurRskAmt,
  lend_lmt_grt_m AS AgreementGuarLendgLmtMaxRskAmt,
  lend_lmt_grt_pct_c AS AgreementGuarLendgLmtCurRskPct,
  lend_lmt_grt_pct_m AS AgreementGuarLendgLmtMaxRskPct,
  ltov_wrt_cag_c AS AgrmtLoanToValAgrmtCurRskAmt,
  ltov_wrt_cag_m AS AgrmtLoanToValAgrmtMaxRskAmt,
  ltov_cag_pct_c AS AgrmtLoanToValAgrmtCurRskPct,
  ltov_cag_pct_m AS AgrmtLoanToValAgrmtMaxRskPct,
  ltov_wrt_pr_c AS AgrLoaToValPriorChrgCurRskAmt,
  ltov_wrt_pr_m AS AgrLoaToValPriorChrgMaxRskAmt,
  ltov_pr_pct_c AS AgrLoaToValPriorChrgRskCurPct,
  ltov_pr_pct_m AS AgrLoaToValPriorChrgMaxRskPct,
  ltov_wrt_rbl_c AS AgreementLoanToValRblCurRskAmt,
  ltov_wrt_rbl_m AS AgreementLoanToValRblMaxRskAmt,
  ltov_rbl_pct_c AS AgreementLoanToValRblCurRskPct,
  ltov_rbl_pct_m AS AgreementLoanToValRblMaxRskPct,
  dist_cv_c AS AgrmtDistrdColltrlCurRskAmt,
  dist_cv_m AS AgrmtDistrdColltrlMaxRskAmt,
  dist_cv_pct_c AS AgrmtDistrdColltrlCurRskPct,
  dist_cv_pct_m AS AgrmtDistrdColltrlMaxRskPct,
  cov_ratio_pct_c AS AgreementCvrgRatioCurRiskPct,
  cov_ratio_pct_m AS AgreementCvrgRatioMaxRiskPct,
  coll_right_c AS AgrmtColltrlRightsCurRskAmt,
  coll_right_m AS AgrmtColltrlRightsMaxRskAmt,
  coll_rgt_pct_c AS AgrmtColltrlRightsCurRskPct,
  coll_rgt_pct_m AS AgrmtColltrlRightsMaxRskPct,
  last_chg_by AS CollateralObjCalcLastChangedBy,
  last_chg_date AS CollateralObjCalcLastChgdDate,
  last_chg_time AS CollateralObjCalcLastChgdTime,
  _ObjectAssetData.ObjectAssetUUID AS ObjectAssetUUID,
  _ObjectAssetData.ObjectAssetReferenceSystem AS ObjectAssetReferenceSystem
FROM cms_calc_obj
LEFT OUTER JOIN I_AgreementAssetCalcData AS _AgreementAssetCalcData ON CollateralObjectUUID = _AgreementAssetCalcData.CollateralAgreementUUID OR CollateralObjectUUID = _AgreementAssetCalcData.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementRelshpCalcData AS _AgreementRelshpCalcData ON CollateralObjectUUID = _AgreementRelshpCalcData.AgreementRelationshipSrceUUID OR CollateralObjectUUID = _AgreementRelshpCalcData.AgreementRelationshipDestUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementPortionCalcData AS _AgreementPortionCalcData ON CollateralObjectUUID = _AgreementPortionCalcData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementReceivableCalcData AS _AgreementReceivableCalcData ON CollateralObjectUUID = _AgreementReceivableCalcData.CollateralAgreementUUID OR ( CollateralRblCreditSystem = _AgreementReceivableCalcData.CollateralRblCreditSystem AND CollateralReceivableID = _AgreementReceivableCalcData.CollateralReceivableID AND CollateralObjectType = 'RBL' )  -- association [0..*]
LEFT OUTER JOIN I_CollateralAgreementData AS _CollateralAgreementData ON CollateralObjectUUID = _CollateralAgreementData.CollateralAgreementUUID  -- association [0..1]
LEFT OUTER JOIN I_AgreementPortion AS _AgreementPortion ON CollateralObjectUUID = _AgreementPortion.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementPartner AS _AgreementPartner ON CollateralObjectUUID = _AgreementPartner.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementSpecialArrangement AS _AgreementSpecialArrangement ON CollateralObjectUUID = _AgreementSpecialArrangement.AgrmtSpecialArrangementRefUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementTerminationAndCost AS _AgreementTerminationAndCost ON CollateralObjectUUID = _AgreementTerminationAndCost.AgreementTermnAndCostLinkUUID  -- association [0..*]
LEFT OUTER JOIN I_AssetAgreementLinkData AS _AssetAgreementLinkData ON CollateralObjectUUID = _AssetAgreementLinkData.CollateralAgreementUUID OR CollateralObjectUUID = _AssetAgreementLinkData.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAgreementRelshp AS _CollateralAgreementRelshp ON CollateralObjectUUID = _CollateralAgreementRelshp.AgreementRelationshipSrceUUID OR CollateralObjectUUID = _CollateralAgreementRelshp.AgreementRelationshipDestUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementReceivableLinkData AS _AgreementReceivableLinkData ON CollateralRblCreditSystem = _AgreementReceivableLinkData.CollateralRblCreditSystem AND CollateralReceivableID = _AgreementReceivableLinkData.CollateralReceivableID AND CollateralObjectType = 'RBL'  -- association [0..*]
LEFT OUTER JOIN I_ReceivableData AS _ReceivableData ON CollateralRblCreditSystem = _ReceivableData.CollateralRblCreditSystem AND CollateralReceivableID = _ReceivableData.CollateralReceivableID AND CollateralObjectType = 'RBL'  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetData AS _ObjectAssetData ON CollateralObjectUUID = _ObjectAssetData.ObjectAssetUUID  -- association [0..1]
LEFT OUTER JOIN I_ObjectAssetPartner AS _ObjectAssetPartner ON CollateralObjectUUID = _ObjectAssetPartner.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetDocument AS _ObjectAssetDocument ON CollateralObjectUUID = _ObjectAssetDocument.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralObjectType AS _CollateralObjectType ON CollateralObjectType = _CollateralObjectType.CollateralObjectType  -- association [0..1]
LEFT OUTER JOIN I_ObjectAssetType AS _ObjectAssetType ON ObjectAssetType = _ObjectAssetType.ObjectAssetType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralObjectCurrency ON CollateralObjectCurrency = _CollateralObjectCurrency.Currency  -- association [0..1]
;