Business Partners and Contract Accounts


Business Partners (BP), or customers,  are the core objects of SAP/ISU. This Sigma Data Model list all BPs with all information from many related objects: The contract account details followed by the contract details, Installation details and premises details. This model is the foundation of all other Sigma Data Models for SAP/ISU.

  • SAP Tables: BUT000, BUT0ID, ADR2, ADR3, ADR6, BUT021FS, ADRC, FKKVKP, EVER, EANL, ETTIFN

Infrastructure (Master Data)


This Sigma data model lists all device locations including all of their attributes (E.G.: Connection size, KVA, Voltage level , Production capabilities etc.) along side with premises and connection objects (buildings), addresses and all attributes and current statuses of each of these objects. This Sigma Data Model can be used to view and analyze the current grid and attached device locations.

  • SAP Tables: EVBS, IFLOT, ILOA, ADRC, AUSP, JEST, JCDS, EANL, EANLH

Meters on Premises


The current state of all meters (devices) installed at customers premises. Every meter with all of its technical attributes along side with installation attributes. Every meter is categorized as primary, control, production and many other categorization factors. Dates of installation, current status (disconnected or connected) is also recorded in this model.

  • SAP Tables: EANL, EANLH, EGERH, EQUI, ETDZ, EASTL, EASTS
 

Meter Reading


The Meter Reading model displays every register reading with all of its attributes like: status, reason, result, value, personnel involved and time stamp. The model can be used to forecast usage, monitor meter reading activities and more.

  • SAP Tables: EABL, EABLG, EQUI, ETDZ, EABLDEL
 

Distributed Energy Agreements


The history of agreements for all specific tailored customers. Every agreement has a reflection in specific rate type, installation fact, start and end period and other attributes. The model allow viewing all agreement in one location and monitor their statuses.

  • SAP Tables: ETDZ, ETTIFN, EANLH, EASTS, EASTL
 

Billing


Every bill created in ISU is documented in this model with bill header attributes along with every line of the bill. This model is a good example of BigData management and is extracted daily under delta controlled environment.

  • SAP Tables: ERDK, DBERDL, DBERDLB, DBERCHZ1-3, ERCH
 

Reading Cube


This OLAP based Data Model shows a calendar summarized view of all billable readings from invoices. The Summation is for each installation or a combination of installation and premises.

  • SAP Tables: ERDK, DBERCHZ2, DBERCHZ3, ETTIFN, EANL, EASTS
 

Meters Stock Management


The management of all transactions between meters warehouses. Move in of meters from purchase process first time into the main warehouse, Move out to installation or to other warehouse, All stock management transaction are listed in this Sigma Data Model.

  • SAP Tables: EQUI, MARA
 

Network Information


Every connection object (building) may have several connection from the grid attached to. The electrical path of each of this connection (Transformer, Transformation Station, High voltage line etc) is listed in this Sigma Data Model.

  • SAP Tables: IFLOT, ILOA, EVBS, NIS
 

Smart Grid – EDM  


Smart meters produce enormous amount of raw data. This Sigma Data Model stores the data in a Big Data structure along with attributes of the meter and the profile attached to. This model can be used for forecasting, charting, display 15 minutes based readings to various application both for internal use of for customer’s based mobile applications that help them keep track of their usage along the day with trend analysis.

 

 

Registers on premises


Every meter has one or more registers (Eg: TOU meter has several registers for each part of the day).
This Sigma Data Model lists all installed on premises meters along with their registers. Each registers has its rate category, rate and price attached to. This model can be used to verify the correct rate attached to each meter in an installation with correlation to the product. It can also be used for billing simulation and forecasting.

 

 

 


 

View other selected Sigma data models