What is C_UtilsBillgReltdInstdDeviceQ in SAP S/4HANA?

C_UtilsBillgReltdInstdDeviceQ is a consumption CDS view in SAP S/4HANA. Billing-Related Installed Device Query It contains 72 fields.

Which tables does C_UtilsBillgReltdInstdDeviceQ read from?

C_UtilsBillgReltdInstdDeviceQ reads data from: I_UtilsBillingRelatedInstdDvce.

What VDM layer is C_UtilsBillgReltdInstdDeviceQ?

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

C_UtilsBillgReltdInstdDeviceQ

DDL: C_UTILSBILLGRELTDINSTDDEVICEQ SQL: CEBILLGRIDVCEQ Type: view CONSUMPTION

72 Fields 1 Data Sources

Billing-Related Installed Device Query

Billing Related Installed Device - Query

C_UtilsBillgReltdInstdDeviceQ (Consumption)

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

Utilities

C_UtilsBillgReltdInstdDeviceQ is a Consumption CDS View that provides data about "Billing-Related Installed Device Query" in SAP S/4HANA. It reads from 1 data source (I_UtilsBillingRelatedInstdDvce) and exposes 72 fields.

SAP API Hub

State	C1
Line of Business	Utilities
Application Component	IS-U-DM
Capabilities	Analytical Query
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_UtilsBillingRelatedInstdDvce	I_UtilsBillingRelatedInstdDvce	from

Parameters (2)

Name	Type	Default
P_Language	sylangu
P_KeyDate	e_keydate_vdm

Annotations (10)

Name	Value	Level
EndUserText.label	Billing-Related Installed Device Query	view
Analytics.query	true	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
AbapCatalog.sqlViewName	CEBILLGRIDVCEQ	view
ObjectModel.usageType.serviceQuality	D	view
ObjectModel.usageType.sizeCategory	L	view
ObjectModel.usageType.dataClass	MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Search.searchable	true	view

Fields (72)

