I_RealEstatePrtAccessory

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_RealEstatePrtAccessory.
-- 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_RealEstatePrtAccessory AS
SELECT
  prt_acs_guid AS RealEstatePrtAccessoryUUID,
  prt_acs_guid_conv AS RealEstatePrtAccsryInternalID,
  obj_prt_guid AS RealEstatePrtUUID,
  part_id AS RealEstatePrtID,
  acs_type AS RealEstatePrtAccessoryType,
  no_of_acs AS RealEstatePrtNumberOfAccessory,
  acs_value AS RealEstatePrtAccessoryAmount,
  acs_value_curr AS RealEstatePrtAccessoryCurrency,
  is_sub_ast_crea AS RealEstatePrtAccsryIsBuilding,
  acs_desc AS RealEstatePrtAccsryDescription,
  acs_id AS RealEstatePrtAccessoryID,
  risk_code AS RealEstatePrtAccsryRiskCode,
  sfty_ind AS RealEsttePrtAccsrySftyDiscSign,
  sfty_dscnt AS RealEstatePrtAccsrySftyDiscPct,
  sfty_amount AS RealEstatePrtAccsrySftyDiscAmt,
  sfty_amt_curr AS RealEsttePrtAccsrySftyDiscCrcy,
  valuation_typ AS RealEstatePrtAccsryValnType,
  unit_valn_freq AS RealEstatePrtAccsryValnFrqcy,
  period_valn_freq AS RealEstatePrtAccsryValnPeriod,
  past_valued_date AS RealEsttePrtAccsryLastRevalDte,
  start_date AS RealEsttePrtAccsryRevalStrtDte,
  end_date AS RealEsttePrtAccsryRevalEndDte,
  lending_rate_ind AS RealEstatePrtAccsryLendgSign,
  lending_rate1 AS RealEsttePrtAccsry1stLendgRate,
  lending_rate2 AS RealEsttePrtAccsry2ndLendgRate,
  lending_rate3 AS RealEsttePrtAccsry3rdLendgRate,
  lending_rate4 AS RealEsttePrtAccsry4thLendgRate,
  lending_rate5 AS RealEsttePrtAccsry5thLendgRate
FROM P_RealEstatePrtAccsry_TF
LEFT OUTER JOIN I_RealEstateObjectPrt AS _RealEstateObjectPrt ON RealEstatePrtUUID = _RealEstateObjectPrt.RealEstatePrtUUID  -- association [0..1]
LEFT OUTER JOIN I_RealEstateObjPrtMstrData AS _RealEstateObjPrtMstrData ON RealEstatePrtUUID = _RealEstateObjPrtMstrData.RealEstatePrtUUID  -- association [0..1]
LEFT OUTER JOIN I_RealEstatePrtPartner AS _RealEstatePrtPartner ON RealEstatePrtUUID = _RealEstatePrtPartner.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstatePrtCost AS _RealEstatePrtCost ON RealEstatePrtUUID = _RealEstatePrtCost.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstatePrtValue AS _RealEstatePrtValue ON RealEstatePrtUUID = _RealEstatePrtValue.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstatePrtLandRegister AS _RealEstatePrtLandRegister ON RealEstatePrtUUID = _RealEstatePrtLandRegister.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetData AS _RealEstatePrtAccsryAssetData ON RealEstatePrtAccsryInternalID = _RealEstatePrtAccsryAssetData.ObjectAssetReferenceNumber  -- association [0..*]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _RealEstatePrtAccessoryType ON RealEstatePrtAccessoryType = _RealEstatePrtAccessoryType.CollateralAttributeIndType AND _RealEstatePrtAccessoryType.CollateralAttributeIndCat = 'REO010'  -- association [0..1]
LEFT OUTER JOIN I_CollateralObjectRiskCode AS _RealEstatePrtAccsryRiskCode ON RealEstatePrtAccsryRiskCode = _RealEstatePrtAccsryRiskCode.CollateralObjectRiskCode  -- association [0..1]
LEFT OUTER JOIN I_CollateralSafetyDiscountSign AS _REPrtAccsrySftyDiscSign ON RealEsttePrtAccsrySftyDiscSign = _REPrtAccsrySftyDiscSign.CollateralSafetyDiscountSign  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _RealEstatePrtAccessoryCrcy ON RealEstatePrtAccessoryCurrency = _RealEstatePrtAccessoryCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _REPrtAccsrySftyDiscCrcy ON RealEsttePrtAccsrySftyDiscCrcy = _REPrtAccsrySftyDiscCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_CollateralValuationType AS _RealEstatePrtAccsryValnType ON RealEstatePrtAccsryValnType = _RealEstatePrtAccsryValnType.CollateralValuationType  -- association [0..1]
LEFT OUTER JOIN I_RealEstateValuationFrqcy AS _RealEstatePrtAccsryValnFrqcy ON RealEstatePrtAccsryValnFrqcy = _RealEstatePrtAccsryValnFrqcy.RealEstateValuationFrqcy  -- association [0..1]
;