R_ColltrlREEngyPerfCertTP

DDL: R_COLLTRLREENGYPERFCERTTP Type: view_entity TRANSACTIONAL
80 Fields 1 Data Sources

Collateral Real Estate EPC - TP

R_ColltrlREEngyPerfCertTP is a Transactional CDS View that provides data about "Collateral Real Estate EPC - TP" in SAP S/4HANA. It reads from 1 data source (I_ColltrlREEngyPerfCert) and exposes 80 fields with key field ColltrlREEngyPerfCertUUID.

Data Sources (1)

SourceAliasJoin Type
I_ColltrlREEngyPerfCert I_ColltrlREEngyPerfCert from

Annotations (10)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name ColltrlREEnergyPerformanceCert view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Collateral Real Estate EPC - TP view

Fields (80)

KeyFieldSource TableSource FieldDescription
KEY ColltrlREEngyPerfCertUUID ColltrlREEngyPerfCertUUID EPC GUID
CollateralRealEstateUUID CollateralRealEstateUUID UUID
ColREEngyPerfCertRegnNumber ColREEngyPerfCertRegnNumber Registration Number
ColltrlREEngyPerfCertLegalType ColltrlREEngyPerfCertLegalType Legal Basis
ColltrlREEngyPerfCertCategory ColltrlREEngyPerfCertCategory Category
ColREEngyPerfCertValidToDate ColREEngyPerfCertValidToDate Validity End Time
ColltrlREEngyPerfCertIssDesc ColltrlREEngyPerfCertIssDesc Issue Description
ColltrlREEngyPerfCertIssueDate ColltrlREEngyPerfCertIssueDate Issue Date
ColltrlREEngyPerfCertDtaPrvdr ColltrlREEngyPerfCertDtaPrvdr Data Provider
ColltrlREEngyPerfCertIsPrelim ColltrlREEngyPerfCertIsPrelim Preliminary EPC
ColltrlREEngyPerfCertIssReason ColltrlREEngyPerfCertIssReason Issue Reason
ColltrlREEngyPerfCertIssuerID ColltrlREEngyPerfCertIssuerID
ColltrlREFnlEngyRqmtValue ColltrlREFnlEngyRqmtValue Fin. En. Requirement
ColREFnlEngyRqmtElctrctyValue ColREFnlEngyRqmtElctrctyValue Fin. En. Req. Elcty
ColltrlREPrimEngyRqmtValue ColltrlREPrimEngyRqmtValue Pr. En. Requirement
ColltrlREEngyRqmtEmissionValue ColltrlREEngyRqmtEmissionValue CO2 Emissions
ColltrlREPrimEngyRqmtActlValue ColltrlREPrimEngyRqmtActlValue Pr. En. Reqmt (Is)
ColltrlREPrimEngyRqmtRqdValue ColltrlREPrimEngyRqmtRqdValue Pr. En. Reqmt (Req)
ColREBldngInsulationActlValue ColREBldngInsulationActlValue Bldg Insulation (Is)
ColREBldngInsulationRqdValue ColREBldngInsulationRqdValue Bldg Insulatn (Req)
ColltrlREIsSummerHeatProtected ColltrlREIsSummerHeatProtected Summer Heat Protect
ColltrlREEngyRqmtCalcMethod ColltrlREEngyRqmtCalcMethod ER Calculatn Method
ColltrlREFnlEngyCnsmpnValue ColltrlREFnlEngyCnsmpnValue Fin. En. Consumption
ColltrlREPrimEngyCnsmpnValue ColltrlREPrimEngyCnsmpnValue Pr. En. Consumption
ColltrlREEngyCnsmpnDescription ColltrlREEngyCnsmpnDescription EC Description
ColREEngyCnsmpnEmissionValue ColREEngyCnsmpnEmissionValue CO2 Emissions
ColREEngyEfficiencyClFnlVal ColREEngyEfficiencyClFnlVal Final En. Eff. Class
ColREEngyEfficiencyClPrimVal ColREEngyEfficiencyClPrimVal Primary En.Eff.Class
ColltrlREEngyPerfCertBldngType ColltrlREEngyPerfCertBldngType Building Type
ColREEngyPerfCertBldngTypeDesc ColREEngyPerfCertBldngTypeDesc Building Type Desc
ColREEngyPerfCertBldngPartDesc ColREEngyPerfCertBldngPartDesc Building Part
ColltrlREEngyPerfCertBldngYear ColltrlREEngyPerfCertBldngYear Building Year
ColREEngyPerfCertBldngUntValue ColREEngyPerfCertBldngUntValue Building Units
ColREEngyPerfCertBldngAreaQty ColREEngyPerfCertBldngAreaQty Usable Area of Bldg
ColREEngyPerfCertBldngAreaUoM ColREEngyPerfCertBldngAreaUoM Area UOM
ColltrlREIsUsableAreaDerived ColltrlREIsUsableAreaDerived Usable Area Derived
ColREHeatingSystCnstrctnYear ColREHeatingSystCnstrctnYear Heating System Year
ColltrlREHeatingEngySrceDesc ColltrlREHeatingEngySrceDesc Energy Source
ColltrlREHeatingEngySrceType ColltrlREHeatingEngySrceType Energy Source 1
ColltrlREHeatingEngySrceType2 ColltrlREHeatingEngySrceType2 Energy Source 2
ColltrlREHeatingEngySrceType3 ColltrlREHeatingEngySrceType3 Energy Source 3
ColltrlREHotWaterEngySrceDesc ColltrlREHotWaterEngySrceDesc Energy Source
ColltrlREHotWaterEngySrceType ColltrlREHotWaterEngySrceType Energy Source 1
ColltrlREHotWaterEngySrceType2 ColltrlREHotWaterEngySrceType2 Energy Source 2
ColltrlREHotWaterEngySrceType3 ColltrlREHotWaterEngySrceType3 Energy Source 3
ColRERnwblEnergyDescription ColRERnwblEnergyDescription Renewable Energy
ColRERnwblEngyUsageDescription ColRERnwblEngyUsageDescription Renew. Energy Usage
ColltrlRERnwblEngySourceType ColltrlRERnwblEngySourceType Renew.En.Src.Type 1
ColltrlRERnwblEnergyUsageType ColltrlRERnwblEnergyUsageType Usage Type 1
ColRERnwblEngyCoveragePercent ColRERnwblEngyCoveragePercent Coverage (%)
ColRERnwblEngyFlfmtPercent ColRERnwblEngyFlfmtPercent Mnd.req.fulfil.(%)
ColltrlRERnwblEngySourceType2 ColltrlRERnwblEngySourceType2 Renew.En.Src.Type 2
ColltrlRERnwblEnergyUsageType2 ColltrlRERnwblEnergyUsageType2 Usage Type 2
ColRERnwblEngyCoveragePercent2 ColRERnwblEngyCoveragePercent2 Coverage (%)
ColRERnwblEngyFlfmtPercent2 ColRERnwblEngyFlfmtPercent2 Mnd.req.fulfil.(%)
ColltrlRERnwblEngySourceType3 ColltrlRERnwblEngySourceType3 Renew.En.Src.Type 3
ColltrlRERnwblEnergyUsageType3 ColltrlRERnwblEnergyUsageType3 Usage Type 3
ColRERnwblEngyCoveragePercent3 ColRERnwblEngyCoveragePercent3 Coverage (%)
ColRERnwblEngyFlfmtPercent3 ColRERnwblEngyFlfmtPercent3 Mnd.req.fulfil.(%)
ColltrlREVentnTypeDescription ColltrlREVentnTypeDescription VentilationType Desc
ColltrlREVentilationType ColltrlREVentilationType Ventilation Type 1
ColltrlREVentilationType2 ColltrlREVentilationType2 Ventilation Type 2
ColltrlREVentilationType3 ColltrlREVentilationType3 Ventilation Type 3
ColRECoolingTypeDescription ColRECoolingTypeDescription Cooling Type Desc
ColltrlRECoolingType ColltrlRECoolingType Cooling Type 1
ColltrlRECoolingType2 ColltrlRECoolingType2 Cooling Type 2
ColltrlRECoolingType3 ColltrlRECoolingType3 Cooling Type 3
ColREIsCoolingWithInspection ColREIsCoolingWithInspection With Inspection
ColRECoolingInspectionDueDate ColRECoolingInspectionDueDate Nxt.insp.due date
ColltrlREInsulationRecmdnType ColltrlREInsulationRecmdnType Building Envelope
ColltrlREInstRecmdnType ColltrlREInstRecmdnType MEP
CollateralRealEstateEnteredBy CollateralRealEstateEnteredBy Version Created By
ColltrlRealEstateEnteredDate ColltrlRealEstateEnteredDate Time Stamp
ColltrlRealEstateEnteredTime ColltrlRealEstateEnteredTime Time Stamp
ColltrlRealEstateEnteredSource ColltrlRealEstateEnteredSource Source Of Entry
ColltrlRealEstateLastChangedBy ColltrlRealEstateLastChangedBy Last Changed by
ColltrlRELastChangedDate ColltrlRELastChangedDate Last Changed on
ColltrlRELastChangedTime ColltrlRELastChangedTime Last Changed at
ColltrlRELastChangedSource ColltrlRELastChangedSource Processing Src
_CollateralRealEstate _CollateralRealEstate

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 R_ColltrlREEngyPerfCertTP.
-- 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 R_ColltrlREEngyPerfCertTP AS
SELECT
  ColltrlREEngyPerfCertUUID,
  CollateralRealEstateUUID,
  ColREEngyPerfCertRegnNumber,
  ColltrlREEngyPerfCertLegalType,
  ColltrlREEngyPerfCertCategory,
  ColREEngyPerfCertValidToDate,
  ColltrlREEngyPerfCertIssDesc,
  ColltrlREEngyPerfCertIssueDate,
  ColltrlREEngyPerfCertDtaPrvdr,
  ColltrlREEngyPerfCertIsPrelim,
  ColltrlREEngyPerfCertIssReason,
  ColltrlREEngyPerfCertIssuerID,
  ColltrlREFnlEngyRqmtValue,
  ColREFnlEngyRqmtElctrctyValue,
  ColltrlREPrimEngyRqmtValue,
  ColltrlREEngyRqmtEmissionValue,
  ColltrlREPrimEngyRqmtActlValue,
  ColltrlREPrimEngyRqmtRqdValue,
  ColREBldngInsulationActlValue,
  ColREBldngInsulationRqdValue,
  ColltrlREIsSummerHeatProtected,
  ColltrlREEngyRqmtCalcMethod,
  ColltrlREFnlEngyCnsmpnValue,
  ColltrlREPrimEngyCnsmpnValue,
  ColltrlREEngyCnsmpnDescription,
  ColREEngyCnsmpnEmissionValue,
  ColREEngyEfficiencyClFnlVal,
  ColREEngyEfficiencyClPrimVal,
  ColltrlREEngyPerfCertBldngType,
  ColREEngyPerfCertBldngTypeDesc,
  ColREEngyPerfCertBldngPartDesc,
  ColltrlREEngyPerfCertBldngYear,
  ColREEngyPerfCertBldngUntValue,
  ColREEngyPerfCertBldngAreaQty,
  ColREEngyPerfCertBldngAreaUoM,
  ColltrlREIsUsableAreaDerived,
  ColREHeatingSystCnstrctnYear,
  ColltrlREHeatingEngySrceDesc,
  ColltrlREHeatingEngySrceType,
  ColltrlREHeatingEngySrceType2,
  ColltrlREHeatingEngySrceType3,
  ColltrlREHotWaterEngySrceDesc,
  ColltrlREHotWaterEngySrceType,
  ColltrlREHotWaterEngySrceType2,
  ColltrlREHotWaterEngySrceType3,
  ColRERnwblEnergyDescription,
  ColRERnwblEngyUsageDescription,
  ColltrlRERnwblEngySourceType,
  ColltrlRERnwblEnergyUsageType,
  ColRERnwblEngyCoveragePercent,
  ColRERnwblEngyFlfmtPercent,
  ColltrlRERnwblEngySourceType2,
  ColltrlRERnwblEnergyUsageType2,
  ColRERnwblEngyCoveragePercent2,
  ColRERnwblEngyFlfmtPercent2,
  ColltrlRERnwblEngySourceType3,
  ColltrlRERnwblEnergyUsageType3,
  ColRERnwblEngyCoveragePercent3,
  ColRERnwblEngyFlfmtPercent3,
  ColltrlREVentnTypeDescription,
  ColltrlREVentilationType,
  ColltrlREVentilationType2,
  ColltrlREVentilationType3,
  ColRECoolingTypeDescription,
  ColltrlRECoolingType,
  ColltrlRECoolingType2,
  ColltrlRECoolingType3,
  ColREIsCoolingWithInspection,
  ColRECoolingInspectionDueDate,
  ColltrlREInsulationRecmdnType,
  ColltrlREInstRecmdnType,
  CollateralRealEstateEnteredBy,
  ColltrlRealEstateEnteredDate,
  ColltrlRealEstateEnteredTime,
  ColltrlRealEstateEnteredSource,
  ColltrlRealEstateLastChangedBy,
  ColltrlRELastChangedDate,
  ColltrlRELastChangedTime,
  ColltrlRELastChangedSource
FROM I_ColltrlREEngyPerfCert
;

Learn More