Field	Source Table	Source Field	Description
AdvancedMeteringSystem	I_UtilsBillingRelatedInstdDvce	AdvancedMeteringSystem	Advanced Metering System
UtilitiesRegisterGroup	I_UtilsBillingRelatedInstdDvce	UtilitiesRegisterGroup	Register Group
UtilsDeviceMeasurementType	I_UtilsBillingRelatedInstdDvce	UtilsDeviceMeasurementType	Type of measurement
UtilsDeviceMeasurementTypeName			Short Text for Fixed Values
Division	I_UtilsBillingRelatedInstdDvce	Division	Internal Division ID
DivisionName			Division Description
UtilsDeviceConstructionClass	I_UtilsBillingRelatedInstdDvce	UtilsDeviceConstructionClass	Construction class
UtilsDeviceFunctionClass	I_UtilsBillingRelatedInstdDvce	UtilsDeviceFunctionClass	Function class
UtilitiesDeviceCategory	I_UtilsBillingRelatedInstdDvce	UtilitiesDeviceCategory	Device Category
UtilsDeviceCategoryDescription	I_UtilsBillingRelatedInstdDvce	UtilsDeviceCategoryDescription	Device Category Name
UtilitiesInstallation	I_UtilsBillingRelatedInstdDvce	UtilitiesInstallation	Installation
UtilsDeviceCertificationYear	I_UtilsBillingRelatedInstdDvce	UtilsDeviceCertificationYear	Certification Year
AdvancedMeterCapabilityGroup	I_UtilsBillingRelatedInstdDvce	AdvancedMeterCapabilityGroup	Advanced Meter Capability Group (AMCG)
UtilsDeviceActivityReason	I_UtilsBillingRelatedInstdDvce	UtilsDeviceActivityReason	Activity reason
SerialNumber	I_UtilsBillingRelatedInstdDvce	SerialNumber	Serial Number
UtilsDeviceAdvncdMeterCat	I_UtilsBillingRelatedInstdDvce	UtilsDeviceAdvncdMeterCat	Advanced Meter
UtilsDeviceAdvncdMeterCatName			Short Text for Fixed Values
UtilitiesDevice	I_UtilsBillingRelatedInstdDvce	UtilitiesDevice	Equipment Number
UtilsDeviceRateFactGroup	I_UtilsBillingRelatedInstdDvce	UtilsDeviceRateFactGroup	Rate fact group
UtilsDeviceRateFactGroupName			Text (30 Characters)
UtilsDeviceRateType	I_UtilsBillingRelatedInstdDvce	UtilsDeviceRateType	Rate Type
UtilsDeviceRateTypeName			Text (30 Characters)
UtilsDevicePriceClass	I_UtilsBillingRelatedInstdDvce	UtilsDevicePriceClass	Price Class
UtilsDevicePriceClassName			Text (30 Characters)
UtilsDeviceValidityEndDate	I_UtilsBillingRelatedInstdDvce	UtilsDeviceValidityEndDate	Validity End Date of Device
UtilsDeviceValidityStartDate	I_UtilsBillingRelatedInstdDvce	UtilsDeviceValidityStartDate	Validity Start Date of Device
MeterReadingUnit	I_UtilsBillingRelatedInstdDvce	MeterReadingUnit	Meter Reading Unit
UtilitiesTemperatureArea	I_UtilsBillingRelatedInstdDvce	UtilitiesTemperatureArea	Temperature area
UtilitiesBillingClass	I_UtilsBillingRelatedInstdDvce	UtilitiesBillingClass	Billing Class
UtilitiesBillingClassName			Billing Class Name
UtilsInstHistValidityEndDate	I_UtilsBillingRelatedInstdDvce	UtilsInstHistValidityEndDate	Validity End Date of Installation
UtilsInstHistValidityStartDate	I_UtilsBillingRelatedInstdDvce	UtilsInstHistValidityStartDate	Validity Start Date of Installation
UtilitiesPremise	I_UtilsBillingRelatedInstdDvce	UtilitiesPremise	Premise
UtilitiesInstGasPrssrLvl	I_UtilsBillingRelatedInstdDvce	UtilitiesInstGasPrssrLvl	Gas Pressure Level at Installation Level (Grid)
UtilitiesInstGasPrssrLvlName			Text (30 Characters)
UtilitiesInstVoltageLevel	I_UtilsBillingRelatedInstdDvce	UtilitiesInstVoltageLevel	Voltage Level
UtilitiesInstVoltageLevelName			Text (30 Characters)
UtilitiesInstallationType	I_UtilsBillingRelatedInstdDvce	UtilitiesInstallationType	Installation type
UtilitiesInstallationTypeName			Text (30 Characters)
UtilsDvceRateDataValdtyEndDte	I_UtilsBillingRelatedInstdDvce	UtilsDvceRateDataValdtyEndDte	Validity End Date of Device Rate Data
UtilsDvceRateDataValdtyStrtDte	I_UtilsBillingRelatedInstdDvce	UtilsDvceRateDataValdtyStrtDte	Validity Start Date of Device Rate Data
UtilsDvceIsRelevantForRntlPrc	I_UtilsBillingRelatedInstdDvce	UtilsDvceIsRelevantForRntlPrc	Pay rental price
UtilsDvceIsNotBillingRelevant	I_UtilsBillingRelatedInstdDvce	UtilsDvceIsNotBillingRelevant	Device Not Relevant for Billing
UtilsDeviceARCRCommandGroup	I_UtilsBillingRelatedInstdDvce	UtilsDeviceARCRCommandGroup	ARCR Command Group
MeterReadingBlockingReason	I_UtilsBillingRelatedInstdDvce	MeterReadingBlockingReason	Reason for blocking meter reading
MeterReadingBlockingReasonName			Text (20 Characters)
UtilsInstIsForEnergyFeedIn	I_UtilsBillingRelatedInstdDvce	UtilsInstIsForEnergyFeedIn	Purchase
UtilsInstGuarOfSupReason	I_UtilsBillingRelatedInstdDvce	UtilsInstGuarOfSupReason	Reason for guarantee of supply
UtilitiesSrvcProviderRole	I_UtilsBillingRelatedInstdDvce	UtilitiesSrvcProviderRole	Service Type
UtilitiesSrvcProviderRoleName			Text for Service Type
UtilsInstIsExmptFrmFrnchsFee	I_UtilsBillingRelatedInstdDvce	UtilsInstIsExmptFrmFrnchsFee	Exempt from franchise fee
UtilitiesRateCategory	I_UtilsBillingRelatedInstdDvce	UtilitiesRateCategory	Rate Category
ConstructionYear	I_UtilsBillingRelatedInstdDvce	ConstructionYear	Device Construction Year
InstdUtilsDeviceIsCertifiable	I_UtilsBillingRelatedInstdDvce	InstdUtilsDeviceIsCertifiable	Certify installed devices
UtilsDeviceActivityReasonName			Text (30 Characters)
UtilsDeviceLocation	I_UtilsBillingRelatedInstdDvce	UtilsDeviceLocation	Device Location
UtilsDeviceInstallationDate	I_UtilsBillingRelatedInstdDvce	UtilsDeviceInstallationDate	Installation date
UtilitiesPrepaymentMeterType	I_UtilsBillingRelatedInstdDvce	UtilitiesPrepaymentMeterType	Prepayment Meter
MaintObjectLocAcctAssgmtNmbr	I_UtilsBillingRelatedInstdDvce	MaintObjectLocAcctAssgmtNmbr	Location and account assignment for technical object
MaintenancePlant	I_UtilsBillingRelatedInstdDvce	MaintenancePlant	Maintenance Plant
MaintenanceObjectLocation	I_UtilsBillingRelatedInstdDvce	MaintenanceObjectLocation	Location of maintenance object
FunctionalLocation	I_UtilsBillingRelatedInstdDvce	FunctionalLocation	Functional Location
Country	I_UtilsBillingRelatedInstdDvce	Country	Country/Region Key
Region	I_UtilsBillingRelatedInstdDvce	Region	Region (State, Province, County)
CityName	I_UtilsBillingRelatedInstdDvce	CityName	Name
District	I_UtilsBillingRelatedInstdDvce	District	District Court
HomeCityName	I_UtilsBillingRelatedInstdDvce	HomeCityName	City (different from postal city)
PostalCode	I_UtilsBillingRelatedInstdDvce	PostalCode	City postal code
StreetName	I_UtilsBillingRelatedInstdDvce	StreetName	Street
HouseNumber	I_UtilsBillingRelatedInstdDvce	HouseNumber	House Number
HouseNumberSupplementText	I_UtilsBillingRelatedInstdDvce	HouseNumberSupplementText	House number supplement
NmbrOfBillgReltdInstdUtilsDvce		NmbrOfBillgReltdInstdUtilsDvce	Number of Billing-Relevant Installed Devices

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_UtilsBillgReltdInstdDeviceQ.
-- 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: CEBILLGRIDVCEQ
-- Parameters: P_Language : sylangu, P_KeyDate : e_keydate_vdm

