C_UtilsBillgReltdInstdDeviceQ

Billing-Related Installed Device Query | view: CEBILLGRIDVCEQ | Extraction: Not supported | Component: Device Management

Tables used: EGERH, EASTL, ADCP, ADRC, TSPA, TSPAT, EQUI, EQUZ, IFLOT, ILOA, EGERS, EANL, EANLH, TE431, TE431T, TE067, TE067T, TE069, TE069T, EAKLASSE, EAKLASSET, ETYP, TE401, TE401T, TE439, TE439T, TE696, TE696T, TE369, TE369T, TE119, TE119T, TECDE, TECDET

🔑 Keys
💰 Amounts
∑ Quantities
📅 Dates (7)
☰ Categorical (7)
Other (35)
🔗 Relations (23)

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
UtilsDeviceValidityEndDate	Validity End Date of Device
UtilsDeviceValidityStartDate	Validity Start Date of Device
UtilsInstHistValidityEndDate	Validity End Date of Installation
UtilsInstHistValidityStartDate	Validity Start Date of Installation
UtilsDvceRateDataValdtyEndDte	Validity End Date of Device Rate Data
UtilsDvceRateDataValdtyStrtDte	Validity Start Date of Device Rate Data
UtilsDeviceInstallationDate	Installation date

Column Name	Description
UtilsDeviceMeasurementType	Type of measurement	Show values
UtilsDeviceAdvncdMeterCat	Advanced Meter	Show values
UtilsDvceIsRelevantForRntlPrc	Pay rental price	Show values
UtilsDvceIsNotBillingRelevant	Device Not Relevant for Billing	Show values
UtilsInstIsForEnergyFeedIn	Purchase	Show values
UtilsInstIsExmptFrmFrnchsFee	Exempt from franchise fee	Show values
InstdUtilsDeviceIsCertifiable	Certify installed devices	Show values

Column Name	Description	Domain name
AdvancedMeteringSystem	Advanced Metering System	E_AMI_AMS
UtilitiesRegisterGroup	Register Group	GEGST
UtilsDeviceMeasurementTypeName	Short Text for Fixed Values	DDTEXT
DivisionName	Division Description	TEXT20
UtilsDeviceCategoryDescription	Device Category Name	TEXT30
UtilitiesInstallation	Installation	ANLAGE
UtilsDeviceCertificationYear	Certification Year	JAHR
AdvancedMeterCapabilityGroup	Advanced Meter Capability Group (AMCG)	E_AMI_CAP_GRP
SerialNumber	Device	GERNR
UtilsDeviceAdvncdMeterCatName	Short Text for Fixed Values	DDTEXT
UtilsDeviceRateFactGroup	Rate fact group	KONDIGR
UtilsDeviceRateFactGroupName	Text (30 Characters)	TEXT30
UtilsDeviceRateType	Rate Type	TARIFART
UtilsDeviceRateTypeName	Text (30 Characters)	TEXT30
UtilsDevicePriceClassName	Text (30 Characters)	TEXT30
UtilitiesBillingClassName	Billing Class Name	TEXT30
UtilitiesInstGasPrssrLvlName	Text (30 Characters)	TEXT30
UtilitiesInstVoltageLevelName	Text (30 Characters)	TEXT30
UtilitiesInstallationTypeName	Text (30 Characters)	TEXT30
UtilsDeviceARCRCommandGroup	ARCR Command Group	GEGST
MeterReadingBlockingReasonName	Text (20 Characters)	TEXT20
UtilitiesSrvcProviderRoleName	Text for Service Type	TEXT25
ConstructionYear	Device Construction Year
UtilsDeviceActivityReasonName	Text (30 Characters)	TEXT30
UtilsDeviceLocation	Device Location	TPLNR
UtilitiesPrepaymentMeterType	Prepayment Meter	PPM_METER
FunctionalLocation	Functional Location	TPLNR
CityName	City	TEXT40
District	District	TEXT40
HomeCityName	City (different from postal city)	TEXT40
PostalCode	City postal code	CHAR10
StreetName	Street	TEXT60
HouseNumber	House Number	TEXT10
HouseNumberSupplementText	House number supplement	TEXT10
NmbrOfBillgReltdInstdUtilsDvce	Number of Billing-Relevant Installed Devices

Master Data Relations	Join Conditions
Country key Client Country/Region Key	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == T005.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.COUNTRY == T005.LAND1`
Location of maintenance object Client Location of maintenance object Maintenance Plant	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == T499S.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.MAINTENANCEOBJECTLOCATION == T499S.STAND` `C_UTILSBILLGRELTDINSTDDEVICEQ.MAINTENANCEPLANT == T499S.WERKS`
Maintenance Plant Client Maintenance Plant	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == T001W.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.MAINTENANCEPLANT == T001W.WERKS`
Location and account assignment for technical object Location and account assignment for technical object Client	`C_UTILSBILLGRELTDINSTDDEVICEQ.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN` `C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == ILOA.MANDT`
Reason for blocking meter reading Client Reason for blocking meter reading	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == TE119.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.METERREADINGBLOCKINGREASON == TE119.ABLSPERR`
Meter Reading Unit Client Meter Reading Unit	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == TE422.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.METERREADINGUNIT == TE422.TERMSCHL`
Region code Client Country/Region Key Region (State, Province, County)	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == T005S.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.COUNTRY == T005S.LAND1` `C_UTILSBILLGRELTDINSTDDEVICEQ.REGION == T005S.BLAND`
Billing Class Client Billing Class	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == EAKLASSE.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE`
Equipment Number Equipment Number Client	`C_UTILSBILLGRELTDINSTDDEVICEQ.UTILITIESDEVICE == EQUI.EQUNR` `C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == EQUI.MANDT`
Device category Client Device category	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == MARA.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.UTILITIESDEVICECATEGORY == MARA.MATNR`
Installation type Client Installation type	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == TE439.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.UTILITIESINSTALLATIONTYPE == TE439.ANLART`
Gas Pressure Level at Installation Level (Grid) Client Gas Pressure Level at Installation Level (Grid)	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == TE696.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.UTILITIESINSTGASPRSSRLVL == TE696.DRUCKSTUF`
Voltage Level Client Voltage Level	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == TE369.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.UTILITIESINSTVOLTAGELEVEL == TE369.SPEBENE`
Premise Client Premise	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == EVBS.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.UTILITIESPREMISE == EVBS.VSTELLE`
Rate Category Client Rate Category	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == ETTA.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.UTILITIESRATECATEGORY == ETTA.TARIFTYP`
Service Type Client Service Type	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == TECDE.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.UTILITIESSRVCPROVIDERROLE == TECDE.SERVICE`
Temperature area Client Temperature area	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == TE307.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.UTILITIESTEMPERATUREAREA == TE307.TEMP_AREA`
Activity reason Activity reason Client	`C_UTILSBILLGRELTDINSTDDEVICEQ.UTILSDEVICEACTIVITYREASON == TE401.GERWECHS` `C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == TE401.MANDT`
Construction class Client Construction class	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == TE237.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.UTILSDEVICECONSTRUCTIONCLASS == TE237.BAUKLAS`
Function class Client Function class	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == TE055.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.UTILSDEVICEFUNCTIONCLASS == TE055.FUNKLAS`
Price Class Client Price Class	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == TE431.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.UTILSDEVICEPRICECLASS == TE431.PREISKLA`
Reason for guarantee of supply Client Reason for guarantee of supply	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == TE759.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.UTILSINSTGUAROFSUPREASON == TE759.NODISCONCT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Division Client Division	`C_UTILSBILLGRELTDINSTDDEVICEQ.MANDT == TESPT.MANDT` `C_UTILSBILLGRELTDINSTDDEVICEQ.DIVISION == TESPT.SPARTE`