I_CollateralRealEstatePartCost

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_CollateralRealEstatePartCost.
-- 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_CollateralRealEstatePartCost AS
SELECT
  prt_cst_guid AS ColltrlRealEstatePartCostUUID,
  obj_prt_guid AS CollateralRealEstatePartUUID,
  part_id AS CollateralRealEstatePartID,
  cost_type AS CollateralRealEstateCostType,
  cost_desc AS ColltrlRECostDescription,
  cost_date AS CollateralRealEstateCostDate,
  cost_amt AS CollateralRealEstateCostAmount,
  cost_curr AS ColltrlRealEstateCostCurrency,
  cost_base_meas AS ColltrlRECostBaseMeasure,
  plan_cost_amt AS ColltrlREPlannedCostAmount,
  plan_cost_curr AS ColltrlREPlannedCostCurrency,
  ind_val_maintain AS ColltrlRECostValueEnhancing,
  cst_measure AS ColltrlRealEstateCostMeasure,
  flg_deduct_cost AS ColltrlRECostIsAllowable,
  deduct_cst_amt AS ColltrlREAllowableCostAmount,
  deduct_cst_curr AS ColltrlREAllowableCostCurrency,
  deduct_cst_pct AS ColltrlREAllowableCostPercent,
  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_cst
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_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_CollateralAttributeIndType AS _CollateralRealEstateCostType ON CollateralRealEstateCostType = _CollateralRealEstateCostType.CollateralAttributeIndType AND _CollateralRealEstateCostType.CollateralAttributeIndCat = 'REO012'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlRealEstateCostMeasure ON ColltrlRealEstateCostMeasure = _ColltrlRealEstateCostMeasure.CollateralAttributeIndType AND _ColltrlRealEstateCostMeasure.CollateralAttributeIndCat = 'REO017'  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBaseMeasure AS _ColltrlREBaseMeasure ON ColltrlRECostBaseMeasure = _ColltrlREBaseMeasure.ColltrlRealEstateBaseMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRealEstateCostCurrency ON ColltrlRealEstateCostCurrency = _ColltrlRealEstateCostCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREPlannedCostCurrency ON ColltrlREPlannedCostCurrency = _ColltrlREPlannedCostCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREAllowableCostCrcy ON ColltrlREAllowableCostCurrency = _ColltrlREAllowableCostCrcy.Currency  -- association [0..1]
;