C_UtilsBillgReltdInstdDvceIRQ

Billing-Related Installed Device Info Record Query | view: CEBILLGRIINFORQ | Extraction: Not supported | Component: Device Management
Tables used: EASTL, EGERR, TSPA, TSPAT, EANL, EANLH, TE431, TE431T, TE067, TE067T, TE069, TE069T, EAKLASSE, EAKLASSET, ETYP, TE439, TE439T, TE696, TE696T, TE759, TE759T, TE369, TE369T, TE119, TE119T, TECDE, TECDET, TE307, TE307T
Column Name Description
Column Name Description
Column Name Description
Column Name Description
UtilsInstHistValidityEndDate Validity End Date of Installation
UtilsInstHistValidityStartDate Validity Start Date of Installation
UtilsDeviceInstallationDate Installation date
UtilsDeviceValidityEndDate Validity End Date of Device
UtilsDeviceValidityStartDate Validity Start Date of Device
UtilsDvceRateDataValdtyEndDte Validity End Date of Device Rate Data
UtilsDvceRateDataValdtyStrtDte Validity Start Date of Device Rate Data
Column Name Description
UtilsInstIsExmptFrmFrnchsFee Exempt from franchise fee Show values
UtilsDeviceMeasurementType Type of measurement Show values
UtilsDeviceAdvncdMeterCat Advanced Meter Show values
UtilsDvceIsNotBillingRelevant Device Not Relevant for Billing Show values
UtilsDvceIsRelevantForRntlPrc Pay rental price Show values
Column Name Description Domain name
DivisionName Division Description TEXT20
UtilsDeviceCategoryDescription Device Category Name TEXT30
UtilitiesInstallation Installation ANLAGE
UtilitiesInstallationTypeName Text (30 Characters) TEXT30
UtilitiesInstVoltageLevelName Text (30 Characters) TEXT30
UtilitiesInstGasPrssrLvlName Text (30 Characters) TEXT30
UtilsInstGuarOfSupReasonName Text for reason for guarantee of supply TEXT30
UtilitiesSrvcProviderRoleName Text for Service Type TEXT25
MeterReadingBlockingReasonName Text (20 Characters) TEXT20
UtilitiesBillingClassName Billing Class Name TEXT30
UtilsDeviceRateType Rate Type TARIFART
UtilsDeviceRateFactGroup Rate fact group KONDIGR
UtilsDevicePriceClassName Text (30 Characters) TEXT30
UtilsDeviceRateTypeName Text (30 Characters) TEXT30
UtilsDeviceRateFactGroupName Text (30 Characters) TEXT30
UtilsDeviceBscCatCombination Combination of a device category KOMBINAT
UtilitiesPrepaymentMeterType Prepayment Meter PPM_METER
UtilsDeviceMeasurementTypeName Short Text for Fixed Values DDTEXT
UtilsDeviceAdvncdMeterCatName Short Text for Fixed Values DDTEXT
UtilitiesTemperatureAreaName Text for temperature area TEXT40
UtilitiesDeviceInfoRecord Equipment Number EQUNR
SerialNumber Device GERNR
NmbrOfBillgReltdInstdInfoRecd Number of Installed Billing-Relevant Device Info Records
Master Data Relations Join Conditions
Reason for blocking meter reading
  • Reason for blocking meter reading
  • Client
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.METERREADINGBLOCKINGREASON == TE119.ABLSPERR
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == TE119.MANDT
Meter Reading Unit
  • Meter Reading Unit
  • Client
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.METERREADINGUNIT == TE422.TERMSCHL
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == TE422.MANDT
Billing Class
  • Billing Class
  • Client
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == EAKLASSE.MANDT
Device category
  • Device category
  • Client
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.UTILITIESDEVICECATEGORY == ETYP.MATNR
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == ETYP.MANDT
Installation type
  • Installation type
  • Client
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.UTILITIESINSTALLATIONTYPE == TE439.ANLART
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == TE439.MANDT
Gas Pressure Level at Installation Level (Grid)
  • Gas Pressure Level at Installation Level (Grid)
  • Client
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.UTILITIESINSTGASPRSSRLVL == TE696.DRUCKSTUF
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == TE696.MANDT
Voltage Level
  • Voltage Level
  • Client
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.UTILITIESINSTVOLTAGELEVEL == TE369.SPEBENE
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == TE369.MANDT
Premise
  • Premise
  • Client
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.UTILITIESPREMISE == EVBS.VSTELLE
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == EVBS.MANDT
Rate Category
  • Client
  • Rate Category
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == ETTA.MANDT
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.UTILITIESRATECATEGORY == ETTA.TARIFTYP
Service Type
  • Client
  • Service Type
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == TECDE.MANDT
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.UTILITIESSRVCPROVIDERROLE == TECDE.SERVICE
Temperature area
  • Client
  • Temperature area
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == TE307.MANDT
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.UTILITIESTEMPERATUREAREA == TE307.TEMP_AREA
Construction class
  • Construction class
  • Client
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.UTILSDEVICECONSTRUCTIONCLASS == TE237.BAUKLAS
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == TE237.MANDT
Function class
  • Function class
  • Client
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.UTILSDEVICEFUNCTIONCLASS == TE055.FUNKLAS
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == TE055.MANDT
Price Class
  • Client
  • Price Class
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == TE431.MANDT
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.UTILSDEVICEPRICECLASS == TE431.PREISKLA
Reason for guarantee of supply
  • Client
  • Reason for guarantee of supply
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == TE759.MANDT
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.UTILSINSTGUAROFSUPREASON == TE759.NODISCONCT
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.MANDT == TESPT.MANDT
  • C_UTILSBILLGRELTDINSTDDVCEIRQ.DIVISION == TESPT.SPARTE