What is I_UtilsInfoRecdHistAndInst in SAP S/4HANA?

I_UtilsInfoRecdHistAndInst is a composite CDS view in SAP S/4HANA. Information Record History And Installation It contains 95 fields.

Which tables does I_UtilsInfoRecdHistAndInst read from?

I_UtilsInfoRecdHistAndInst reads data from: I_UtilitiesInstallationHist, I_UtilsDeviceRateData, I_UtilsDvceInfoRecordHistory.

What VDM layer is I_UtilsInfoRecdHistAndInst?

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

I_UtilsInfoRecdHistAndInst

DDL: I_UTILSINFORECDHISTANDINST SQL: IEINFRECHANDINST Type: view COMPOSITE

95 Fields 3 Data Sources 1 Associations

Information Record History And Installation

I_UtilsInfoRecdHistAndInst is a Composite CDS View that provides data about "Information Record History And Installation" in SAP S/4HANA. It reads from 3 data sources (I_UtilitiesInstallationHist, I_UtilsDeviceRateData, I_UtilsDvceInfoRecordHistory) and exposes 95 fields. It has 1 association to related views.

Data Sources (3)

Source	Alias	Join Type
I_UtilitiesInstallationHist	I_UtilitiesInstallationHist	inner
I_UtilsDeviceRateData	I_UtilsDeviceRateData	from
I_UtilsDvceInfoRecordHistory	I_UtilsDvceInfoRecordHistory	inner

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_UtilitiesInstallation	_UtilitiesInstallation	`$projection.UtilitiesInstallation = _UtilitiesInstallation.UtilitiesInstallation`

Annotations (9)

Name	Value	Level
EndUserText.label	Information Record History And Installation	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.sqlViewName	IEINFRECHANDINST	view
ObjectModel.usageType.serviceQuality	C	view
ObjectModel.usageType.sizeCategory	L	view
ObjectModel.usageType.dataClass	MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (95)

