I_ObjectAssetData

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_ObjectAssetData.
-- 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_ObjectAssetData AS
SELECT
  ast_guid AS ObjectAssetUUID,
  ast_id AS ObjectAssetID,
  ast_typ AS ObjectAssetType,
  parent_guid AS ObjectAssetParentUUID,
  object_ref_id AS ObjectAssetReferenceNumber,
  risk_code AS ObjectAssetRiskCode,
  sfty_ind AS ObjectAssetSafetyDiscountSign,
  sfty_dscnt AS ObjectAssetSafetyDiscountPct,
  sfty_amount AS ObjectAssetSafetyDiscountAmt,
  sfty_amt_curr AS ObjectAssetSafetyDiscountCrcy,
  objsysid AS ObjectAssetReferenceSystem,
  valuation_typ AS ObjectAssetValuationType,
  unit_valn_freq AS ObjectAssetValuationFrequency,
  period_valn_freq AS ObjectAssetValuationPeriod,
  past_valued_date AS ObjectAssetLastRevaluationDate,
  start_date AS ObjectAssetRevaluationStartDte,
  end_date AS ObjectAssetRevaluationEndDate,
  lending_rate_ind AS ObjectAssetLendingRateSign,
  lending_rate1 AS ObjectAsset1stLendingRate,
  lending_rate2 AS ObjectAsset2ndLendingRate,
  lending_rate3 AS ObjectAsset3rdLendingRate,
  lending_rate4 AS ObjectAsset4thLendingRate,
  lending_rate5 AS ObjectAsset5thLendingRate,
  liqd_typ AS ObjectAssetLiquidationType,
  liqd_reason AS ObjectAssetLiquidationReason,
  liqd_date AS ObjectAssetLiquidationDate,
  liqd_amt AS ObjectAssetLiquidationAmount,
  liqd_curr AS ObjectAssetLiquidationCurrency,
  acc_number_liq AS ObjectAssetLqdtnAccountNumber,
  bank_cntry_liq AS ObjectAssetLqdtnBankCountry,
  bank_key_liq AS ObjectAssetLiquidationBankKey,
  bank_ctrlkey_liq AS ObjectAssetBankControlKey,
  unit_verf_freq AS ObjectAssetVerificationFrqcy,
  period_verf_freq AS ObjectAssetVerificationPeriod,
  last_verf_date AS ObjectAssetVerificationDate,
  nom_value AS ObjectAssetNominalAmount,
  nom_value_curr AS ObjectAssetNominalCurrency,
  ast_value AS ObjectAssetFinalAmount,
  ast_value_curr AS ObjectAssetFinalCurrency,
  quantity AS ObjectAssetQuantity,
  unit_of_measure AS ObjectAssetUnitOfMeasure,
  ori_value AS ObjectAssetOriginalAmount,
  ori_value_curr AS ObjectAssetOriginalCurrency
FROM cms_ast
LEFT OUTER JOIN I_ObjectAssetPartner AS _ObjectAssetPartner ON ObjectAssetUUID = _ObjectAssetPartner.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetDocument AS _ObjectAssetDocument ON ObjectAssetUUID = _ObjectAssetDocument.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_AssetAgreementLinkData AS _AssetAgreementLinkData ON ObjectAssetUUID = _AssetAgreementLinkData.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstateObjectData AS _RealEstateObjectData ON ObjectAssetReferenceNumber = _RealEstateObjectData.RealEstateInternalID  -- association [0..*]
LEFT OUTER JOIN I_CollateralRealEstate AS _CollateralRealEstate ON ObjectAssetReferenceNumber = _CollateralRealEstate.ColltrlRealEstateConvertedID  -- association [0..*]
LEFT OUTER JOIN I_RealEstateObjectPrt AS _RealEstateObjectPrt ON ObjectAssetReferenceNumber = _RealEstateObjectPrt.RealEstatePrtInternalID  -- association [0..*]
LEFT OUTER JOIN I_CollateralRealEstatePart AS _CollateralRealEstatePart ON ObjectAssetReferenceNumber = _CollateralRealEstatePart.ColltrlREPartConvertedID  -- association [0..*]
LEFT OUTER JOIN I_RealEstatePrtAccessory AS _RealEstatePrtAccessory ON ObjectAssetReferenceNumber = _RealEstatePrtAccessory.RealEstatePrtAccsryInternalID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartAccessory AS _ColltrlREPartAccessory ON ObjectAssetReferenceNumber = _ColltrlREPartAccessory.ColltrlREPrtAccsryConvertedID  -- association [0..*]
LEFT OUTER JOIN I_MovableObjectData AS _MovableObjectData ON ObjectAssetReferenceNumber = _MovableObjectData.MovableObjectInternalID  -- association [0..*]
LEFT OUTER JOIN I_ShipObjectData AS _ShipObjectData ON ObjectAssetUUID = _ShipObjectData.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_RightsObjectData AS _RightsObjectData ON ObjectAssetReferenceNumber = _RightsObjectData.RightsObjectInternalID  -- association [0..*]
LEFT OUTER JOIN I_InsuranceObjectData AS _InsuranceObjectData ON ObjectAssetReferenceNumber = _InsuranceObjectData.InsuranceObjectInternalID  -- association [0..*]
LEFT OUTER JOIN I_CollateralInsurance AS _CollateralInsurance ON ObjectAssetReferenceNumber = _CollateralInsurance.CollateralInsuranceConvertedID  -- association [0..*]
LEFT OUTER JOIN I_SecuritiesAccountObjectData AS _SecuritiesAccountObjectData ON ObjectAssetReferenceNumber = _SecuritiesAccountObjectData.SecuritiesAcctObjInternalID  -- association [0..*]
LEFT OUTER JOIN I_SecuritiesAccountPosition AS _SecuritiesAccountPosition ON ObjectAssetReferenceNumber = _SecuritiesAccountPosition.SecuritiesAcctPosInternalID  -- association [0..*]
LEFT OUTER JOIN I_CollateralObjectCalcData AS _CollateralObjectCalcData ON ObjectAssetUUID = _CollateralObjectCalcData.CollateralObjectUUID AND _CollateralObjectCalcData.CollateralObjectType = 'AST'  -- association [0..1]
LEFT OUTER JOIN I_AgreementAssetCalcData AS _AgreementAssetCalcData ON ObjectAssetUUID = _AgreementAssetCalcData.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetType AS _ObjectAssetType ON ObjectAssetType = _ObjectAssetType.ObjectAssetType  -- association [0..1]
LEFT OUTER JOIN I_CollateralSafetyDiscountSign AS _ObjectAssetSafetyDiscountSign ON ObjectAssetSafetyDiscountSign = _ObjectAssetSafetyDiscountSign.CollateralSafetyDiscountSign  -- association [0..1]
LEFT OUTER JOIN I_ObjectAssetLiquidationType AS _ObjectAssetLiquidationType ON ObjectAssetLiquidationType = _ObjectAssetLiquidationType.ObjectAssetLiquidationType  -- association [0..1]
LEFT OUTER JOIN I_ObjectReferenceSystem AS _ObjectAssetReferenceSystem ON ObjectAssetReferenceSystem = _ObjectAssetReferenceSystem.ObjectReferenceSystem  -- association [0..1]
LEFT OUTER JOIN I_CollateralValuationType AS _ObjectAssetValuationType ON ObjectAssetValuationType = _ObjectAssetValuationType.CollateralValuationType  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ObjectAssetLiquidationReason ON ObjectAssetLiquidationReason = _ObjectAssetLiquidationReason.CollateralAttributeIndType AND _ObjectAssetLiquidationReason.CollateralAttributeIndCat = 'AST004'  -- association [0..1]
LEFT OUTER JOIN I_ObjectAssetValuationFrqcy AS _ObjectAssetValuationFrequency ON ObjectAssetValuationFrequency = _ObjectAssetValuationFrequency.ObjectAssetValuationFrequency  -- association [0..1]
LEFT OUTER JOIN I_ObjectAssetVerificationFrqcy AS _ObjectAssetVerificationFrqcy ON ObjectAssetVerificationFrqcy = _ObjectAssetVerificationFrqcy.ObjectAssetVerificationFrqcy  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ObjectAssetSafetyDiscountCrcy ON ObjectAssetSafetyDiscountCrcy = _ObjectAssetSafetyDiscountCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ObjectAssetLiquidationCrcy ON ObjectAssetLiquidationCurrency = _ObjectAssetLiquidationCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ObjectAssetNominalCurrency ON ObjectAssetNominalCurrency = _ObjectAssetNominalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ObjectAssetFinalCurrency ON ObjectAssetFinalCurrency = _ObjectAssetFinalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ObjectAssetOriginalCurrency ON ObjectAssetOriginalCurrency = _ObjectAssetOriginalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Country AS _ObjectAssetLqdtnBankCountry ON ObjectAssetLqdtnBankCountry = _ObjectAssetLqdtnBankCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ObjectAssetUnitOfMeasure ON ObjectAssetUnitOfMeasure = _ObjectAssetUnitOfMeasure.UnitOfMeasure  -- association [0..1]
;