What is C_UtilitiesDeviceHistoryDEX in SAP S/4HANA?

C_UtilitiesDeviceHistoryDEX is a consumption CDS view in SAP S/4HANA. Data Extractor for Device History It contains 115 fields.

Which tables does C_UtilitiesDeviceHistoryDEX read from?

C_UtilitiesDeviceHistoryDEX reads data from: I_UtilitiesDeviceHistory.

What VDM layer is C_UtilitiesDeviceHistoryDEX?

C_UtilitiesDeviceHistoryDEX is classified as a Consumption view optimized for specific business scenarios and reporting.

C_UtilitiesDeviceHistoryDEX

DDL: C_UTILITIESDEVICEHISTORYDEX Type: view_entity CONSUMPTION

115 Fields 1 Data Sources

Data Extractor for Device History

C_UtilitiesDeviceHistoryDEX (Consumption)

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

Utilities Device · Utilities

C_UtilitiesDeviceHistoryDEX is a Consumption CDS View (Fact) that provides data about "Data Extractor for Device History" in SAP S/4HANA. It reads from 1 data source (I_UtilitiesDeviceHistory) and exposes 115 fields with key fields Equipment, UtilsDeviceValidityEndDate.

SAP API Hub

State	C1
Line of Business	Utilities
Application Component	IS-U-DM
Capabilities	Data Source for Data Extraction
Package	Utilities for SAP S/4HANA
Description	<p>This CDS view provides data for the register info group.</p>

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_UtilitiesDeviceHistory	I_UtilitiesDeviceHistory	from

Annotations (12)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Data Extractor for Device History	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.modelingPattern	#NONE	view
ObjectModel.sapObjectNodeType.name	UtilitiesDevice	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
Analytics.dataCategory	#FACT	view
Analytics.technicalName	CUTILDEVICEHISTDEX	view
Analytics.dataExtraction.enabled	true	view

Fields (115)