Field	Source Table	Source Field	Description
UtilitiesInstallation	I_UtilsDeviceRateData	UtilitiesInstallation	Installation
UtilitiesLogicalDeviceNumber	I_UtilsDeviceRateData	UtilitiesLogicalDeviceNumber	Log. dev. no.
UtilsDvceRateDataValdtyEndDte	I_UtilsDeviceRateData	UtilsDvceRateDataValdtyEndDte
UtilsDvceRateDataValdtyStrtDte	I_UtilsDeviceRateData	UtilsDvceRateDataValdtyStrtDte
UtilsDevicePriceClass	I_UtilsDeviceRateData	UtilsDevicePriceClass	Price Class
UtilsDvceIsRelevantForRntlPrc	I_UtilsDeviceRateData	UtilsDvceIsRelevantForRntlPrc	Rental price
UtilsDeviceRateType	I_UtilsDeviceRateData	UtilsDeviceRateType	Rate Type
UtilsDeviceRateFactGroup	I_UtilsDeviceRateData	UtilsDeviceRateFactGroup	Rate fact group
UtilsDvceIsNotBillingRelevant	I_UtilsDeviceRateData	UtilsDvceIsNotBillingRelevant	Dev.Not B.-Rel.
_UtilsDevicePriceClass	I_UtilsDeviceRateData	_UtilsDevicePriceClass
_UtilsDeviceRateFactGrp	I_UtilsDeviceRateData	_UtilsDeviceRateFactGrp
_UtilsDeviceRateType	I_UtilsDeviceRateData	_UtilsDeviceRateType
UtilitiesDeviceInfoRecord	I_UtilsDvceInfoRecordHistory	UtilitiesDeviceInfoRecord	Equipment
UtilsDeviceValidityEndDate	I_UtilsDvceInfoRecordHistory	UtilsDeviceValidityEndDate
UtilsDeviceValidityStartDate	I_UtilsDvceInfoRecordHistory	UtilsDeviceValidityStartDate
UtilitiesRegisterGroup	I_UtilsDvceInfoRecordHistory	UtilitiesRegisterGroup	Register Group
UtilitiesDeviceCategory	I_UtilsDvceInfoRecordHistory	UtilitiesDeviceCategory
UtilsDeviceBscCatCombination	I_UtilsDvceInfoRecordHistory	UtilsDeviceBscCatCombination	Dev. type comb.
UtilsDeviceInstallationDate	I_UtilsDvceInfoRecordHistory	UtilsDeviceInstallationDate	Install. date
UtilsDeviceRemovalDate	I_UtilsDvceInfoRecordHistory	UtilsDeviceRemovalDate	Removal date
UtilsDeviceGroup	I_UtilsDvceInfoRecordHistory	UtilsDeviceGroup	Device group
UtilitiesPrepaymentMeterType	I_UtilsDvceInfoRecordHistory	UtilitiesPrepaymentMeterType	PP Meter
UtilsDeviceLossDetnGroup	I_UtilsDvceInfoRecordHistory	UtilsDeviceLossDetnGroup	Loss Det. Group
DvcePwrTrnsfrmtrPrimVoltVal	I_UtilsDvceInfoRecordHistory	DvcePwrTrnsfrmtrPrimVoltVal
DvcePwrTrnsfrmtrSecdryVoltVal	I_UtilsDvceInfoRecordHistory	DvcePwrTrnsfrmtrSecdryVoltVal
DvcePwrTrnsfrmtrTrnsfRatingVal	I_UtilsDvceInfoRecordHistory	DvcePwrTrnsfrmtrTrnsfRatingVal
AdvancedMeteringSystem	I_UtilsDvceInfoRecordHistory	AdvancedMeteringSystem	AMS
AdvancedMeterCapabilityGroup	I_UtilsDvceInfoRecordHistory	AdvancedMeterCapabilityGroup	AMCG
UniqueItemIdentifier	I_UtilsDvceInfoRecordHistory	UniqueItemIdentifier	UII
UtilsDeviceWindingGroup	I_UtilsDvceInfoRecordHistory	UtilsDeviceWindingGroup	Winding group
UtilsDeviceInfoRecdSrvcPrvd	I_UtilsDvceInfoRecordHistory	UtilsDeviceInfoRecdSrvcPrvd	Serv. Provider
SerialNumber	I_UtilsDvceInfoRecordHistory	SerialNumber	Serial Number
UtilsInfoRecdAuthorizationGrp	I_UtilsDvceInfoRecordHistory	UtilsInfoRecdAuthorizationGrp	AuthorizGroup
_UtilsAdvncdMeteringSystem	I_UtilsDvceInfoRecordHistory	_UtilsAdvncdMeteringSystem
_UtilsDvceLossDetnGroup	I_UtilsDvceInfoRecordHistory	_UtilsDvceLossDetnGroup
_UtilsRegisterGroupInfoText	I_UtilsDvceInfoRecordHistory	_UtilsRegisterGroupInfoText
UtilitiesInstallationType
UtilitiesInstVoltageLevel
UtilitiesInstGasPrssrLvl
UtilsInstTimeZone
UtilsInstGuarOfSupReason
UtilsInstDeregulationSts
UtilsInstDataReleaseStatus
UtilitiesSrvcProviderRole
UtilsInstIsForEnergyFeedIn
UtilsInstCreationDate
UtilsInstCreatedByUser
UtilsInstLastChangeDate
UtilsInstLastChangedByUser
MeterReadingBlockingReason
MeterReadingBasePeriodCat
NmbrOfAllwdMtrRdngsCntrlCode
IsMarkedForDeletion
UtilitiesPremise
AuthorizationGroup
Division
_Division
_UtilsInstallationType
_UtilsInstCreatedByUser
_UtilsInstDataReleaseSts
_UtilsInstDeregulationSts
_UtilsInstGasPressureLvl
_UtilsInstGuarOfSupRsn
_UtilsInstLastChangedByUser
_UtilsInstVltgLevel
_UtilsMtrRdngBasePerdCat
_UtilsMtrRdngBlockReason
_UtilsNmbrOfAllwdMRCtrlCode
_UtilsServiceProviderRole
_UtilitiesInstallation		_UtilitiesInstallation
UtilsInstHistValidityEndDate	I_UtilitiesInstallationHist	UtilsInstHistValidityEndDate
UtilsInstHistValidityStartDate	I_UtilitiesInstallationHist	UtilsInstHistValidityStartDate
UtilitiesRateCategory	I_UtilitiesInstallationHist	UtilitiesRateCategory	Rate category
UtilitiesBillingSchema	I_UtilitiesInstallationHist	UtilitiesBillingSchema	Billing schema
UtilitiesBillingClass	I_UtilitiesInstallationHist	UtilitiesBillingClass	Billing Class
MeterReadingUnit	I_UtilitiesInstallationHist	MeterReadingUnit	MR unit
UtilitiesTemperatureArea	I_UtilitiesInstallationHist	UtilitiesTemperatureArea	Temp. area
UtilsInstIsExmptFrmFrnchsFee	I_UtilitiesInstallationHist	UtilsInstIsExmptFrmFrnchsFee	No franch. fee
UtilsInstDvceAllctnIsNotAllwd	I_UtilitiesInstallationHist	UtilsInstDvceAllctnIsNotAllwd	No dev. alloc.
UtilitiesFranchiseContract	I_UtilitiesInstallationHist	UtilitiesFranchiseContract	Franchise cont.
UtilitiesBillingParty	I_UtilitiesInstallationHist	UtilitiesBillingParty	Billing ServPr.
UtilitiesInvoicingParty	I_UtilitiesInstallationHist	UtilitiesInvoicingParty	Supplier
ObligatorySupUtilsSrvcProvider	I_UtilitiesInstallationHist	ObligatorySupUtilsSrvcProvider	Supply Obligatn
PrimaryUtilitiesInstallation	I_UtilitiesInstallationHist	PrimaryUtilitiesInstallation	Primary Inst.
UtilsInstallationGroupRole	I_UtilitiesInstallationHist	UtilsInstallationGroupRole	Installtn Role
UtilsInstallationGroupType	I_UtilitiesInstallationHist	UtilsInstallationGroupType	Grouping Type
HigherLevelUtilsInstallation	I_UtilitiesInstallationHist	HigherLevelUtilsInstallation	High.-Level Installn
UnbilldRevnXtrapltnType	I_UtilitiesInstallationHist	UnbilldRevnXtrapltnType	Extrapol. type
UtilsRegDepdntValdtnGroup	I_UtilitiesInstallationHist	UtilsRegDepdntValdtnGroup	ValGrp dep.vals
_UtilsBillingClass	I_UtilitiesInstallationHist	_UtilsBillingClass
_UtilsDepdntValdtnGroup	I_UtilitiesInstallationHist	_UtilsDepdntValdtnGroup
_UtilsInstGroupRole	I_UtilitiesInstallationHist	_UtilsInstGroupRole
_UtilsInstGroupType	I_UtilitiesInstallationHist	_UtilsInstGroupType
_UtilsTemperatureArea	I_UtilitiesInstallationHist	_UtilsTemperatureArea
_UtilsUnbilldRevnXtrapltnType	I_UtilitiesInstallationHist	_UtilsUnbilldRevnXtrapltnType

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_UtilsInfoRecdHistAndInst.
-- 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: IEINFRECHANDINST

