SAP Energy Data Management Tables
Are you looking for the right table related to SAP Energy Data Management Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Energy Data Management (IS-U-EDM) module.
Top 10 tables in Energy Data Management
| Table | Description |
|---|---|
| ESRCSYSTEM | Source System |
| EPROFVALSTATHIST | History of Profile Value Status |
| EFORMULATRIGKMP | ISU EDM Compressed Trigger File for Formula Inst. (DB Table) |
| EEDMSETTLPODGEN | Check EEDMSETTLPODCONS Generation |
| EEDMFORMHEADT | Formula (Text) |
| EEDMSETTLCHKTYT | Customizing: Define Description of Check Type |
| ERTPDAYTYPEXIDT | Daytype Exception Code Text |
| ERTPCOMPT | Component for RTP Interface (Text) |
| EPROFVAL10_TMP | Temporary Profile Values in 10-Minute Intervals |
| EEDMSETTLUF | Usage Factors per Settlement Run |
List of tables in Energy Data Management
| Table | Description |
|---|---|
| ESRCSYSTEM | Source System |
| EPROFVALSTATHIST | History of Profile Value Status |
| EFORMULATRIGKMP | ISU EDM Compressed Trigger File for Formula Inst. (DB Table) |
| EEDMSETTLPODGEN | Check EEDMSETTLPODCONS Generation |
| EEDMFORMHEADT | Formula (Text) |
| EEDMSETTLCHKTYT | Customizing: Define Description of Check Type |
| ERTPDAYTYPEXIDT | Daytype Exception Code Text |
| ERTPCOMPT | Component for RTP Interface (Text) |
| EPROFVAL10_TMP | Temporary Profile Values in 10-Minute Intervals |
| EEDMSETTLUF | Usage Factors per Settlement Run |
| ERTPINFOTYPET | Information Types for RTP Interface (Text) |
| EPROFVALDT | Profile Values for Large Intervals (Days, Months, Years) |
| EPROFVALMONTHTMP | Temporary Profile Values for One Month |
| ERTPIFACERES | Result Parameters for RTP Interface (Text) |
| EEDMREPGRPERR | IS-U-EDM: Actions for Errors for Each Replacement Procedure |
| ESOURCEH | Source of Object (Historical Data) |
| EEDMSETTLDOCVARH | Variants for Header Info of Settlement Document |
| EEDMSETTLDOCERR | Settlement Document (Errors) |
| EFORMULASTATGRP | Status Group of Formula Instance |
| EEDMSETTLUNITGEN | Settlement Unit: Generated Form |
| EFORMULAHIER | IS-U EDM Hierarchy Levels of Formula Instance (DB Table) |
| EEDMSETTLPARAMT | Settlement Parameter: Profiles and Values (Paramter Texts) |
| ERTPIFACEINSTPAR | Allocation of Parameters to RTP Interface for Indiv. Insts |
| EEDMSETTLPROCSUC | Settlement Unit Category for Selection |
| EFORMULASTATGRPT | Description of Status Group of Formula Instance |
| EEDMSETTLSTEPT | Settlement Steps (Text) |
| ERTPINFOTYPE | Information Types for RTP Interface |
| EEDMSTATUS_EX_IN | Conversion of External Status to Internal Transaction |
| EEDMSETTLVIEW | Settlement View |
| EEDMCONCHKERR | IS-U EDM Consistency Checks for Error Codes |
| ERTPDAYTYPEX | Allocate Exceptions to Day Groups |
| ERTPFCOMPHEAD | RTP Component |
| EPROFVAL05_2 | Profile Values in 5 Minute Intervals - Part 2 |
| EEDMCONSLOGH_DB | IS-U EDM Profile Import Consistency Log: Header |
| EDAYTYPBLOCKT | Day Group (Text) |
| EPROFCATEGORY | Profile Categories |
| EEDMSETTLVIEWT | Settlement View (Text) |
| EEDMSETTLPROCPA | Settlement Procedure (Procedure Parameters) |
| EPROFVALCATT | Profile Value Category (Text) |
| EEDMSYNPRFACTORT | Function Modules for Dynamic Modification Factors (Text) |
| EEDMREPLACEGRP | IS-U-EDM Replacement Value Procedure Group |
| EFORMULAINTERVAL | ISU EDM Intervals of Hierarchy Level (DB table) |
| EDAYTYPBLOCK | Day Group |
| EEDMFORMPART | Formula Parameters |
| EEDMCONGRPCHK | IS-U EDM Allocation of Consistency Checks to Check Group |
| ESOURCE | Source of Object |
| ERTPIFACEREST | Result Parameter for RTP Interface |
| EPROFVALSTAT_TMP | Status of Temporary Profile Values |
| EEDMPROFCONTEXTT | Text for Context for Profile Allocation |
| EEDMFORMMODPAR | Calculation Mode Options per Formula Parameter |
| EEDMSUNITCAT | Settlement Unit Category |
| EEDMSETTLTABLE | Table for Updating Settlement Parameters |
| EEDMSETTLPARAM | Settlement Parameter: Profiles and Values |
| EEDMIMPORTLOG_DB | EDM Import Log: Database Table |
| EEDMSELTYPET | Selection Type for Settlement |
| EPROFHEAD | Profile Header Data |
| EPROFHEADT | Profile Header Data (Text) |
| EEDMSETTLPROCSEL | Selections for Settlement Procedure |
| EPROFVALMONTH | Profile Values for One Month |
| EEDMSETTLSTEPPA | Settlement Steps (Parameters) |
| EEDMSETTLUNITH | Settlement Unit (Historical Data) |
| ETOUPER | Periods for TOU Period |
| EPROFVALCSTATCST | Display for User Status of Profile Values |
| EEDMSTATUS_EXT | External Status for Profile Values |
| EEDMFORMDETVAR | Determination Method for EDM Formula Variable |
| EEDMCONSLOGP_DB | IS-U EDM: Profile Import Consistency Log - Attribute Values |
| ERTPFCOMPHEADT | Component for RTP Interface (Text) |
| EEDMREPLACET | IS-U: EDM Replacement Value Procedure |
| EDAYTYPE | Day Types |
| EEDMSETTLIN | Load Shapes Per Settlement Run |
| EFORMULAINST | IS-U EDM Header Data of Formula Instance (DB Table) |
| EEDMCONCHK | IS-U: EDM Consistency Checks for Profile Import |
| EEDMPROFOPROLE | Operand - Profile Role Allocation |
| EEDMSETTLDOCRUN | Settlement Document (Run) |
| EEDMSETTLDOCSNDS | Settlement Document (Sent Profiles) Status |
| EPROFVALDT_TMP | Temp. Profile Values for Large Intervals (Day, Month, Year) |
| ERTPIFACETEMP | Allocation of Reference Parameter to RTP Interface |
| EEDMSETTLPROCT | Settlement Procedure (Text) |
| ESEASONBLOCKDEF | Season Group Definition |
| EFORMULAINSTCALC | ISU EDM Control Data for Calculation Run Number (DB Table) |
| EEDMSETTLDOCUPDP | Settlement Document (Updated Profiles) |
| EEDMSETTLUNITPOD | Allocation of Settlement Unit to Point of Delivery |
| EEDMREPLACEERR | IS-U-EDM: Replacement Value Procedure - Error Codes |
| EEDMSETTLPARAMV | Settlement Paramter: Definition of Values |
| EPROFVAL15 | Profile Values in 15-Minute Intervals |
| ERTPFCOMPDATA | Data for Flexible RTP Components |
| EPROFISPERM | Permissibility of Interval Length |
| EEDMSETTLPODCONS | Generated Consumption per Point of Delivery |
| EEDMFORMGRPT | EDM Formula Group (Text) |
| ERTPEXDAY_TO_INS | Allocation of Exception Agreement for Installation |
| EEDMCONGRPERR | IS-U EDM Error Actions per Consistency Check |
| EEDMREPLACE | IS-U: EDM Replacement Value Procedure |
| EEDMFORMDEFVAL | Default Value for EDM Formula Calculation |
| EPROFVALCAT | Profile Value Category |
| EEDMFORMDETVART | Determination Method for EDM Formula Variable (Text) |
| EPROFINTSIZE | Interval Lengths |
| EDAYTYPBLOCKDEF | Defintion of Day Group |
| EPROFVAL60 | Profile Values in 60-Minute Intervals |
| EEDMSTATUS_EXTT | External Status for Text of Profile Values |
| ETOUBLOCK | Day Group |
| EEDMCONGRPT | IS-U EDM Consistency Check Group for Profile Import Texts |
| EPROFASSROLET | Roles for Profile Allocation |
| ESEASONT | Season Definitions (Text) |
| EEDMSETTLDOCVARI | Variant on Settlement Document |
| EPROFVERSHEAD | Header Data for Profile Version |
| EDAYTYPET | Day Types (Text) |
| EEDMREPLACEASS | Allocation of Replacement Value Procedure |
| EEDMSETTLUNIT | Settlement Unit (Header Data) |
| EPROFVAL05_1 | Profile Values in 5 Minute Intervals - Part 1 |
| EEDMPROFROLESRS | Source Role for Profile Allocation and Usage Factor Calc. |
| EEDMSETTLPARAMP | Settlement Paramter: Definition of Reference Profiles |
| EFORMULATRIGTMP | ISU EDM Temporary Trigger File for Formula Inst. (DB Table) |
| EEDMSUNITREASON | Reason for Allocating Higher-Level Settlement Unit |
| EPROFASSROLE | Roles for Profile Allocation |
| ERTPCOMPCODE | Internal Code for Individual Levels of RTP Component |
| TEDM_STAT_CONTR | Activate Change Documents for Status of EDM Profiles |
| EEDMDAYOFFSETT | EDM Day Offset |
| EEDMPROSEND | Recording of Sent Profiles |
| EEDMSETTLPROC | Settlement Procedure (Header Data) |
| EEDMRESULTT | Result Function for Profile (Text) |
| EFORMULAINSTPMI | ISU EDM Input Parameters for Formula Instance (DB Table) |
| TEDM_STAT_CUST_1 | Priority for Value-Related Status for Longer Interval Lngths |
| EEDMREPLACEERRT | IS-U-EDM Replacement Value Procedure: Texts for Error Codes |
| ESEASONBLOCK | Season Group |
| EPROFVAL05_1_TMP | Temporary Profile Values in 5-Minute Intervals: Part 1 |
| ETOUBLOCKT | Day Group (Text) |
| EEDMCONCHKERRT | IS-U EDM Consistency Checks: Texts for Error Codes |
| EPROFTYPE_VERS | Create Version of Profile Values According to Profile Type |
| ERTPDAYTYPEXID | Exception to Day Type |
| EEDMSETTLPROCRR | Settlement Procedure (Role for Register Allocation) |
| EPROFVAL05_2_TMP | Temporary Profile Values in 5-Minute Intervals: Part 2 |
| EPROFVAL30_TMP | Temporary Profile Values in 30-Minute Intervals |
| EEDMCONCHKT | IS-U: EDM Profile Import - Consistency Check Texts |
| EEDMSETTLPROCSER | Settlement Procedure (Service Type for Procedure) |
| ERTPIFACEHIDDENC | Hidden Entries: RTP Interface |
| EPROFVERSSTAT | Status of Profile Version of Version |
| EPROFVAL30 | Profile Values in 30-Minute Intervals |
| ESRCSYSTEMT | Source System (Text) |
| ERTPIFACECOMP | Components for RTP Interface |
| TEDM_STAT_CUST | Allocate Profile Values to Status Profile for User Status |
| EVERSREASONT | Reason for Creating Profile Version (Text) |
| EEDMSETTLDOC | Settlement Document (Header) |
| EDIVDIM | Permitted Dimensions for Division Cat. and Profile Val. Cat. |
| EEDMSUNITREASONT | Reason for Allocating Higher-Level Settlement Unit (Text) |
| EEDMSETTLPROCPRT | Settlement Procedure (Log Display: Texts) |
| EEDMSYNPROFALLOC | Synthetic Profile: Allocation of Profiles |
| EPROFVAL15_TMP | Temporary Profile Values in 15-Minute Intervals |
| ERTPINTERFACE | RTP Interface (Header Data) |
| EEDMSETTLDOCPARV | Settlement Document (Persistent Value Parameters) |
| EEDMSETTLCHKTY | Customizing: Define Check Type |
| EEDMSETTLPROCPAG | Settlement Procedure (Profiles as Procedure Parameters) |
| ERTPINTERFACET | RTP Interface (Header Data) |
| EEDMPROFCONTEXT | Context for Profile Allocation |
| EPROFCATEGORYT | Profile Categories (Text) |
| ESEASON | Season Definitions |
| ESEASONPER | Season Periods |
| EPROFTYPE | Profile Type |
| EFORMULAINSTLOCK | IS-U EDM Lock Table for Formula Instance Calculation |
| EEDMSETTLPROCRS | Settlement Procedure (Role for Profiles for Sending) |
| EPROFVALSTATCUST | Display for System Status of Profile Values |
| ERTPIFACECOMPHIS | Components for RTP Interface (Historical Part) |
| ETOUT | Definition of TOU Period (Text) |
| EEDMSUNITCATT | Settlement Unit Category (Text) |
| EFORMULAINSTPMO | ISU EDM Output Parameters for Formula Instance (DB Table) |
| EPROFVAL60_TMP | Temporary Profile Values in 60-Minute Intervals |
| EEDMFORMMOD | Calculation Mode for Value in Formulas |
| ESEASONBLOCKT | Season Group (Text) |
| EEDMFORMDEFVALT | Default Value for Formula Calculation (Text) |
| EPROFINTSIZET | Interval Lengths for Profiles (Text) |
| EPROFVERSVALUE | Values for Profile Version |
| EEDMSETTLUNITT | Settlement Unit (Text) |
| EEDMSYNPROF | Synthetic Profile: Additional Data |
| EZWGEPROFASS | Template for Creating and Allocating Profiles |
| EEDMFORMPAR | Formula Parameters |
| EFORMULASTATUS | EDM Status for Status Group (DB Table) |
| ETOU | Definition of TOU Period |
| ETOUBLOCKDEF | Day Group Data |
| ERTPCOMP | RTP Component |
| EEDMFORMMODT | Calculation Mode for Value in Formulas |
| TEDM_STAT_CUST_3 | Priority for User Status for Longer Interval Lengths |
| EPROFVAL10 | Profile Values in 10 Minute Intervals |
| EEDMDAYOFFSET | EDM Day Offset |
| EVERSREASON | Reason for Creating Profile Version |
| EEDMSYNPROFCODE | Synthetic Profile: Internal Code for Individual Levels |
| EEDMFORMGRP | EDM Formula Group |
| EPROFASS | Allocation of Profiles |
| EEDMSETTLPROCRI | Settlement Procedure (Roles for Installation Allocation) |
| ERTPIFACEINP | Allocation of Input Parameters for RTP Interface |
| EPROFHEAD_TMP | Header Data of Temporary Profile |
| EEDMSETTLDOCSNDP | Settlement Document (Sent Profiles) |
| EEDMSETTLDOCUNIT | Settlement Document (Settlement Units Accounted for) |
| EEDMREPLACEGRPT | IS-U-EDM Replacement Value Group Texts |
| EPROFHEADT_TMP | Header Data of Temporary Profile (Text) |
| EEDMSELTYPE | Selection Type for Settlement |
| EEDMCONGRP | IS-U EDM Consistency Check Group for Profile Import |
| EEDMUISETTLUNIT | Allocation of Point of Delivery to Settlement Unit |
| EEDMFORMHEAD | Formula Header Data |
| EEDMRESULT | Result Function for Profile |
| EEDMSETTLPROCPRO | Settlement Procedure (Log Display) |
| EEDMSYNPRFACTOR | Control Table of Function Modules for Dynamic Mod. Factors |
| EEDMSTATUS_IN_EX | Conversion of Internal Status to External Status |
| EPROFTYPET | Profile Type (Text) |
| EPROFVALSTAT | Profile Value Status |
| EEDMSETTLSTEP | Settlement Steps (Header Data) |
| ERTPIFACEINST | Activation of RTP Components for Individual Installations |
| EEDMSETTLDOCVART | Variant: Settlement Document Text |
| EEDMSETTLDOCLINE | Settlement Document (Lines) |
| TEDM_STAT_CUST_2 | Priority for Cond.-Related Status for Longer Interval Lngths |
| EPROFINTTIME | Control Table with Interval Times for Profile Values |
| EEDMSETTLDOCALER | Settlement Document (Alerts) |
| ERTPIFACEOUT | Allocation of Output Parameters to RTP Interface |