I_ColltrlREPartAccessory

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_ColltrlREPartAccessory.
-- 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_ColltrlREPartAccessory AS
SELECT
  prt_acs_guid AS ColltrlREPartAccessoryUUID,
  cast( bintohex( prt_acs_guid ) as cms_dte_obj_refid ) AS ColltrlREPrtAccsryConvertedID,
  obj_prt_guid AS CollateralRealEstatePartUUID,
  part_id AS CollateralRealEstatePartID,
  acs_type AS ColltrlRealEstateAccessoryType,
  no_of_acs AS ColltrlRENumberOfAccessory,
  acs_value AS ColltrlREAccessoryAmount,
  acs_value_curr AS ColltrlREAccessoryCurrency,
  is_sub_ast_crea AS ColltrlREIsSubAssetCreated,
  acs_desc AS ColltrlREAccessoryDescription,
  acs_id AS ColltrlRealEstateAccessoryID,
  risk_code AS CollateralRealEstateRiskCode,
  sfty_ind AS ColltrlRESafetyDiscountSign,
  sfty_dscnt AS ColltrlRESafetyDiscountPercent,
  sfty_amount AS ColltrlRESafetyDiscountAmount,
  sfty_amt_curr AS ColltrlRESftyDiscountCurrency,
  valuation_typ AS ColltrlRealEstateValuationType,
  unit_valn_freq AS ColltrlREValuationFrequency,
  period_valn_freq AS ColltrlREValuationPeriod,
  past_valued_date AS ColltrlRELastRevaluationDate,
  start_date AS ColltrlRERevaluationStartDate,
  end_date AS ColltrlRERevaluationEndDate,
  lending_rate_ind AS ColltrlRealEstateLendingSign,
  lending_rate1 AS ColltrlRE1stLendingRate,
  lending_rate2 AS ColltrlRE2ndLendingRate,
  lending_rate3 AS ColltrlRE3rdLendingRate,
  lending_rate4 AS ColltrlRE4thLendingRate,
  lending_rate5 AS ColltrlRE5thLendingRate,
  created_by AS CollateralRealEstateEnteredBy,
  created_date AS ColltrlRealEstateEnteredDate,
  created_time AS ColltrlRealEstateEnteredTime,
  entry_src AS ColltrlRealEstateEnteredSource,
  last_chg_by AS ColltrlRealEstateLastChangedBy,
  last_chg_date AS ColltrlRELastChangedDate,
  last_chg_time AS ColltrlRELastChangedTime,
  processing_src AS ColltrlRELastChangedSource
FROM cms_re_prt_acs
LEFT OUTER JOIN I_CollateralRealEstatePart AS _CollateralRealEstatePart ON CollateralRealEstatePartUUID = _CollateralRealEstatePart.CollateralRealEstatePartUUID  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREPartMaster AS _ColltrlREPartMaster ON CollateralRealEstatePartUUID = _ColltrlREPartMaster.CollateralRealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREPartPartner AS _ColltrlREPartPartner ON CollateralRealEstatePartUUID = _ColltrlREPartPartner.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralRealEstatePartCost AS _CollateralRealEstatePartCost ON CollateralRealEstatePartUUID = _CollateralRealEstatePartCost.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartValue AS _ColltrlREPartValue ON CollateralRealEstatePartUUID = _ColltrlREPartValue.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlRELandRegister AS _ColltrlRELandRegister ON CollateralRealEstatePartUUID = _ColltrlRELandRegister.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetData AS _RealEstatePrtAccsryAssetData ON ColltrlREPrtAccsryConvertedID = _RealEstatePrtAccsryAssetData.ObjectAssetReferenceNumber  -- association [0..*]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREAccessoryType ON ColltrlRealEstateAccessoryType = _ColltrlREAccessoryType.CollateralAttributeIndType AND _ColltrlREAccessoryType.CollateralAttributeIndCat = 'REO010'  -- association [0..1]
LEFT OUTER JOIN I_CollateralObjectRiskCode AS _CollateralRealEstateRiskCode ON CollateralRealEstateRiskCode = _CollateralRealEstateRiskCode.CollateralObjectRiskCode  -- association [0..1]
LEFT OUTER JOIN I_CollateralSafetyDiscountSign AS _ColltrlRESafetyDiscountSign ON ColltrlRESafetyDiscountSign = _ColltrlRESafetyDiscountSign.CollateralSafetyDiscountSign  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREAccessoryCurrency ON ColltrlREAccessoryCurrency = _ColltrlREAccessoryCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRESftyDiscountCurrency ON ColltrlRESftyDiscountCurrency = _ColltrlRESftyDiscountCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CollateralValuationType AS _ColltrlREValuationType ON ColltrlRealEstateValuationType = _ColltrlREValuationType.CollateralValuationType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREValuationFrequency AS _ColltrlREValuationFrequency ON ColltrlREValuationFrequency = _ColltrlREValuationFrequency.ColltrlREValuationFrequency  -- association [0..1]
LEFT OUTER JOIN I_CollateralAssetData AS _ColltrlREPrtAccsryAssetData ON ColltrlREPrtAccsryConvertedID = _ColltrlREPrtAccsryAssetData.CollateralAssetReferenceNumber  -- association [0..*]
;