CMS_RE_OBJ_EPC
Real Estate Energy Performance Certificate details
CMS_RE_OBJ_EPC is an SAP database table in S/4HANA. Real Estate Energy Performance Certificate details. It contains 80 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ColltrlREEngyPerfCert | view_entity | from | BASIC | Colltrl RE Energy Perf Cert Details |
Fields (80)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | obj_epc_guid | CMS_RE_DTE_ESG_EPC_GUID | EPC GUID | |||
| obj_guid | CMS_RE_DTE_OBJ_GUID | Object GUID | ||||
| epc_reg_no | CMS_RE_DTE_ESG_EPC_REG_NO | Registration Number | ||||
| epc_legal_type | CMS_RE_DTE_ESG_EPC_LEGAL_TYPE | Legal Basis | ||||
| epc_category | CMS_RE_DTE_ESG_EPC_CATEGORY | Category | ||||
| valid_to | CMS_DTE_VALID_TO | Valid to | ||||
| issue_desc | CMS_RE_DTE_ESG_ISSUE_DESC | Issue Description | ||||
| issue_date | CMS_RE_DTE_ESG_ISSUE_DATE | Issue Date | ||||
| data_provider | CMS_RE_DTE_ESG_DATA_PROVIDER | Data Provider | ||||
| issue_preliminary | CMS_RE_DTE_ESG_ISSUE_PRELIM | Preliminary EPC | ||||
| issue_reason | CMS_RE_DTE_ESG_ISSUE_REASON | Issue Reason | ||||
| issue_bp | CMS_RE_DTE_ESG_ISSUE_BP | EPC Issuer | ||||
| er_fin_aa | CMS_RE_DTE_ESG_ER_FIN_AA | Fin. En. Requirement | ||||
| er_fin_el_aa | CMS_RE_DTE_ESG_ER_FIN_EL_AA | Fin. En. Req. Elcty | ||||
| er_prim_aa | CMS_RE_DTE_ESG_ER_PRIM_AA | Pr. En. Requirement | ||||
| er_emission | CMS_RE_DTE_ESG_ER_EMISSION | CO2 Emissions | ||||
| er_prim_is | CMS_RE_DTE_ESG_ER_PRIM_IS | Pr. En. Reqmt (Is) | ||||
| er_prim_req | CMS_RE_DTE_ESG_ER_PRIM_REQ | Pr. En. Reqmt (Req) | ||||
| er_ins_is | CMS_RE_DTE_ESG_ER_INS_IS | Bldg Insulation (Is) | ||||
| er_ins_req | CMS_RE_DTE_ESG_ER_INS_REQ | Bldg Insulatn (Req) | ||||
| er_summer_hp | CMS_RE_DTE_ESG_ER_SUMMER_HP | Summer Heat Protect | ||||
| er_calc_meth | CMS_RE_DTE_ESG_ER_CALC_METH | ER Calculatn Method | ||||
| ec_fin_aa | CMS_RE_DTE_ESG_EC_FIN_AA | Fin. En. Consumption | ||||
| ec_prim_aa | CMS_RE_DTE_ESG_EC_PRIM_AA | Pr. En. Consumption | ||||
| ec_desc | CMS_RE_DTE_ESG_EC_DESC | EC Description | ||||
| ec_emission | CMS_RE_DTE_ESG_EC_EMISSION | CO2 Emissions | ||||
| en_class_fin | CMS_RE_DTE_ESG_EN_CLASS_FIN | Final En. Eff. Class | ||||
| en_class_prim | CMS_RE_DTE_ESG_EN_CLASS_PRIM | Primary En.Eff.Class | ||||
| bld_type | CMS_RE_DTE_ESG_BLD_TYPE | Building Type | ||||
| bld_type_desc | CMS_RE_DTE_ESG_BLD_TYP_DESC | Building Type Desc | ||||
| bld_part | CMS_RE_DTE_ESG_BLD_PART | Building Part | ||||
| bld_year | CMS_RE_DTE_ESG_BLD_YEAR | Building Year | ||||
| bld_units | CMS_RE_DTE_ESG_BLD_UNITS | Building Units | ||||
| bld_area | CMS_RE_DTE_ESG_BLD_USABLE_AREA | Usable Area of Bldg | ||||
| bld_area_uom | CMS_RE_DTE_USBL_AREA_UOM | Area UOM | ||||
| bld_area_der_frm_res | CMS_RE_DTE_ESG_BLD_AREA_DERIVE | Usable Area Derived | ||||
| heat_year | CMS_RE_DTE_ESG_HEAT_YEAR | Heating System Year | ||||
| heat_es_desc | CMS_RE_DTE_ESG_HEAT_ES_DESC | Energy Source | ||||
| heat_es_type_1 | CMS_RE_DTE_ESG_HEAT_ES_TYPE_1 | Energy Source 1 | ||||
| heat_es_type_2 | CMS_RE_DTE_ESG_HEAT_ES_TYPE_2 | Energy Source 2 | ||||
| heat_es_type_3 | CMS_RE_DTE_ESG_HEAT_ES_TYPE_3 | Energy Source 3 | ||||
| water_es_desc | CMS_RE_DTE_ESG_WATER_ES_DESC | Energy Source | ||||
| water_es_type_1 | CMS_RE_DTE_ESG_WATER_ES_TYPE_1 | Energy Source 1 | ||||
| water_es_type_2 | CMS_RE_DTE_ESG_WATER_ES_TYPE_2 | Energy Source 2 | ||||
| water_es_type_3 | CMS_RE_DTE_ESG_WATER_ES_TYPE_3 | Energy Source 3 | ||||
| renew_desc | CMS_RE_DTE_ESG_RENEW_DESC | Renewable Energy | ||||
| renew_usage_desc | CMS_RE_DTE_ESG_RENEW_USG_DESC | Renew. Energy Usage | ||||
| renew_type_1 | CMS_RE_DTE_ESG_RENEW_TYPE_1 | Renew.En.Src.Type 1 | ||||
| renew_usage_type_1 | CMS_RE_DTE_ESG_RENEW_USG_TYP_1 | Usage Type 1 | ||||
| renew_type_1_pa | CMS_RE_DTE_ESG_PA | Coverage (%) | ||||
| renew_type_1_pm | CMS_RE_DTE_ESG_PM | Mnd.req.fulfil.(%) | ||||
| renew_type_2 | CMS_RE_DTE_ESG_RENEW_TYPE_2 | Renew.En.Src.Type 2 | ||||
| renew_usage_type_2 | CMS_RE_DTE_ESG_RENEW_USG_TYP_2 | Usage Type 2 | ||||
| renew_type_2_pa | CMS_RE_DTE_ESG_PA | Coverage (%) | ||||
| renew_type_2_pm | CMS_RE_DTE_ESG_PM | Mnd.req.fulfil.(%) | ||||
| renew_type_3 | CMS_RE_DTE_ESG_RENEW_TYPE_3 | Renew.En.Src.Type 3 | ||||
| renew_usage_type_3 | CMS_RE_DTE_ESG_RENEW_USG_TYP_3 | Usage Type 3 | ||||
| renew_type_3_pa | CMS_RE_DTE_ESG_PA | Coverage (%) | ||||
| renew_type_3_pm | CMS_RE_DTE_ESG_PM | Mnd.req.fulfil.(%) | ||||
| vnt_typ_desc | CMS_RE_DTE_ESG_VNT_TYPE_DESC | VentilationType Desc | ||||
| vnt_type_1 | CMS_RE_DTE_ESG_VNT_TYPE_1 | Ventilation Type 1 | ||||
| vnt_type_2 | CMS_RE_DTE_ESG_VNT_TYPE_2 | Ventilation Type 2 | ||||
| vnt_type_3 | CMS_RE_DTE_ESG_VNT_TYPE_3 | Ventilation Type 3 | ||||
| cool_desc | CMS_RE_DTE_ESG_COOL_DESC | Cooling Type Desc | ||||
| cool_type_1 | CMS_RE_DTE_ESG_COOL_TYPE_1 | Cooling Type 1 | ||||
| cool_type_2 | CMS_RE_DTE_ESG_COOL_TYPE_2 | Cooling Type 2 | ||||
| cool_type_3 | CMS_RE_DTE_ESG_COOL_TYPE_3 | Cooling Type 3 | ||||
| cool_insp | CMS_RE_DTE_ESG_COOL_INSP | With Inspection | ||||
| cool_insp_date | CMS_RE_DTE_ESG_COOL_INSP_DATE | Nxt.insp.due date | ||||
| rec_insulation | CMS_RE_DTE_ESG_REC_INSULATION | Building Envelope | ||||
| rec_installation | CMS_RE_DTE_ESG_REC_INSTALLATN | MEP | ||||
| created_by | CMS_RE_DTE_CR_BY | Created By | ||||
| created_date | CMS_RE_DTE_CR_ON | Created On | ||||
| created_time | CMS_RE_DTE_CR_AT | Created At | ||||
| entry_src | CMS_RE_DTE_SRC_INIT | Source Of Entry | ||||
| last_chg_by | CMS_RE_DTE_CHG_BY | Last Changed by | ||||
| last_chg_date | CMS_RE_DTE_CHG_ON | Last Changed On | ||||
| last_chg_time | CMS_RE_DTE_CHG_AT | Last Changed At | ||||
| processing_src | CMS_RE_DTE_PRC_SRC | Processing Src |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Real Estate Energy Performance Certificate details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_RE_OBJ_EPC (
MANDT, -- Client [MANDT]
OBJ_EPC_GUID, -- EPC GUID [CMS_RE_DTE_ESG_EPC_GUID]
OBJ_GUID, -- Object GUID [CMS_RE_DTE_OBJ_GUID]
EPC_REG_NO, -- Registration Number [CMS_RE_DTE_ESG_EPC_REG_NO]
EPC_LEGAL_TYPE, -- Legal Basis [CMS_RE_DTE_ESG_EPC_LEGAL_TYPE]
EPC_CATEGORY, -- Category [CMS_RE_DTE_ESG_EPC_CATEGORY]
VALID_TO, -- Valid to [CMS_DTE_VALID_TO]
ISSUE_DESC, -- Issue Description [CMS_RE_DTE_ESG_ISSUE_DESC]
ISSUE_DATE, -- Issue Date [CMS_RE_DTE_ESG_ISSUE_DATE]
DATA_PROVIDER, -- Data Provider [CMS_RE_DTE_ESG_DATA_PROVIDER]
ISSUE_PRELIMINARY, -- Preliminary EPC [CMS_RE_DTE_ESG_ISSUE_PRELIM]
ISSUE_REASON, -- Issue Reason [CMS_RE_DTE_ESG_ISSUE_REASON]
ISSUE_BP, -- EPC Issuer [CMS_RE_DTE_ESG_ISSUE_BP]
ER_FIN_AA, -- Fin. En. Requirement [CMS_RE_DTE_ESG_ER_FIN_AA]
ER_FIN_EL_AA, -- Fin. En. Req. Elcty [CMS_RE_DTE_ESG_ER_FIN_EL_AA]
ER_PRIM_AA, -- Pr. En. Requirement [CMS_RE_DTE_ESG_ER_PRIM_AA]
ER_EMISSION, -- CO2 Emissions [CMS_RE_DTE_ESG_ER_EMISSION]
ER_PRIM_IS, -- Pr. En. Reqmt (Is) [CMS_RE_DTE_ESG_ER_PRIM_IS]
ER_PRIM_REQ, -- Pr. En. Reqmt (Req) [CMS_RE_DTE_ESG_ER_PRIM_REQ]
ER_INS_IS, -- Bldg Insulation (Is) [CMS_RE_DTE_ESG_ER_INS_IS]
ER_INS_REQ, -- Bldg Insulatn (Req) [CMS_RE_DTE_ESG_ER_INS_REQ]
ER_SUMMER_HP, -- Summer Heat Protect [CMS_RE_DTE_ESG_ER_SUMMER_HP]
ER_CALC_METH, -- ER Calculatn Method [CMS_RE_DTE_ESG_ER_CALC_METH]
EC_FIN_AA, -- Fin. En. Consumption [CMS_RE_DTE_ESG_EC_FIN_AA]
EC_PRIM_AA, -- Pr. En. Consumption [CMS_RE_DTE_ESG_EC_PRIM_AA]
EC_DESC, -- EC Description [CMS_RE_DTE_ESG_EC_DESC]
EC_EMISSION, -- CO2 Emissions [CMS_RE_DTE_ESG_EC_EMISSION]
EN_CLASS_FIN, -- Final En. Eff. Class [CMS_RE_DTE_ESG_EN_CLASS_FIN]
EN_CLASS_PRIM, -- Primary En.Eff.Class [CMS_RE_DTE_ESG_EN_CLASS_PRIM]
BLD_TYPE, -- Building Type [CMS_RE_DTE_ESG_BLD_TYPE]
BLD_TYPE_DESC, -- Building Type Desc [CMS_RE_DTE_ESG_BLD_TYP_DESC]
BLD_PART, -- Building Part [CMS_RE_DTE_ESG_BLD_PART]
BLD_YEAR, -- Building Year [CMS_RE_DTE_ESG_BLD_YEAR]
BLD_UNITS, -- Building Units [CMS_RE_DTE_ESG_BLD_UNITS]
BLD_AREA, -- Usable Area of Bldg [CMS_RE_DTE_ESG_BLD_USABLE_AREA]
BLD_AREA_UOM, -- Area UOM [CMS_RE_DTE_USBL_AREA_UOM]
BLD_AREA_DER_FRM_RES, -- Usable Area Derived [CMS_RE_DTE_ESG_BLD_AREA_DERIVE]
HEAT_YEAR, -- Heating System Year [CMS_RE_DTE_ESG_HEAT_YEAR]
HEAT_ES_DESC, -- Energy Source [CMS_RE_DTE_ESG_HEAT_ES_DESC]
HEAT_ES_TYPE_1, -- Energy Source 1 [CMS_RE_DTE_ESG_HEAT_ES_TYPE_1]
HEAT_ES_TYPE_2, -- Energy Source 2 [CMS_RE_DTE_ESG_HEAT_ES_TYPE_2]
HEAT_ES_TYPE_3, -- Energy Source 3 [CMS_RE_DTE_ESG_HEAT_ES_TYPE_3]
WATER_ES_DESC, -- Energy Source [CMS_RE_DTE_ESG_WATER_ES_DESC]
WATER_ES_TYPE_1, -- Energy Source 1 [CMS_RE_DTE_ESG_WATER_ES_TYPE_1]
WATER_ES_TYPE_2, -- Energy Source 2 [CMS_RE_DTE_ESG_WATER_ES_TYPE_2]
WATER_ES_TYPE_3, -- Energy Source 3 [CMS_RE_DTE_ESG_WATER_ES_TYPE_3]
RENEW_DESC, -- Renewable Energy [CMS_RE_DTE_ESG_RENEW_DESC]
RENEW_USAGE_DESC, -- Renew. Energy Usage [CMS_RE_DTE_ESG_RENEW_USG_DESC]
RENEW_TYPE_1, -- Renew.En.Src.Type 1 [CMS_RE_DTE_ESG_RENEW_TYPE_1]
RENEW_USAGE_TYPE_1, -- Usage Type 1 [CMS_RE_DTE_ESG_RENEW_USG_TYP_1]
RENEW_TYPE_1_PA, -- Coverage (%) [CMS_RE_DTE_ESG_PA]
RENEW_TYPE_1_PM, -- Mnd.req.fulfil.(%) [CMS_RE_DTE_ESG_PM]
RENEW_TYPE_2, -- Renew.En.Src.Type 2 [CMS_RE_DTE_ESG_RENEW_TYPE_2]
RENEW_USAGE_TYPE_2, -- Usage Type 2 [CMS_RE_DTE_ESG_RENEW_USG_TYP_2]
RENEW_TYPE_2_PA, -- Coverage (%) [CMS_RE_DTE_ESG_PA]
RENEW_TYPE_2_PM, -- Mnd.req.fulfil.(%) [CMS_RE_DTE_ESG_PM]
RENEW_TYPE_3, -- Renew.En.Src.Type 3 [CMS_RE_DTE_ESG_RENEW_TYPE_3]
RENEW_USAGE_TYPE_3, -- Usage Type 3 [CMS_RE_DTE_ESG_RENEW_USG_TYP_3]
RENEW_TYPE_3_PA, -- Coverage (%) [CMS_RE_DTE_ESG_PA]
RENEW_TYPE_3_PM, -- Mnd.req.fulfil.(%) [CMS_RE_DTE_ESG_PM]
VNT_TYP_DESC, -- VentilationType Desc [CMS_RE_DTE_ESG_VNT_TYPE_DESC]
VNT_TYPE_1, -- Ventilation Type 1 [CMS_RE_DTE_ESG_VNT_TYPE_1]
VNT_TYPE_2, -- Ventilation Type 2 [CMS_RE_DTE_ESG_VNT_TYPE_2]
VNT_TYPE_3, -- Ventilation Type 3 [CMS_RE_DTE_ESG_VNT_TYPE_3]
COOL_DESC, -- Cooling Type Desc [CMS_RE_DTE_ESG_COOL_DESC]
COOL_TYPE_1, -- Cooling Type 1 [CMS_RE_DTE_ESG_COOL_TYPE_1]
COOL_TYPE_2, -- Cooling Type 2 [CMS_RE_DTE_ESG_COOL_TYPE_2]
COOL_TYPE_3, -- Cooling Type 3 [CMS_RE_DTE_ESG_COOL_TYPE_3]
COOL_INSP, -- With Inspection [CMS_RE_DTE_ESG_COOL_INSP]
COOL_INSP_DATE, -- Nxt.insp.due date [CMS_RE_DTE_ESG_COOL_INSP_DATE]
REC_INSULATION, -- Building Envelope [CMS_RE_DTE_ESG_REC_INSULATION]
REC_INSTALLATION, -- MEP [CMS_RE_DTE_ESG_REC_INSTALLATN]
CREATED_BY, -- Created By [CMS_RE_DTE_CR_BY]
CREATED_DATE, -- Created On [CMS_RE_DTE_CR_ON]
CREATED_TIME, -- Created At [CMS_RE_DTE_CR_AT]
ENTRY_SRC, -- Source Of Entry [CMS_RE_DTE_SRC_INIT]
LAST_CHG_BY, -- Last Changed by [CMS_RE_DTE_CHG_BY]
LAST_CHG_DATE, -- Last Changed On [CMS_RE_DTE_CHG_ON]
LAST_CHG_TIME, -- Last Changed At [CMS_RE_DTE_CHG_AT]
PROCESSING_SRC, -- Processing Src [CMS_RE_DTE_PRC_SRC]
PRIMARY KEY (MANDT, OBJ_EPC_GUID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA