What is I_UtilsDvcePerdcRplcmntList in SAP S/4HANA?

I_UtilsDvcePerdcRplcmntList is a composite CDS view in SAP S/4HANA. Device Periodic Replacement List It contains 146 fields.

Which tables does I_UtilsDvcePerdcRplcmntList read from?

I_UtilsDvcePerdcRplcmntList reads data from: I_UtilitiesDevice, I_UtilsPeriodicRplcmtList.

What VDM layer is I_UtilsDvcePerdcRplcmntList?

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

I_UtilsDvcePerdcRplcmntList

DDL: I_UTILSDVCEPERDCRPLCMNTLIST SQL: IEDVCEPERDCRL Type: view COMPOSITE

146 Fields 2 Data Sources 4 Associations

Device Periodic Replacement List

I_UtilsDvcePerdcRplcmntList (Composite)

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

Utilities

I_UtilsDvcePerdcRplcmntList is a Composite CDS View (Cube) that provides data about "Device Periodic Replacement List" in SAP S/4HANA. It reads from 2 data sources (I_UtilitiesDevice, I_UtilsPeriodicRplcmtList) and exposes 146 fields with key field UtilsEquipmentPerdcRplcmtList. It has 4 associations to related views.

SAP API Hub

State	C1
Line of Business	Utilities
Application Component	IS-U-DM-IS-PR
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>Which installed devices included in a periodic replacement list still have to be replaced?</p></li> <li><p>Which devices included in a periodic replacement list have already been removed?</p></li> <li><p>What is the processing status of the periodic replacement list according to the regional structure for the current year and past years?</p></li> <li><p>Is it necessary to schedule service technicians for forthcoming device replacements and how can resource planning be optimized here?</p></li> <li><p>What type of construction should devices have that are to be replaced? Are enough corresponding devices still available or is it necessary to acquire these?</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 (2)

Source	Alias	Join Type
I_UtilitiesDevice	I_UtilitiesDevice	inner
I_UtilsPeriodicRplcmtList	I_UtilsPeriodicRplcmtList	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_UtilsPeriodicRplcmtList	_UtilsPerdcRplcmtListExtension	`$projection.UtilitiesDevice = _UtilsPerdcRplcmtListExtension.UtilsEquipmentPerdcRplcmtList`
[0..1]	E_UtilitiesDeviceHeader	_UtilsDeviceHeaderExtension	`$projection.UtilitiesDevice = _UtilsDeviceHeaderExtension.Equipment`

Annotations (13)

Name	Value	Level
EndUserText.label	Device Periodic Replacement List	view
Analytics.dataCategory	#CUBE	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#MANDATORY	view
AbapCatalog.sqlViewName	IEDVCEPERDCRL	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 (146)

Key	Field	Source Table	Source Field	Description
KEY	UtilsEquipmentPerdcRplcmtList	I_UtilsPeriodicRplcmtList	UtilsEquipmentPerdcRplcmtList	Equipment Number
	UtilsPerdcRplcmtYear	I_UtilsPeriodicRplcmtList	UtilsPerdcRplcmtYear	Periodic replacement year
	UtilsDeviceRemovalDate	I_UtilsPeriodicRplcmtList	UtilsDeviceRemovalDate	Device removal date
	MaintenanceOrder	I_UtilsPeriodicRplcmtList	MaintenanceOrder	Order Number
	MaintenanceNotification	I_UtilsPeriodicRplcmtList	MaintenanceNotification	Notification Number
	MeterReadingUnit	I_UtilsPeriodicRplcmtList	MeterReadingUnit	Meter Reading Unit
	Material	I_UtilsPeriodicRplcmtList	Material	Material Number
	UtilitiesDivision	I_UtilsPeriodicRplcmtList	UtilitiesDivision	Insurance LOB
	RegionalStructureGrouping	I_UtilsPeriodicRplcmtList	RegionalStructureGrouping	Regional structure grouping
	UtilsPerdcRplcmtCreationDate			Record Created On
	UtilsPerdcRplcmtCreatedByUser			Name of Person Responsible for Creating the Object
	UtilsPerdcRplcmtLastChangeDate			Last Changed On
	UtilsPerdcRplcmtLastChgdByUser			Name of Person Who Changed Object
	_CreatedByUser
	_LastChangedByUser
	UtilsDeviceValidityEndDate	I_UtilitiesDevice	UtilsDeviceValidityEndDate	Validity End Date of Device
	UtilitiesDevice	I_UtilitiesDevice	UtilitiesDevice	Equipment Number
	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
	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.
	_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
	_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
	AddressID	_UtilsTechObjLocationAddr	AddressID	Ship-to address
	_Address	_UtilsTechObjLocationAddr	_Address
	_Address2	_UtilsTechObjLocationAddr	_Address2
	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
	HomeCityName			City (different from postal city)
	PostalCode			City postal code
	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
	MaintenanceObjectLocation	_UtilsTechObjLocationAddr	MaintenanceObjectLocation	Location of maintenance object

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_UtilsDvcePerdcRplcmntList.
-- 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: IEDVCEPERDCRL
-- Parameters: P_KeyDate : e_keydate_vdm

