Sigma for Utilities - Data Models

Meter Maintenance


Maintenance activities (notifications) like: removal, replacements, connect or disconnect of meters at customer’s premises are listed in this Sigma Data Model. Each activity is displayed alongside with its attributes, meters involved, personnel  involved, dates, completion reasons and statuses.

  • SAP Tables: QMEL, QMSM, QMFE, QMMA

Installation Checks


After every event in the installation life cycle  (E.G.: first installment, change of connection size or other events) an electrical check must be taken to ensure safety regulation. This Sigma Data Model lists all checks (notifications) done alongside with reasons, completion status, personnel involved and statuses.

  • SAP Tables: QMEL, QMSM, QMFE, QPCT, QMIH

Meter Tests


Meters are going under periodical technical tests due to regulation, suspect of illegal usage or due to customer’s request. The technical tests and their results alongside with many other attributes are listed in this Sigma Data Model.

  • SAP Tables: QMEL, QMFE, QMUR, QPCT, QMIH
 

Orders


Expansion of grid elements, new buildings or new customers requires handling purchase orders (Notifications). These include: New connection objects (buildings), new or revised device locations (e.g.: upgrading the connection size), grid maintenance, PV and distributed energy resources and more. This Sigma Data Model is used to track and monitor the statuses of all orders.

  • SAP Tables: QMEL, VBAK, VBAP
 

Order’s Activities


This Sigma Data Model keeps track of all activities scheduled for each order. Dates of release and completion. Personnel involved, SLA compliance and statuses.

  • SAP Tables: QMEL, QMSM, QPCT, QMIH
 

Order’s General Ledger


Budget and financial control of all operations resulting from orders. Planing, accounting and bookkeeping.

  • SAP tables: QMEL, VBAP, VBAK, DFFKOP, DFKKKO, DFKKOPK
view other selected sigma data models: