Analyzing Utilities Business Data

Objective

After completing this lesson, you will be able to analyze the critical components of utilities business data to identify key insights.

Overview

Utilities business data (UBD) facilitate data exchange to connect processes between the market communication system MaCo Cloud and the business system SAP S/4HANA Utilities.

The exchanged data include several types. First, there is master data, which consists of information like point-of-delivery or business partner details. Next, energy data involves meter reading values or profile values. Then, process data covers items such as grid usage invoices or payment advices. Finally, settlement data comes from the energy quantity settlement run.

Diagram illustrating components of SAP Market Communication. At the top, under Market Communication in General, are: Message Exchange, CONTRL and APERAK, Aggregation, Reversal, Partner Management. Below, Market Communication by Role includes: Meter Operator, Distributor, Supplier, Settlement Coordinator. Utilities Business Data section lists: Master Data, Energy Data, Process Data, Settlement Data. At the bottom, SAP Fiori Apps features: Monitoring, Configuration. The background is light blue.

Utilities Business Data – Examples

The figure shows the most important supported utilities business data structures.

SAP Help Portal: Data Structures Exchanged With the Business System (UBD)

Diagram showing components of SAP Utilities Business Data. At the top, under Master Data, are: Name and Address, Point-of-Delivery, Supply Scenario, Device. Below, Energy Data includes: Meter Reading, Load Shape Value, Intelligent Metering Data. Process Data section lists: Master Data Change, Invoice Document, Payment Advice. At the bottom, Energy Quantity Settlement Data (EQS) features: Clearing List, Settlement Territory, Scenario. The background is light blue.
Name and Address
The Name and Address structure is used to request and receive name and address information from the business system.

SAP Help Portal: Name and Address

Point-of-Delivery
The Point-of-Delivery structure is used to request and receive details about the point of delivery from the business system.

SAP Help Portal: Point of Delivery

Supply Scenario
The Supply Scenario structure is used to request and receive details about the supply scenario from the business system.

SAP Help Portal: Supply Scenario

Device
The Device structure is used to request and receive details about devices from the business system.

SAP Help Portal: Device

Meter Reading
The Meter Reading structure is used to request and receive meter readings from the business system.

SAP Help Portal: Meter Reading

Load Shape Value
The Load Shape Value structure is used to request and receive details about the load shape values from the business system.

SAP Help Portal: Load Shape Value

Intelligent Metering
The Intelligent Metering structure is used to exchange details about the intelligent metering data with the business system.

SAP Help Portal: Intelligent Metering Data

Master Data Change
The Master Data Change structure is used to exchange details about master data changes.

SAP Help Portal: Master Data Change

Invoice Document
The Invoice Document structure is used to request and receive invoice document details from the business system.

SAP Help Portal: Invoice Document

Payment Advice
The Payment Advice structure is used to request and receive payment advice details by the business system.

SAP Help Portal: Payment Advice

EQS Clearing List
The EQS Clearing List structure is used to request and receive clearing list details from the business system.

SAP Help Portal: EQS Clearing List: SUP

EQS Settlement Territory
The EQS Settlement Territory structure is used to exchange settlement territory details between the business system and the MaCo cloud.

SAP Help Portal: EQS Settlement Territory

EQS Scenario
The EQS Scenario structure is used to request and receive EQS subscription details from the business system.

SAP Help Portal: EQS Scenario

Transfer Document

The technical means for exchanging utilities business data are transfer documents (TDOC), which each carry a business message. You can view the transferred data structures and their content in the Details section of the Monitor TDOC app. A business message comprises one or more business objects, with each object corresponding to one of the data structures.

Diagram showing elements of a data retrieval system. Listed in order are: Retrieval Table, Retrieval Class, Components, Single Fields and Allowed Values. The background is light blue.

For the exchanged data structures, there are corresponding DDIC structures in the business system that have a table on the top level. All these data retrieval tables are contained in table /US4G/S_UBD_DATA.

For most of these DDIC structures, there is a dedicated ABAP class that handles the data retrieval to fill the structure. In the class documentation in the business system, you find more information about how the retrieval works.

In messages that request data from another system, the REQUEST and REQ_FILTER components are used. When sending messages with actual content, the DATA components are filled. These DATA components can include several levels of detailed information.

Down on field level, you see details like data type and field length. There are fields for free values like text or meter readings, and there are fields with a fixed set of allowed values. For the fixed values, the MaCo cloud uses human-readable values in camel case notation instead of the codes from the BDEW documents. For example, for the meter reading complaint reason, ComplaintValuesTooHigh and TooLow, instead of the BDEW codes Z04 and Z05. When converted into EDIFACT messages later, of course, the prescripted codes are used.

Log in to track your progress & complete quizzes