Key	Field	Source Table	Source Field	Description
KEY	Equipment	I_UtilitiesDeviceHistory	Equipment	Equipment Number
KEY	UtilsDeviceValidityEndDate	I_UtilitiesDeviceHistory	UtilsDeviceValidityEndDate	Validity End Date of Device
	UtilsDeviceActivityReason	I_UtilitiesDeviceHistory	UtilsDeviceActivityReason	Activity reason
	UtilsDeviceValidityStartDate	I_UtilitiesDeviceHistory	UtilsDeviceValidityStartDate	Validity Start Date of Device
	UtilsDeviceBscCatCombination	I_UtilitiesDeviceHistory	UtilsDeviceBscCatCombination	Combination of a device category
	UtilitiesLogicalDeviceNumber	I_UtilitiesDeviceHistory	UtilitiesLogicalDeviceNumber	Logical device number
	UtilitiesRegisterGroup	I_UtilitiesDeviceHistory	UtilitiesRegisterGroup	Register Group
	UtilsDeviceInstallationDate	I_UtilitiesDeviceHistory	UtilsDeviceInstallationDate	Installation date
	UtilsDeviceRemovalDate	I_UtilitiesDeviceHistory	UtilsDeviceRemovalDate	Device removal date
	UtilsDeviceLocation	I_UtilitiesDeviceHistory	UtilsDeviceLocation	Device Location
	UtilsDeviceGroup	I_UtilitiesDeviceHistory	UtilsDeviceGroup	Device group
	UtilsDeviceWindingGroup	I_UtilitiesDeviceHistory	UtilsDeviceWindingGroup	Winding group
	UtilitiesPrepaymentMeterType	I_UtilitiesDeviceHistory	UtilitiesPrepaymentMeterType	Prepayment Meter
	UtilsDeviceLossDetnGroup	I_UtilitiesDeviceHistory	UtilsDeviceLossDetnGroup	Loss Determination Group
	DvcePwrTrnsfrmtrTrnsfRatingVal	I_UtilitiesDeviceHistory	DvcePwrTrnsfrmtrTrnsfRatingVal	Power Transformer: Rating
	DvcePwrTrnsfrmtrPrimVoltVal	I_UtilitiesDeviceHistory	DvcePwrTrnsfrmtrPrimVoltVal	Power Transformer: Primary Voltage
	DvcePwrTrnsfrmtrSecdryVoltVal	I_UtilitiesDeviceHistory	DvcePwrTrnsfrmtrSecdryVoltVal	Power Transformer: Secondary Voltage
	AdvancedMeteringSystem	I_UtilitiesDeviceHistory	AdvancedMeteringSystem	Advanced Metering System
	AdvancedMeterCapabilityGroup	I_UtilitiesDeviceHistory	AdvancedMeterCapabilityGroup	Advanced Meter Capability Group (AMCG)
	UtilsDeviceInOutGroup	I_UtilitiesDeviceHeader	UtilsDeviceInOutGroup	Input/output group
	UtilsDeviceARCRCommandGroup	I_UtilitiesDeviceHeader	UtilsDeviceARCRCommandGroup	ARCR Command Group
	UtilsDeviceSampleLot	I_UtilitiesDeviceHeader	UtilsDeviceSampleLot	Sample lot
	UtilsDeviceMeasuredPressure	I_UtilitiesDeviceHeader	UtilsDeviceMeasuredPressure	Measured Pressure (Outlet Pressure) in Bars
	UtilsDeviceTransformationRatio	I_UtilitiesDeviceHeader	UtilsDeviceTransformationRatio	Transformation ratio
	UtilsDeviceInspRelevanceCode	I_UtilitiesDeviceHeader	UtilsDeviceInspRelevanceCode	Inspection relevance of device
	UtilsDeviceCertificationYear	I_UtilitiesDeviceHeader	UtilsDeviceCertificationYear	Certification Year
	UtilsDeviceAdvncRplcmtYear	I_UtilitiesDeviceHeader	UtilsDeviceAdvncRplcmtYear	Advance replacement year
	UtilsDeviceCertfnStatus	I_UtilitiesDeviceHeader	UtilsDeviceCertfnStatus	Certification status
	SampleUtilsDeviceStatus	I_UtilitiesDeviceHeader	SampleUtilsDeviceStatus	Status of sample device
	UtilsDeviceLastLeadSealingDate	I_UtilitiesDeviceHeader	UtilsDeviceLastLeadSealingDate	Date of last lead sealing
	UtilsDeviceCertfnType	I_UtilitiesDeviceHeader	UtilsDeviceCertfnType	Type of certification
	UtilsDeviceCertificationNumber	I_UtilitiesDeviceHeader	UtilsDeviceCertificationNumber	Certification number
	UtilsDeviceModificationDate	I_UtilitiesDeviceHeader	UtilsDeviceModificationDate	Modification date
	UtilsDeviceModReason	I_UtilitiesDeviceHeader	UtilsDeviceModReason	Modification reason
	UtilsDeviceCalibrnValdtyIsUsed	I_UtilitiesDeviceHeader	UtilsDeviceCalibrnValdtyIsUsed	Use calibration validity
	UtilsDeviceParametrizationCode	I_UtilitiesDeviceHeader	UtilsDeviceParametrizationCode	Parametrization
	UtilsDeviceLeadSealingCode	I_UtilitiesDeviceHeader	UtilsDeviceLeadSealingCode	Seal code
	LastChangeDate	I_UtilitiesDeviceHeader	LastChangeDate	Last Changed On
	UtilsDeviceLastChangedByUser	I_UtilitiesDeviceHeader	UtilsDeviceLastChangedByUser	Name of Person Who Changed Object
	UtilsDeviceInspPointGroup	I_UtilitiesDeviceHeader	UtilsDeviceInspPointGroup	Inspection point group
	InstdUtilsDeviceIsCertifiable	I_UtilitiesDeviceHeader	InstdUtilsDeviceIsCertifiable	Certify installed devices
	UtilsDeviceInspectionNumber	I_UtilitiesDeviceHeader	UtilsDeviceInspectionNumber	Device inspection number
	DvceIndivCertfnValdtyInYrs	I_UtilitiesDeviceHeader	DvceIndivCertfnValdtyInYrs	Individual cal. validity (years) of dev. subject to certif.
	EquipmentOID	I_Equipment	EquipmentOID	Object Instance ID of an Equipment
	EquipmentCategory	I_Equipment	EquipmentCategory	Equipment category
	TechnicalObjectType	I_Equipment	TechnicalObjectType	Type of Technical Object
	Plant	I_Equipment	Plant	Valuation Area
	Division	I_Equipment	Division	Internal Division ID
	StorageLocation	I_Equipment	StorageLocation	Storage Location
	AssetManufacturerName	I_Equipment	AssetManufacturerName	Manufacturer of Asset
	ManufacturerPartTypeName	I_Equipment	ManufacturerPartTypeName	Manufacturer model number
	ManufacturerCountry	I_Equipment	ManufacturerCountry	Country/Region of Manufacture
	ConstructionYear	I_Equipment	ConstructionYear	Year of construction
	ConstructionMonth	I_Equipment	ConstructionMonth	Month of construction
	AcquisitionDate	I_Equipment	AcquisitionDate	Acquisition date
	Currency	I_Equipment	Currency	Valuation Crcy
	AcquisitionValue	I_Equipment	AcquisitionValue	Acquisition Value
	MaintObjectInternalID	I_Equipment	MaintObjectInternalID	Object number
	SerialNumber	I_Equipment	SerialNumber	Serial Number
	EquipUsagePeriodSequenceNumber	I_Equipment	EquipUsagePeriodSequenceNumber	Consecutive numbering of EquipUsagePeriods on same day
	Material	I_Equipment	Material	Material Number
	Customer	I_Equipment	Customer	Customer to Whom Serial Number was Delivered
	AuthorizationGroup	I_Equipment	AuthorizationGroup	Technical Object Authorization Group
	ManufacturerSerialNumber	I_Equipment	ManufacturerSerialNumber	Manufacturer's Serial Number
	UniqueItemIdentifier	I_Equipment	UniqueItemIdentifier	Unique Item Identifier
	UniqueItemIdentifierStrucType	I_Equipment	UniqueItemIdentifierStrucType	Structure Type of UII
	UniqueItemIdentifierRespPlant	I_Equipment	UniqueItemIdentifierRespPlant	Plant Responsible for UII
	AssetSynchronizationRule	I_Equipment	AssetSynchronizationRule	Change Equipment Master when Changing Asset
	InventoryNumber	I_Equipment	InventoryNumber	Inventory number
	GrossWeight	I_Equipment	GrossWeight	Weight of object
	GrossWeightUnit	I_Equipment	GrossWeightUnit	Unit of weight
	SizeOrDimensionText	I_Equipment	SizeOrDimensionText	Size/dimensions
	Batch	I_Equipment	Batch	Batch Number
	OperationStartDate	I_Equipment	OperationStartDate	Start-up Date of the Technical Object
	Supplier	I_Equipment	Supplier	Vendor number
	HasEquipmentData	I_Equipment	HasEquipmentData	Equipment data exists
	EquipmentHasStockInformation	I_Equipment	EquipmentHasStockInformation	Indicator: Stock Information Available
	MasterWarranty	I_Equipment	MasterWarranty	Master warranty number
	LastChangeDateTime	I_Equipment	LastChangeDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	EquipmentFirstDeliveryDate	I_Equipment	EquipmentFirstDeliveryDate	First delivery date of the equipment
	ValidityStartDate	I_Equipment	ValidityStartDate	Validity Start Date
	ValidityEndDate	I_Equipment	ValidityEndDate	Valid To Date
	MatlSrlNmbrLastGdsMvtDte	I_Equipment	MatlSrlNmbrLastGdsMvtDte	Date of Last Goods Movement
	EquipmentEndOfUseDate	I_Equipment	EquipmentEndOfUseDate	End-of-Use Date of the Technical Object
	MaintenancePlan	I_Equipment	MaintenancePlan	Maintenance Plan
	MeasuringPoint	I_Equipment	MeasuringPoint	Measuring Point
	_UtilitiesDeviceHeader	I_UtilitiesDeviceHistory	_UtilitiesDeviceHeader
	_UtilsAdvncdMeteringSystem	I_UtilitiesDeviceHistory	_UtilsAdvncdMeteringSystem
	_UtilsDvceActivityReason	I_UtilitiesDeviceHistory	_UtilsDvceActivityReason
	_UtilsDvceLossDetnGroup	I_UtilitiesDeviceHistory	_UtilsDvceLossDetnGroup
	_UtilsRegisterGroupInfoText	I_UtilitiesDeviceHistory	_UtilsRegisterGroupInfoText
	_UtilsDeviceCertfnStatus	I_UtilitiesDeviceHeader	_UtilsDeviceCertfnStatus
	_UtilsDeviceCertfnType	I_UtilitiesDeviceHeader	_UtilsDeviceCertfnType
	_UtilsDeviceLastChangedByUser	I_UtilitiesDeviceHeader	_UtilsDeviceLastChangedByUser
	_UtilsDeviceModReason	I_UtilitiesDeviceHeader	_UtilsDeviceModReason
	_UtilsDeviceSampleLot	I_UtilitiesDeviceHeader	_UtilsDeviceSampleLot
	_UtilsDvceInspRelevance	I_UtilitiesDeviceHeader	_UtilsDvceInspRelevance
	_UtilsDvceParametrization	I_UtilitiesDeviceHeader	_UtilsDvceParametrization
	_UtilsSampleDeviceStatus	I_UtilitiesDeviceHeader	_UtilsSampleDeviceStatus
	_Batch	I_Equipment	_Batch
	_Currency	I_Equipment	_Currency
	_Customer	I_Equipment	_Customer
	_Division	I_Equipment	_Division
	_EquipmentCategory	I_Equipment	_EquipmentCategory
	_GrossWeightUnit	I_Equipment	_GrossWeightUnit
	_ManufacturerCountry	I_Equipment	_ManufacturerCountry
	_MasterWarranty	I_Equipment	_MasterWarranty
	_MasterWrntyObjectAssgmt	I_Equipment	_MasterWrntyObjectAssgmt
	_Material	I_Equipment	_Material
	_Plant	I_Equipment	_Plant
	_PlantMaintenancePartner	I_Equipment	_PlantMaintenancePartner
	_Status	I_Equipment	_Status
	_StorageLocation	I_Equipment	_StorageLocation
	_Supplier	I_Equipment	_Supplier
	_TechnicalObjectType	I_Equipment	_TechnicalObjectType

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 C_UtilitiesDeviceHistoryDEX.
-- 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.

