I_CollateralAssetData

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_CollateralAssetData.
-- 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_CollateralAssetData AS
SELECT
  ast_guid AS CollateralAssetUUID,
  ast_id AS CollateralAssetIdentifier,
  ast_typ AS CollateralAssetType,
  parent_guid AS CollateralAssetParentUUID,
  subast_id AS ColltrlSubsqntAssetIdentifier,
  subast_typ AS ColltrlSubsequentAssetType,
  description AS CollateralAssetDescription,
  object_ref_id AS CollateralAssetReferenceNumber,
  country_key AS CollateralAssetCountryKey,
  risk_code AS CollateralAssetRiskCode,
  sfty_ind AS ColltrlAssetSafetyDiscountSign,
  sfty_dscnt AS ColltrlAssetSafetyDiscountPct,
  sfty_amount AS ColltrlAssetSafetyDiscountAmt,
  sfty_amt_curr AS ColltrlAssetSafetyDiscountCrcy,
  objsysid AS CollateralReferenceSystem,
  valuation_typ AS CollateralAssetValuationType,
  unit_valn_freq AS ColltrlAssetValuationFrequency,
  period_valn_freq AS CollateralAssetValuationPeriod,
  past_valued_date AS ColltrlAstLastRevaluationDate,
  start_date AS ColltrlAstRevaluationStartDte,
  end_date AS ColltrlAssetRevaluationEndDate,
  lending_rate_ind AS CollateralAssetLendingRateSign,
  lending_rate1 AS CollateralAssetLendingRate,
  lending_rate2 AS CollateralAssetLendingRate2,
  lending_rate3 AS CollateralAssetLendingRate3,
  lending_rate4 AS CollateralAssetLendingRate4,
  lending_rate5 AS CollateralAssetLendingRate5,
  liqd_typ AS CollateralAssetLiquidationType,
  liqd_reason AS ColltrlAssetLiquidationReason,
  liqd_date AS ColltrlAssetLiquidationDate,
  liqd_amt AS ColltrlAssetLiquidationAmount,
  liqd_curr AS ColltrlAstLiquidationCurrency,
  exp_prcd_amnt AS ColltrlAstLqdtnExpdProceedAmt,
  exp_prcd_curr AS ColltrlAstLqdtnExpdProceedCrcy,
  exp_acc_date AS ColltrlAstLqdtnExpdAccrualDate,
  obj_exp_prc_time AS ColltrlAstLqdtnExpdProceedDate,
  acc_number_liq AS ColltrlAstLqdtnAccountNumber,
  bank_cntry_liq AS ColltrlAstLqdtnBankCountry,
  bank_key_liq AS ColltrlAssetLiquidationBankKey,
  bank_ctrlkey_liq AS ColltrlAstLqdtnBankControlKey,
  unit_verf_freq AS ColltrlAstVerificatFrequency,
  period_verf_freq AS ColltrlAssetVerificationPeriod,
  last_verf_date AS ColltrlAssetVerificationDate,
  nom_value AS CollateralAssetNominalAmount,
  nom_value_curr AS CollateralAssetNominalCurrency,
  ast_value AS CollateralAssetFinalAmount,
  ast_value_curr AS CollateralAssetFinalCurrency,
  quantity AS CollateralAssetQuantity,
  unit_of_measure AS CollateralAssetQuantityUoM,
  rec_at AS ColltrlAssetRecordingDateTime,
  pur_price AS CollateralAssetPurchasePrice,
  pur_price_curr AS ColltrlAssetPurchaseCurrency,
  pur_date AS CollateralAssetPurchaseDate,
  ori_value AS CollateralAssetOriginalAmount,
  ori_value_curr AS ColltrlAssetOriginalCurrency,
  admin_org_unit AS CollateralAdminOrgUnit,
  bankarea AS CollateralBankArea,
  created_by AS CollateralAssetEnteredBy,
  created_at AS CollateralAssetEnteredDateTime,
  changed_by AS CollateralAssetLastChangedBy,
  changed_at AS ColltrlAstLastChangedDateTime,
  sourceofentry AS CollateralAssetEnteredSource,
  nxt_valued_date AS ColltrlAstNextRevaluationDate