CREATE VIEW I_UtilsDvcePerdcRplcmntList AS
SELECT
  I_UtilsPeriodicRplcmtList.UtilsEquipmentPerdcRplcmtList AS UtilsEquipmentPerdcRplcmtList,
  I_UtilsPeriodicRplcmtList.UtilsPerdcRplcmtYear AS UtilsPerdcRplcmtYear,
  I_UtilsPeriodicRplcmtList.UtilsDeviceRemovalDate AS UtilsDeviceRemovalDate,
  I_UtilsPeriodicRplcmtList.MaintenanceOrder AS MaintenanceOrder,
  I_UtilsPeriodicRplcmtList.MaintenanceNotification AS MaintenanceNotification,
  I_UtilsPeriodicRplcmtList.MeterReadingUnit AS MeterReadingUnit,
  I_UtilsPeriodicRplcmtList.Material AS Material,
  I_UtilsPeriodicRplcmtList.UtilitiesDivision AS UtilitiesDivision,
  I_UtilsPeriodicRplcmtList.RegionalStructureGrouping AS RegionalStructureGrouping,
  I_UtilsPeriodicRplcmtList._UtilsPerdcRplcmtListAndHdr.UtilsPerdcRplcmtCreationDate AS UtilsPerdcRplcmtCreationDate,
  I_UtilsPeriodicRplcmtList._UtilsPerdcRplcmtListAndHdr.UtilsPerdcRplcmtCreatedByUser AS UtilsPerdcRplcmtCreatedByUser,
  I_UtilsPeriodicRplcmtList._UtilsPerdcRplcmtListAndHdr.UtilsPerdcRplcmtLastChangeDate AS UtilsPerdcRplcmtLastChangeDate,
  I_UtilsPeriodicRplcmtList._UtilsPerdcRplcmtListAndHdr.UtilsPerdcRplcmtLastChgdByUser AS UtilsPerdcRplcmtLastChgdByUser,
  I_UtilsPeriodicRplcmtList._UtilsPerdcRplcmtListAndHdr._CreatedByUser AS _CreatedByUser,
  I_UtilsPeriodicRplcmtList._UtilsPerdcRplcmtListAndHdr._LastChangedByUser AS _LastChangedByUser,
  I_UtilitiesDevice.UtilsDeviceValidityEndDate AS UtilsDeviceValidityEndDate,
  I_UtilitiesDevice.UtilitiesDevice AS UtilitiesDevice,
  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.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,
  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,
  _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.AddressID AS AddressID,
  _UtilsTechObjLocationAddr._Address AS _Address,
  _UtilsTechObjLocationAddr._Address2 AS _Address2,
  _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.VillageName AS HomeCityName,
  _UtilsTechObjLocationAddr._Address2.PostalCode AS PostalCode,
  _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.MaintenanceObjectLocation AS MaintenanceObjectLocation
FROM I_UtilsPeriodicRplcmtList
INNER JOIN I_UtilitiesDevice ON /* join condition not captured in parsed metadata */
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_UtilsPeriodicRplcmtList AS _UtilsPerdcRplcmtListExtension ON UtilitiesDevice = _UtilsPerdcRplcmtListExtension.UtilsEquipmentPerdcRplcmtList  -- association [0..1]
LEFT OUTER JOIN E_UtilitiesDeviceHeader AS _UtilsDeviceHeaderExtension ON UtilitiesDevice = _UtilsDeviceHeaderExtension.Equipment  -- association [0..1]
;

Depth:

I_UtilsDvcePerdcRplcmntList view

I_UtilsPeriodicRplcmtList view
I_UtilitiesDevice view

C_UtilsDvcePerdcRplcmntListQ view