What is I_UtilsBillingRelatedInstdDvce in SAP S/4HANA?

I_UtilsBillingRelatedInstdDvce is a composite CDS view in SAP S/4HANA. Billing Related Installed Device - Cube It contains 201 fields.

Which tables does I_UtilsBillingRelatedInstdDvce read from?

I_UtilsBillingRelatedInstdDvce reads data from: I_UtilsInstdDvceAndInst.

What VDM layer is I_UtilsBillingRelatedInstdDvce?

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

I_UtilsBillingRelatedInstdDvce

DDL: I_UTILSBILLINGRELATEDINSTDDVCE SQL: IEBILLGRIDVCE Type: view COMPOSITE

201 Fields 1 Data Sources 5 Associations

Billing Related Installed Device - Cube

I_UtilsBillingRelatedInstdDvce (Composite)

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

Utilities

I_UtilsBillingRelatedInstdDvce is a Composite CDS View (Cube) that provides data about "Billing Related Installed Device - Cube" in SAP S/4HANA. It reads from 1 data source (I_UtilsInstdDvceAndInst) and exposes 201 fields with key fields UtilitiesDevice, UtilitiesLogicalDeviceNumber, UtilitiesInstallation. It has 5 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 questions:</p> <ul><li><p>How many and what type of devices are installed (billing-related)?</p></li> <li><p>How many and what type of advanced meters are installed (billing-related)?</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_UtilsInstdDvceAndInst	I_UtilsInstdDvceAndInst	from

Parameters (1)

Name	Type	Default
P_KeyDate	e_keydate_vdm

Associations (5)

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]	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 - Cube	view
Analytics.dataCategory	#CUBE	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#MANDATORY	view
AbapCatalog.sqlViewName	IEBILLGRIDVCE	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 (201)

