What is C_UtilsInstallationHistoryDEX in SAP S/4HANA?

C_UtilsInstallationHistoryDEX is a consumption CDS view in SAP S/4HANA. Data Extractor for Intstallation History It contains 42 fields.

Which tables does C_UtilsInstallationHistoryDEX read from?

C_UtilsInstallationHistoryDEX reads data from: I_UtilitiesInstallationHist.

What VDM layer is C_UtilsInstallationHistoryDEX?

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

C_UtilsInstallationHistoryDEX

DDL: C_UTILSINSTALLATIONHISTORYDEX Type: view_entity CONSUMPTION

42 Fields 1 Data Sources 2 Associations

Data Extractor for Intstallation History

C_UtilsInstallationHistoryDEX (Consumption)

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

Utilities Installation · Utilities

C_UtilsInstallationHistoryDEX is a Consumption CDS View (Fact) that provides data about "Data Extractor for Intstallation History" in SAP S/4HANA. It reads from 1 data source (I_UtilitiesInstallationHist) and exposes 42 fields with key fields UtilitiesInstallation, UtilsInstHistValidityEndDate. It has 2 associations to related views.

SAP Help Documentation

Category	Installation
Data Category	Fact
Status	C1
Corresponding DataSource	2CCUTILINSTHISTDEX

Purpose
This CDS view provides information about the connection between the IS-U installation and the historical data of an installation and allows data extraction to the SAP Business Warehouse (SAP BW). In addition, this CDS view can directly be used as a data source in the SAP Data Sphere or SAP Analytics Cloud (SAC) .

SAP Business Warehouse (SAP BW) Extraction
Data extraction type Delta-enabled with Change Data Capture (CDC) Corresponding DataSource (Extractor) Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content .

Prerequisites
Authorizations The following authorization objects are required to use this CDS view: E_INSTLN (Authorization to display installation data )

Structure
Important fields in this view include the following: Field Name Description UtilitiesInstallation Installation UtilitiesRateCategory Rate Category MeterReadingUnit Meter Reading Unit UtilitiesBillingClass Billing Class UtilitiesDivision Division UtilitiesBillingParty Service provider who bills the installation

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Utilities
Application Component	IS-U-MD
Capabilities	Data Source for Data Extraction
Package	Utilities for SAP S/4HANA

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_UtilitiesInstallationHist	I_UtilitiesInstallationHist	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	E_UtilitiesInstallation	_ExtensionInstallation	`_ExtensionInstallation.UtilitiesInstallation = $projection.UtilitiesInstallation`
[0..1]	E_UtilitiesInstallationHist	_ExtensionInstallationHist	`_ExtensionInstallationHist.UtilitiesInstallation = $projection.UtilitiesInstallation and _ExtensionInstallationHist.UtilsInstHistValidityEndDate = $projection.UtilsInstHistValidityEndDate`

Annotations (12)

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

Fields (42)

