What is I_UtilsBillgReltdInstdDvceIR in SAP S/4HANA?

I_UtilsBillgReltdInstdDvceIR is a composite CDS view in SAP S/4HANA. Billing Related Installed Device Info Record - Cube It contains 115 fields.

Which tables does I_UtilsBillgReltdInstdDvceIR read from?

I_UtilsBillgReltdInstdDvceIR reads data from: I_UtilsInfoRecdHistAndInst.

What VDM layer is I_UtilsBillgReltdInstdDvceIR?

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

I_UtilsBillgReltdInstdDvceIR

DDL: I_UTILSBILLGRELTDINSTDDVCEIR SQL: IEBILLGRIDVCEIR Type: view COMPOSITE

115 Fields 1 Data Sources 4 Associations

Billing Related Installed Device Info Record - Cube

I_UtilsBillgReltdInstdDvceIR (Composite)

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

Utilities

I_UtilsBillgReltdInstdDvceIR is a Composite CDS View (Cube) that provides data about "Billing Related Installed Device Info Record - Cube" in SAP S/4HANA. It reads from 1 data source (I_UtilsInfoRecdHistAndInst) and exposes 115 fields with key fields UtilitiesInstallation, UtilitiesLogicalDeviceNumber, UtilitiesDeviceInfoRecord. 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 cube provides the prerequisites for answering the following business question:</p> <ul><li><p>How many and which device information records are in use?</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_UtilsInfoRecdHistAndInst	I_UtilsInfoRecdHistAndInst	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]	E_UtilsDvceInfoRecordHistory	_InfoRecordHistoryExtension	`$projection.UtilitiesDeviceInfoRecord = _InfoRecordHistoryExtension.UtilitiesDeviceInfoRecord and $projection.UtilsDeviceValidityEndDate = _InfoRecordHistoryExtension.UtilsDeviceValidityEndDate`
[0..1]	E_UtilitiesInstallation	_UtilsInstallationExtension	`$projection.UtilitiesInstallation = _UtilsInstallationExtension.UtilitiesInstallation`
[0..1]	E_UtilitiesInstallationHist	_UtilsInstallHistExtension	`$projection.UtilitiesInstallation = _UtilsInstallHistExtension.UtilitiesInstallation and $projection.UtilsInstHistValidityEndDate = _UtilsInstallHistExtension.UtilsInstHistValidityEndDate`

Annotations (13)

Name	Value	Level
EndUserText.label	Billing Related Installed Device Info Record - Cube	view
Analytics.dataCategory	#CUBE	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.sqlViewName	IEBILLGRIDVCEIR	view
ObjectModel.usageType.serviceQuality	C	view
ObjectModel.usageType.sizeCategory	L	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 (115)