Key	Field	Source Table	Source Field	Description
KEY	UtilitiesDevice	I_UtilsInstdDvceAndInst	UtilitiesDevice	Equipment Number
KEY	UtilitiesLogicalDeviceNumber	I_UtilsInstdDvceAndInst	UtilitiesLogicalDeviceNumber	Logical device number
KEY	UtilitiesInstallation	I_UtilsInstdDvceAndInst	UtilitiesInstallation	Installation
	UtilsDvceRateDataValdtyEndDte	I_UtilsInstdDvceAndInst	UtilsDvceRateDataValdtyEndDte	Validity End Date of Device Rate Data
	UtilsDvceRateDataValdtyStrtDte	I_UtilsInstdDvceAndInst	UtilsDvceRateDataValdtyStrtDte	Validity Start Date of Device Rate Data
	UtilsDevicePriceClass	I_UtilsInstdDvceAndInst	UtilsDevicePriceClass	Price Class
	UtilsDvceIsRelevantForRntlPrc	I_UtilsInstdDvceAndInst	UtilsDvceIsRelevantForRntlPrc	Pay rental price
	UtilsDeviceRateType	I_UtilsInstdDvceAndInst	UtilsDeviceRateType	Rate Type
	UtilsDeviceRateFactGroup	I_UtilsInstdDvceAndInst	UtilsDeviceRateFactGroup	Rate fact group
	UtilsDvceIsNotBillingRelevant	I_UtilsInstdDvceAndInst	UtilsDvceIsNotBillingRelevant	Device Not Relevant for Billing
	UtilsDeviceValidityEndDate	I_UtilsInstdDvceAndInst	UtilsDeviceValidityEndDate	Validity End Date of Device
	UtilsDeviceActivityReason	I_UtilsInstdDvceAndInst	UtilsDeviceActivityReason	Activity reason
	UtilsDeviceValidityStartDate	I_UtilsInstdDvceAndInst	UtilsDeviceValidityStartDate	Validity Start Date of Device
	UtilsDeviceBscCatCombination	I_UtilsInstdDvceAndInst	UtilsDeviceBscCatCombination	Combination of a device category
	UtilitiesRegisterGroup	I_UtilsInstdDvceAndInst	UtilitiesRegisterGroup	Register Group
	UtilsDeviceInstallationDate	I_UtilsInstdDvceAndInst	UtilsDeviceInstallationDate	Installation date
	UtilsDeviceRemovalDate	I_UtilsInstdDvceAndInst	UtilsDeviceRemovalDate	Device removal date
	UtilsDeviceLocation	I_UtilsInstdDvceAndInst	UtilsDeviceLocation	Device Location
	UtilsDeviceGroup	I_UtilsInstdDvceAndInst	UtilsDeviceGroup	Device group
	UtilsDeviceWindingGroup	I_UtilsInstdDvceAndInst	UtilsDeviceWindingGroup	Winding group
	UtilitiesPrepaymentMeterType	I_UtilsInstdDvceAndInst	UtilitiesPrepaymentMeterType	Prepayment Meter
	UtilsDeviceLossDetnGroup	I_UtilsInstdDvceAndInst	UtilsDeviceLossDetnGroup	Loss Determination Group
	DvcePwrTrnsfrmtrTrnsfRatingVal	I_UtilsInstdDvceAndInst	DvcePwrTrnsfrmtrTrnsfRatingVal	Power Transformer: Rating
	DvcePwrTrnsfrmtrPrimVoltVal	I_UtilsInstdDvceAndInst	DvcePwrTrnsfrmtrPrimVoltVal	Power Transformer: Primary Voltage
	DvcePwrTrnsfrmtrSecdryVoltVal	I_UtilsInstdDvceAndInst	DvcePwrTrnsfrmtrSecdryVoltVal	Power Transformer: Secondary Voltage
	AdvancedMeteringSystem	I_UtilsInstdDvceAndInst	AdvancedMeteringSystem	Advanced Metering System
	AdvancedMeterCapabilityGroup	I_UtilsInstdDvceAndInst	AdvancedMeterCapabilityGroup	Advanced Meter Capability Group (AMCG)
	EquipmentCategory	I_UtilsInstdDvceAndInst	EquipmentCategory	Equipment category
	TechnicalObjectType	I_UtilsInstdDvceAndInst	TechnicalObjectType	Type of Technical Object
	AuthorizationGroup	I_UtilsInstdDvceAndInst	AuthorizationGroup	Technical Object Authorization Group
	AcquisitionDate	I_UtilsInstdDvceAndInst	AcquisitionDate	Acquisition date
	AcquisitionValue	I_UtilsInstdDvceAndInst	AcquisitionValue	Acquisition Value
	Currency	I_UtilsInstdDvceAndInst	Currency	Valuation Crcy
	AssetManufacturerName	I_UtilsInstdDvceAndInst	AssetManufacturerName	Manufacturer of Asset
	ManufacturerCountry	I_UtilsInstdDvceAndInst	ManufacturerCountry	Country/Region of Manufacture
	ManufacturerSerialNumber	I_UtilsInstdDvceAndInst	ManufacturerSerialNumber	Manufacturer's Serial Number
	ManufacturerPartTypeName	I_UtilsInstdDvceAndInst	ManufacturerPartTypeName	Manufacturer model number
	ConstructionYear	I_UtilsInstdDvceAndInst	ConstructionYear	Device Construction Year
	UtilitiesDeviceCategory	I_UtilsInstdDvceAndInst	UtilitiesDeviceCategory	Device Category
	SerialNumber	I_UtilsInstdDvceAndInst	SerialNumber	Serial Number
	Plant	I_UtilsInstdDvceAndInst	Plant	Valuation Area
	Division	I_UtilsInstdDvceAndInst	Division	Internal Division ID
	StorageLocation	I_UtilsInstdDvceAndInst	StorageLocation	Storage Location
	UniqueItemIdentifier	I_UtilsInstdDvceAndInst	UniqueItemIdentifier	Unique Item Identifier
	UniqueItemIdentifierStrucType	I_UtilsInstdDvceAndInst	UniqueItemIdentifierStrucType	Structure Type of UII
	UniqueItemIdentifierRespPlant	I_UtilsInstdDvceAndInst	UniqueItemIdentifierRespPlant	Plant Responsible for UII
	UtilsDeviceInOutGroup	I_UtilsInstdDvceAndInst	UtilsDeviceInOutGroup	Input/output group
	UtilsDeviceARCRCommandGroup	I_UtilsInstdDvceAndInst	UtilsDeviceARCRCommandGroup	ARCR Command Group
	UtilsDeviceSampleLot	I_UtilsInstdDvceAndInst	UtilsDeviceSampleLot	Sample lot
	UtilsDeviceMeasuredPressure	I_UtilsInstdDvceAndInst	UtilsDeviceMeasuredPressure	Measured Pressure (Outlet Pressure) in Bars
	UtilsDeviceTransformationRatio	I_UtilsInstdDvceAndInst	UtilsDeviceTransformationRatio	Transformation ratio
	UtilsDeviceInspRelevanceCode	I_UtilsInstdDvceAndInst	UtilsDeviceInspRelevanceCode	Inspection relevance of device
	UtilsDeviceCertificationYear	I_UtilsInstdDvceAndInst	UtilsDeviceCertificationYear	Certification Year
	UtilsDeviceAdvncRplcmtYear	I_UtilsInstdDvceAndInst	UtilsDeviceAdvncRplcmtYear	Advance replacement year
	UtilsDeviceCertfnStatus	I_UtilsInstdDvceAndInst	UtilsDeviceCertfnStatus	Certification status
	SampleUtilsDeviceStatus	I_UtilsInstdDvceAndInst	SampleUtilsDeviceStatus	Status of sample device
	UtilsDeviceLastLeadSealingDate	I_UtilsInstdDvceAndInst	UtilsDeviceLastLeadSealingDate	Date of last lead sealing
	UtilsDeviceCertfnType	I_UtilsInstdDvceAndInst	UtilsDeviceCertfnType	Type of certification
	UtilsDeviceCertificationNumber	I_UtilsInstdDvceAndInst	UtilsDeviceCertificationNumber	Certification number
	UtilsDeviceModificationDate	I_UtilsInstdDvceAndInst	UtilsDeviceModificationDate	Modification date
	UtilsDeviceModReason	I_UtilsInstdDvceAndInst	UtilsDeviceModReason	Modification reason
	UtilsDeviceCalibrnValdtyIsUsed	I_UtilsInstdDvceAndInst	UtilsDeviceCalibrnValdtyIsUsed	Use calibration validity
	UtilsDeviceParametrizationCode	I_UtilsInstdDvceAndInst	UtilsDeviceParametrizationCode	Parametrization
	UtilsDeviceLeadSealingCode	I_UtilsInstdDvceAndInst	UtilsDeviceLeadSealingCode	Seal code
	LastChangeDate	I_UtilsInstdDvceAndInst	LastChangeDate	Last Changed On
	UtilsDeviceLastChangedByUser	I_UtilsInstdDvceAndInst	UtilsDeviceLastChangedByUser	Name of Person Who Changed Object
	UtilsDeviceInspPointGroup	I_UtilsInstdDvceAndInst	UtilsDeviceInspPointGroup	Inspection point group
	InstdUtilsDeviceIsCertifiable	I_UtilsInstdDvceAndInst	InstdUtilsDeviceIsCertifiable	Certify installed devices
	UtilsDeviceInspectionNumber	I_UtilsInstdDvceAndInst	UtilsDeviceInspectionNumber	Device inspection number
	DvceIndivCertfnValdtyInYrs	I_UtilsInstdDvceAndInst	DvceIndivCertfnValdtyInYrs	Individual cal. validity (years) of dev. subject to certif.
	UtilitiesInstallationType	I_UtilsInstdDvceAndInst	UtilitiesInstallationType	Installation type
	UtilitiesInstVoltageLevel	I_UtilsInstdDvceAndInst	UtilitiesInstVoltageLevel	Voltage Level
	UtilitiesInstGasPrssrLvl	I_UtilsInstdDvceAndInst	UtilitiesInstGasPrssrLvl	Gas Pressure Level at Installation Level (Grid)
	UtilsInstTimeZone	I_UtilsInstdDvceAndInst	UtilsInstTimeZone	Time Zone for EDM Objects
	UtilsInstGuarOfSupReason	I_UtilsInstdDvceAndInst	UtilsInstGuarOfSupReason	Reason for guarantee of supply
	UtilsInstDeregulationSts	I_UtilsInstdDvceAndInst	UtilsInstDeregulationSts	Deregulation status
	UtilsInstDataReleaseStatus	I_UtilsInstdDvceAndInst	UtilsInstDataReleaseStatus	Release Status for Installation Data
	UtilitiesSrvcProviderRole	I_UtilsInstdDvceAndInst	UtilitiesSrvcProviderRole	Service Type
	UtilsInstIsForEnergyFeedIn	I_UtilsInstdDvceAndInst	UtilsInstIsForEnergyFeedIn	Purchase
	UtilsInstCreationDate	I_UtilsInstdDvceAndInst	UtilsInstCreationDate	Record Created On
	UtilsInstCreatedByUser	I_UtilsInstdDvceAndInst	UtilsInstCreatedByUser	Name of Person Responsible for Creating the Object
	UtilsInstLastChangeDate	I_UtilsInstdDvceAndInst	UtilsInstLastChangeDate	Last Changed On
	UtilsInstLastChangedByUser	I_UtilsInstdDvceAndInst	UtilsInstLastChangedByUser	Name of Person Who Changed Object
	MeterReadingBlockingReason	I_UtilsInstdDvceAndInst	MeterReadingBlockingReason	Reason for blocking meter reading
	MeterReadingBasePeriodCat	I_UtilsInstdDvceAndInst	MeterReadingBasePeriodCat	Base period category
	NmbrOfAllwdMtrRdngsCntrlCode	I_UtilsInstdDvceAndInst	NmbrOfAllwdMtrRdngsCntrlCode	Control of perm. number of cust. MRs and autom. estimations
	IsMarkedForDeletion	I_UtilsInstdDvceAndInst	IsMarkedForDeletion	Deletion Indicator
	UtilitiesPremise	I_UtilsInstdDvceAndInst	UtilitiesPremise	Premise
	UtilsInstHistValidityEndDate	I_UtilsInstdDvceAndInst	UtilsInstHistValidityEndDate	Validity End Date of Installation
	UtilsInstHistValidityStartDate	I_UtilsInstdDvceAndInst	UtilsInstHistValidityStartDate	Validity Start Date of Installation
	UtilitiesRateCategory	I_UtilsInstdDvceAndInst	UtilitiesRateCategory	Rate Category
	UtilitiesBillingSchema	I_UtilsInstdDvceAndInst	UtilitiesBillingSchema	Number of the billing schema
	UtilitiesBillingClass	I_UtilsInstdDvceAndInst	UtilitiesBillingClass	Billing Class
	MeterReadingUnit	I_UtilsInstdDvceAndInst	MeterReadingUnit	Meter Reading Unit
	UtilitiesTemperatureArea	I_UtilsInstdDvceAndInst	UtilitiesTemperatureArea	Temperature area
	UtilsInstIsExmptFrmFrnchsFee	I_UtilsInstdDvceAndInst	UtilsInstIsExmptFrmFrnchsFee	Exempt from franchise fee
	UtilsInstDvceAllctnIsNotAllwd	I_UtilsInstdDvceAndInst	UtilsInstDvceAllctnIsNotAllwd	Device allocation is not possible
	UtilitiesFranchiseContract	I_UtilsInstdDvceAndInst	UtilitiesFranchiseContract	Franchise contract
	UtilitiesBillingParty	I_UtilsInstdDvceAndInst	UtilitiesBillingParty	Service Provider that Bills the Installation
	UtilitiesInvoicingParty	I_UtilsInstdDvceAndInst	UtilitiesInvoicingParty	Service Provider That Invoices the Contract
	ObligatorySupUtilsSrvcProvider	I_UtilsInstdDvceAndInst	ObligatorySupUtilsSrvcProvider	Obligation to Supply
	PrimaryUtilitiesInstallation	I_UtilsInstdDvceAndInst	PrimaryUtilitiesInstallation	Key of Primary Installation
	UtilsInstallationGroupRole	I_UtilsInstdDvceAndInst	UtilsInstallationGroupRole	Role of an Installation Within the Installation Group
	UtilsInstallationGroupType	I_UtilsInstdDvceAndInst	UtilsInstallationGroupType	Grouping Type for Installation Group
	HigherLevelUtilsInstallation	I_UtilsInstdDvceAndInst	HigherLevelUtilsInstallation	Higher-Level Installation
	UnbilldRevnXtrapltnType	I_UtilsInstdDvceAndInst	UnbilldRevnXtrapltnType	Type of extrapolation in unbilled revenue reporting
	UtilsRegDepdntValdtnGroup	I_UtilsInstdDvceAndInst	UtilsRegDepdntValdtnGroup	Validation group for dependent validations
	_Currency	I_UtilsInstdDvceAndInst	_Currency
	_Division	I_UtilsInstdDvceAndInst	_Division
	_EquipmentCategory	I_UtilsInstdDvceAndInst	_EquipmentCategory
	_EquipmentText	I_UtilsInstdDvceAndInst	_EquipmentText
	_EquipmentTimeSeg	I_UtilsInstdDvceAndInst	_EquipmentTimeSeg
	_Plant	I_UtilsInstdDvceAndInst	_Plant
	_SerialNumberStockSegment	I_UtilsInstdDvceAndInst	_SerialNumberStockSegment
	_StorageLocation	I_UtilsInstdDvceAndInst	_StorageLocation
	_TechnicalObjectType	I_UtilsInstdDvceAndInst	_TechnicalObjectType
	_UtilsAdvncdMeteringSystem	I_UtilsInstdDvceAndInst	_UtilsAdvncdMeteringSystem
	_UtilsBillingClass	I_UtilsInstdDvceAndInst	_UtilsBillingClass
	_UtilsDepdntValdtnGroup	I_UtilsInstdDvceAndInst	_UtilsDepdntValdtnGroup
	_UtilsDeviceCertfnStatus	I_UtilsInstdDvceAndInst	_UtilsDeviceCertfnStatus
	_UtilsDeviceCertfnType	I_UtilsInstdDvceAndInst	_UtilsDeviceCertfnType
	_UtilsDeviceLastChangedByUser	I_UtilsInstdDvceAndInst	_UtilsDeviceLastChangedByUser
	_UtilsDeviceModReason	I_UtilsInstdDvceAndInst	_UtilsDeviceModReason
	_UtilsDevicePriceClass	I_UtilsInstdDvceAndInst	_UtilsDevicePriceClass
	_UtilsDeviceRateFactGrp	I_UtilsInstdDvceAndInst	_UtilsDeviceRateFactGrp
	_UtilsDeviceRateType	I_UtilsInstdDvceAndInst	_UtilsDeviceRateType
	_UtilsDvceActivityReason	I_UtilsInstdDvceAndInst	_UtilsDvceActivityReason
	_UtilsDvceInspRelevance	I_UtilsInstdDvceAndInst	_UtilsDvceInspRelevance
	_UtilsDvceLossDetnGroup	I_UtilsInstdDvceAndInst	_UtilsDvceLossDetnGroup
	_UtilsDvceParametrization	I_UtilsInstdDvceAndInst	_UtilsDvceParametrization
	_UtilsInstallationType	I_UtilsInstdDvceAndInst	_UtilsInstallationType
	_UtilsInstCreatedByUser	I_UtilsInstdDvceAndInst	_UtilsInstCreatedByUser
	_UtilsInstDataReleaseSts	I_UtilsInstdDvceAndInst	_UtilsInstDataReleaseSts
	_UtilsInstDeregulationSts	I_UtilsInstdDvceAndInst	_UtilsInstDeregulationSts
	_UtilsInstGasPressureLvl	I_UtilsInstdDvceAndInst	_UtilsInstGasPressureLvl
	_UtilsInstGroupRole	I_UtilsInstdDvceAndInst	_UtilsInstGroupRole
	_UtilsInstGroupType	I_UtilsInstdDvceAndInst	_UtilsInstGroupType
	_UtilsInstGuarOfSupRsn	I_UtilsInstdDvceAndInst	_UtilsInstGuarOfSupRsn
	_UtilsInstLastChangedByUser	I_UtilsInstdDvceAndInst	_UtilsInstLastChangedByUser
	_UtilsInstVltgLevel	I_UtilsInstdDvceAndInst	_UtilsInstVltgLevel
	_UtilsMtrRdngBasePerdCat	I_UtilsInstdDvceAndInst	_UtilsMtrRdngBasePerdCat
	_UtilsMtrRdngBlockReason	I_UtilsInstdDvceAndInst	_UtilsMtrRdngBlockReason
	_UtilsNmbrOfAllwdMRCtrlCode	I_UtilsInstdDvceAndInst	_UtilsNmbrOfAllwdMRCtrlCode
	_UtilsRegisterGroupInfoText	I_UtilsInstdDvceAndInst	_UtilsRegisterGroupInfoText
	_UtilsSampleDeviceStatus	I_UtilsInstdDvceAndInst	_UtilsSampleDeviceStatus
	_UtilsServiceProviderRole	I_UtilsInstdDvceAndInst	_UtilsServiceProviderRole
	_UtilsTemperatureArea	I_UtilsInstdDvceAndInst	_UtilsTemperatureArea
	_UtilsUnbilldRevnXtrapltnType	I_UtilsInstdDvceAndInst	_UtilsUnbilldRevnXtrapltnType
	_UtilitiesInstallation	I_UtilsInstdDvceAndInst	_UtilitiesInstallation
	_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
	_FunctionalLocationText	_UtilsTechObjLocationAddr	_FunctionalLocationText
	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
	NmbrOfBillgReltdInstdUtilsDvce			Number of Billing-Relevant Installed Devices

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_UtilsBillingRelatedInstdDvce.
-- 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: IEBILLGRIDVCE
-- Parameters: P_KeyDate : e_keydate_vdm

