I_ColltrlREEngyPerfCert

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_ColltrlREEngyPerfCert.
-- 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_ColltrlREEngyPerfCert AS
SELECT
  obj_epc_guid AS ColltrlREEngyPerfCertUUID,
  obj_guid AS CollateralRealEstateUUID,
  epc_reg_no AS ColREEngyPerfCertRegnNumber,
  epc_legal_type AS ColltrlREEngyPerfCertLegalType,
  epc_category AS ColltrlREEngyPerfCertCategory,
  valid_to AS ColREEngyPerfCertValidToDate,
  issue_desc AS ColltrlREEngyPerfCertIssDesc,
  issue_date AS ColltrlREEngyPerfCertIssueDate,
  data_provider AS ColltrlREEngyPerfCertDtaPrvdr,
  issue_preliminary AS ColltrlREEngyPerfCertIsPrelim,
  issue_reason AS ColltrlREEngyPerfCertIssReason,
  cast( issue_bp as cms_dte_bpid_vdm preserving type ) AS ColltrlREEngyPerfCertIssuerID,
  er_fin_aa AS ColltrlREFnlEngyRqmtValue,
  er_fin_el_aa AS ColREFnlEngyRqmtElctrctyValue,
  er_prim_aa AS ColltrlREPrimEngyRqmtValue,
  er_emission AS ColltrlREEngyRqmtEmissionValue,
  er_prim_is AS ColltrlREPrimEngyRqmtActlValue,
  er_prim_req AS ColltrlREPrimEngyRqmtRqdValue,
  er_ins_is AS ColREBldngInsulationActlValue,
  er_ins_req AS ColREBldngInsulationRqdValue,
  er_summer_hp AS ColltrlREIsSummerHeatProtected,
  er_calc_meth AS ColltrlREEngyRqmtCalcMethod,
  ec_fin_aa AS ColltrlREFnlEngyCnsmpnValue,
  ec_prim_aa AS ColltrlREPrimEngyCnsmpnValue,
  ec_desc AS ColltrlREEngyCnsmpnDescription,
  ec_emission AS ColREEngyCnsmpnEmissionValue,
  en_class_fin AS ColREEngyEfficiencyClFnlVal,
  en_class_prim AS ColREEngyEfficiencyClPrimVal,
  bld_type AS ColltrlREEngyPerfCertBldngType,
  bld_type_desc AS ColREEngyPerfCertBldngTypeDesc,
  bld_part AS ColREEngyPerfCertBldngPartDesc,
  bld_year AS ColltrlREEngyPerfCertBldngYear,
  bld_units AS ColREEngyPerfCertBldngUntValue,
  bld_area AS ColREEngyPerfCertBldngAreaQty,
  bld_area_uom AS ColREEngyPerfCertBldngAreaUoM,
  bld_area_der_frm_res AS ColltrlREIsUsableAreaDerived,
  heat_year AS ColREHeatingSystCnstrctnYear,
  heat_es_desc AS ColltrlREHeatingEngySrceDesc,
  heat_es_type_1 AS ColltrlREHeatingEngySrceType,
  heat_es_type_2 AS ColltrlREHeatingEngySrceType2,
  heat_es_type_3 AS ColltrlREHeatingEngySrceType3,
  water_es_desc AS ColltrlREHotWaterEngySrceDesc,
  water_es_type_1 AS ColltrlREHotWaterEngySrceType,
  water_es_type_2 AS ColltrlREHotWaterEngySrceType2,
  water_es_type_3 AS ColltrlREHotWaterEngySrceType3,
  renew_desc AS ColRERnwblEnergyDescription,
  renew_usage_desc AS ColRERnwblEngyUsageDescription,
  renew_type_1 AS ColltrlRERnwblEngySourceType,
  renew_usage_type_1 AS ColltrlRERnwblEnergyUsageType,
  renew_type_1_pa AS ColRERnwblEngyCoveragePercent,
  renew_type_1_pm AS ColRERnwblEngyFlfmtPercent,
  renew_type_2 AS ColltrlRERnwblEngySourceType2,
  renew_usage_type_2 AS ColltrlRERnwblEnergyUsageType2,
  renew_type_2_pa AS ColRERnwblEngyCoveragePercent2,
  renew_type_2_pm AS ColRERnwblEngyFlfmtPercent2,
  renew_type_3 AS ColltrlRERnwblEngySourceType3,
  renew_usage_type_3 AS ColltrlRERnwblEnergyUsageType3,
  renew_type_3_pa AS ColRERnwblEngyCoveragePercent3,
  renew_type_3_pm AS ColRERnwblEngyFlfmtPercent3,
  vnt_typ_desc AS ColltrlREVentnTypeDescription,
  vnt_type_1 AS ColltrlREVentilationType,
  vnt_type_2 AS ColltrlREVentilationType2,
  vnt_type_3 AS ColltrlREVentilationType3,
  cool_desc AS ColRECoolingTypeDescription,
  cool_type_1 AS ColltrlRECoolingType,
  cool_type_2 AS ColltrlRECoolingType2,
  cool_type_3 AS ColltrlRECoolingType3,
  cool_insp AS ColREIsCoolingWithInspection,
  cool_insp_date AS ColRECoolingInspectionDueDate,
  rec_insulation AS ColltrlREInsulationRecmdnType,
  rec_installation AS ColltrlREInstRecmdnType,
  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_obj_epc
