I_CollateralAgreementData

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_CollateralAgreementData.
-- 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_CollateralAgreementData AS
SELECT
  cag_guid AS CollateralAgreementUUID,
  cagmtid AS CollateralAgreementID,
  cagmt_type AS CollateralAgreementType,
  nom_value AS CollateralAgreementNominalAmt,
  nom_value_curr AS CollateralAgrmtNominalCrcy,
  asmt_amt AS ColltrlAgrmtAssessmentAmt,
  asmt_curr AS ColltrlAgrmtAssessmentCrcy,
  asmt_date AS ColltrlAgrmtAssessmentDate,
  cagmt_date AS ColltrlAgreementConcludeDate,
  cast( substring(valid_from, 2, 8 ) as cms_dte_date ) AS ColltrlAgreementValidFromDate,
  cast( substring(valid_to, 2, 8 ) as cms_dte_date ) AS ColltrlAgreementValidToDate,
  admin_org_unit AS CollateralAdminOrgUnit,
  bankarea AS CollateralBankArea,
  country_key AS ColltrlAgrmtJurisdictionCntry,
  flg_global AS CollateralAgreementIsGlobal,
  spl_markdown_pct AS ColltrlAgrmtSpclMarkDwnPct,
  spl_markdown_amt AS ColltrlAgrmtSpclMarkDwnAmt,
  spl_mrkdown_curr AS ColltrlAgrmtSpclMarkdownCrcy,
  description AS CollateralAgreementDescription,
  unit_rel_freq AS ColltrlAgrmtReleaseFrequency,
  period_rel_freq AS ColltrlAgrmtReleasePeriod,
  old_cagmtid AS ColltrlAgrmtExtRefNumber,
  min_ql_excep_typ AS ColltrlAgrmtMinQltatvExcptn,
  min_ql_reason AS ColltrlAgrmtMinQltatvCritraRsn,
  flg_min_ql_reqmt AS ColltrlAgrmtIsMinQltatvRqmts,
  min_ql_crite AS ColltrlAgrmtMinQltatvCriteria,
  pct_asset_val AS CollateralAgreementAssetPct,
  term_right_typ AS ColltrlAgrmtTermnRightType,
  unit_term_freq AS ColltrlAgrmtTermnFrequency,
  period_term_freq AS ColltrlAgrmtTermnPeriod,
  notice_prd_unit AS ColltrlAgrmtTermnNoticeFrqcy,
  req_notice_prd AS ColltrlAgrmtTermnNoticePeriod,
  term_notice_date AS ColltrlAgrmtTermnNoticeDate,
  term_reason AS ColltrlAgrmtTerminationReason,
  term_guar_amt AS ColltrlAgrmtTermnGuarAmt,
  termination_curr AS ColltrlAgrmtTermnGuarCrcy,
  guar_rate AS ColltrlAgrmtGuaranteePct,
  flg_counter_guar AS ColltrlAgrmtHasCounterGuar,
  flg_co_guar AS ColltrlAgrmtHasAdditionalGuar,
  flg_fixed_liabty AS ColltrlAgrmtGuarIsFxdLiability,
  flg_def_liabty AS ColltrlAgrmtGuarIsDfltLblty,
  pct_def_liabty AS ColltrlAgrmtGuarDfltLbltyPct,
  flg_incl_cag_lnk AS ColltrlAgrmtGuarLinkInCalc,
  ind_appr_auth AS ColltrlAgrmtGuarAuthApproval,
  flg_enforceable AS ColltrlAgrmtGuarIsEnforceable,
  lending_rate AS ColltrlAgrmtGuarLendingRate,
  unit_redu_freq AS ColltrlAgrmtGuarReducnFrqcy,
  period_redu_freq AS ColltrlAgrmtGuarReducnPeriod,
  redu_amt AS ColltrlAgrmtGuarReducnAmt,
  redu_curr AS ColltrlAgrmtGuarReducnCrcy,
  redu_pct AS ColltrlAgrmtGuarReducnPct,
  ori_value AS ColltrlAgrmtOriginalAmount,
  ori_value_curr AS ColltrlAgrmtOriginalCurrency,
  flg_leasing_txn AS ColltrlAgrmtTransfIsLeasing,
  ind_lessor_lien AS ColltrlAgrmtTransfLessorLien,
  ind_acc_liable AS ColltrlAgrmtTransfAccsryLblty,
  flg_asgmt_ar AS ColltrlAgrmtAcctRblAssgmt,
  min_stock_amt AS ColltrlAgrmtMinStockAmount,
  min_stock_curr AS ColltrlAgrmtMinStockCurrency,
  flg_addnl_rbl AS ColltrlAgrmtHasAdditionalRbl,
  addnl_rbl_date AS ColltrlAgrmtAdditionalRblDate,
  ind_gbc_lien AS AgrmtGenBusCndnLienWvr,
  flg_discl AS ColltrlAgrmtPledgeIsDisclosed,
  discl_date AS ColltrlAgrmtPledgeDisclosedDte,
  asgmt_reason AS ColltrlAgrmtAssignmentReason,
  int_rate AS AgrmtLandChrgInterestRate,
  incidental_paymt AS AgrmtLandChrgIncidentalPaytPct,
  unit_pmt_freq AS AgrmtLandChrgPaytFrqcy,
  period_pmt_freq AS AgrmtLandChrgPaytPeriod,
  int_start_date AS AgrmtLandChrgCalcStrtDate,
  num_yr_lchg_int AS AgrmtLandChrgIntrstCapitalYrs,
  ind_enforcmt_typ AS AgrmtLandChrgEnforcementType,
  enforcmt_amt AS AgrmtLandChrgEnforcementAmt,
  enforcmt_curr AS AgrmtLandChrgEnforcementCrcy,
  ref_enforcmt_amt AS AgrmtLandChrgRefEnforcementAmt,
  enforcmt_title AS AgrmtLandChrgEnfrcmntTtlType,
  unit_int_freq AS ColAgrHtBlRgIntrstPayFrqUnit,
  period_int_freq AS ColAgrHtBlRgIntrstPayFrqPerd,
  flg_interest_inc AS ColAgrHtBlRgIsIntrstIncreasing,
  unit_inc_freq AS ColAgrHtBlRgIntIncFrqUnit,
  period_inc_freq AS ColAgrHtBlRgIntIncFrqPerd,
  inc_pct AS ColAgrHtBlRgIncreasePct,
  inc_amt AS ColAgrHtBlRgIncreaseAmt,
  inc_curr AS ColAgrHtBlRgIncreaseCrcy,
  inc_start_date AS ColAgrHtBlRgIntrstIncrStartDte,
  ind_hbr_waiver AS ColAgrHtBlRgEnfrcmntWvr,
  inc_last_date AS ColAgrHtBlRgIntrstIncrLastDte,
  flg_coll_lchg AS AgrmtLandChrgIsCollective,
  flg_charge_cert AS AgrmtLandChrgHasCert,
  charge_cert_num AS AgrmtLandChrgCertNumber,
  file_num AS AgrmtLandChrgFileNumber,
  scope_ins_cover AS ColltrlAgrmtCreditInsurCover,
  org_unit1 AS ColltrlAgrmtUnit1,
  org_unit2 AS ColltrlAgrmtUnit2,
  org_unit3 AS ColltrlAgrmtUnit3,
  org_unit4 AS ColltrlAgrmtUnit4,
  org_unit5 AS ColltrlAgrmtUnit5,
  liqd_mode AS ColltrlAgrmtLiquidationMode,
  cor_role AS ColltrlAgrmtCorrespncRole,
  rel_threshold AS ColltrlAgrmtPoolRelThreshold,
  flg_min_ql_reqmt AS ColAgrMinQltatvRqmtIndCode
