I_ReceivableData

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_ReceivableData.
-- 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_ReceivableData AS
SELECT
  rbl_guid AS CollateralReceivableUUID,
  creditsystem AS CollateralRblCreditSystem,
  rbl_id AS CollateralReceivableID,
  prd_class AS CollateralRblProductClass,
  product AS CollateralRblProduct,
  rbl_org_unit AS CollateralRblOrganizationUnit,
  ind_credit AS CollateralRblIsCredit,
  otherbank AS CollateralRblIsOtherBank,
  descr AS CollateralRblDescription,
  admin_org_unit AS CollateralAdminOrgUnit,
  status AS CollateralRblStatus,
  ref_crdsys AS CollateralRblCreditSystemRef,
  ref_id AS CollateralRblReferenceNumber,
  cast( substring(valid_from, 2, 8 ) as cms_dte_date ) AS CollateralRblRiskValidFromDate,
  cast( substring(valid_to, 2, 8 ) as cms_dte_date ) AS CollateralRblRiskValidToDate,
  cast( substring(fixed_from, 2, 8 ) as cms_dte_date ) AS ColltrlRblCndnFxdPerdStrtDte,
  cast( substring(fixed_to, 2, 8 ) as cms_dte_date ) AS ColltrlRblCndnFxdPerdEndDte,
  cont_amount AS CollateralRblContractAmount,
  cont_currency AS CollateralRblContractCurrency,
  amt_maxrisk AS CollateralRblMaximumRiskAmount,
  amt_currrisk AS CollateralRblCurrentRiskAmount,
  curr_risk AS CollateralRblRiskCurrency,
  amt_oblig AS CollateralRblDisbmtOblgnAmt,
  curr_oblig AS CollateralRblDisbmtOblgnCrcy,
  amt_util AS CollateralRblUtilizationAmount,
  curr_util AS CollateralRblUtilizationCrcy,
  amt_drawdown AS CollateralRblDrawdownAmount,
  curr_drawdown AS CollateralRblDrawdownCurrency,
  amt_interest AS CollateralRblInterestAmount,
  curr_interest AS CollateralRblInterestCurrency,
  amt_fees AS CollateralRblFeesAmount,
  curr_fees AS CollateralRblFeesCurrency,
  amt_1 AS CollateralRbl1stAmount,
  curr_1 AS CollateralRbl1stCurrency,
  amt_2 AS CollateralRbl2ndAmount,
  curr_2 AS CollateralRbl2ndCurrency,
  amt_3 AS CollateralRbl3rdAmount,
  curr_3 AS CollateralRbl3rdCurrency,
  amt_4 AS CollateralRbl4thAmount,
  curr_4 AS CollateralRbl4thCurrency,
  org_unit1 AS CollateralRblOrgUnit1,
  org_unit2 AS CollateralRblOrgUnit2,
  org_unit3 AS CollateralRblOrgUnit3,
  org_unit4 AS CollateralRblOrgUnit4,
  org_unit5 AS CollateralRblOrgUnit5
FROM cms_rbl
LEFT OUTER JOIN I_AgreementReceivableLinkData AS _AgreementReceivableLinkData ON CollateralRblCreditSystem = _AgreementReceivableLinkData.CollateralRblCreditSystem AND CollateralReceivableID = _AgreementReceivableLinkData.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_AgreementReceivableCalcData AS _AgreementReceivableCalcData ON CollateralRblCreditSystem = _AgreementReceivableCalcData.CollateralRblCreditSystem AND CollateralReceivableID = _AgreementReceivableCalcData.CollateralReceivableID  -- association [0..*]
LEFT OUTER JOIN I_CollateralRblCreditSystem AS _CollateralRblCreditSystem ON CollateralRblCreditSystem = _CollateralRblCreditSystem.CollateralRblCreditSystem  -- association [0..1]
LEFT OUTER JOIN I_CollateralRblCreditSystem AS _CollateralRblCreditSystemRef ON CollateralRblCreditSystemRef = _CollateralRblCreditSystemRef.CollateralRblCreditSystem  -- association [0..1]
LEFT OUTER JOIN I_CollateralRblOrgUnit AS _CollateralRblOrganizationUnit ON CollateralRblOrganizationUnit = _CollateralRblOrganizationUnit.CollateralRblOrganizationUnit  -- association [0..1]
LEFT OUTER JOIN I_CollateralRblProductClass AS _CollateralRblProductClass ON CollateralRblProductClass = _CollateralRblProductClass.CollateralRblProductClass  -- association [0..1]
LEFT OUTER JOIN I_CollateralRblProduct AS _CollateralRblProduct ON CollateralRblProduct = _CollateralRblProduct.CollateralRblProduct  -- association [0..1]
LEFT OUTER JOIN I_CollateralRblStatus AS _CollateralRblStatus ON CollateralRblStatus = _CollateralRblStatus.CollateralRblStatus  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralRblContractCurrency ON CollateralRblContractCurrency = _CollateralRblContractCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralRblRiskCurrency ON CollateralRblRiskCurrency = _CollateralRblRiskCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralRblDisbmtOblgnCrcy ON CollateralRblDisbmtOblgnCrcy = _CollateralRblDisbmtOblgnCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralRblUtilizationCrcy ON CollateralRblUtilizationCrcy = _CollateralRblUtilizationCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralRblDrawdownCurrency ON CollateralRblDrawdownCurrency = _CollateralRblDrawdownCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralRblInterestCurrency ON CollateralRblInterestCurrency = _CollateralRblInterestCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralRblFeesCurrency ON CollateralRblFeesCurrency = _CollateralRblFeesCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralRbl1stCurrency ON CollateralRbl1stCurrency = _CollateralRbl1stCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralRbl2ndCurrency ON CollateralRbl2ndCurrency = _CollateralRbl2ndCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralRbl3rdCurrency ON CollateralRbl3rdCurrency = _CollateralRbl3rdCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralRbl4thCurrency ON CollateralRbl4thCurrency = _CollateralRbl4thCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CollateralFinancedObject AS _CollateralFinancedObject ON CollateralRblCreditSystem = _CollateralFinancedObject.CollateralRblCreditSystem AND CollateralReceivableID = _CollateralFinancedObject.CollateralReceivableID  -- association [0..*]
;