CREATE VIEW I_UtilsBillingRelatedInstdDvce AS
SELECT
  I_UtilsInstdDvceAndInst.UtilitiesDevice AS UtilitiesDevice,
  I_UtilsInstdDvceAndInst.UtilitiesLogicalDeviceNumber AS UtilitiesLogicalDeviceNumber,
  I_UtilsInstdDvceAndInst.UtilitiesInstallation AS UtilitiesInstallation,
  I_UtilsInstdDvceAndInst.UtilsDvceRateDataValdtyEndDte AS UtilsDvceRateDataValdtyEndDte,
  I_UtilsInstdDvceAndInst.UtilsDvceRateDataValdtyStrtDte AS UtilsDvceRateDataValdtyStrtDte,
  I_UtilsInstdDvceAndInst.UtilsDevicePriceClass AS UtilsDevicePriceClass,
  I_UtilsInstdDvceAndInst.UtilsDvceIsRelevantForRntlPrc AS UtilsDvceIsRelevantForRntlPrc,
  I_UtilsInstdDvceAndInst.UtilsDeviceRateType AS UtilsDeviceRateType,
  I_UtilsInstdDvceAndInst.UtilsDeviceRateFactGroup AS UtilsDeviceRateFactGroup,
  I_UtilsInstdDvceAndInst.UtilsDvceIsNotBillingRelevant AS UtilsDvceIsNotBillingRelevant,
  I_UtilsInstdDvceAndInst.UtilsDeviceValidityEndDate AS UtilsDeviceValidityEndDate,
  I_UtilsInstdDvceAndInst.UtilsDeviceActivityReason AS UtilsDeviceActivityReason,
  I_UtilsInstdDvceAndInst.UtilsDeviceValidityStartDate AS UtilsDeviceValidityStartDate,
  I_UtilsInstdDvceAndInst.UtilsDeviceBscCatCombination AS UtilsDeviceBscCatCombination,
  I_UtilsInstdDvceAndInst.UtilitiesRegisterGroup AS UtilitiesRegisterGroup,
  I_UtilsInstdDvceAndInst.UtilsDeviceInstallationDate AS UtilsDeviceInstallationDate,
  I_UtilsInstdDvceAndInst.UtilsDeviceRemovalDate AS UtilsDeviceRemovalDate,
  I_UtilsInstdDvceAndInst.UtilsDeviceLocation AS UtilsDeviceLocation,
  I_UtilsInstdDvceAndInst.UtilsDeviceGroup AS UtilsDeviceGroup,
  I_UtilsInstdDvceAndInst.UtilsDeviceWindingGroup AS UtilsDeviceWindingGroup,
  I_UtilsInstdDvceAndInst.UtilitiesPrepaymentMeterType AS UtilitiesPrepaymentMeterType,
  I_UtilsInstdDvceAndInst.UtilsDeviceLossDetnGroup AS UtilsDeviceLossDetnGroup,
  I_UtilsInstdDvceAndInst.DvcePwrTrnsfrmtrTrnsfRatingVal AS DvcePwrTrnsfrmtrTrnsfRatingVal,
  I_UtilsInstdDvceAndInst.DvcePwrTrnsfrmtrPrimVoltVal AS DvcePwrTrnsfrmtrPrimVoltVal,
  I_UtilsInstdDvceAndInst.DvcePwrTrnsfrmtrSecdryVoltVal AS DvcePwrTrnsfrmtrSecdryVoltVal,
  I_UtilsInstdDvceAndInst.AdvancedMeteringSystem AS AdvancedMeteringSystem,
  I_UtilsInstdDvceAndInst.AdvancedMeterCapabilityGroup AS AdvancedMeterCapabilityGroup,
  I_UtilsInstdDvceAndInst.EquipmentCategory AS EquipmentCategory,
  I_UtilsInstdDvceAndInst.TechnicalObjectType AS TechnicalObjectType,
  I_UtilsInstdDvceAndInst.AuthorizationGroup AS AuthorizationGroup,
  I_UtilsInstdDvceAndInst.AcquisitionDate AS AcquisitionDate,
  I_UtilsInstdDvceAndInst.AcquisitionValue AS AcquisitionValue,
  I_UtilsInstdDvceAndInst.Currency AS Currency,
  I_UtilsInstdDvceAndInst.AssetManufacturerName AS AssetManufacturerName,
  I_UtilsInstdDvceAndInst.ManufacturerCountry AS ManufacturerCountry,
  I_UtilsInstdDvceAndInst.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  I_UtilsInstdDvceAndInst.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  I_UtilsInstdDvceAndInst.ConstructionYear AS ConstructionYear,
  I_UtilsInstdDvceAndInst.UtilitiesDeviceCategory AS UtilitiesDeviceCategory,
  I_UtilsInstdDvceAndInst.SerialNumber AS SerialNumber,
  I_UtilsInstdDvceAndInst.Plant AS Plant,
  I_UtilsInstdDvceAndInst.Division AS Division,
  I_UtilsInstdDvceAndInst.StorageLocation AS StorageLocation,
  I_UtilsInstdDvceAndInst.UniqueItemIdentifier AS UniqueItemIdentifier,
  I_UtilsInstdDvceAndInst.UniqueItemIdentifierStrucType AS UniqueItemIdentifierStrucType,
  I_UtilsInstdDvceAndInst.UniqueItemIdentifierRespPlant AS UniqueItemIdentifierRespPlant,
  I_UtilsInstdDvceAndInst.UtilsDeviceInOutGroup AS UtilsDeviceInOutGroup,
  I_UtilsInstdDvceAndInst.UtilsDeviceARCRCommandGroup AS UtilsDeviceARCRCommandGroup,
  I_UtilsInstdDvceAndInst.UtilsDeviceSampleLot AS UtilsDeviceSampleLot,
  I_UtilsInstdDvceAndInst.UtilsDeviceMeasuredPressure AS UtilsDeviceMeasuredPressure,
  I_UtilsInstdDvceAndInst.UtilsDeviceTransformationRatio AS UtilsDeviceTransformationRatio,
  I_UtilsInstdDvceAndInst.UtilsDeviceInspRelevanceCode AS UtilsDeviceInspRelevanceCode,
  I_UtilsInstdDvceAndInst.UtilsDeviceCertificationYear AS UtilsDeviceCertificationYear,
  I_UtilsInstdDvceAndInst.UtilsDeviceAdvncRplcmtYear AS UtilsDeviceAdvncRplcmtYear,
  I_UtilsInstdDvceAndInst.UtilsDeviceCertfnStatus AS UtilsDeviceCertfnStatus,
  I_UtilsInstdDvceAndInst.SampleUtilsDeviceStatus AS SampleUtilsDeviceStatus,
  I_UtilsInstdDvceAndInst.UtilsDeviceLastLeadSealingDate AS UtilsDeviceLastLeadSealingDate,
  I_UtilsInstdDvceAndInst.UtilsDeviceCertfnType AS UtilsDeviceCertfnType,
  I_UtilsInstdDvceAndInst.UtilsDeviceCertificationNumber AS UtilsDeviceCertificationNumber,
  I_UtilsInstdDvceAndInst.UtilsDeviceModificationDate AS UtilsDeviceModificationDate,
  I_UtilsInstdDvceAndInst.UtilsDeviceModReason AS UtilsDeviceModReason,
  I_UtilsInstdDvceAndInst.UtilsDeviceCalibrnValdtyIsUsed AS UtilsDeviceCalibrnValdtyIsUsed,
  I_UtilsInstdDvceAndInst.UtilsDeviceParametrizationCode AS UtilsDeviceParametrizationCode,
  I_UtilsInstdDvceAndInst.UtilsDeviceLeadSealingCode AS UtilsDeviceLeadSealingCode,
  I_UtilsInstdDvceAndInst.LastChangeDate AS LastChangeDate,
  I_UtilsInstdDvceAndInst.UtilsDeviceLastChangedByUser AS UtilsDeviceLastChangedByUser,
  I_UtilsInstdDvceAndInst.UtilsDeviceInspPointGroup AS UtilsDeviceInspPointGroup,
  I_UtilsInstdDvceAndInst.InstdUtilsDeviceIsCertifiable AS InstdUtilsDeviceIsCertifiable,
  I_UtilsInstdDvceAndInst.UtilsDeviceInspectionNumber AS UtilsDeviceInspectionNumber,
  I_UtilsInstdDvceAndInst.DvceIndivCertfnValdtyInYrs AS DvceIndivCertfnValdtyInYrs,
  I_UtilsInstdDvceAndInst.UtilitiesInstallationType AS UtilitiesInstallationType,
  I_UtilsInstdDvceAndInst.UtilitiesInstVoltageLevel AS UtilitiesInstVoltageLevel,
  I_UtilsInstdDvceAndInst.UtilitiesInstGasPrssrLvl AS UtilitiesInstGasPrssrLvl,
  I_UtilsInstdDvceAndInst.UtilsInstTimeZone AS UtilsInstTimeZone,
  I_UtilsInstdDvceAndInst.UtilsInstGuarOfSupReason AS UtilsInstGuarOfSupReason,
  I_UtilsInstdDvceAndInst.UtilsInstDeregulationSts AS UtilsInstDeregulationSts,
  I_UtilsInstdDvceAndInst.UtilsInstDataReleaseStatus AS UtilsInstDataReleaseStatus,
  I_UtilsInstdDvceAndInst.UtilitiesSrvcProviderRole AS UtilitiesSrvcProviderRole,
  I_UtilsInstdDvceAndInst.UtilsInstIsForEnergyFeedIn AS UtilsInstIsForEnergyFeedIn,
  I_UtilsInstdDvceAndInst.UtilsInstCreationDate AS UtilsInstCreationDate,
  I_UtilsInstdDvceAndInst.UtilsInstCreatedByUser AS UtilsInstCreatedByUser,
  I_UtilsInstdDvceAndInst.UtilsInstLastChangeDate AS UtilsInstLastChangeDate,
  I_UtilsInstdDvceAndInst.UtilsInstLastChangedByUser AS UtilsInstLastChangedByUser,
  I_UtilsInstdDvceAndInst.MeterReadingBlockingReason AS MeterReadingBlockingReason,
  I_UtilsInstdDvceAndInst.MeterReadingBasePeriodCat AS MeterReadingBasePeriodCat,
  I_UtilsInstdDvceAndInst.NmbrOfAllwdMtrRdngsCntrlCode AS NmbrOfAllwdMtrRdngsCntrlCode,
  I_UtilsInstdDvceAndInst.IsMarkedForDeletion AS IsMarkedForDeletion,
  I_UtilsInstdDvceAndInst.UtilitiesPremise AS UtilitiesPremise,
  I_UtilsInstdDvceAndInst.UtilsInstHistValidityEndDate AS UtilsInstHistValidityEndDate,
  I_UtilsInstdDvceAndInst.UtilsInstHistValidityStartDate AS UtilsInstHistValidityStartDate,
  I_UtilsInstdDvceAndInst.UtilitiesRateCategory AS UtilitiesRateCategory,
  I_UtilsInstdDvceAndInst.UtilitiesBillingSchema AS UtilitiesBillingSchema,
  I_UtilsInstdDvceAndInst.UtilitiesBillingClass AS UtilitiesBillingClass,
  I_UtilsInstdDvceAndInst.MeterReadingUnit AS MeterReadingUnit,
  I_UtilsInstdDvceAndInst.UtilitiesTemperatureArea AS UtilitiesTemperatureArea,
  I_UtilsInstdDvceAndInst.UtilsInstIsExmptFrmFrnchsFee AS UtilsInstIsExmptFrmFrnchsFee,
  I_UtilsInstdDvceAndInst.UtilsInstDvceAllctnIsNotAllwd AS UtilsInstDvceAllctnIsNotAllwd,
  I_UtilsInstdDvceAndInst.UtilitiesFranchiseContract AS UtilitiesFranchiseContract,
  I_UtilsInstdDvceAndInst.UtilitiesBillingParty AS UtilitiesBillingParty,
  I_UtilsInstdDvceAndInst.UtilitiesInvoicingParty AS UtilitiesInvoicingParty,
  I_UtilsInstdDvceAndInst.ObligatorySupUtilsSrvcProvider AS ObligatorySupUtilsSrvcProvider,
  I_UtilsInstdDvceAndInst.PrimaryUtilitiesInstallation AS PrimaryUtilitiesInstallation,
  I_UtilsInstdDvceAndInst.UtilsInstallationGroupRole AS UtilsInstallationGroupRole,
  I_UtilsInstdDvceAndInst.UtilsInstallationGroupType AS UtilsInstallationGroupType,
  I_UtilsInstdDvceAndInst.HigherLevelUtilsInstallation AS HigherLevelUtilsInstallation,
  I_UtilsInstdDvceAndInst.UnbilldRevnXtrapltnType AS UnbilldRevnXtrapltnType,
  I_UtilsInstdDvceAndInst.UtilsRegDepdntValdtnGroup AS UtilsRegDepdntValdtnGroup,
  I_UtilsInstdDvceAndInst._Currency AS _Currency,
  I_UtilsInstdDvceAndInst._Division AS _Division,
  I_UtilsInstdDvceAndInst._EquipmentCategory AS _EquipmentCategory,
  I_UtilsInstdDvceAndInst._EquipmentText AS _EquipmentText,
  I_UtilsInstdDvceAndInst._EquipmentTimeSeg AS _EquipmentTimeSeg,
  I_UtilsInstdDvceAndInst._Plant AS _Plant,
  I_UtilsInstdDvceAndInst._SerialNumberStockSegment AS _SerialNumberStockSegment,
  I_UtilsInstdDvceAndInst._StorageLocation AS _StorageLocation,
  I_UtilsInstdDvceAndInst._TechnicalObjectType AS _TechnicalObjectType,
  I_UtilsInstdDvceAndInst._UtilsAdvncdMeteringSystem AS _UtilsAdvncdMeteringSystem,
  I_UtilsInstdDvceAndInst._UtilsBillingClass AS _UtilsBillingClass,
  I_UtilsInstdDvceAndInst._UtilsDepdntValdtnGroup AS _UtilsDepdntValdtnGroup,
  I_UtilsInstdDvceAndInst._UtilsDeviceCertfnStatus AS _UtilsDeviceCertfnStatus,
  I_UtilsInstdDvceAndInst._UtilsDeviceCertfnType AS _UtilsDeviceCertfnType,
  I_UtilsInstdDvceAndInst._UtilsDeviceLastChangedByUser AS _UtilsDeviceLastChangedByUser,
  I_UtilsInstdDvceAndInst._UtilsDeviceModReason AS _UtilsDeviceModReason,
  I_UtilsInstdDvceAndInst._UtilsDevicePriceClass AS _UtilsDevicePriceClass,
  I_UtilsInstdDvceAndInst._UtilsDeviceRateFactGrp AS _UtilsDeviceRateFactGrp,
  I_UtilsInstdDvceAndInst._UtilsDeviceRateType AS _UtilsDeviceRateType,
  I_UtilsInstdDvceAndInst._UtilsDvceActivityReason AS _UtilsDvceActivityReason,
  I_UtilsInstdDvceAndInst._UtilsDvceInspRelevance AS _UtilsDvceInspRelevance,
  I_UtilsInstdDvceAndInst._UtilsDvceLossDetnGroup AS _UtilsDvceLossDetnGroup,
  I_UtilsInstdDvceAndInst._UtilsDvceParametrization AS _UtilsDvceParametrization,
  I_UtilsInstdDvceAndInst._UtilsInstallationType AS _UtilsInstallationType,
  I_UtilsInstdDvceAndInst._UtilsInstCreatedByUser AS _UtilsInstCreatedByUser,
  I_UtilsInstdDvceAndInst._UtilsInstDataReleaseSts AS _UtilsInstDataReleaseSts,
  I_UtilsInstdDvceAndInst._UtilsInstDeregulationSts AS _UtilsInstDeregulationSts,
  I_UtilsInstdDvceAndInst._UtilsInstGasPressureLvl AS _UtilsInstGasPressureLvl,
  I_UtilsInstdDvceAndInst._UtilsInstGroupRole AS _UtilsInstGroupRole,
  I_UtilsInstdDvceAndInst._UtilsInstGroupType AS _UtilsInstGroupType,
  I_UtilsInstdDvceAndInst._UtilsInstGuarOfSupRsn AS _UtilsInstGuarOfSupRsn,
  I_UtilsInstdDvceAndInst._UtilsInstLastChangedByUser AS _UtilsInstLastChangedByUser,
  I_UtilsInstdDvceAndInst._UtilsInstVltgLevel AS _UtilsInstVltgLevel,
  I_UtilsInstdDvceAndInst._UtilsMtrRdngBasePerdCat AS _UtilsMtrRdngBasePerdCat,
  I_UtilsInstdDvceAndInst._UtilsMtrRdngBlockReason AS _UtilsMtrRdngBlockReason,
  I_UtilsInstdDvceAndInst._UtilsNmbrOfAllwdMRCtrlCode AS _UtilsNmbrOfAllwdMRCtrlCode,
  I_UtilsInstdDvceAndInst._UtilsRegisterGroupInfoText AS _UtilsRegisterGroupInfoText,
  I_UtilsInstdDvceAndInst._UtilsSampleDeviceStatus AS _UtilsSampleDeviceStatus,
  I_UtilsInstdDvceAndInst._UtilsServiceProviderRole AS _UtilsServiceProviderRole,
  I_UtilsInstdDvceAndInst._UtilsTemperatureArea AS _UtilsTemperatureArea,
  I_UtilsInstdDvceAndInst._UtilsUnbilldRevnXtrapltnType AS _UtilsUnbilldRevnXtrapltnType,
  I_UtilsInstdDvceAndInst._UtilitiesInstallation AS _UtilitiesInstallation,
  _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._FunctionalLocationText AS _FunctionalLocationText,
  _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,
  cast(1 as e_billrell_dev_vdm) AS NmbrOfBillgReltdInstdUtilsDvce
FROM I_UtilsInstdDvceAndInst
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 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_UtilsBillingRelatedInstdDvce view

I_UtilsInstdDvceAndInst view

C_UtilsBillgReltdInstdDeviceQ view