LEFT OUTER JOIN I_CollateralRealEstate AS _CollateralRealEstate ON CollateralRealEstateUUID = _CollateralRealEstate.CollateralRealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREEngyPerfCertLglType AS _ColltrlREEngyPerfCertLglType ON ColltrlREEngyPerfCertLegalType = _ColltrlREEngyPerfCertLglType.ColltrlREEngyPerfCertLegalType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREEngyPerfCertCat AS _ColltrlREEngyPerfCertCat ON ColltrlREEngyPerfCertCategory = _ColltrlREEngyPerfCertCat.ColltrlREEngyPerfCertCategory  -- association [0..1]
LEFT OUTER JOIN I_ColREEngyPerfCertDtaPrvdr AS _ColREEngyPerfCertDtaPrvdr ON ColltrlREEngyPerfCertDtaPrvdr = _ColREEngyPerfCertDtaPrvdr.ColltrlREEngyPerfCertDtaPrvdr  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREEngyPerfCertIssRsn AS _ColltrlREEngyPerfCertIssRsn ON ColltrlREEngyPerfCertIssReason = _ColltrlREEngyPerfCertIssRsn.ColltrlREEngyPerfCertIssReason  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREEngyRqmtCalcMethod AS _ColltrlREEngyRqmtCalcMethod ON ColltrlREEngyRqmtCalcMethod = _ColltrlREEngyRqmtCalcMethod.ColltrlREEngyRqmtCalcMethod  -- association [0..1]
LEFT OUTER JOIN I_ColREEngyPerfCertBldngType AS _ColREEngyPerfCertBldngType ON ColltrlREEngyPerfCertBldngType = _ColREEngyPerfCertBldngType.ColltrlREEngyPerfCertBldngType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREHeatingEngySrceType AS _ColltrlREHeatingEngySrceType ON ColltrlREHeatingEngySrceType = _ColltrlREHeatingEngySrceType.ColltrlREHeatingEngySrceType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREHeatingEngySrceType AS _ColltrlREHeatingEngySrceType2 ON ColltrlREHeatingEngySrceType2 = _ColltrlREHeatingEngySrceType2.ColltrlREHeatingEngySrceType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREHeatingEngySrceType AS _ColltrlREHeatingEngySrceType3 ON ColltrlREHeatingEngySrceType3 = _ColltrlREHeatingEngySrceType3.ColltrlREHeatingEngySrceType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREHeatingEngySrceType AS _ColREHotWaterEngySrceType ON ColltrlREHotWaterEngySrceType = _ColREHotWaterEngySrceType.ColltrlREHeatingEngySrceType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREHeatingEngySrceType AS _ColREHotWaterEngySrceType2 ON ColltrlREHotWaterEngySrceType2 = _ColREHotWaterEngySrceType2.ColltrlREHeatingEngySrceType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREHeatingEngySrceType AS _ColREHotWaterEngySrceType3 ON ColltrlREHotWaterEngySrceType3 = _ColREHotWaterEngySrceType3.ColltrlREHeatingEngySrceType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlRERnwblEngySourceType AS _ColltrlRERnwblEngySourceType ON ColltrlRERnwblEngySourceType = _ColltrlRERnwblEngySourceType.ColltrlRERnwblEngySourceType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlRERnwblEngySourceType AS _ColltrlRERnwblEngySourceType2 ON ColltrlRERnwblEngySourceType2 = _ColltrlRERnwblEngySourceType2.ColltrlRERnwblEngySourceType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlRERnwblEngySourceType AS _ColltrlRERnwblEngySourceType3 ON ColltrlRERnwblEngySourceType3 = _ColltrlRERnwblEngySourceType3.ColltrlRERnwblEngySourceType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlRERnwblEngyUsageType AS _ColltrlRERnwblEngyUsageType ON ColltrlRERnwblEnergyUsageType = _ColltrlRERnwblEngyUsageType.ColltrlRERnwblEnergyUsageType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlRERnwblEngyUsageType AS _ColltrlRERnwblEngyUsageType2 ON ColltrlRERnwblEnergyUsageType2 = _ColltrlRERnwblEngyUsageType2.ColltrlRERnwblEnergyUsageType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlRERnwblEngyUsageType AS _ColltrlRERnwblEngyUsageType3 ON ColltrlRERnwblEnergyUsageType3 = _ColltrlRERnwblEngyUsageType3.ColltrlRERnwblEnergyUsageType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREVentilationType AS _ColltrlREVentilationType ON ColltrlREVentilationType = _ColltrlREVentilationType.ColltrlREVentilationType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREVentilationType AS _ColltrlREVentilationType2 ON ColltrlREVentilationType2 = _ColltrlREVentilationType2.ColltrlREVentilationType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREVentilationType AS _ColltrlREVentilationType3 ON ColltrlREVentilationType3 = _ColltrlREVentilationType3.ColltrlREVentilationType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlRECoolingType AS _ColltrlRECoolingType ON ColltrlRECoolingType = _ColltrlRECoolingType.ColltrlRECoolingType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlRECoolingType AS _ColltrlRECoolingType2 ON ColltrlRECoolingType2 = _ColltrlRECoolingType2.ColltrlRECoolingType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlRECoolingType AS _ColltrlRECoolingType3 ON ColltrlRECoolingType3 = _ColltrlRECoolingType3.ColltrlRECoolingType  -- association [0..1]
LEFT OUTER JOIN I_ColREEngyEfficiencyRecmdn AS _ColltrlREInsulationRecmdnType ON ColltrlREInsulationRecmdnType = _ColltrlREInsulationRecmdnType.ColltrlREEngyEfficiencyRecmdn  -- association [0..1]
LEFT OUTER JOIN I_ColREEngyEfficiencyRecmdn AS _ColltrlREInstRecmdnType ON ColltrlREInstRecmdnType = _ColltrlREInstRecmdnType.ColltrlREEngyEfficiencyRecmdn  -- association [0..1]
;