I_AgreementReceivableLinkData

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_AgreementReceivableLinkData.
-- 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_AgreementReceivableLinkData AS
SELECT
  cag_rbl_guid AS AgreementReceivableUUID,
  cag_por_guid AS AgreementPortionUUID,
  creditsystem AS CollateralRblCreditSystem,
  rbl_id AS CollateralReceivableID,
  cast( substring(valid_from, 2, 8 ) as cms_dte_date ) AS AgreementRblLinkValidFromDate,
  cast( substring(valid_to, 2, 8 ) as cms_dte_date ) AS AgreementRblLinkValidToDate,
  priority AS AgreementRblPriorityVal,
  ranking_class AS AgreementRblRankingClassVal,
  ind_link_typ AS AgreementReceivableLinkType,
  ind_tran_coll AS AgreementTemporaryColltrlSign,
  rbl_amt AS AgreementRblSecuredAmount,
  rbl_curr AS AgreementRblSecuredCurrency,
  rbl_pct AS AgreementReceivablePercent,
  rbl_portion AS AgreementReceivablePortion,
  ref_rbl_amt AS AgreementRblMiddlePortnRefAmt,
  ref_rbl_pct AS AgreementRblMiddlePortnRefPct,
  component_type AS AgreementRblComponentType,
  created_by AS AgreementRblLinkEnteredBy,
  created_at AS AgreementRblLinkEnteredDteTme,
  changed_by AS AgreementRblLinkLastChangedBy,
  changed_at AS AgreementRblLinkLastChgdDteTme
FROM cms_cag_rbl
LEFT OUTER JOIN I_AgreementPortion AS _AgreementPortion ON AgreementPortionUUID = _AgreementPortion.AgreementPortionUUID  -- association [0..1]
LEFT OUTER JOIN I_AgreementPartner AS _AgreementPartner ON AgreementPortionUUID = _AgreementPartner.AgreementPortionUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementPortionRules AS _AgreementPortionRules ON AgreementPortionUUID = _AgreementPortionRules.AgreementPortionUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementSpecialArrangement AS _AgreementSpecialArrangement ON AgreementPortionUUID = _AgreementSpecialArrangement.AgrmtSpecialArrangementRefUUID  -- association [0..*]
LEFT OUTER JOIN I_ReceivableData AS _ReceivableData ON CollateralRblCreditSystem = _ReceivableData.CollateralRblCreditSystem AND CollateralReceivableID = _ReceivableData.CollateralReceivableID  -- association [0..*]
LEFT OUTER JOIN I_CollateralObjectCalcData AS _CollateralObjectCalcData ON CollateralRblCreditSystem = _CollateralObjectCalcData.CollateralRblCreditSystem AND CollateralReceivableID = _CollateralObjectCalcData.CollateralReceivableID AND _CollateralObjectCalcData.CollateralObjectType = 'RBL'  -- association [0..*]
LEFT OUTER JOIN I_AgreementPortionCalcData AS _AgreementPortionCalcData ON AgreementPortionUUID = _AgreementPortionCalcData.AgreementPortionUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementReceivableCalcData AS _AgreementReceivableCalcData ON AgreementReceivableUUID = _AgreementReceivableCalcData.AgreementReceivableUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralRblCreditSystem AS _CollateralRblCreditSystem ON CollateralRblCreditSystem = _CollateralRblCreditSystem.CollateralRblCreditSystem  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AgreementRblSecuredCurrency ON AgreementRblSecuredCurrency = _AgreementRblSecuredCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_AgreementReceivablePortion AS _AgreementReceivablePortion ON AgreementReceivablePortion = _AgreementReceivablePortion.AgreementReceivablePortion  -- association [0..1]
LEFT OUTER JOIN I_AgreementRblComponentType AS _AgreementRblComponentType ON AgreementRblComponentType = _AgreementRblComponentType.AgreementRblComponentType  -- association [0..1]
;