I_ColltrlREPartValue

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_ColltrlREPartValue.
-- 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_ColltrlREPartValue AS
SELECT
  prt_val_guid AS ColltrlRealEstatePartValueUUID,
  obj_prt_guid AS CollateralRealEstatePartUUID,
  part_id AS CollateralRealEstatePartID,
  val_type AS CollateralRealEstateValueType,
  calc_amount AS ColltrlREValueCalculatedAmount,
  calc_amt_curr AS ColltrlREValCalculatedCurrency,
  entered_amount AS ColltrlREValueEnteredAmount,
  ent_amt_curr AS ColltrlREValueEnteredCurrency,
  val_valid_from AS ColltrlREValueValidFromDate,
  val_valid_to AS ColltrlREValueValidToDate,
  val_date AS ColltrlRealEstateValuationDate,
  val_origin AS ColltrlRealEstateValueOrigin,
  created_by AS CollateralRealEstateEnteredBy,
  created_date AS ColltrlRealEstateEnteredDate,
  created_time AS ColltrlRealEstateEnteredTime,
  last_chg_by AS ColltrlRealEstateLastChangedBy,
  last_chg_date AS ColltrlRELastChangedDate,
  last_chg_time AS ColltrlRELastChangedTime,
  entry_src AS ColltrlRealEstateEnteredSource,
  processing_src AS ColltrlRELastChangedSource
FROM cms_re_prt_val
LEFT OUTER JOIN I_CollateralRealEstatePart AS _CollateralRealEstatePart ON CollateralRealEstatePartUUID = _CollateralRealEstatePart.CollateralRealEstatePartUUID  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREPartMaster AS _ColltrlREPartMaster ON CollateralRealEstatePartUUID = _ColltrlREPartMaster.CollateralRealEstatePartUUID  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREPartAccessory AS _ColltrlREPartAccessory ON CollateralRealEstatePartUUID = _ColltrlREPartAccessory.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartAccessoryMaster AS _ColltrlREPartAccessoryMaster ON CollateralRealEstatePartUUID = _ColltrlREPartAccessoryMaster.CollateralRealEstatePartUUID  -- association [0..*]
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_ColltrlRELandRegister AS _ColltrlRELandRegister ON CollateralRealEstatePartUUID = _ColltrlRELandRegister.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREValuationResult AS _ColltrlREValuationResult ON CollateralRealEstateValueType = _ColltrlREValuationResult.ColltrlREValuationResult  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREValCalculatedCrcy ON ColltrlREValCalculatedCurrency = _ColltrlREValCalculatedCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREValueEnteredCurrency ON ColltrlREValueEnteredCurrency = _ColltrlREValueEnteredCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlRealEstateValueOrigin ON _ColltrlRealEstateValueOrigin.CollateralAttributeIndCat = 'REO016' AND ColltrlRealEstateValueOrigin = _ColltrlRealEstateValueOrigin.CollateralAttributeIndType  -- association [0..1]
;