CREATE VIEW I_UtilsInfoRecdHistAndInst AS
SELECT
  I_UtilsDeviceRateData.UtilitiesInstallation AS UtilitiesInstallation,
  I_UtilsDeviceRateData.UtilitiesLogicalDeviceNumber AS UtilitiesLogicalDeviceNumber,
  I_UtilsDeviceRateData.UtilsDvceRateDataValdtyEndDte AS UtilsDvceRateDataValdtyEndDte,
  I_UtilsDeviceRateData.UtilsDvceRateDataValdtyStrtDte AS UtilsDvceRateDataValdtyStrtDte,
  I_UtilsDeviceRateData.UtilsDevicePriceClass AS UtilsDevicePriceClass,
  I_UtilsDeviceRateData.UtilsDvceIsRelevantForRntlPrc AS UtilsDvceIsRelevantForRntlPrc,
  I_UtilsDeviceRateData.UtilsDeviceRateType AS UtilsDeviceRateType,
  I_UtilsDeviceRateData.UtilsDeviceRateFactGroup AS UtilsDeviceRateFactGroup,
  I_UtilsDeviceRateData.UtilsDvceIsNotBillingRelevant AS UtilsDvceIsNotBillingRelevant,
  I_UtilsDeviceRateData._UtilsDevicePriceClass AS _UtilsDevicePriceClass,
  I_UtilsDeviceRateData._UtilsDeviceRateFactGrp AS _UtilsDeviceRateFactGrp,
  I_UtilsDeviceRateData._UtilsDeviceRateType AS _UtilsDeviceRateType,
  I_UtilsDvceInfoRecordHistory.UtilitiesDeviceInfoRecord AS UtilitiesDeviceInfoRecord,
  I_UtilsDvceInfoRecordHistory.UtilsDeviceValidityEndDate AS UtilsDeviceValidityEndDate,
  I_UtilsDvceInfoRecordHistory.UtilsDeviceValidityStartDate AS UtilsDeviceValidityStartDate,
  I_UtilsDvceInfoRecordHistory.UtilitiesRegisterGroup AS UtilitiesRegisterGroup,
  I_UtilsDvceInfoRecordHistory.UtilitiesDeviceCategory AS UtilitiesDeviceCategory,
  I_UtilsDvceInfoRecordHistory.UtilsDeviceBscCatCombination AS UtilsDeviceBscCatCombination,
  I_UtilsDvceInfoRecordHistory.UtilsDeviceInstallationDate AS UtilsDeviceInstallationDate,
  I_UtilsDvceInfoRecordHistory.UtilsDeviceRemovalDate AS UtilsDeviceRemovalDate,
  I_UtilsDvceInfoRecordHistory.UtilsDeviceGroup AS UtilsDeviceGroup,
  I_UtilsDvceInfoRecordHistory.UtilitiesPrepaymentMeterType AS UtilitiesPrepaymentMeterType,
  I_UtilsDvceInfoRecordHistory.UtilsDeviceLossDetnGroup AS UtilsDeviceLossDetnGroup,
  I_UtilsDvceInfoRecordHistory.DvcePwrTrnsfrmtrPrimVoltVal AS DvcePwrTrnsfrmtrPrimVoltVal,
  I_UtilsDvceInfoRecordHistory.DvcePwrTrnsfrmtrSecdryVoltVal AS DvcePwrTrnsfrmtrSecdryVoltVal,
  I_UtilsDvceInfoRecordHistory.DvcePwrTrnsfrmtrTrnsfRatingVal AS DvcePwrTrnsfrmtrTrnsfRatingVal,
  I_UtilsDvceInfoRecordHistory.AdvancedMeteringSystem AS AdvancedMeteringSystem,
  I_UtilsDvceInfoRecordHistory.AdvancedMeterCapabilityGroup AS AdvancedMeterCapabilityGroup,
  I_UtilsDvceInfoRecordHistory.UniqueItemIdentifier AS UniqueItemIdentifier,
  I_UtilsDvceInfoRecordHistory.UtilsDeviceWindingGroup AS UtilsDeviceWindingGroup,
  I_UtilsDvceInfoRecordHistory.UtilsDeviceInfoRecdSrvcPrvd AS UtilsDeviceInfoRecdSrvcPrvd,
  I_UtilsDvceInfoRecordHistory.SerialNumber AS SerialNumber,
  I_UtilsDvceInfoRecordHistory.UtilsInfoRecdAuthorizationGrp AS UtilsInfoRecdAuthorizationGrp,
  I_UtilsDvceInfoRecordHistory._UtilsAdvncdMeteringSystem AS _UtilsAdvncdMeteringSystem,
  I_UtilsDvceInfoRecordHistory._UtilsDvceLossDetnGroup AS _UtilsDvceLossDetnGroup,
  I_UtilsDvceInfoRecordHistory._UtilsRegisterGroupInfoText AS _UtilsRegisterGroupInfoText,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilitiesInstallationType AS UtilitiesInstallationType,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilitiesInstVoltageLevel AS UtilitiesInstVoltageLevel,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilitiesInstGasPrssrLvl AS UtilitiesInstGasPrssrLvl,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstTimeZone AS UtilsInstTimeZone,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstGuarOfSupReason AS UtilsInstGuarOfSupReason,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstDeregulationSts AS UtilsInstDeregulationSts,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstDataReleaseStatus AS UtilsInstDataReleaseStatus,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilitiesSrvcProviderRole AS UtilitiesSrvcProviderRole,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstIsForEnergyFeedIn AS UtilsInstIsForEnergyFeedIn,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstCreationDate AS UtilsInstCreationDate,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstCreatedByUser AS UtilsInstCreatedByUser,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstLastChangeDate AS UtilsInstLastChangeDate,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstLastChangedByUser AS UtilsInstLastChangedByUser,
  I_UtilitiesInstallationHist._UtilitiesInstallation.MeterReadingBlockingReason AS MeterReadingBlockingReason,
  I_UtilitiesInstallationHist._UtilitiesInstallation.MeterReadingBasePeriodCat AS MeterReadingBasePeriodCat,
  I_UtilitiesInstallationHist._UtilitiesInstallation.NmbrOfAllwdMtrRdngsCntrlCode AS NmbrOfAllwdMtrRdngsCntrlCode,
  I_UtilitiesInstallationHist._UtilitiesInstallation.IsMarkedForDeletion AS IsMarkedForDeletion,
  I_UtilitiesInstallationHist._UtilitiesInstallation.UtilitiesPremise AS UtilitiesPremise,
  I_UtilitiesInstallationHist._UtilitiesInstallation.AuthorizationGroup AS AuthorizationGroup,
  I_UtilitiesInstallationHist._UtilitiesInstallation.Division AS Division,
  I_UtilitiesInstallationHist._UtilitiesInstallation._Division AS _Division,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstallationType AS _UtilsInstallationType,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstCreatedByUser AS _UtilsInstCreatedByUser,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstDataReleaseSts AS _UtilsInstDataReleaseSts,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstDeregulationSts AS _UtilsInstDeregulationSts,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstGasPressureLvl AS _UtilsInstGasPressureLvl,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstGuarOfSupRsn AS _UtilsInstGuarOfSupRsn,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstLastChangedByUser AS _UtilsInstLastChangedByUser,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstVltgLevel AS _UtilsInstVltgLevel,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsMtrRdngBasePerdCat AS _UtilsMtrRdngBasePerdCat,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsMtrRdngBlockReason AS _UtilsMtrRdngBlockReason,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsNmbrOfAllwdMRCtrlCode AS _UtilsNmbrOfAllwdMRCtrlCode,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsServiceProviderRole AS _UtilsServiceProviderRole,
  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_UtilitiesInstallationHist._UtilsBillingClass AS _UtilsBillingClass,
  I_UtilitiesInstallationHist._UtilsDepdntValdtnGroup AS _UtilsDepdntValdtnGroup,
  I_UtilitiesInstallationHist._UtilsInstGroupRole AS _UtilsInstGroupRole,
  I_UtilitiesInstallationHist._UtilsInstGroupType AS _UtilsInstGroupType,
  I_UtilitiesInstallationHist._UtilsTemperatureArea AS _UtilsTemperatureArea,
  I_UtilitiesInstallationHist._UtilsUnbilldRevnXtrapltnType AS _UtilsUnbilldRevnXtrapltnType
FROM I_UtilsDeviceRateData
INNER JOIN I_UtilsDvceInfoRecordHistory ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilitiesInstallationHist ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilitiesInstallation AS _UtilitiesInstallation ON UtilitiesInstallation = _UtilitiesInstallation.UtilitiesInstallation  -- association [1..1]
;

Depth:

I_UtilsInfoRecdHistAndInst view

I_UtilsBillgReltdInstdDvceIR view