CREATE VIEW C_UtilitiesDeviceHistoryDEX AS
SELECT
  I_UtilitiesDeviceHistory.Equipment AS Equipment,
  I_UtilitiesDeviceHistory.UtilsDeviceValidityEndDate AS UtilsDeviceValidityEndDate,
  I_UtilitiesDeviceHistory.UtilsDeviceActivityReason AS UtilsDeviceActivityReason,
  I_UtilitiesDeviceHistory.UtilsDeviceValidityStartDate AS UtilsDeviceValidityStartDate,
  I_UtilitiesDeviceHistory.UtilsDeviceBscCatCombination AS UtilsDeviceBscCatCombination,
  I_UtilitiesDeviceHistory.UtilitiesLogicalDeviceNumber AS UtilitiesLogicalDeviceNumber,
  I_UtilitiesDeviceHistory.UtilitiesRegisterGroup AS UtilitiesRegisterGroup,
  I_UtilitiesDeviceHistory.UtilsDeviceInstallationDate AS UtilsDeviceInstallationDate,
  I_UtilitiesDeviceHistory.UtilsDeviceRemovalDate AS UtilsDeviceRemovalDate,
  I_UtilitiesDeviceHistory.UtilsDeviceLocation AS UtilsDeviceLocation,
  I_UtilitiesDeviceHistory.UtilsDeviceGroup AS UtilsDeviceGroup,
  I_UtilitiesDeviceHistory.UtilsDeviceWindingGroup AS UtilsDeviceWindingGroup,
  I_UtilitiesDeviceHistory.UtilitiesPrepaymentMeterType AS UtilitiesPrepaymentMeterType,
  I_UtilitiesDeviceHistory.UtilsDeviceLossDetnGroup AS UtilsDeviceLossDetnGroup,
  I_UtilitiesDeviceHistory.DvcePwrTrnsfrmtrTrnsfRatingVal AS DvcePwrTrnsfrmtrTrnsfRatingVal,
  I_UtilitiesDeviceHistory.DvcePwrTrnsfrmtrPrimVoltVal AS DvcePwrTrnsfrmtrPrimVoltVal,
  I_UtilitiesDeviceHistory.DvcePwrTrnsfrmtrSecdryVoltVal AS DvcePwrTrnsfrmtrSecdryVoltVal,
  I_UtilitiesDeviceHistory.AdvancedMeteringSystem AS AdvancedMeteringSystem,
  I_UtilitiesDeviceHistory.AdvancedMeterCapabilityGroup AS AdvancedMeterCapabilityGroup,
  I_UtilitiesDeviceHeader.UtilsDeviceInOutGroup AS UtilsDeviceInOutGroup,
  I_UtilitiesDeviceHeader.UtilsDeviceARCRCommandGroup AS UtilsDeviceARCRCommandGroup,
  I_UtilitiesDeviceHeader.UtilsDeviceSampleLot AS UtilsDeviceSampleLot,
  I_UtilitiesDeviceHeader.UtilsDeviceMeasuredPressure AS UtilsDeviceMeasuredPressure,
  I_UtilitiesDeviceHeader.UtilsDeviceTransformationRatio AS UtilsDeviceTransformationRatio,
  I_UtilitiesDeviceHeader.UtilsDeviceInspRelevanceCode AS UtilsDeviceInspRelevanceCode,
  I_UtilitiesDeviceHeader.UtilsDeviceCertificationYear AS UtilsDeviceCertificationYear,
  I_UtilitiesDeviceHeader.UtilsDeviceAdvncRplcmtYear AS UtilsDeviceAdvncRplcmtYear,
  I_UtilitiesDeviceHeader.UtilsDeviceCertfnStatus AS UtilsDeviceCertfnStatus,
  I_UtilitiesDeviceHeader.SampleUtilsDeviceStatus AS SampleUtilsDeviceStatus,
  I_UtilitiesDeviceHeader.UtilsDeviceLastLeadSealingDate AS UtilsDeviceLastLeadSealingDate,
  I_UtilitiesDeviceHeader.UtilsDeviceCertfnType AS UtilsDeviceCertfnType,
  I_UtilitiesDeviceHeader.UtilsDeviceCertificationNumber AS UtilsDeviceCertificationNumber,
  I_UtilitiesDeviceHeader.UtilsDeviceModificationDate AS UtilsDeviceModificationDate,
  I_UtilitiesDeviceHeader.UtilsDeviceModReason AS UtilsDeviceModReason,
  I_UtilitiesDeviceHeader.UtilsDeviceCalibrnValdtyIsUsed AS UtilsDeviceCalibrnValdtyIsUsed,
  I_UtilitiesDeviceHeader.UtilsDeviceParametrizationCode AS UtilsDeviceParametrizationCode,
  I_UtilitiesDeviceHeader.UtilsDeviceLeadSealingCode AS UtilsDeviceLeadSealingCode,
  I_UtilitiesDeviceHeader.LastChangeDate AS LastChangeDate,
  I_UtilitiesDeviceHeader.UtilsDeviceLastChangedByUser AS UtilsDeviceLastChangedByUser,
  I_UtilitiesDeviceHeader.UtilsDeviceInspPointGroup AS UtilsDeviceInspPointGroup,
  I_UtilitiesDeviceHeader.InstdUtilsDeviceIsCertifiable AS InstdUtilsDeviceIsCertifiable,
  I_UtilitiesDeviceHeader.UtilsDeviceInspectionNumber AS UtilsDeviceInspectionNumber,
  I_UtilitiesDeviceHeader.DvceIndivCertfnValdtyInYrs AS DvceIndivCertfnValdtyInYrs,
  I_Equipment.EquipmentOID AS EquipmentOID,
  I_Equipment.EquipmentCategory AS EquipmentCategory,
  I_Equipment.TechnicalObjectType AS TechnicalObjectType,
  I_Equipment.Plant AS Plant,
  I_Equipment.Division AS Division,
  I_Equipment.StorageLocation AS StorageLocation,
  I_Equipment.AssetManufacturerName AS AssetManufacturerName,
  I_Equipment.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  I_Equipment.ManufacturerCountry AS ManufacturerCountry,
  I_Equipment.ConstructionYear AS ConstructionYear,
  I_Equipment.ConstructionMonth AS ConstructionMonth,
  I_Equipment.AcquisitionDate AS AcquisitionDate,
  I_Equipment.Currency AS Currency,
  I_Equipment.AcquisitionValue AS AcquisitionValue,
  I_Equipment.MaintObjectInternalID AS MaintObjectInternalID,
  I_Equipment.SerialNumber AS SerialNumber,
  I_Equipment.EquipUsagePeriodSequenceNumber AS EquipUsagePeriodSequenceNumber,
  I_Equipment.Material AS Material,
  I_Equipment.Customer AS Customer,
  I_Equipment.AuthorizationGroup AS AuthorizationGroup,
  I_Equipment.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  I_Equipment.UniqueItemIdentifier AS UniqueItemIdentifier,
  I_Equipment.UniqueItemIdentifierStrucType AS UniqueItemIdentifierStrucType,
  I_Equipment.UniqueItemIdentifierRespPlant AS UniqueItemIdentifierRespPlant,
  I_Equipment.AssetSynchronizationRule AS AssetSynchronizationRule,
  I_Equipment.InventoryNumber AS InventoryNumber,
  I_Equipment.GrossWeight AS GrossWeight,
  I_Equipment.GrossWeightUnit AS GrossWeightUnit,
  I_Equipment.SizeOrDimensionText AS SizeOrDimensionText,
  I_Equipment.Batch AS Batch,
  I_Equipment.OperationStartDate AS OperationStartDate,
  I_Equipment.Supplier AS Supplier,
  I_Equipment.HasEquipmentData AS HasEquipmentData,
  I_Equipment.EquipmentHasStockInformation AS EquipmentHasStockInformation,
  I_Equipment.MasterWarranty AS MasterWarranty,
  I_Equipment.LastChangeDateTime AS LastChangeDateTime,
  I_Equipment.EquipmentFirstDeliveryDate AS EquipmentFirstDeliveryDate,
  I_Equipment.ValidityStartDate AS ValidityStartDate,
  I_Equipment.ValidityEndDate AS ValidityEndDate,
  I_Equipment.MatlSrlNmbrLastGdsMvtDte AS MatlSrlNmbrLastGdsMvtDte,
  I_Equipment.EquipmentEndOfUseDate AS EquipmentEndOfUseDate,
  I_Equipment.MaintenancePlan AS MaintenancePlan,
  I_Equipment.MeasuringPoint AS MeasuringPoint,
  I_UtilitiesDeviceHistory._UtilitiesDeviceHeader AS _UtilitiesDeviceHeader,
  I_UtilitiesDeviceHistory._UtilsAdvncdMeteringSystem AS _UtilsAdvncdMeteringSystem,
  I_UtilitiesDeviceHistory._UtilsDvceActivityReason AS _UtilsDvceActivityReason,
  I_UtilitiesDeviceHistory._UtilsDvceLossDetnGroup AS _UtilsDvceLossDetnGroup,
  I_UtilitiesDeviceHistory._UtilsRegisterGroupInfoText AS _UtilsRegisterGroupInfoText,
  I_UtilitiesDeviceHeader._UtilsDeviceCertfnStatus AS _UtilsDeviceCertfnStatus,
  I_UtilitiesDeviceHeader._UtilsDeviceCertfnType AS _UtilsDeviceCertfnType,
  I_UtilitiesDeviceHeader._UtilsDeviceLastChangedByUser AS _UtilsDeviceLastChangedByUser,
  I_UtilitiesDeviceHeader._UtilsDeviceModReason AS _UtilsDeviceModReason,
  I_UtilitiesDeviceHeader._UtilsDeviceSampleLot AS _UtilsDeviceSampleLot,
  I_UtilitiesDeviceHeader._UtilsDvceInspRelevance AS _UtilsDvceInspRelevance,
  I_UtilitiesDeviceHeader._UtilsDvceParametrization AS _UtilsDvceParametrization,
  I_UtilitiesDeviceHeader._UtilsSampleDeviceStatus AS _UtilsSampleDeviceStatus,
  I_Equipment._Batch AS _Batch,
  I_Equipment._Currency AS _Currency,
  I_Equipment._Customer AS _Customer,
  I_Equipment._Division AS _Division,
  I_Equipment._EquipmentCategory AS _EquipmentCategory,
  I_Equipment._GrossWeightUnit AS _GrossWeightUnit,
  I_Equipment._ManufacturerCountry AS _ManufacturerCountry,
  I_Equipment._MasterWarranty AS _MasterWarranty,
  I_Equipment._MasterWrntyObjectAssgmt AS _MasterWrntyObjectAssgmt,
  I_Equipment._Material AS _Material,
  I_Equipment._Plant AS _Plant,
  I_Equipment._PlantMaintenancePartner AS _PlantMaintenancePartner,
  I_Equipment._Status AS _Status,
  I_Equipment._StorageLocation AS _StorageLocation,
  I_Equipment._Supplier AS _Supplier,
  I_Equipment._TechnicalObjectType AS _TechnicalObjectType
FROM I_UtilitiesDeviceHistory
;

Depth:

C_UtilitiesDeviceHistoryDEX view_entity

I_UtilitiesDeviceHistory view