Key	Field	Source Table	Source Field	Description
KEY	UtilitiesInstallation	I_UtilitiesInstallationHist	UtilitiesInstallation	Installation
KEY	UtilsInstHistValidityEndDate	I_UtilitiesInstallationHist	UtilsInstHistValidityEndDate	Validity End Date of Installation
	UtilsInstHistValidityStartDate	I_UtilitiesInstallationHist	UtilsInstHistValidityStartDate	Validity Start Date of Installation
	UtilitiesRateCategory	I_UtilitiesInstallationHist	UtilitiesRateCategory	Rate category
	UtilitiesBillingSchema	I_UtilitiesInstallationHist	UtilitiesBillingSchema	Number of the billing schema
	UtilitiesBillingClass	I_UtilitiesInstallationHist	UtilitiesBillingClass	Billing Class
	MeterReadingUnit	I_UtilitiesInstallationHist	MeterReadingUnit	Meter Reading Unit
	UtilitiesTemperatureArea	I_UtilitiesInstallationHist	UtilitiesTemperatureArea	Temperature area
	UtilsInstIsExmptFrmFrnchsFee	I_UtilitiesInstallationHist	UtilsInstIsExmptFrmFrnchsFee	Exempt from franchise fee
	UtilsInstDvceAllctnIsNotAllwd	I_UtilitiesInstallationHist	UtilsInstDvceAllctnIsNotAllwd	Device allocation is not possible
	UtilitiesFranchiseContract	I_UtilitiesInstallationHist	UtilitiesFranchiseContract	Franchise contract
	UtilitiesBillingParty	I_UtilitiesInstallationHist	UtilitiesBillingParty	Service Provider that Bills the Installation
	UtilitiesInvoicingParty	I_UtilitiesInstallationHist	UtilitiesInvoicingParty	Service Provider That Invoices the Contract
	ObligatorySupUtilsSrvcProvider	I_UtilitiesInstallationHist	ObligatorySupUtilsSrvcProvider	Obligation to Supply
	PrimaryUtilitiesInstallation	I_UtilitiesInstallationHist	PrimaryUtilitiesInstallation	Key of Primary Installation
	UtilsInstallationGroupRole	I_UtilitiesInstallationHist	UtilsInstallationGroupRole	Role of an Installation Within the Installation Group
	UtilsInstallationGroupType	I_UtilitiesInstallationHist	UtilsInstallationGroupType	Grouping Type for Installation Group
	HigherLevelUtilsInstallation	I_UtilitiesInstallationHist	HigherLevelUtilsInstallation	Higher-Level Installation
	UnbilldRevnXtrapltnType	I_UtilitiesInstallationHist	UnbilldRevnXtrapltnType	Type of extrapolation in unbilled revenue reporting
	UtilsRegDepdntValdtnGroup	I_UtilitiesInstallationHist	UtilsRegDepdntValdtnGroup	Validation group for dependent validations
	UtilitiesInstallationType	I_UtilitiesInstallation	UtilitiesInstallationType	Installation type
	Division	I_UtilitiesInstallation	Division	Internal Division ID
	UtilitiesInstVoltageLevel	I_UtilitiesInstallation	UtilitiesInstVoltageLevel	Voltage Level
	UtilitiesInstGasPrssrLvl	I_UtilitiesInstallation	UtilitiesInstGasPrssrLvl	Gas Pressure Level at Installation Level (Grid)
	UtilsInstTimeZone	I_UtilitiesInstallation	UtilsInstTimeZone	Time Zone for EDM Objects
	UtilsInstGuarOfSupReason	I_UtilitiesInstallation	UtilsInstGuarOfSupReason	Reason for guarantee of supply
	UtilsInstDeregulationSts	I_UtilitiesInstallation	UtilsInstDeregulationSts	Deregulation status
	UtilsInstDataReleaseStatus	I_UtilitiesInstallation	UtilsInstDataReleaseStatus	Release Status for Installation Data
	UtilitiesSrvcProviderRole	I_UtilitiesInstallation	UtilitiesSrvcProviderRole	Service Type
	UtilsInstIsForEnergyFeedIn	I_UtilitiesInstallation	UtilsInstIsForEnergyFeedIn	Purchase
	UtilsInstCreationDate	I_UtilitiesInstallation	UtilsInstCreationDate	Record Created On
	UtilsInstCreatedByUser	I_UtilitiesInstallation	UtilsInstCreatedByUser	Name of Person Responsible for Creating the Object
	UtilsInstLastChangeDate	I_UtilitiesInstallation	UtilsInstLastChangeDate	Last Changed On
	UtilsInstLastChangedByUser	I_UtilitiesInstallation	UtilsInstLastChangedByUser	Name of Person Who Changed Object
	MeterReadingBlockingReason	I_UtilitiesInstallation	MeterReadingBlockingReason	Reason for blocking meter reading
	MeterReadingBasePeriodCat	I_UtilitiesInstallation	MeterReadingBasePeriodCat	Base period category
	NmbrOfAllwdMtrRdngsCntrlCode	I_UtilitiesInstallation	NmbrOfAllwdMtrRdngsCntrlCode	Control of perm. number of cust. MRs and autom. estimations
	AuthorizationGroup	I_UtilitiesInstallation	AuthorizationGroup	Authorization Group
	IsMarkedForDeletion	I_UtilitiesInstallation	IsMarkedForDeletion	Deletion Indicator
	UtilitiesPremise	I_UtilitiesInstallation	UtilitiesPremise	Premise
	UtilitiesGeoLocAltitudeValue	I_UtilitiesInstallation	UtilitiesGeoLocAltitudeValue	Altitude (Height Above Sea Level)
	_UtilitiesInstallation	I_UtilitiesInstallationHist	_UtilitiesInstallation

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_UtilsInstallationHistoryDEX.
-- 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_UtilsInstallationHistoryDEX AS
SELECT
  I_UtilitiesInstallationHist.UtilitiesInstallation AS UtilitiesInstallation,
  I_UtilitiesInstallationHist.UtilsInstHistValidityEndDate AS UtilsInstHistValidityEndDate,
  I_UtilitiesInstallationHist.UtilsInstHistValidityStartDate AS UtilsInstHistValidityStartDate,
  I_UtilitiesInstallationHist.UtilitiesRateCategory AS UtilitiesRateCategory,
  I_UtilitiesInstallationHist.UtilitiesBillingSchema AS UtilitiesBillingSchema,
  I_UtilitiesInstallationHist.UtilitiesBillingClass AS UtilitiesBillingClass,
  I_UtilitiesInstallationHist.MeterReadingUnit AS MeterReadingUnit,
  I_UtilitiesInstallationHist.UtilitiesTemperatureArea AS UtilitiesTemperatureArea,
  I_UtilitiesInstallationHist.UtilsInstIsExmptFrmFrnchsFee AS UtilsInstIsExmptFrmFrnchsFee,
  I_UtilitiesInstallationHist.UtilsInstDvceAllctnIsNotAllwd AS UtilsInstDvceAllctnIsNotAllwd,
  I_UtilitiesInstallationHist.UtilitiesFranchiseContract AS UtilitiesFranchiseContract,
  I_UtilitiesInstallationHist.UtilitiesBillingParty AS UtilitiesBillingParty,
  I_UtilitiesInstallationHist.UtilitiesInvoicingParty AS UtilitiesInvoicingParty,
  I_UtilitiesInstallationHist.ObligatorySupUtilsSrvcProvider AS ObligatorySupUtilsSrvcProvider,
  I_UtilitiesInstallationHist.PrimaryUtilitiesInstallation AS PrimaryUtilitiesInstallation,
  I_UtilitiesInstallationHist.UtilsInstallationGroupRole AS UtilsInstallationGroupRole,
  I_UtilitiesInstallationHist.UtilsInstallationGroupType AS UtilsInstallationGroupType,
  I_UtilitiesInstallationHist.HigherLevelUtilsInstallation AS HigherLevelUtilsInstallation,
  I_UtilitiesInstallationHist.UnbilldRevnXtrapltnType AS UnbilldRevnXtrapltnType,
  I_UtilitiesInstallationHist.UtilsRegDepdntValdtnGroup AS UtilsRegDepdntValdtnGroup,
  I_UtilitiesInstallation.UtilitiesInstallationType AS UtilitiesInstallationType,
  I_UtilitiesInstallation.Division AS Division,
  I_UtilitiesInstallation.UtilitiesInstVoltageLevel AS UtilitiesInstVoltageLevel,
  I_UtilitiesInstallation.UtilitiesInstGasPrssrLvl AS UtilitiesInstGasPrssrLvl,
  I_UtilitiesInstallation.UtilsInstTimeZone AS UtilsInstTimeZone,
  I_UtilitiesInstallation.UtilsInstGuarOfSupReason AS UtilsInstGuarOfSupReason,
  I_UtilitiesInstallation.UtilsInstDeregulationSts AS UtilsInstDeregulationSts,
  I_UtilitiesInstallation.UtilsInstDataReleaseStatus AS UtilsInstDataReleaseStatus,
  I_UtilitiesInstallation.UtilitiesSrvcProviderRole AS UtilitiesSrvcProviderRole,
  I_UtilitiesInstallation.UtilsInstIsForEnergyFeedIn AS UtilsInstIsForEnergyFeedIn,
  I_UtilitiesInstallation.UtilsInstCreationDate AS UtilsInstCreationDate,
  I_UtilitiesInstallation.UtilsInstCreatedByUser AS UtilsInstCreatedByUser,
  I_UtilitiesInstallation.UtilsInstLastChangeDate AS UtilsInstLastChangeDate,
  I_UtilitiesInstallation.UtilsInstLastChangedByUser AS UtilsInstLastChangedByUser,
  I_UtilitiesInstallation.MeterReadingBlockingReason AS MeterReadingBlockingReason,
  I_UtilitiesInstallation.MeterReadingBasePeriodCat AS MeterReadingBasePeriodCat,
  I_UtilitiesInstallation.NmbrOfAllwdMtrRdngsCntrlCode AS NmbrOfAllwdMtrRdngsCntrlCode,
  I_UtilitiesInstallation.AuthorizationGroup AS AuthorizationGroup,
  I_UtilitiesInstallation.IsMarkedForDeletion AS IsMarkedForDeletion,
  I_UtilitiesInstallation.UtilitiesPremise AS UtilitiesPremise,
  I_UtilitiesInstallation.UtilitiesGeoLocAltitudeValue AS UtilitiesGeoLocAltitudeValue,
  I_UtilitiesInstallationHist._UtilitiesInstallation AS _UtilitiesInstallation
FROM I_UtilitiesInstallationHist
LEFT OUTER JOIN E_UtilitiesInstallation AS _ExtensionInstallation ON _ExtensionInstallation.UtilitiesInstallation = UtilitiesInstallation  -- association [0..1]
LEFT OUTER JOIN E_UtilitiesInstallationHist AS _ExtensionInstallationHist ON _ExtensionInstallationHist.UtilitiesInstallation = UtilitiesInstallation AND _ExtensionInstallationHist.UtilsInstHistValidityEndDate = UtilsInstHistValidityEndDate  -- association [0..1]
;

Depth:

C_UtilsInstallationHistoryDEX view_entity

I_UtilitiesInstallationHist view