FROM cms_ast
LEFT OUTER JOIN I_CollateralAssetPartner AS _CollateralAssetPartner ON CollateralAssetUUID = _CollateralAssetPartner.CollateralAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAssetDocument AS _CollateralAssetDocument ON CollateralAssetUUID = _CollateralAssetDocument.CollateralAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralRealEstate AS _CollateralRealEstate ON CollateralAssetReferenceNumber = _CollateralRealEstate.ColltrlRealEstateConvertedID  -- association [0..*]
LEFT OUTER JOIN I_CollateralRealEstatePart AS _CollateralRealEstatePart ON CollateralAssetReferenceNumber = _CollateralRealEstatePart.ColltrlREPartConvertedID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartAccessory AS _ColltrlREPartAccessory ON CollateralAssetReferenceNumber = _ColltrlREPartAccessory.ColltrlREPrtAccsryConvertedID  -- association [0..*]
LEFT OUTER JOIN I_CollateralCharge AS _CollateralCharge ON CollateralAssetUUID = _CollateralCharge.CollateralAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralFinancedObject AS _CollateralFinancedObject ON CollateralAssetUUID = _CollateralFinancedObject.CollateralAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralInsurance AS _CollateralInsurance ON CollateralAssetReferenceNumber = _CollateralInsurance.CollateralInsuranceConvertedID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAssetType AS _CollateralAssetType ON CollateralAssetType = _CollateralAssetType.CollateralAssetType  -- association [0..1]
LEFT OUTER JOIN I_CollateralSafetyDiscountSign AS _ColltrlAstSafetyDiscountSign ON ColltrlAssetSafetyDiscountSign = _ColltrlAstSafetyDiscountSign.CollateralSafetyDiscountSign  -- association [0..1]
LEFT OUTER JOIN I_ColltrlAssetLiquidationType AS _ColltrlAssetLiquidationType ON CollateralAssetLiquidationType = _ColltrlAssetLiquidationType.CollateralAssetLiquidationType  -- association [0..1]
LEFT OUTER JOIN I_CollateralReferenceSystem AS _ColltrlAssetReferenceSystem ON CollateralReferenceSystem = _ColltrlAssetReferenceSystem.CollateralReferenceSystem  -- association [0..1]
LEFT OUTER JOIN I_CollateralValuationType AS _CollateralAssetValuationType ON CollateralAssetValuationType = _CollateralAssetValuationType.CollateralValuationType  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlAssetLiquidationReason ON ColltrlAssetLiquidationReason = _ColltrlAssetLiquidationReason.CollateralAttributeIndType AND _ColltrlAssetLiquidationReason.CollateralAttributeIndCat = 'AST004'  -- association [0..1]
LEFT OUTER JOIN I_ColltrlAstValuationFrequency AS _ColltrlAstValuationFrequency ON ColltrlAssetValuationFrequency = _ColltrlAstValuationFrequency.ColltrlAssetValuationFrequency  -- association [0..1]
LEFT OUTER JOIN I_ColltrlAstVerificatFrequency AS _ColltrlAstVerificatFrequency ON ColltrlAstVerificatFrequency = _ColltrlAstVerificatFrequency.ColltrlAstVerificatFrequency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlAstSafetyDiscountCrcy ON ColltrlAssetSafetyDiscountCrcy = _ColltrlAstSafetyDiscountCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlAstLiquidationCurrency ON ColltrlAstLiquidationCurrency = _ColltrlAstLiquidationCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlAstExpdProceedCurrency ON ColltrlAstLqdtnExpdProceedCrcy = _ColltrlAstExpdProceedCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlAssetNominalCurrency ON CollateralAssetNominalCurrency = _ColltrlAssetNominalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CollateralAssetFinalCurrency ON CollateralAssetFinalCurrency = _CollateralAssetFinalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlAssetPurchaseCurrency ON ColltrlAssetPurchaseCurrency = _ColltrlAssetPurchaseCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlAssetOriginalCurrency ON ColltrlAssetOriginalCurrency = _ColltrlAssetOriginalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Country AS _ColltrlAstLqdtnBankCountry ON ColltrlAstLqdtnBankCountry = _ColltrlAstLqdtnBankCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CollateralAssetUnitOfMeasure ON CollateralAssetQuantityUoM = _CollateralAssetUnitOfMeasure.UnitOfMeasure  -- association [0..1]
;