Key	Field	Source Table	Source Field	Description
KEY	UtilitiesInstallation	I_UtilsInfoRecdHistAndInst	UtilitiesInstallation	Installation
KEY	UtilitiesLogicalDeviceNumber	I_UtilsInfoRecdHistAndInst	UtilitiesLogicalDeviceNumber	Logical device number
KEY	UtilitiesDeviceInfoRecord	I_UtilsInfoRecdHistAndInst	UtilitiesDeviceInfoRecord	Equipment Number
	UtilsDvceRateDataValdtyEndDte	I_UtilsInfoRecdHistAndInst	UtilsDvceRateDataValdtyEndDte	Validity End Date of Device Rate Data
	UtilsDvceRateDataValdtyStrtDte	I_UtilsInfoRecdHistAndInst	UtilsDvceRateDataValdtyStrtDte	Validity Start Date of Device Rate Data
	UtilsDevicePriceClass	I_UtilsInfoRecdHistAndInst	UtilsDevicePriceClass	Price Class
	UtilsDvceIsRelevantForRntlPrc	I_UtilsInfoRecdHistAndInst	UtilsDvceIsRelevantForRntlPrc	Pay rental price
	UtilsDeviceRateType	I_UtilsInfoRecdHistAndInst	UtilsDeviceRateType	Rate Type
	UtilsDeviceRateFactGroup	I_UtilsInfoRecdHistAndInst	UtilsDeviceRateFactGroup	Rate fact group
	UtilsDvceIsNotBillingRelevant	I_UtilsInfoRecdHistAndInst	UtilsDvceIsNotBillingRelevant	Device Not Relevant for Billing
	UtilsDeviceValidityEndDate	I_UtilsInfoRecdHistAndInst	UtilsDeviceValidityEndDate	Validity End Date of Device
	UtilsDeviceValidityStartDate	I_UtilsInfoRecdHistAndInst	UtilsDeviceValidityStartDate	Validity Start Date of Device
	UtilitiesRegisterGroup	I_UtilsInfoRecdHistAndInst	UtilitiesRegisterGroup	Register Group
	UtilitiesDeviceCategory	I_UtilsInfoRecdHistAndInst	UtilitiesDeviceCategory	Device Category
	UtilsDeviceBscCatCombination	I_UtilsInfoRecdHistAndInst	UtilsDeviceBscCatCombination	Combination of a device category
	UtilsDeviceInstallationDate	I_UtilsInfoRecdHistAndInst	UtilsDeviceInstallationDate	Installation date
	UtilsDeviceRemovalDate	I_UtilsInfoRecdHistAndInst	UtilsDeviceRemovalDate	Device removal date
	UtilsDeviceGroup	I_UtilsInfoRecdHistAndInst	UtilsDeviceGroup	Device group
	UtilitiesPrepaymentMeterType	I_UtilsInfoRecdHistAndInst	UtilitiesPrepaymentMeterType	Prepayment Meter
	UtilsDeviceLossDetnGroup	I_UtilsInfoRecdHistAndInst	UtilsDeviceLossDetnGroup	Loss Determination Group
	DvcePwrTrnsfrmtrPrimVoltVal	I_UtilsInfoRecdHistAndInst	DvcePwrTrnsfrmtrPrimVoltVal	Power Transformer: Rating
	DvcePwrTrnsfrmtrSecdryVoltVal	I_UtilsInfoRecdHistAndInst	DvcePwrTrnsfrmtrSecdryVoltVal	Power Transformer: Primary Voltage
	DvcePwrTrnsfrmtrTrnsfRatingVal	I_UtilsInfoRecdHistAndInst	DvcePwrTrnsfrmtrTrnsfRatingVal	Power Transformer: Secondary Voltage
	AdvancedMeteringSystem	I_UtilsInfoRecdHistAndInst	AdvancedMeteringSystem	Advanced Metering System
	AdvancedMeterCapabilityGroup	I_UtilsInfoRecdHistAndInst	AdvancedMeterCapabilityGroup	Advanced Meter Capability Group (AMCG)
	UniqueItemIdentifier	I_UtilsInfoRecdHistAndInst	UniqueItemIdentifier	Unique Item Identifier
	UtilsDeviceInfoRecdSrvcPrvd	I_UtilsInfoRecdHistAndInst	UtilsDeviceInfoRecdSrvcPrvd	Service Provider for Device Info Record
	SerialNumber	I_UtilsInfoRecdHistAndInst	SerialNumber	Serial Number
	UtilitiesInstallationType	I_UtilsInfoRecdHistAndInst	UtilitiesInstallationType	Installation type
	UtilitiesInstVoltageLevel	I_UtilsInfoRecdHistAndInst	UtilitiesInstVoltageLevel	Voltage Level
	UtilitiesInstGasPrssrLvl	I_UtilsInfoRecdHistAndInst	UtilitiesInstGasPrssrLvl	Gas Pressure Level at Installation Level (Grid)
	UtilsInstTimeZone	I_UtilsInfoRecdHistAndInst	UtilsInstTimeZone	Time Zone for EDM Objects
	UtilsInstGuarOfSupReason	I_UtilsInfoRecdHistAndInst	UtilsInstGuarOfSupReason	Reason for guarantee of supply
	UtilsInstDeregulationSts	I_UtilsInfoRecdHistAndInst	UtilsInstDeregulationSts	Deregulation status
	UtilsInstDataReleaseStatus	I_UtilsInfoRecdHistAndInst	UtilsInstDataReleaseStatus	Release Status for Installation Data
	UtilitiesSrvcProviderRole	I_UtilsInfoRecdHistAndInst	UtilitiesSrvcProviderRole	Service Type
	UtilsInstIsForEnergyFeedIn	I_UtilsInfoRecdHistAndInst	UtilsInstIsForEnergyFeedIn	Purchase
	UtilsInstCreationDate	I_UtilsInfoRecdHistAndInst	UtilsInstCreationDate	Record Created On
	UtilsInstCreatedByUser	I_UtilsInfoRecdHistAndInst	UtilsInstCreatedByUser	Name of Person Responsible for Creating the Object
	UtilsInstLastChangeDate	I_UtilsInfoRecdHistAndInst	UtilsInstLastChangeDate	Last Changed On
	UtilsInstLastChangedByUser	I_UtilsInfoRecdHistAndInst	UtilsInstLastChangedByUser	Name of Person Who Changed Object
	MeterReadingBlockingReason	I_UtilsInfoRecdHistAndInst	MeterReadingBlockingReason	Reason for blocking meter reading
	MeterReadingBasePeriodCat	I_UtilsInfoRecdHistAndInst	MeterReadingBasePeriodCat	Base period category
	NmbrOfAllwdMtrRdngsCntrlCode	I_UtilsInfoRecdHistAndInst	NmbrOfAllwdMtrRdngsCntrlCode	Control of perm. number of cust. MRs and autom. estimations
	IsMarkedForDeletion	I_UtilsInfoRecdHistAndInst	IsMarkedForDeletion	Deletion Indicator
	UtilitiesPremise	I_UtilsInfoRecdHistAndInst	UtilitiesPremise	Premise
	AuthorizationGroup	I_UtilsInfoRecdHistAndInst	AuthorizationGroup	Authorization Group
	UtilsInfoRecdAuthorizationGrp	I_UtilsInfoRecdHistAndInst	UtilsInfoRecdAuthorizationGrp	Technical Object Authorization Group
	Division	I_UtilsInfoRecdHistAndInst	Division	Internal Division ID
	_Division	I_UtilsInfoRecdHistAndInst	_Division
	_UtilsInstallationType	I_UtilsInfoRecdHistAndInst	_UtilsInstallationType
	_UtilsInstCreatedByUser	I_UtilsInfoRecdHistAndInst	_UtilsInstCreatedByUser
	_UtilsInstDataReleaseSts	I_UtilsInfoRecdHistAndInst	_UtilsInstDataReleaseSts
	_UtilsInstDeregulationSts	I_UtilsInfoRecdHistAndInst	_UtilsInstDeregulationSts
	_UtilsInstGasPressureLvl	I_UtilsInfoRecdHistAndInst	_UtilsInstGasPressureLvl
	_UtilsInstGuarOfSupRsn	I_UtilsInfoRecdHistAndInst	_UtilsInstGuarOfSupRsn
	_UtilsInstLastChangedByUser	I_UtilsInfoRecdHistAndInst	_UtilsInstLastChangedByUser
	_UtilsInstVltgLevel	I_UtilsInfoRecdHistAndInst	_UtilsInstVltgLevel
	_UtilsMtrRdngBasePerdCat	I_UtilsInfoRecdHistAndInst	_UtilsMtrRdngBasePerdCat
	_UtilsMtrRdngBlockReason	I_UtilsInfoRecdHistAndInst	_UtilsMtrRdngBlockReason
	_UtilsNmbrOfAllwdMRCtrlCode	I_UtilsInfoRecdHistAndInst	_UtilsNmbrOfAllwdMRCtrlCode
	_UtilsServiceProviderRole	I_UtilsInfoRecdHistAndInst	_UtilsServiceProviderRole
	UtilsInstHistValidityEndDate	I_UtilsInfoRecdHistAndInst	UtilsInstHistValidityEndDate	Validity End Date of Installation
	UtilsInstHistValidityStartDate	I_UtilsInfoRecdHistAndInst	UtilsInstHistValidityStartDate	Validity Start Date of Installation
	UtilitiesRateCategory	I_UtilsInfoRecdHistAndInst	UtilitiesRateCategory	Rate Category
	UtilitiesBillingSchema	I_UtilsInfoRecdHistAndInst	UtilitiesBillingSchema	Number of the billing schema
	UtilitiesBillingClass	I_UtilsInfoRecdHistAndInst	UtilitiesBillingClass	Billing Class
	MeterReadingUnit	I_UtilsInfoRecdHistAndInst	MeterReadingUnit	Meter Reading Unit
	UtilitiesTemperatureArea	I_UtilsInfoRecdHistAndInst	UtilitiesTemperatureArea	Temperature area
	UtilsInstIsExmptFrmFrnchsFee	I_UtilsInfoRecdHistAndInst	UtilsInstIsExmptFrmFrnchsFee	Exempt from franchise fee
	UtilsInstDvceAllctnIsNotAllwd	I_UtilsInfoRecdHistAndInst	UtilsInstDvceAllctnIsNotAllwd	Device allocation is not possible
	UtilitiesFranchiseContract	I_UtilsInfoRecdHistAndInst	UtilitiesFranchiseContract	Franchise contract
	UtilitiesBillingParty	I_UtilsInfoRecdHistAndInst	UtilitiesBillingParty	Service Provider that Bills the Installation
	UtilitiesInvoicingParty	I_UtilsInfoRecdHistAndInst	UtilitiesInvoicingParty	Service Provider That Invoices the Contract
	ObligatorySupUtilsSrvcProvider	I_UtilsInfoRecdHistAndInst	ObligatorySupUtilsSrvcProvider	Obligation to Supply
	PrimaryUtilitiesInstallation	I_UtilsInfoRecdHistAndInst	PrimaryUtilitiesInstallation	Key of Primary Installation
	UtilsInstallationGroupRole	I_UtilsInfoRecdHistAndInst	UtilsInstallationGroupRole	Role of an Installation Within the Installation Group
	UtilsInstallationGroupType	I_UtilsInfoRecdHistAndInst	UtilsInstallationGroupType	Grouping Type for Installation Group
	HigherLevelUtilsInstallation	I_UtilsInfoRecdHistAndInst	HigherLevelUtilsInstallation	Higher-Level Installation
	UnbilldRevnXtrapltnType	I_UtilsInfoRecdHistAndInst	UnbilldRevnXtrapltnType	Type of extrapolation in unbilled revenue reporting
	UtilsRegDepdntValdtnGroup	I_UtilsInfoRecdHistAndInst	UtilsRegDepdntValdtnGroup	Validation group for dependent validations
	_UtilsBillingClass	I_UtilsInfoRecdHistAndInst	_UtilsBillingClass
	_UtilsDepdntValdtnGroup	I_UtilsInfoRecdHistAndInst	_UtilsDepdntValdtnGroup
	_UtilsInstGroupRole	I_UtilsInfoRecdHistAndInst	_UtilsInstGroupRole
	_UtilsInstGroupType	I_UtilsInfoRecdHistAndInst	_UtilsInstGroupType
	_UtilsTemperatureArea	I_UtilsInfoRecdHistAndInst	_UtilsTemperatureArea
	_UtilsUnbilldRevnXtrapltnType	I_UtilsInfoRecdHistAndInst	_UtilsUnbilldRevnXtrapltnType
	_UtilitiesInstallation	I_UtilsInfoRecdHistAndInst	_UtilitiesInstallation
	_UtilsAdvncdMeteringSystem	I_UtilsInfoRecdHistAndInst	_UtilsAdvncdMeteringSystem
	_UtilsDevicePriceClass	I_UtilsInfoRecdHistAndInst	_UtilsDevicePriceClass
	_UtilsDeviceRateFactGrp	I_UtilsInfoRecdHistAndInst	_UtilsDeviceRateFactGrp
	_UtilsDeviceRateType	I_UtilsInfoRecdHistAndInst	_UtilsDeviceRateType
	_UtilsDvceLossDetnGroup	I_UtilsInfoRecdHistAndInst	_UtilsDvceLossDetnGroup
	_UtilsRegisterGroupInfoText	I_UtilsInfoRecdHistAndInst	_UtilsRegisterGroupInfoText
	_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
	NmbrOfBillgReltdInstdInfoRecd			Number of Installed Billing-Relevant Device Info Records

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_UtilsBillgReltdInstdDvceIR.
-- 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: IEBILLGRIDVCEIR
-- Parameters: P_KeyDate : e_keydate_vdm