CREATE VIEW C_UtilsBillgReltdInstdDeviceQ AS
SELECT
  I_UtilsBillingRelatedInstdDvce.AdvancedMeteringSystem AS AdvancedMeteringSystem,
  I_UtilsBillingRelatedInstdDvce.UtilitiesRegisterGroup AS UtilitiesRegisterGroup,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceMeasurementType AS UtilsDeviceMeasurementType,
  I_UtilsBillingRelatedInstdDvce._UtilsDeviceMsmtType._UtilsDeviceMsmtTypeText[1: Language=$parameters.P_Language].UtilsDeviceMeasurementTypeName AS UtilsDeviceMeasurementTypeName,
  I_UtilsBillingRelatedInstdDvce.Division AS Division,
  I_UtilsBillingRelatedInstdDvce._Division._Text[1: Language=$parameters.P_Language].DivisionName AS DivisionName,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceConstructionClass AS UtilsDeviceConstructionClass,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceFunctionClass AS UtilsDeviceFunctionClass,
  I_UtilsBillingRelatedInstdDvce.UtilitiesDeviceCategory AS UtilitiesDeviceCategory,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceCategoryDescription AS UtilsDeviceCategoryDescription,
  I_UtilsBillingRelatedInstdDvce.UtilitiesInstallation AS UtilitiesInstallation,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceCertificationYear AS UtilsDeviceCertificationYear,
  I_UtilsBillingRelatedInstdDvce.AdvancedMeterCapabilityGroup AS AdvancedMeterCapabilityGroup,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceActivityReason AS UtilsDeviceActivityReason,
  I_UtilsBillingRelatedInstdDvce.SerialNumber AS SerialNumber,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceAdvncdMeterCat AS UtilsDeviceAdvncdMeterCat,
  I_UtilsBillingRelatedInstdDvce._UtilsDvceAdvncdMeterCat._UtilsDvceAdvncdMeterCatText[1: Language=$parameters.P_Language].UtilsDeviceAdvncdMeterCatName AS UtilsDeviceAdvncdMeterCatName,
  I_UtilsBillingRelatedInstdDvce.UtilitiesDevice AS UtilitiesDevice,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceRateFactGroup AS UtilsDeviceRateFactGroup,
  I_UtilsBillingRelatedInstdDvce._UtilsDeviceRateFactGrp._UtilsDeviceRateFactGrpText[1: Language=$parameters.P_Language].UtilsDeviceRateFactGroupName AS UtilsDeviceRateFactGroupName,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceRateType AS UtilsDeviceRateType,
  I_UtilsBillingRelatedInstdDvce._UtilsDeviceRateType._UtilsDeviceRateTypeText[1: Language=$parameters.P_Language].UtilsDeviceRateTypeName AS UtilsDeviceRateTypeName,
  I_UtilsBillingRelatedInstdDvce.UtilsDevicePriceClass AS UtilsDevicePriceClass,
  I_UtilsBillingRelatedInstdDvce._UtilsDevicePriceClass._UtilsDevicePriceClassText[1: Language=$parameters.P_Language].UtilsDevicePriceClassName AS UtilsDevicePriceClassName,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceValidityEndDate AS UtilsDeviceValidityEndDate,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceValidityStartDate AS UtilsDeviceValidityStartDate,
  I_UtilsBillingRelatedInstdDvce.MeterReadingUnit AS MeterReadingUnit,
  I_UtilsBillingRelatedInstdDvce.UtilitiesTemperatureArea AS UtilitiesTemperatureArea,
  I_UtilsBillingRelatedInstdDvce.UtilitiesBillingClass AS UtilitiesBillingClass,
  I_UtilsBillingRelatedInstdDvce._UtilsBillingClass._UtilsBillingClassText[1: Language=$parameters.P_Language].UtilitiesBillingClassName AS UtilitiesBillingClassName,
  I_UtilsBillingRelatedInstdDvce.UtilsInstHistValidityEndDate AS UtilsInstHistValidityEndDate,
  I_UtilsBillingRelatedInstdDvce.UtilsInstHistValidityStartDate AS UtilsInstHistValidityStartDate,
  I_UtilsBillingRelatedInstdDvce.UtilitiesPremise AS UtilitiesPremise,
  I_UtilsBillingRelatedInstdDvce.UtilitiesInstGasPrssrLvl AS UtilitiesInstGasPrssrLvl,
  I_UtilsBillingRelatedInstdDvce._UtilsInstGasPressureLvl._UtilsInstGasPressureLvlText[1: Language=$parameters.P_Language].UtilitiesInstGasPrssrLvlName AS UtilitiesInstGasPrssrLvlName,
  I_UtilsBillingRelatedInstdDvce.UtilitiesInstVoltageLevel AS UtilitiesInstVoltageLevel,
  I_UtilsBillingRelatedInstdDvce._UtilsInstVltgLevel._UtilsInstVltgLevelText[1: Language=$parameters.P_Language].UtilitiesInstVoltageLevelName AS UtilitiesInstVoltageLevelName,
  I_UtilsBillingRelatedInstdDvce.UtilitiesInstallationType AS UtilitiesInstallationType,
  I_UtilsBillingRelatedInstdDvce._UtilsInstallationType._UtilsInstallationTypeText[1: Language=$parameters.P_Language].UtilitiesInstallationTypeName AS UtilitiesInstallationTypeName,
  I_UtilsBillingRelatedInstdDvce.UtilsDvceRateDataValdtyEndDte AS UtilsDvceRateDataValdtyEndDte,
  I_UtilsBillingRelatedInstdDvce.UtilsDvceRateDataValdtyStrtDte AS UtilsDvceRateDataValdtyStrtDte,
  I_UtilsBillingRelatedInstdDvce.UtilsDvceIsRelevantForRntlPrc AS UtilsDvceIsRelevantForRntlPrc,
  I_UtilsBillingRelatedInstdDvce.UtilsDvceIsNotBillingRelevant AS UtilsDvceIsNotBillingRelevant,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceARCRCommandGroup AS UtilsDeviceARCRCommandGroup,
  I_UtilsBillingRelatedInstdDvce.MeterReadingBlockingReason AS MeterReadingBlockingReason,
  I_UtilsBillingRelatedInstdDvce._UtilsMtrRdngBlockReason._UtilsMtrRdngBlockReasonText[1: Language=$parameters.P_Language].MeterReadingBlockingReasonName AS MeterReadingBlockingReasonName,
  I_UtilsBillingRelatedInstdDvce.UtilsInstIsForEnergyFeedIn AS UtilsInstIsForEnergyFeedIn,
  I_UtilsBillingRelatedInstdDvce.UtilsInstGuarOfSupReason AS UtilsInstGuarOfSupReason,
  I_UtilsBillingRelatedInstdDvce.UtilitiesSrvcProviderRole AS UtilitiesSrvcProviderRole,
  I_UtilsBillingRelatedInstdDvce._UtilsServiceProviderRole._UtilsServiceProviderRoleText[1: Language=$parameters.P_Language].UtilitiesSrvcProviderRoleName AS UtilitiesSrvcProviderRoleName,
  I_UtilsBillingRelatedInstdDvce.UtilsInstIsExmptFrmFrnchsFee AS UtilsInstIsExmptFrmFrnchsFee,
  I_UtilsBillingRelatedInstdDvce.UtilitiesRateCategory AS UtilitiesRateCategory,
  I_UtilsBillingRelatedInstdDvce.ConstructionYear AS ConstructionYear,
  I_UtilsBillingRelatedInstdDvce.InstdUtilsDeviceIsCertifiable AS InstdUtilsDeviceIsCertifiable,
  I_UtilsBillingRelatedInstdDvce._UtilsDvceActivityReason._UtilsDvceActivityReasonText[1: Language=$parameters.P_Language].UtilsDeviceActivityReasonName AS UtilsDeviceActivityReasonName,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceLocation AS UtilsDeviceLocation,
  I_UtilsBillingRelatedInstdDvce.UtilsDeviceInstallationDate AS UtilsDeviceInstallationDate,
  I_UtilsBillingRelatedInstdDvce.UtilitiesPrepaymentMeterType AS UtilitiesPrepaymentMeterType,
  I_UtilsBillingRelatedInstdDvce.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  I_UtilsBillingRelatedInstdDvce.MaintenancePlant AS MaintenancePlant,
  I_UtilsBillingRelatedInstdDvce.MaintenanceObjectLocation AS MaintenanceObjectLocation,
  I_UtilsBillingRelatedInstdDvce.FunctionalLocation AS FunctionalLocation,
  I_UtilsBillingRelatedInstdDvce.Country AS Country,
  I_UtilsBillingRelatedInstdDvce.Region AS Region,
  I_UtilsBillingRelatedInstdDvce.CityName AS CityName,
  I_UtilsBillingRelatedInstdDvce.District AS District,
  I_UtilsBillingRelatedInstdDvce.HomeCityName AS HomeCityName,
  I_UtilsBillingRelatedInstdDvce.PostalCode AS PostalCode,
  I_UtilsBillingRelatedInstdDvce.StreetName AS StreetName,
  I_UtilsBillingRelatedInstdDvce.HouseNumber AS HouseNumber,
  I_UtilsBillingRelatedInstdDvce.HouseNumberSupplementText AS HouseNumberSupplementText,
  NmbrOfBillgReltdInstdUtilsDvce
FROM I_UtilsBillingRelatedInstdDvce
;

Depth:

C_UtilsBillgReltdInstdDeviceQ view

I_UtilsBillingRelatedInstdDvce view