Sap is u utility master data relationship

SAP IS-U data model – Business and Technical Master Data | SAP Blogs

sap is u utility master data relationship

Business Partner can be a person, group or organisation with whom the utility company has a business relationship. 1/19/ SAP IS-U data model – Business and Technical Master Data | SAP g.g. For the purposes of this discussion. the relationship https://blogs. However. List of SAP IS SAP Utilities(IS-U) Tables and the relationships between them. EAMI_DEV_NO_IN - Structure for master data update inbound process.

More than one device can be in a device location or each device can be its own location. So these would be treated as two device locations that have two individual devices installed. Device locations are handy to capture the co-ordinates so that when there is a maintenance activity to be performed on the device, it is easy for the field personnel to locate the device.

This refers to the physical location where the various services are provided. It is the service address and usually the address of the house but in case of apartment complex could be different than the address of the apartment that actually consumes the service.

Master data for CRM IS-Utility integration

Device locations discussed above take the address of the connection object with additional qualifiers to pin point their location. The address of these locations will still be my house address but the additional qualifier would be basement, hallway etc. In SAP, the connection object is nothing but a plant maintenance functional location object.

This refers to the spatial unit or the enclosed structure to which the utility services have to be rendered. It is attached to the connection object and takes the address of the connection object but the premise also has other attributes attached to it. Note that this may sound like a duplicate of connection object, but there are some differences, because connection object is all about location data where premise is additional information about the actual structure and space within.

It is at the installation level various billing schema, rate tariffs and billing procedures are attached for the services provided.

sap is u utility master data relationship

The installation groups various devices based on registers etc so that specific billing values like rate category can be maintained for the services. Also, every installation is attached to the premise so that actual supply point can be linkedwith the site where the services are provided. Point to note that is there is a one to one relationship between installation and contract.

sap is u utility master data relationship

This is a globally identified unique service point where a utility service is provided. In a deregulated market a topic in itselfthere are multiple service providers providing a customer different services. So, in a deregulated market, it becomes important to uniquely identify service point and it is done using the point of delivery data object. There is a 1: This groups the various devices in to different categories based on the technical characteristics. This enables us to maintain the data that is common for a group of devices, there by grouping them in a logical way.

Some examples of device categories are Meter, Transformer, Pressure regulator etc. This summarizes the key master data objects that make up the IS-U data model. There are other data objects like Technical Installation, Connection, Grid and Services that are used for augmenting these key data objects.

More information can be obtained here. Of course there are many tables that hold data that relates to these data objects.

Master data for CRM IS-Utility integration

That is, these master data can be created first in either CRM or ECC and it is replicated to the other system as a part of the replication process. I have identified a separate blog on CRM replication and we will discuss about these nuances in detail there. I am also working on interactive chart on various IS-U master data, transaction data and their relationships.

Once done, I will either publish it as a separate blog or as a part of the blog identified for conversions. Hopefully, this blog acts a starting point for understanding IS-U master data model. The Premise is allocated to a Connection object and to the address of that Connection object.

sap is u utility master data relationship

Utility installation represents the supply of utility services provided at a location. It is division-specific grouping of devices, registers and specific billing values that are allocated to a premise and that belong together for billing purposes.


An installation provides a single point of view for both metering and billing information. An installation groups together the devices that are allocated to the same site, and that are therefore billed together. Device location in a connection object is where any number of devices can be installed. A Device is an instrument used for measuring consumption, processing data, or controlling and protecting other instruments.

Devices can be of following types: Meters, Converters, Data loggers, installation kits, meter boxes, bypasses etc.

sap is u utility master data relationship

In SAP, devices are created in the system by referring to a device category. The relation between the IS-U technical master data is shown below through a pictorial representation.

SAP - Excellence: SAP- ISU

The process of linking the device to installation and device location is called as Full Installation. The details provided by the user are stored in the temporary data structures and used by the program during data creation.

The function module returns the created connection object. The function module returns the created premise. The function module returns the created installation.

The function module returns the device location.