CREATE VIEW I_UtilsBillgReltdInstdDvceIR AS
SELECT
  I_UtilsInfoRecdHistAndInst.UtilitiesInstallation AS UtilitiesInstallation,
  I_UtilsInfoRecdHistAndInst.UtilitiesLogicalDeviceNumber AS UtilitiesLogicalDeviceNumber,
  I_UtilsInfoRecdHistAndInst.UtilitiesDeviceInfoRecord AS UtilitiesDeviceInfoRecord,
  I_UtilsInfoRecdHistAndInst.UtilsDvceRateDataValdtyEndDte AS UtilsDvceRateDataValdtyEndDte,
  I_UtilsInfoRecdHistAndInst.UtilsDvceRateDataValdtyStrtDte AS UtilsDvceRateDataValdtyStrtDte,
  I_UtilsInfoRecdHistAndInst.UtilsDevicePriceClass AS UtilsDevicePriceClass,
  I_UtilsInfoRecdHistAndInst.UtilsDvceIsRelevantForRntlPrc AS UtilsDvceIsRelevantForRntlPrc,
  I_UtilsInfoRecdHistAndInst.UtilsDeviceRateType AS UtilsDeviceRateType,
  I_UtilsInfoRecdHistAndInst.UtilsDeviceRateFactGroup AS UtilsDeviceRateFactGroup,
  I_UtilsInfoRecdHistAndInst.UtilsDvceIsNotBillingRelevant AS UtilsDvceIsNotBillingRelevant,
  I_UtilsInfoRecdHistAndInst.UtilsDeviceValidityEndDate AS UtilsDeviceValidityEndDate,
  I_UtilsInfoRecdHistAndInst.UtilsDeviceValidityStartDate AS UtilsDeviceValidityStartDate,
  I_UtilsInfoRecdHistAndInst.UtilitiesRegisterGroup AS UtilitiesRegisterGroup,
  I_UtilsInfoRecdHistAndInst.UtilitiesDeviceCategory AS UtilitiesDeviceCategory,
  I_UtilsInfoRecdHistAndInst.UtilsDeviceBscCatCombination AS UtilsDeviceBscCatCombination,
  I_UtilsInfoRecdHistAndInst.UtilsDeviceInstallationDate AS UtilsDeviceInstallationDate,
  I_UtilsInfoRecdHistAndInst.UtilsDeviceRemovalDate AS UtilsDeviceRemovalDate,
  I_UtilsInfoRecdHistAndInst.UtilsDeviceGroup AS UtilsDeviceGroup,
  I_UtilsInfoRecdHistAndInst.UtilitiesPrepaymentMeterType AS UtilitiesPrepaymentMeterType,
  I_UtilsInfoRecdHistAndInst.UtilsDeviceLossDetnGroup AS UtilsDeviceLossDetnGroup,
  I_UtilsInfoRecdHistAndInst.DvcePwrTrnsfrmtrPrimVoltVal AS DvcePwrTrnsfrmtrPrimVoltVal,
  I_UtilsInfoRecdHistAndInst.DvcePwrTrnsfrmtrSecdryVoltVal AS DvcePwrTrnsfrmtrSecdryVoltVal,
  I_UtilsInfoRecdHistAndInst.DvcePwrTrnsfrmtrTrnsfRatingVal AS DvcePwrTrnsfrmtrTrnsfRatingVal,
  I_UtilsInfoRecdHistAndInst.AdvancedMeteringSystem AS AdvancedMeteringSystem,
  I_UtilsInfoRecdHistAndInst.AdvancedMeterCapabilityGroup AS AdvancedMeterCapabilityGroup,
  I_UtilsInfoRecdHistAndInst.UniqueItemIdentifier AS UniqueItemIdentifier,
  I_UtilsInfoRecdHistAndInst.UtilsDeviceInfoRecdSrvcPrvd AS UtilsDeviceInfoRecdSrvcPrvd,
  I_UtilsInfoRecdHistAndInst.SerialNumber AS SerialNumber,
  I_UtilsInfoRecdHistAndInst.UtilitiesInstallationType AS UtilitiesInstallationType,
  I_UtilsInfoRecdHistAndInst.UtilitiesInstVoltageLevel AS UtilitiesInstVoltageLevel,
  I_UtilsInfoRecdHistAndInst.UtilitiesInstGasPrssrLvl AS UtilitiesInstGasPrssrLvl,
  I_UtilsInfoRecdHistAndInst.UtilsInstTimeZone AS UtilsInstTimeZone,
  I_UtilsInfoRecdHistAndInst.UtilsInstGuarOfSupReason AS UtilsInstGuarOfSupReason,
  I_UtilsInfoRecdHistAndInst.UtilsInstDeregulationSts AS UtilsInstDeregulationSts,
  I_UtilsInfoRecdHistAndInst.UtilsInstDataReleaseStatus AS UtilsInstDataReleaseStatus,
  I_UtilsInfoRecdHistAndInst.UtilitiesSrvcProviderRole AS UtilitiesSrvcProviderRole,
  I_UtilsInfoRecdHistAndInst.UtilsInstIsForEnergyFeedIn AS UtilsInstIsForEnergyFeedIn,
  I_UtilsInfoRecdHistAndInst.UtilsInstCreationDate AS UtilsInstCreationDate,
  I_UtilsInfoRecdHistAndInst.UtilsInstCreatedByUser AS UtilsInstCreatedByUser,
  I_UtilsInfoRecdHistAndInst.UtilsInstLastChangeDate AS UtilsInstLastChangeDate,
  I_UtilsInfoRecdHistAndInst.UtilsInstLastChangedByUser AS UtilsInstLastChangedByUser,
  I_UtilsInfoRecdHistAndInst.MeterReadingBlockingReason AS MeterReadingBlockingReason,
  I_UtilsInfoRecdHistAndInst.MeterReadingBasePeriodCat AS MeterReadingBasePeriodCat,
  I_UtilsInfoRecdHistAndInst.NmbrOfAllwdMtrRdngsCntrlCode AS NmbrOfAllwdMtrRdngsCntrlCode,
  I_UtilsInfoRecdHistAndInst.IsMarkedForDeletion AS IsMarkedForDeletion,
  I_UtilsInfoRecdHistAndInst.UtilitiesPremise AS UtilitiesPremise,
  I_UtilsInfoRecdHistAndInst.AuthorizationGroup AS AuthorizationGroup,
  I_UtilsInfoRecdHistAndInst.UtilsInfoRecdAuthorizationGrp AS UtilsInfoRecdAuthorizationGrp,
  I_UtilsInfoRecdHistAndInst.Division AS Division,
  I_UtilsInfoRecdHistAndInst._Division AS _Division,
  I_UtilsInfoRecdHistAndInst._UtilsInstallationType AS _UtilsInstallationType,
  I_UtilsInfoRecdHistAndInst._UtilsInstCreatedByUser AS _UtilsInstCreatedByUser,
  I_UtilsInfoRecdHistAndInst._UtilsInstDataReleaseSts AS _UtilsInstDataReleaseSts,
  I_UtilsInfoRecdHistAndInst._UtilsInstDeregulationSts AS _UtilsInstDeregulationSts,
  I_UtilsInfoRecdHistAndInst._UtilsInstGasPressureLvl AS _UtilsInstGasPressureLvl,
  I_UtilsInfoRecdHistAndInst._UtilsInstGuarOfSupRsn AS _UtilsInstGuarOfSupRsn,
  I_UtilsInfoRecdHistAndInst._UtilsInstLastChangedByUser AS _UtilsInstLastChangedByUser,
  I_UtilsInfoRecdHistAndInst._UtilsInstVltgLevel AS _UtilsInstVltgLevel,
  I_UtilsInfoRecdHistAndInst._UtilsMtrRdngBasePerdCat AS _UtilsMtrRdngBasePerdCat,
  I_UtilsInfoRecdHistAndInst._UtilsMtrRdngBlockReason AS _UtilsMtrRdngBlockReason,
  I_UtilsInfoRecdHistAndInst._UtilsNmbrOfAllwdMRCtrlCode AS _UtilsNmbrOfAllwdMRCtrlCode,
  I_UtilsInfoRecdHistAndInst._UtilsServiceProviderRole AS _UtilsServiceProviderRole,
  I_UtilsInfoRecdHistAndInst.UtilsInstHistValidityEndDate AS UtilsInstHistValidityEndDate,
  I_UtilsInfoRecdHistAndInst.UtilsInstHistValidityStartDate AS UtilsInstHistValidityStartDate,
  I_UtilsInfoRecdHistAndInst.UtilitiesRateCategory AS UtilitiesRateCategory,
  I_UtilsInfoRecdHistAndInst.UtilitiesBillingSchema AS UtilitiesBillingSchema,
  I_UtilsInfoRecdHistAndInst.UtilitiesBillingClass AS UtilitiesBillingClass,
  I_UtilsInfoRecdHistAndInst.MeterReadingUnit AS MeterReadingUnit,
  I_UtilsInfoRecdHistAndInst.UtilitiesTemperatureArea AS UtilitiesTemperatureArea,
  I_UtilsInfoRecdHistAndInst.UtilsInstIsExmptFrmFrnchsFee AS UtilsInstIsExmptFrmFrnchsFee,
  I_UtilsInfoRecdHistAndInst.UtilsInstDvceAllctnIsNotAllwd AS UtilsInstDvceAllctnIsNotAllwd,
  I_UtilsInfoRecdHistAndInst.UtilitiesFranchiseContract AS UtilitiesFranchiseContract,
  I_UtilsInfoRecdHistAndInst.UtilitiesBillingParty AS UtilitiesBillingParty,
  I_UtilsInfoRecdHistAndInst.UtilitiesInvoicingParty AS UtilitiesInvoicingParty,
  I_UtilsInfoRecdHistAndInst.ObligatorySupUtilsSrvcProvider AS ObligatorySupUtilsSrvcProvider,
  I_UtilsInfoRecdHistAndInst.PrimaryUtilitiesInstallation AS PrimaryUtilitiesInstallation,
  I_UtilsInfoRecdHistAndInst.UtilsInstallationGroupRole AS UtilsInstallationGroupRole,
  I_UtilsInfoRecdHistAndInst.UtilsInstallationGroupType AS UtilsInstallationGroupType,
  I_UtilsInfoRecdHistAndInst.HigherLevelUtilsInstallation AS HigherLevelUtilsInstallation,
  I_UtilsInfoRecdHistAndInst.UnbilldRevnXtrapltnType AS UnbilldRevnXtrapltnType,
  I_UtilsInfoRecdHistAndInst.UtilsRegDepdntValdtnGroup AS UtilsRegDepdntValdtnGroup,
  I_UtilsInfoRecdHistAndInst._UtilsBillingClass AS _UtilsBillingClass,
  I_UtilsInfoRecdHistAndInst._UtilsDepdntValdtnGroup AS _UtilsDepdntValdtnGroup,
  I_UtilsInfoRecdHistAndInst._UtilsInstGroupRole AS _UtilsInstGroupRole,
  I_UtilsInfoRecdHistAndInst._UtilsInstGroupType AS _UtilsInstGroupType,
  I_UtilsInfoRecdHistAndInst._UtilsTemperatureArea AS _UtilsTemperatureArea,
  I_UtilsInfoRecdHistAndInst._UtilsUnbilldRevnXtrapltnType AS _UtilsUnbilldRevnXtrapltnType,
  I_UtilsInfoRecdHistAndInst._UtilitiesInstallation AS _UtilitiesInstallation,
  I_UtilsInfoRecdHistAndInst._UtilsAdvncdMeteringSystem AS _UtilsAdvncdMeteringSystem,
  I_UtilsInfoRecdHistAndInst._UtilsDevicePriceClass AS _UtilsDevicePriceClass,
  I_UtilsInfoRecdHistAndInst._UtilsDeviceRateFactGrp AS _UtilsDeviceRateFactGrp,
  I_UtilsInfoRecdHistAndInst._UtilsDeviceRateType AS _UtilsDeviceRateType,
  I_UtilsInfoRecdHistAndInst._UtilsDvceLossDetnGroup AS _UtilsDvceLossDetnGroup,
  I_UtilsInfoRecdHistAndInst._UtilsRegisterGroupInfoText AS _UtilsRegisterGroupInfoText,
  _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,
  cast(1 as e_billrell_infrec_vdm) AS NmbrOfBillgReltdInstdInfoRecd