FROM cms_cag
LEFT OUTER JOIN I_AgreementPortion AS _AgreementPortion ON CollateralAgreementUUID = _AgreementPortion.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementPartner AS _AgreementPartner ON CollateralAgreementUUID = _AgreementPartner.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementSpecialArrangement AS _AgreementSpecialArrangement ON CollateralAgreementUUID = _AgreementSpecialArrangement.AgrmtSpecialArrangementRefUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementTerminationAndCost AS _AgreementTerminationAndCost ON CollateralAgreementUUID = _AgreementTerminationAndCost.AgreementTermnAndCostLinkUUID  -- association [0..*]
LEFT OUTER JOIN I_AssetAgreementLinkData AS _AssetAgreementLinkData ON CollateralAgreementUUID = _AssetAgreementLinkData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAgreementRelshp AS _CollateralAgreementRelshp ON CollateralAgreementUUID = _CollateralAgreementRelshp.AgreementRelationshipSrceUUID OR CollateralAgreementUUID = _CollateralAgreementRelshp.AgreementRelationshipDestUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralObjectCalcData AS _CollateralObjectCalcData ON CollateralAgreementUUID = _CollateralObjectCalcData.CollateralObjectUUID AND _CollateralObjectCalcData.CollateralObjectType = 'CAG'  -- association [0..1]
LEFT OUTER JOIN I_AgreementAssetCalcData AS _AgreementAssetCalcData ON CollateralAgreementUUID = _AgreementAssetCalcData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementRelshpCalcData AS _AgreementRelshpCalcData ON CollateralAgreementUUID = _AgreementRelshpCalcData.AgreementRelationshipSrceUUID OR CollateralAgreementUUID = _AgreementRelshpCalcData.AgreementRelationshipDestUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementPortionCalcData AS _AgreementPortionCalcData ON CollateralAgreementUUID = _AgreementPortionCalcData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementReceivableCalcData AS _AgreementReceivableCalcData ON CollateralAgreementUUID = _AgreementReceivableCalcData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementType AS _CollateralAgreementType ON CollateralAgreementType = _CollateralAgreementType.CollateralAgreementType  -- association [0..1]
LEFT OUTER JOIN I_AgrmtGenBusCndnLienWvr AS _AgrmtGenBusCndnLienWvr ON AgrmtGenBusCndnLienWvr = _AgrmtGenBusCndnLienWvr.AgrmtGenBusCndnLienWvr  -- association [0..1]
LEFT OUTER JOIN I_AgreementFrequencyUnit AS _ColltrlAgrmtReleaseFrequency ON ColltrlAgrmtReleaseFrequency = _ColltrlAgrmtReleaseFrequency.AgreementFrequencyUnit  -- association [0..1]
LEFT OUTER JOIN I_AgreementFrequencyUnit AS _ColltrlAgrmtTermnFrequency ON ColltrlAgrmtTermnFrequency = _ColltrlAgrmtTermnFrequency.AgreementFrequencyUnit  -- association [0..1]
LEFT OUTER JOIN I_AgreementFrequencyUnit AS _ColltrlAgrmtGuarReducnFrqcy ON ColltrlAgrmtGuarReducnFrqcy = _ColltrlAgrmtGuarReducnFrqcy.AgreementFrequencyUnit  -- association [0..1]
LEFT OUTER JOIN I_AgreementFrequencyUnit AS _AgrmtLandChrgPaytFrqcy ON AgrmtLandChrgPaytFrqcy = _AgrmtLandChrgPaytFrqcy.AgreementFrequencyUnit  -- association [0..1]
LEFT OUTER JOIN I_AgreementFrequencyUnit AS _ColAgrHtBlRgIntrstPayFrqUnit ON ColAgrHtBlRgIntrstPayFrqUnit = _ColAgrHtBlRgIntrstPayFrqUnit.AgreementFrequencyUnit  -- association [0..1]
LEFT OUTER JOIN I_AgreementFrequencyUnit AS _ColAgrHtBlRgIntIncFrqUnit ON ColAgrHtBlRgIntIncFrqUnit = _ColAgrHtBlRgIntIncFrqUnit.AgreementFrequencyUnit  -- association [0..1]
LEFT OUTER JOIN I_CollateralAdminOrgUnitAttrib AS _CollateralAdminOrgUnitAttrib ON CollateralAdminOrgUnit = _CollateralAdminOrgUnitAttrib.CollateralAdminOrgUnit  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralAgrmtNominalCrcy ON CollateralAgrmtNominalCrcy = _CollateralAgrmtNominalCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlAgrmtAssessmentCrcy ON ColltrlAgrmtAssessmentCrcy = _ColltrlAgrmtAssessmentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlAgrmtMinStockCurrency ON ColltrlAgrmtMinStockCurrency = _ColltrlAgrmtMinStockCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlAgrmtSpclMarkdownCrcy ON ColltrlAgrmtSpclMarkdownCrcy = _ColltrlAgrmtSpclMarkdownCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlAgrmtTermnGuarCrcy ON ColltrlAgrmtTermnGuarCrcy = _ColltrlAgrmtTermnGuarCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlAgrmtGuarReducnCrcy ON ColltrlAgrmtGuarReducnCrcy = _ColltrlAgrmtGuarReducnCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlAgrmtOriginalCurrency ON ColltrlAgrmtOriginalCurrency = _ColltrlAgrmtOriginalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AgrmtLandChrgEnforcementCrcy ON AgrmtLandChrgEnforcementCrcy = _AgrmtLandChrgEnforcementCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColAgrHtBlRgIncreaseCrcy ON ColAgrHtBlRgIncreaseCrcy = _ColAgrHtBlRgIncreaseCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Country AS _ColltrlAgrmtJurisdictionCntry ON ColltrlAgrmtJurisdictionCntry = _ColltrlAgrmtJurisdictionCntry.Country  -- association [0..1]
LEFT OUTER JOIN I_AgreementMinQltatvException AS _ColltrlAgrmtMinQltatvExcptn ON ColltrlAgrmtMinQltatvExcptn = _ColltrlAgrmtMinQltatvExcptn.ColltrlAgrmtMinQltatvExcptn  -- association [0..1]
LEFT OUTER JOIN I_AgreementMinQltatvCriteria AS _ColltrlAgrmtMinQltatvCriteria ON ColltrlAgrmtMinQltatvCriteria = _ColltrlAgrmtMinQltatvCriteria.ColltrlAgrmtMinQltatvCriteria  -- association [0..1]
LEFT OUTER JOIN I_AgreementTermnNtcFrqcy AS _ColltrlAgrmtTermnNoticeFrqcy ON ColltrlAgrmtTermnNoticeFrqcy = _ColltrlAgrmtTermnNoticeFrqcy.ColltrlAgrmtTermnNoticeFrqcy  -- association [0..1]
LEFT OUTER JOIN I_AgrmtGuaranteeAuthApprvl AS _ColltrlAgrmtGuarAuthApproval ON ColltrlAgrmtGuarAuthApproval = _ColltrlAgrmtGuarAuthApproval.ColltrlAgrmtGuarAuthApproval  -- association [0..1]
LEFT OUTER JOIN I_AgreementTransferLessorLien AS _ColltrlAgrmtTransfLessorLien ON ColltrlAgrmtTransfLessorLien = _ColltrlAgrmtTransfLessorLien.ColltrlAgrmtTransfLessorLien  -- association [0..1]
LEFT OUTER JOIN I_AgrmtLandChrgEnforcementType AS _AgrmtLandChrgEnforcementType ON AgrmtLandChrgEnforcementType = _AgrmtLandChrgEnforcementType.AgrmtLandChrgEnforcementType  -- association [0..1]
LEFT OUTER JOIN I_AgrmtLandChrgEnforcementTtl AS _AgrmtLandChrgEnfrcmntTtlType ON AgrmtLandChrgEnfrcmntTtlType = _AgrmtLandChrgEnfrcmntTtlType.AgrmtLandChrgEnfrcmntTtlType  -- association [0..1]
LEFT OUTER JOIN I_AgreementTermnRightType AS _ColltrlAgrmtTermnRightType ON ColltrlAgrmtTermnRightType = _ColltrlAgrmtTermnRightType.AgreementTermnRightType  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _AgrmtMinQltatvCritraRsn ON ColltrlAgrmtMinQltatvCritraRsn = _AgrmtMinQltatvCritraRsn.CollateralAttributeIndType AND _AgrmtMinQltatvCritraRsn.CollateralAttributeIndCat = 'CAG001'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlAgrmtTerminationReason ON ColltrlAgrmtTerminationReason = _ColltrlAgrmtTerminationReason.CollateralAttributeIndType AND _ColltrlAgrmtTerminationReason.CollateralAttributeIndCat = 'CAG002'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlAgrmtAssignmentReason ON ColltrlAgrmtAssignmentReason = _ColltrlAgrmtAssignmentReason.CollateralAttributeIndType AND _ColltrlAgrmtAssignmentReason.CollateralAttributeIndCat = 'CAG006'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlAgrmtCreditInsurCover ON ColltrlAgrmtCreditInsurCover = _ColltrlAgrmtCreditInsurCover.CollateralAttributeIndType AND _ColltrlAgrmtCreditInsurCover.CollateralAttributeIndCat = 'CAG004'  -- association [0..1]
LEFT OUTER JOIN I_ColAgrHtBlRgEnfrcmntWvr AS _ColAgrHtBlRgEnfrcmntWvr ON ColAgrHtBlRgEnfrcmntWvr = _ColAgrHtBlRgEnfrcmntWvr.ColAgrHtBlRgEnfrcmntWvr  -- association [0..1]
;