What is I_UtilsInstalledDevice in SAP S/4HANA?

I_UtilsInstalledDevice is a composite CDS view in SAP S/4HANA. Installed Device It contains 138 fields.

Which tables does I_UtilsInstalledDevice read from?

I_UtilsInstalledDevice reads data from: I_UtilitiesDevice.

What VDM layer is I_UtilsInstalledDevice?

I_UtilsInstalledDevice is classified as a Composite view that combines data from multiple basic views.

I_UtilsInstalledDevice

DDL: I_UTILSINSTALLEDDEVICE SQL: IEINSTALLEDDVCE Type: view COMPOSITE

138 Fields 1 Data Sources 4 Associations

Installed Device

I_UtilsInstalledDevice (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Utilities

I_UtilsInstalledDevice is a Composite CDS View (Cube) that provides data about "Installed Device" in SAP S/4HANA. It reads from 1 data source (I_UtilitiesDevice) and exposes 138 fields with key field UtilitiesDevice. It has 4 associations to related views.

SAP API Hub

State	C1
Line of Business	Utilities
Application Component	IS-U-DM
Capabilities	Data Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities
Package	Utilities for SAP S/4HANA
Description	<p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul><li><p>How many and what type of devices are installed?</p></li> <li><p>How many devices are contained in a specific sample lot?</p></li> <li><p>Which devices were installed recently?</p></li> <li><p>How many and what type of advanced meters are installed?</p></li> <li><p>Which advanced meters were installed recently?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA, onpremise edition — Explore SAP S/4HANA Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_UtilitiesDevice	I_UtilitiesDevice	from

Parameters (1)

Name	Type	Default
P_KeyDate	e_keydate_vdm

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	I_UtilsDeviceCategory	_UtilsDeviceCategory	`$projection.UtilitiesDeviceCategory = _UtilsDeviceCategory.UtilitiesDeviceCategory`
[0..1]	I_UtilsTechObjLocationAddr	_UtilsTechObjLocationAddr	`$projection.UtilsDeviceLocation = _UtilsTechObjLocationAddr.FunctionalLocation`
[0..1]	E_UtilitiesDeviceHeader	_UtilsDeviceHeaderExtension	`$projection.UtilitiesDevice = _UtilsDeviceHeaderExtension.Equipment`
[0..1]	I_FunctionalLocation	_FunctionalLocation	`$projection.functionallocation = _FunctionalLocation.FunctionalLocation`

Annotations (13)

Name	Value	Level
EndUserText.label	Installed Device	view
Analytics.dataCategory	#CUBE	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#MANDATORY	view
AbapCatalog.sqlViewName	IEINSTALLEDDVCE	view
ObjectModel.usageType.serviceQuality	D	view
ObjectModel.usageType.sizeCategory	XL	view
ObjectModel.usageType.dataClass	MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view

Fields (138)

Key	Field	Source Table	Source Field	Description
KEY	UtilitiesDevice	I_UtilitiesDevice	UtilitiesDevice	Equipment Number
	UtilsDeviceValidityEndDate	I_UtilitiesDevice	UtilsDeviceValidityEndDate	Validity End Date of Device
	UtilsDeviceActivityReason	I_UtilitiesDevice	UtilsDeviceActivityReason	Activity reason
	UtilsDeviceValidityStartDate	I_UtilitiesDevice	UtilsDeviceValidityStartDate	Validity Start Date of Device
	UtilsDeviceBscCatCombination	I_UtilitiesDevice	UtilsDeviceBscCatCombination	Combination of a device category
	UtilitiesLogicalDeviceNumber	I_UtilitiesDevice	UtilitiesLogicalDeviceNumber	Logical device number
	UtilitiesRegisterGroup	I_UtilitiesDevice	UtilitiesRegisterGroup	Register Group
	UtilsDeviceInstallationDate	I_UtilitiesDevice	UtilsDeviceInstallationDate	Installation date
	UtilsDeviceRemovalDate	I_UtilitiesDevice	UtilsDeviceRemovalDate	Device removal date
	UtilsDeviceLocation	I_UtilitiesDevice	UtilsDeviceLocation	Device Location
	UtilsDeviceGroup	I_UtilitiesDevice	UtilsDeviceGroup	Device group
	UtilsDeviceWindingGroup	I_UtilitiesDevice	UtilsDeviceWindingGroup	Winding group
	UtilitiesPrepaymentMeterType	I_UtilitiesDevice	UtilitiesPrepaymentMeterType	Prepayment Meter
	UtilsDeviceLossDetnGroup	I_UtilitiesDevice	UtilsDeviceLossDetnGroup	Loss Determination Group
	DvcePwrTrnsfrmtrTrnsfRatingVal	I_UtilitiesDevice	DvcePwrTrnsfrmtrTrnsfRatingVal	Power Transformer: Rating
	DvcePwrTrnsfrmtrPrimVoltVal	I_UtilitiesDevice	DvcePwrTrnsfrmtrPrimVoltVal	Power Transformer: Primary Voltage
	DvcePwrTrnsfrmtrSecdryVoltVal	I_UtilitiesDevice	DvcePwrTrnsfrmtrSecdryVoltVal	Power Transformer: Secondary Voltage
	AdvancedMeteringSystem	I_UtilitiesDevice	AdvancedMeteringSystem	Advanced Metering System
	AdvancedMeterCapabilityGroup	I_UtilitiesDevice	AdvancedMeterCapabilityGroup	Advanced Meter Capability Group (AMCG)
	EquipmentCategory	I_UtilitiesDevice	EquipmentCategory	Equipment category
	TechnicalObjectType	I_UtilitiesDevice	TechnicalObjectType	Type of Technical Object
	AuthorizationGroup	I_UtilitiesDevice	AuthorizationGroup	Technical Object Authorization Group
	AcquisitionDate	I_UtilitiesDevice	AcquisitionDate	Acquisition date
	AcquisitionValue	I_UtilitiesDevice	AcquisitionValue	Acquisition Value
	Currency	I_UtilitiesDevice	Currency	Valuation Crcy
	AssetManufacturerName	I_UtilitiesDevice	AssetManufacturerName	Manufacturer of Asset
	ManufacturerCountry	I_UtilitiesDevice	ManufacturerCountry	Country/Region of Manufacture
	ManufacturerSerialNumber	I_UtilitiesDevice	ManufacturerSerialNumber	Manufacturer's Serial Number
	ManufacturerPartTypeName	I_UtilitiesDevice	ManufacturerPartTypeName	Manufacturer model number
	ConstructionYear	I_UtilitiesDevice	ConstructionYear	Device Construction Year
	UtilitiesDeviceCategory	I_UtilitiesDevice	UtilitiesDeviceCategory	Device Category
	SerialNumber	I_UtilitiesDevice	SerialNumber	Serial Number
	Plant	I_UtilitiesDevice	Plant	Valuation Area
	Division	I_UtilitiesDevice	Division	Internal Division ID
	StorageLocation	I_UtilitiesDevice	StorageLocation	Storage Location
	UniqueItemIdentifier	I_UtilitiesDevice	UniqueItemIdentifier	Unique Item Identifier
	UniqueItemIdentifierStrucType	I_UtilitiesDevice	UniqueItemIdentifierStrucType	Structure Type of UII
	UniqueItemIdentifierRespPlant	I_UtilitiesDevice	UniqueItemIdentifierRespPlant	Plant Responsible for UII
	UtilsDeviceInOutGroup	I_UtilitiesDevice	UtilsDeviceInOutGroup	Input/output group
	UtilsDeviceARCRCommandGroup	I_UtilitiesDevice	UtilsDeviceARCRCommandGroup	ARCR Command Group
	UtilsDeviceSampleLot	I_UtilitiesDevice	UtilsDeviceSampleLot	Sample lot
	UtilsDeviceMeasuredPressure	I_UtilitiesDevice	UtilsDeviceMeasuredPressure	Measured Pressure (Outlet Pressure) in Bars
	UtilsDeviceTransformationRatio	I_UtilitiesDevice	UtilsDeviceTransformationRatio	Transformation ratio
	UtilsDeviceInspRelevanceCode	I_UtilitiesDevice	UtilsDeviceInspRelevanceCode	Inspection relevance of device
	UtilsDeviceCertificationYear	I_UtilitiesDevice	UtilsDeviceCertificationYear	Certification Year
	UtilsDeviceAdvncRplcmtYear	I_UtilitiesDevice	UtilsDeviceAdvncRplcmtYear	Advance replacement year
	UtilsDeviceCertfnStatus	I_UtilitiesDevice	UtilsDeviceCertfnStatus	Certification status
	SampleUtilsDeviceStatus	I_UtilitiesDevice	SampleUtilsDeviceStatus	Status of sample device
	UtilsDeviceLastLeadSealingDate	I_UtilitiesDevice	UtilsDeviceLastLeadSealingDate	Date of last lead sealing
	UtilsDeviceCertfnType	I_UtilitiesDevice	UtilsDeviceCertfnType	Type of certification
	UtilsDeviceCertificationNumber	I_UtilitiesDevice	UtilsDeviceCertificationNumber	Certification number
	UtilsDeviceModificationDate	I_UtilitiesDevice	UtilsDeviceModificationDate	Modification date
	UtilsDeviceModReason	I_UtilitiesDevice	UtilsDeviceModReason	Modification reason
	UtilsDeviceCalibrnValdtyIsUsed	I_UtilitiesDevice	UtilsDeviceCalibrnValdtyIsUsed	Use calibration validity
	UtilsDeviceParametrizationCode	I_UtilitiesDevice	UtilsDeviceParametrizationCode	Parametrization
	UtilsDeviceLeadSealingCode	I_UtilitiesDevice	UtilsDeviceLeadSealingCode	Seal code
	LastChangeDate	I_UtilitiesDevice	LastChangeDate	Last Changed On
	UtilsDeviceLastChangedByUser	I_UtilitiesDevice	UtilsDeviceLastChangedByUser	Name of Person Who Changed Object
	UtilsDeviceInspPointGroup	I_UtilitiesDevice	UtilsDeviceInspPointGroup	Inspection point group
	InstdUtilsDeviceIsCertifiable	I_UtilitiesDevice	InstdUtilsDeviceIsCertifiable	Certify installed devices
	UtilsDeviceInspectionNumber	I_UtilitiesDevice	UtilsDeviceInspectionNumber	Device inspection number
	DvceIndivCertfnValdtyInYrs	I_UtilitiesDevice	DvceIndivCertfnValdtyInYrs	Individual cal. validity (years) of dev. subject to certif.
	NmbrOfInstalledUtilsDevices			Number of Installed Devices
	_Currency	I_UtilitiesDevice	_Currency
	_Division	I_UtilitiesDevice	_Division
	_EquipmentCategory	I_UtilitiesDevice	_EquipmentCategory
	_EquipmentText	I_UtilitiesDevice	_EquipmentText
	_EquipmentTimeSeg	I_UtilitiesDevice	_EquipmentTimeSeg
	_Plant	I_UtilitiesDevice	_Plant
	_SerialNumberStockSegment	I_UtilitiesDevice	_SerialNumberStockSegment
	_StorageLocation	I_UtilitiesDevice	_StorageLocation
	_TechnicalObjectType	I_UtilitiesDevice	_TechnicalObjectType
	_UtilsAdvncdMeteringSystem	I_UtilitiesDevice	_UtilsAdvncdMeteringSystem
	_UtilsDeviceCertfnStatus	I_UtilitiesDevice	_UtilsDeviceCertfnStatus
	_UtilsDeviceCertfnType	I_UtilitiesDevice	_UtilsDeviceCertfnType
	_UtilsDeviceLastChangedByUser	I_UtilitiesDevice	_UtilsDeviceLastChangedByUser
	_UtilsDeviceModReason	I_UtilitiesDevice	_UtilsDeviceModReason
	_UtilsDvceActivityReason	I_UtilitiesDevice	_UtilsDvceActivityReason
	_UtilsDvceInspRelevance	I_UtilitiesDevice	_UtilsDvceInspRelevance
	_UtilsDvceLossDetnGroup	I_UtilitiesDevice	_UtilsDvceLossDetnGroup
	_UtilsDvceParametrization	I_UtilitiesDevice	_UtilsDvceParametrization
	_UtilsRegisterGroupInfoText	I_UtilitiesDevice	_UtilsRegisterGroupInfoText
	_UtilsSampleDeviceStatus	I_UtilitiesDevice	_UtilsSampleDeviceStatus
	_UtilsDeviceSampleLot	I_UtilitiesDevice	_UtilsDeviceSampleLot
	_UtilsDeviceCategory		_UtilsDeviceCategory
	UtilsDeviceFunctionClass	_UtilsDeviceCategory	UtilsDeviceFunctionClass	Function class
	UtilsDeviceConstructionClass	_UtilsDeviceCategory	UtilsDeviceConstructionClass	Construction class
	UtilsDeviceCategoryDescription	_UtilsDeviceCategory	UtilsDeviceCategoryDescription	Device Category Name
	UtilsDeviceCategoryPriceClass	_UtilsDeviceCategory	UtilsDeviceCategoryPriceClass	Price Class
	UtilsDevicePTIRegnNmbr	_UtilsDeviceCategory	UtilsDevicePTIRegnNmbr	PTI number
	UtilsDeviceGGWARegnNmbr	_UtilsDeviceCategory	UtilsDeviceGGWARegnNmbr	GGWA number
	UtilsDeviceCertfnRqmtType	_UtilsDeviceCategory	UtilsDeviceCertfnRqmtType	Type of certification requirement
	UtilsDvceCalibrnValdtylnYears	_UtilsDeviceCategory	UtilsDvceCalibrnValdtylnYears	Calibration validity (yrs) for ext. devs subject to certif.
	UtilsDvceIntCertfnPerdInYears	_UtilsDeviceCategory	UtilsDvceIntCertfnPerdInYears	Internal certification period (years)
	UtilsDvceCalcNextRplcmtInYears	_UtilsDeviceCategory	UtilsDvceCalcNextRplcmtInYears	Old cal. validity/int. cert. period (yrs) until prod. year
	UtilsDeviceOldCertfnInYears	_UtilsDeviceCategory	UtilsDeviceOldCertfnInYears	Prod. yr until which old calib. valid./int.insp.per.is valid
	UtilsDeviceMeasurementType	_UtilsDeviceCategory	UtilsDeviceMeasurementType	Type of measurement
	UtilsDeviceNominalLoadValue	_UtilsDeviceCategory	UtilsDeviceNominalLoadValue	Nominal load
	UtilsDeviceAdvncdMeterCat	_UtilsDeviceCategory	UtilsDeviceAdvncdMeterCat	Advanced Meter
	_UtilsDeviceFunctionClass	_UtilsDeviceCategory	_UtilsDeviceFunctionClass
	_UtilsDeviceMsmtType	_UtilsDeviceCategory	_UtilsDeviceMsmtType
	_UtilsDvceAdvncdMeterCat	_UtilsDeviceCategory	_UtilsDvceAdvncdMeterCat
	_UtilsDvceCertfnRqmtType	_UtilsDeviceCategory	_UtilsDvceCertfnRqmtType
	_UtilsDvceConstructionClass	_UtilsDeviceCategory	_UtilsDvceConstructionClass
	FunctionalLocation	_UtilsTechObjLocationAddr	FunctionalLocation	Functional Location
	_FunctionalLocation		_FunctionalLocation
	MaintenancePlant	_UtilsTechObjLocationAddr	MaintenancePlant	Maintenance Plant
	MaintenanceObjectLocation	_UtilsTechObjLocationAddr	MaintenanceObjectLocation	Location of maintenance object
	_UtilsTechObjLocationAddr		_UtilsTechObjLocationAddr
	_Address	_UtilsTechObjLocationAddr	_Address
	_Address2	_UtilsTechObjLocationAddr	_Address2
	AddressID	_UtilsTechObjLocationAddr	AddressID	Ship-to address
	CityNumber	_UtilsTechObjLocationAddr	CityNumber	City code for city/street file
	_PostalCity	_UtilsTechObjLocationAddr	_PostalCity
	Country	_UtilsTechObjLocationAddr	Country	Country/Region Key
	_Country	_UtilsTechObjLocationAddr	_Country
	Region	_UtilsTechObjLocationAddr	Region	Region (State, Province, County)
	_Region	_UtilsTechObjLocationAddr	_Region
	CountyCode	_UtilsTechObjLocationAddr	CountyCode	County code for county
	_CountyCode	_UtilsTechObjLocationAddr	_CountyCode
	CityName			City
	District			District
	DistrictName			District
	PostalCode			City postal code
	HomeCityName			City (different from postal city)
	StreetName			Street
	HouseNumber			House Number
	HouseNumberSupplementText			House number supplement
	MaintObjectLocAcctAssgmtNmbr	_UtilsTechObjLocationAddr	MaintObjectLocAcctAssgmtNmbr	Location and account assignment for technical object
	MaintenancePlanningPlant	_UtilsTechObjLocationAddr	MaintenancePlanningPlant	Maintenance Planning Plant
	MaintenancePlannerGroup	_UtilsTechObjLocationAddr	MaintenancePlannerGroup	Planner Group for Customer Service and Plant Maintenance
	AssetLocation	_UtilsTechObjLocationAddr	AssetLocation	Location of maintenance object
	ControllingArea	_UtilsTechObjLocationAddr	ControllingArea	Controlling Area
	CostCenter	_UtilsTechObjLocationAddr	CostCenter	Cost Center
	_MaintenancePlant	_UtilsTechObjLocationAddr	_Plant
	_PlanningPlant	_UtilsTechObjLocationAddr	_PlanningPlant
	_MaintenancePlanningPlant	_UtilsTechObjLocationAddr	_MaintenancePlanningPlant
	PlantName2			Name 2

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_UtilsInstalledDevice.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IEINSTALLEDDVCE
-- Parameters: P_KeyDate : e_keydate_vdm

CREATE VIEW I_UtilsInstalledDevice AS
SELECT
  I_UtilitiesDevice.UtilitiesDevice AS UtilitiesDevice,
  I_UtilitiesDevice.UtilsDeviceValidityEndDate AS UtilsDeviceValidityEndDate,
  I_UtilitiesDevice.UtilsDeviceActivityReason AS UtilsDeviceActivityReason,
  I_UtilitiesDevice.UtilsDeviceValidityStartDate AS UtilsDeviceValidityStartDate,
  I_UtilitiesDevice.UtilsDeviceBscCatCombination AS UtilsDeviceBscCatCombination,
  I_UtilitiesDevice.UtilitiesLogicalDeviceNumber AS UtilitiesLogicalDeviceNumber,
  I_UtilitiesDevice.UtilitiesRegisterGroup AS UtilitiesRegisterGroup,
  I_UtilitiesDevice.UtilsDeviceInstallationDate AS UtilsDeviceInstallationDate,
  I_UtilitiesDevice.UtilsDeviceRemovalDate AS UtilsDeviceRemovalDate,
  I_UtilitiesDevice.UtilsDeviceLocation AS UtilsDeviceLocation,
  I_UtilitiesDevice.UtilsDeviceGroup AS UtilsDeviceGroup,
  I_UtilitiesDevice.UtilsDeviceWindingGroup AS UtilsDeviceWindingGroup,
  I_UtilitiesDevice.UtilitiesPrepaymentMeterType AS UtilitiesPrepaymentMeterType,
  I_UtilitiesDevice.UtilsDeviceLossDetnGroup AS UtilsDeviceLossDetnGroup,
  I_UtilitiesDevice.DvcePwrTrnsfrmtrTrnsfRatingVal AS DvcePwrTrnsfrmtrTrnsfRatingVal,
  I_UtilitiesDevice.DvcePwrTrnsfrmtrPrimVoltVal AS DvcePwrTrnsfrmtrPrimVoltVal,
  I_UtilitiesDevice.DvcePwrTrnsfrmtrSecdryVoltVal AS DvcePwrTrnsfrmtrSecdryVoltVal,
  I_UtilitiesDevice.AdvancedMeteringSystem AS AdvancedMeteringSystem,
  I_UtilitiesDevice.AdvancedMeterCapabilityGroup AS AdvancedMeterCapabilityGroup,
  I_UtilitiesDevice.EquipmentCategory AS EquipmentCategory,
  I_UtilitiesDevice.TechnicalObjectType AS TechnicalObjectType,
  I_UtilitiesDevice.AuthorizationGroup AS AuthorizationGroup,
  I_UtilitiesDevice.AcquisitionDate AS AcquisitionDate,
  I_UtilitiesDevice.AcquisitionValue AS AcquisitionValue,
  I_UtilitiesDevice.Currency AS Currency,
  I_UtilitiesDevice.AssetManufacturerName AS AssetManufacturerName,
  I_UtilitiesDevice.ManufacturerCountry AS ManufacturerCountry,
  I_UtilitiesDevice.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  I_UtilitiesDevice.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  I_UtilitiesDevice.ConstructionYear AS ConstructionYear,
  I_UtilitiesDevice.UtilitiesDeviceCategory AS UtilitiesDeviceCategory,
  I_UtilitiesDevice.SerialNumber AS SerialNumber,
  I_UtilitiesDevice.Plant AS Plant,
  I_UtilitiesDevice.Division AS Division,
  I_UtilitiesDevice.StorageLocation AS StorageLocation,
  I_UtilitiesDevice.UniqueItemIdentifier AS UniqueItemIdentifier,
  I_UtilitiesDevice.UniqueItemIdentifierStrucType AS UniqueItemIdentifierStrucType,
  I_UtilitiesDevice.UniqueItemIdentifierRespPlant AS UniqueItemIdentifierRespPlant,
  I_UtilitiesDevice.UtilsDeviceInOutGroup AS UtilsDeviceInOutGroup,
  I_UtilitiesDevice.UtilsDeviceARCRCommandGroup AS UtilsDeviceARCRCommandGroup,
  I_UtilitiesDevice.UtilsDeviceSampleLot AS UtilsDeviceSampleLot,
  I_UtilitiesDevice.UtilsDeviceMeasuredPressure AS UtilsDeviceMeasuredPressure,
  I_UtilitiesDevice.UtilsDeviceTransformationRatio AS UtilsDeviceTransformationRatio,
  I_UtilitiesDevice.UtilsDeviceInspRelevanceCode AS UtilsDeviceInspRelevanceCode,
  I_UtilitiesDevice.UtilsDeviceCertificationYear AS UtilsDeviceCertificationYear,
  I_UtilitiesDevice.UtilsDeviceAdvncRplcmtYear AS UtilsDeviceAdvncRplcmtYear,
  I_UtilitiesDevice.UtilsDeviceCertfnStatus AS UtilsDeviceCertfnStatus,
  I_UtilitiesDevice.SampleUtilsDeviceStatus AS SampleUtilsDeviceStatus,
  I_UtilitiesDevice.UtilsDeviceLastLeadSealingDate AS UtilsDeviceLastLeadSealingDate,
  I_UtilitiesDevice.UtilsDeviceCertfnType AS UtilsDeviceCertfnType,
  I_UtilitiesDevice.UtilsDeviceCertificationNumber AS UtilsDeviceCertificationNumber,
  I_UtilitiesDevice.UtilsDeviceModificationDate AS UtilsDeviceModificationDate,
  I_UtilitiesDevice.UtilsDeviceModReason AS UtilsDeviceModReason,
  I_UtilitiesDevice.UtilsDeviceCalibrnValdtyIsUsed AS UtilsDeviceCalibrnValdtyIsUsed,
  I_UtilitiesDevice.UtilsDeviceParametrizationCode AS UtilsDeviceParametrizationCode,
  I_UtilitiesDevice.UtilsDeviceLeadSealingCode AS UtilsDeviceLeadSealingCode,
  I_UtilitiesDevice.LastChangeDate AS LastChangeDate,
  I_UtilitiesDevice.UtilsDeviceLastChangedByUser AS UtilsDeviceLastChangedByUser,
  I_UtilitiesDevice.UtilsDeviceInspPointGroup AS UtilsDeviceInspPointGroup,
  I_UtilitiesDevice.InstdUtilsDeviceIsCertifiable AS InstdUtilsDeviceIsCertifiable,
  I_UtilitiesDevice.UtilsDeviceInspectionNumber AS UtilsDeviceInspectionNumber,
  I_UtilitiesDevice.DvceIndivCertfnValdtyInYrs AS DvceIndivCertfnValdtyInYrs,
  cast (1 as e_inst_devices_vdm ) AS NmbrOfInstalledUtilsDevices,
  I_UtilitiesDevice._Currency AS _Currency,
  I_UtilitiesDevice._Division AS _Division,
  I_UtilitiesDevice._EquipmentCategory AS _EquipmentCategory,
  I_UtilitiesDevice._EquipmentText AS _EquipmentText,
  I_UtilitiesDevice._EquipmentTimeSeg AS _EquipmentTimeSeg,
  I_UtilitiesDevice._Plant AS _Plant,
  I_UtilitiesDevice._SerialNumberStockSegment AS _SerialNumberStockSegment,
  I_UtilitiesDevice._StorageLocation AS _StorageLocation,
  I_UtilitiesDevice._TechnicalObjectType AS _TechnicalObjectType,
  I_UtilitiesDevice._UtilsAdvncdMeteringSystem AS _UtilsAdvncdMeteringSystem,
  I_UtilitiesDevice._UtilsDeviceCertfnStatus AS _UtilsDeviceCertfnStatus,
  I_UtilitiesDevice._UtilsDeviceCertfnType AS _UtilsDeviceCertfnType,
  I_UtilitiesDevice._UtilsDeviceLastChangedByUser AS _UtilsDeviceLastChangedByUser,
  I_UtilitiesDevice._UtilsDeviceModReason AS _UtilsDeviceModReason,
  I_UtilitiesDevice._UtilsDvceActivityReason AS _UtilsDvceActivityReason,
  I_UtilitiesDevice._UtilsDvceInspRelevance AS _UtilsDvceInspRelevance,
  I_UtilitiesDevice._UtilsDvceLossDetnGroup AS _UtilsDvceLossDetnGroup,
  I_UtilitiesDevice._UtilsDvceParametrization AS _UtilsDvceParametrization,
  I_UtilitiesDevice._UtilsRegisterGroupInfoText AS _UtilsRegisterGroupInfoText,
  I_UtilitiesDevice._UtilsSampleDeviceStatus AS _UtilsSampleDeviceStatus,
  I_UtilitiesDevice._UtilsDeviceSampleLot AS _UtilsDeviceSampleLot,
  _UtilsDeviceCategory.UtilsDeviceFunctionClass AS UtilsDeviceFunctionClass,
  _UtilsDeviceCategory.UtilsDeviceConstructionClass AS UtilsDeviceConstructionClass,
  _UtilsDeviceCategory.UtilsDeviceCategoryDescription AS UtilsDeviceCategoryDescription,
  _UtilsDeviceCategory.UtilsDeviceCategoryPriceClass AS UtilsDeviceCategoryPriceClass,
  _UtilsDeviceCategory.UtilsDevicePTIRegnNmbr AS UtilsDevicePTIRegnNmbr,
  _UtilsDeviceCategory.UtilsDeviceGGWARegnNmbr AS UtilsDeviceGGWARegnNmbr,
  _UtilsDeviceCategory.UtilsDeviceCertfnRqmtType AS UtilsDeviceCertfnRqmtType,
  _UtilsDeviceCategory.UtilsDvceCalibrnValdtylnYears AS UtilsDvceCalibrnValdtylnYears,
  _UtilsDeviceCategory.UtilsDvceIntCertfnPerdInYears AS UtilsDvceIntCertfnPerdInYears,
  _UtilsDeviceCategory.UtilsDvceCalcNextRplcmtInYears AS UtilsDvceCalcNextRplcmtInYears,
  _UtilsDeviceCategory.UtilsDeviceOldCertfnInYears AS UtilsDeviceOldCertfnInYears,
  _UtilsDeviceCategory.UtilsDeviceMeasurementType AS UtilsDeviceMeasurementType,
  _UtilsDeviceCategory.UtilsDeviceNominalLoadValue AS UtilsDeviceNominalLoadValue,
  _UtilsDeviceCategory.UtilsDeviceAdvncdMeterCat AS UtilsDeviceAdvncdMeterCat,
  _UtilsDeviceCategory._UtilsDeviceFunctionClass AS _UtilsDeviceFunctionClass,
  _UtilsDeviceCategory._UtilsDeviceMsmtType AS _UtilsDeviceMsmtType,
  _UtilsDeviceCategory._UtilsDvceAdvncdMeterCat AS _UtilsDvceAdvncdMeterCat,
  _UtilsDeviceCategory._UtilsDvceCertfnRqmtType AS _UtilsDvceCertfnRqmtType,
  _UtilsDeviceCategory._UtilsDvceConstructionClass AS _UtilsDvceConstructionClass,
  _UtilsTechObjLocationAddr.FunctionalLocation AS FunctionalLocation,
  _UtilsTechObjLocationAddr.MaintenancePlant AS MaintenancePlant,
  _UtilsTechObjLocationAddr.MaintenanceObjectLocation AS MaintenanceObjectLocation,
  _UtilsTechObjLocationAddr._Address AS _Address,
  _UtilsTechObjLocationAddr._Address2 AS _Address2,
  _UtilsTechObjLocationAddr.AddressID AS AddressID,
  _UtilsTechObjLocationAddr.CityNumber AS CityNumber,
  _UtilsTechObjLocationAddr._PostalCity AS _PostalCity,
  _UtilsTechObjLocationAddr.Country AS Country,
  _UtilsTechObjLocationAddr._Country AS _Country,
  _UtilsTechObjLocationAddr.Region AS Region,
  _UtilsTechObjLocationAddr._Region AS _Region,
  _UtilsTechObjLocationAddr.CountyCode AS CountyCode,
  _UtilsTechObjLocationAddr._CountyCode AS _CountyCode,
  _UtilsTechObjLocationAddr._Address2.CityName AS CityName,
  _UtilsTechObjLocationAddr._Address.District AS District,
  _UtilsTechObjLocationAddr._Address2.DistrictName AS DistrictName,
  _UtilsTechObjLocationAddr._Address2.PostalCode AS PostalCode,
  _UtilsTechObjLocationAddr._Address2.VillageName AS HomeCityName,
  _UtilsTechObjLocationAddr._Address2.StreetName AS StreetName,
  _UtilsTechObjLocationAddr._Address2.HouseNumber AS HouseNumber,
  _UtilsTechObjLocationAddr._Address2.HouseNumberSupplementText AS HouseNumberSupplementText,
  _UtilsTechObjLocationAddr.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  _UtilsTechObjLocationAddr.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _UtilsTechObjLocationAddr.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _UtilsTechObjLocationAddr.AssetLocation AS AssetLocation,
  _UtilsTechObjLocationAddr.ControllingArea AS ControllingArea,
  _UtilsTechObjLocationAddr.CostCenter AS CostCenter,
  _UtilsTechObjLocationAddr._Plant AS _MaintenancePlant,
  _UtilsTechObjLocationAddr._PlanningPlant AS _PlanningPlant,
  _UtilsTechObjLocationAddr._MaintenancePlanningPlant AS _MaintenancePlanningPlant,
  _UtilsTechObjLocationAddr._MaintenancePlanningPlant.PlantName2 AS PlantName2
FROM I_UtilitiesDevice
LEFT OUTER JOIN I_UtilsDeviceCategory AS _UtilsDeviceCategory ON UtilitiesDeviceCategory = _UtilsDeviceCategory.UtilitiesDeviceCategory  -- association [1..1]
LEFT OUTER JOIN I_UtilsTechObjLocationAddr AS _UtilsTechObjLocationAddr ON UtilsDeviceLocation = _UtilsTechObjLocationAddr.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN E_UtilitiesDeviceHeader AS _UtilsDeviceHeaderExtension ON UtilitiesDevice = _UtilsDeviceHeaderExtension.Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON functionallocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
;

Depth:

I_UtilsInstalledDevice view

I_UtilitiesDevice view

C_UtilsInstalledDeviceQuery view