FROM I_UtilsInfoRecdHistAndInst
LEFT OUTER JOIN I_UtilsDeviceCategory AS _UtilsDeviceCategory ON UtilitiesDeviceCategory = _UtilsDeviceCategory.UtilitiesDeviceCategory  -- association [1..1]
LEFT OUTER JOIN E_UtilsDvceInfoRecordHistory AS _InfoRecordHistoryExtension ON UtilitiesDeviceInfoRecord = _InfoRecordHistoryExtension.UtilitiesDeviceInfoRecord AND UtilsDeviceValidityEndDate = _InfoRecordHistoryExtension.UtilsDeviceValidityEndDate  -- association [0..1]
LEFT OUTER JOIN E_UtilitiesInstallation AS _UtilsInstallationExtension ON UtilitiesInstallation = _UtilsInstallationExtension.UtilitiesInstallation  -- association [0..1]
LEFT OUTER JOIN E_UtilitiesInstallationHist AS _UtilsInstallHistExtension ON UtilitiesInstallation = _UtilsInstallHistExtension.UtilitiesInstallation AND UtilsInstHistValidityEndDate = _UtilsInstallHistExtension.UtilsInstHistValidityEndDate  -- association [0..1]
;

Depth:

I_UtilsBillgReltdInstdDvceIR view

I_UtilsInfoRecdHistAndInst view

C_UtilsBillgReltdInstdDvceIRQ view