Which tables does P_UtilsDeviceInfoRecordEntSrch read from?

P_UtilsDeviceInfoRecordEntSrch reads data from: I_UtilitiesInstallationHist, I_UtilsDeviceRateData, I_UtilsDvceInfoRecordHistory.

What VDM layer is P_UtilsDeviceInfoRecordEntSrch?

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

P_UtilsDeviceInfoRecordEntSrch

Q: What is P_UtilsDeviceInfoRecordEntSrch in SAP S/4HANA?

P_UtilsDeviceInfoRecordEntSrch is a composite CDS view in SAP S/4HANA. It contains 71 fields.

DDL: P_UTILSDEVICEINFORECORDENTSRCH Type: view_entity COMPOSITE

71 Fields 3 Data Sources 2 Associations

P_UtilsDeviceInfoRecordEntSrch is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_UtilitiesInstallationHist, I_UtilsDeviceRateData, I_UtilsDvceInfoRecordHistory) and exposes 71 fields with key fields UtilitiesInstallation, UtilsInstHistValidityEndDate, UtilitiesLogicalDeviceNumber, UtilsDvceRateDataValdtyEndDte, UtilitiesDeviceInfoRecord. It has 2 associations 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 (2)

Cardinality	Target	Alias	Condition
[1..1]	I_UtilitiesInstallation	_UtilitiesInstallation	`$projection.UtilitiesInstallation = _UtilitiesInstallation.UtilitiesInstallation`
[1..1]	I_FunctionalLocation	_FunctionalLocation	`$projection.UtilitiesConnectionObject = _FunctionalLocation.FunctionalLocation`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.private	true	view
VDM.viewType	#COMPOSITE	view
ObjectModel.representativeKey	UtilitiesDeviceInfoRecord	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (71)

Key	Field	Source Table	Source Field	Description
KEY	UtilitiesInstallation	I_UtilitiesInstallationHist	UtilitiesInstallation	Installation
KEY	UtilsInstHistValidityEndDate	I_UtilitiesInstallationHist	UtilsInstHistValidityEndDate
KEY	UtilitiesLogicalDeviceNumber	I_UtilsDeviceRateData	UtilitiesLogicalDeviceNumber	Log. dev. no.
KEY	UtilsDvceRateDataValdtyEndDte	I_UtilsDeviceRateData	UtilsDvceRateDataValdtyEndDte
KEY	UtilitiesDeviceInfoRecord	I_UtilsDvceInfoRecordHistory	UtilitiesDeviceInfoRecord	Equipment
	UtilsDeviceValidityEndDate	I_UtilsDvceInfoRecordHistory	UtilsDeviceValidityEndDate
	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
	IndustrySector	I_UtilitiesInstallationHist	IndustrySector	Industry
	UtilsDvceRateDataValdtyStrtDte	I_UtilsDeviceRateData	UtilsDvceRateDataValdtyStrtDte
	UtilsInstallationDvceRateData	I_UtilsDeviceRateData	UtilsInstallationDvceRateData	Installation
	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.
	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
	Division	I_UtilsDvceInfoRecordHistory	Division	Internal Division ID
	UtilsInfoRecdAuthorizationGrp	I_UtilsDvceInfoRecordHistory	UtilsInfoRecdAuthorizationGrp	AuthorizGroup
	_MeterReadingUnit	I_UtilitiesInstallationHist	_MeterReadingUnit
	_UtilitiesInstallation	I_UtilitiesInstallationHist	_UtilitiesInstallation
	UtilitiesConnectionObject
	LocationSupplement
	_UtilitiesRateCategory	I_UtilitiesInstallationHist	_UtilitiesRateCategory
	_UtilsBillingClass	I_UtilitiesInstallationHist	_UtilsBillingClass
	_UtilsDepdntValdtnGroup	I_UtilitiesInstallationHist	_UtilsDepdntValdtnGroup
	_UtilsInstGroupRole	I_UtilitiesInstallationHist	_UtilsInstGroupRole
	_UtilsInstGroupType	I_UtilitiesInstallationHist	_UtilsInstGroupType
	_UtilsTemperatureArea	I_UtilitiesInstallationHist	_UtilsTemperatureArea
	_UtilsUnbilldRevnXtrapltnType	I_UtilitiesInstallationHist	_UtilsUnbilldRevnXtrapltnType
	_UtilsDevicePriceClass	I_UtilsDeviceRateData	_UtilsDevicePriceClass
	_UtilsDeviceRateFactGrp	I_UtilsDeviceRateData	_UtilsDeviceRateFactGrp
	_UtilsDeviceRateType	I_UtilsDeviceRateData	_UtilsDeviceRateType
	_Division	I_UtilsDvceInfoRecordHistory	_Division
	_UtilsAdvncdMeteringSystem	I_UtilsDvceInfoRecordHistory	_UtilsAdvncdMeteringSystem
	_UtilsDvceLossDetnGroup	I_UtilsDvceInfoRecordHistory	_UtilsDvceLossDetnGroup
	_UtilsRegisterGroupInfoText	I_UtilsDvceInfoRecordHistory	_UtilsRegisterGroupInfoText
	_FunctionalLocation		_FunctionalLocation

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 P_UtilsDeviceInfoRecordEntSrch.
-- 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 P_UtilsDeviceInfoRecordEntSrch AS
SELECT
  I_UtilitiesInstallationHist.UtilitiesInstallation AS UtilitiesInstallation,
  I_UtilitiesInstallationHist.UtilsInstHistValidityEndDate AS UtilsInstHistValidityEndDate,
  I_UtilsDeviceRateData.UtilitiesLogicalDeviceNumber AS UtilitiesLogicalDeviceNumber,
  I_UtilsDeviceRateData.UtilsDvceRateDataValdtyEndDte AS UtilsDvceRateDataValdtyEndDte,
  I_UtilsDvceInfoRecordHistory.UtilitiesDeviceInfoRecord AS UtilitiesDeviceInfoRecord,
  I_UtilsDvceInfoRecordHistory.UtilsDeviceValidityEndDate AS UtilsDeviceValidityEndDate,
  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.IndustrySector AS IndustrySector,
  I_UtilsDeviceRateData.UtilsDvceRateDataValdtyStrtDte AS UtilsDvceRateDataValdtyStrtDte,
  I_UtilsDeviceRateData.UtilsInstallationDvceRateData AS UtilsInstallationDvceRateData,
  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_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.Division AS Division,
  I_UtilsDvceInfoRecordHistory.UtilsInfoRecdAuthorizationGrp AS UtilsInfoRecdAuthorizationGrp,
  I_UtilitiesInstallationHist._MeterReadingUnit AS _MeterReadingUnit,
  I_UtilitiesInstallationHist._UtilitiesInstallation AS _UtilitiesInstallation,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilitiesPremise.UtilitiesConnectionObject AS UtilitiesConnectionObject,
  I_UtilitiesInstallationHist._UtilitiesInstallation._UtilitiesPremise.LocationSupplement AS LocationSupplement,
  I_UtilitiesInstallationHist._UtilitiesRateCategory AS _UtilitiesRateCategory,
  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,
  I_UtilsDeviceRateData._UtilsDevicePriceClass AS _UtilsDevicePriceClass,
  I_UtilsDeviceRateData._UtilsDeviceRateFactGrp AS _UtilsDeviceRateFactGrp,
  I_UtilsDeviceRateData._UtilsDeviceRateType AS _UtilsDeviceRateType,
  I_UtilsDvceInfoRecordHistory._Division AS _Division,
  I_UtilsDvceInfoRecordHistory._UtilsAdvncdMeteringSystem AS _UtilsAdvncdMeteringSystem,
  I_UtilsDvceInfoRecordHistory._UtilsDvceLossDetnGroup AS _UtilsDvceLossDetnGroup,
  I_UtilsDvceInfoRecordHistory._UtilsRegisterGroupInfoText AS _UtilsRegisterGroupInfoText
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]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON UtilitiesConnectionObject = _FunctionalLocation.FunctionalLocation  -- association [1..1]
;

Depth:

P_UtilsDeviceInfoRecordEntSrch view_entity

ESH_N_IEDVCEIRS view