I_UtilsBillingRelatedInstdDvce

Billing-Related Installed Device | view: IEBILLGRIDVCE | TRAN | Extraction: Not supported | Component: Device Management
Tables used: EGERH, EASTL, ADCP, ADRC, EQUI, EQUZ, IFLOT, ILOA, EGERS, EANL, EANLH, ETYP
Column Name Description
UtilitiesDevice FK Equipment Number
UtilitiesLogicalDeviceNumber Logical device number
UtilitiesInstallation Installation
Column Name Description
💲 Currency Key (Currency):
AcquisitionValue Acquisition Value
Column Name Description
Column Name Description
UtilsDvceRateDataValdtyEndDte Validity End Date of Device Rate Data
UtilsDvceRateDataValdtyStrtDte Validity Start Date of Device Rate Data
UtilsDeviceValidityEndDate Validity End Date of Device
UtilsDeviceValidityStartDate Validity Start Date of Device
UtilsDeviceInstallationDate Installation date
UtilsDeviceRemovalDate Device removal date
AcquisitionDate Acquisition date
UtilsDeviceLastLeadSealingDate Date of last lead sealing
UtilsDeviceModificationDate Modification date
LastChangeDate Last Changed On
UtilsInstCreationDate Date on which the record was created
UtilsInstLastChangeDate Last Changed On
UtilsInstHistValidityEndDate Validity End Date of Installation
UtilsInstHistValidityStartDate Validity Start Date of Installation
Column Name Description
UtilsDvceIsRelevantForRntlPrc Pay rental price Show values
UtilsDvceIsNotBillingRelevant Device Not Relevant for Billing Show values
UtilsDeviceCertfnStatus Certification status Show values
SampleUtilsDeviceStatus Status of sample device Show values
UtilsDeviceCalibrnValdtyIsUsed Use calibration validity Show values
InstdUtilsDeviceIsCertifiable Certify installed devices Show values
UtilsInstIsForEnergyFeedIn Purchase Show values
MeterReadingBasePeriodCat Base period category Show values
IsMarkedForDeletion Deletion Indicator Show values
UtilsInstIsExmptFrmFrnchsFee Exempt from franchise fee Show values
UtilsInstDvceAllctnIsNotAllwd Device allocation is not possible Show values
UnbilldRevnXtrapltnType Type of extrapolation in unbilled revenue reporting Show values
UtilsDeviceCertfnRqmtType Type of certification requirement Show values
UtilsDeviceMeasurementType Type of measurement Show values
UtilsDeviceAdvncdMeterCat Advanced Meter Show values
Column Name Description Domain name
UtilsDeviceRateType Rate Type TARIFART
UtilsDeviceRateFactGroup Rate fact group KONDIGR
UtilsDeviceBscCatCombination Combination of a device category KOMBINAT
UtilitiesRegisterGroup Register Group GEGST
UtilsDeviceLocation Device Location TPLNR
UtilsDeviceGroup Device group DEVGRP
UtilsDeviceWindingGroup Winding group GEGST
UtilitiesPrepaymentMeterType Prepayment Meter PPM_METER
AdvancedMeteringSystem Advanced Metering System E_AMI_AMS
AdvancedMeterCapabilityGroup Advanced Meter Capability Group (AMCG) E_AMI_CAP_GRP
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerSerialNumber Manufacturer's Serial Number CHAR30
ManufacturerPartTypeName Manufacturer model number TYPBZ
ConstructionYear Device Construction Year
SerialNumber Device GERNR
UniqueItemIdentifier Unique Item Identifier UII_CHAR72
UniqueItemIdentifierRespPlant Plant Responsible for UII WERKS
UtilsDeviceInOutGroup Input/output group GEGST
UtilsDeviceARCRCommandGroup ARCR Command Group GEGST
UtilsDeviceSampleLot Sample lot GEGST
UtilsDeviceMeasuredPressure Measured Pressure (Outlet Pressure) in Bars MESSDRCK
UtilsDeviceTransformationRatio Transformation ratio UEBERV
UtilsDeviceInspRelevanceCode Inspection relevance of device BESITZ
UtilsDeviceCertificationYear Certification Year JAHR
UtilsDeviceAdvncRplcmtYear Advance replacement year JAHR
UtilsDeviceCertificationNumber Certification number CHAR15
UtilsDeviceLastChangedByUser Name of Person Who Changed Object USNAM
UtilsDeviceInspPointGroup Inspection point group GEGST
UtilsDeviceInspectionNumber Device inspection number CHAR15
DvceIndivCertfnValdtyInYrs Individual cal. validity (years) of dev. subject to certif. ALLGVLZEIT
UtilsInstCreatedByUser Name of Person Responsible for Creating the Object USNAM
UtilsInstLastChangedByUser Name of Person Who Changed Object USNAM
UtilitiesFranchiseContract Franchise contract KONZVER
UtilsDeviceCategoryDescription Device Category Name TEXT30
UtilsDevicePTIRegnNmbr PTI number REGNUMMER
UtilsDeviceGGWARegnNmbr GGWA number REGNUMMER
UtilsDvceCalibrnValdtylnYears Calibration validity (yrs) for ext. devs subject to certif. ALLGVLZEIT
UtilsDvceIntCertfnPerdInYears Internal certification period (years) ALLGVLZEIT
UtilsDvceCalcNextRplcmtInYears Old cal. validity/int. cert. period (yrs) until prod. year ALLGVLZEIT
UtilsDeviceOldCertfnInYears Prod. yr until which old calib. valid./int.insp.per.is valid JAHR
UtilsDeviceNominalLoadValue Nominal load NENNBEL
FunctionalLocation Functional Location TPLNR
CityName City TEXT40
District District TEXT40
PostalCode City postal code CHAR10
HomeCityName City (different from postal city) TEXT40
StreetName Street TEXT60
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
CountyCode County code for county CNTY_CODE
NmbrOfBillgReltdInstdUtilsDvce Number of Billing-Relevant Installed Devices
Master Data Relations | to Other Relations ↓ Join Conditions
Address Number
  • Client
  • Address Number
  • ?
  • ?
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == ADRC.CLIENT
  • I_UTILSBILLINGRELATEDINSTDDVCE.ADDRESSID == ADRC.ADDRNUMBER
  • I_UTILSBILLINGRELATEDINSTDDVCE.[column in domain "AD_NATION"] == ADRC.NATION
  • I_UTILSBILLINGRELATEDINSTDDVCE.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Location of maintenance object
  • Maintenance Plant
  • Client
  • Location of maintenance object
  • Location of maintenance object
  • I_UTILSBILLINGRELATEDINSTDDVCE.MAINTENANCEPLANT == T499S.WERKS
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == T499S.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.ASSETLOCATION == T499S.STAND
  • I_UTILSBILLINGRELATEDINSTDDVCE.MAINTENANCEOBJECTLOCATION == T499S.STAND
Technical Object Authorization Group
  • Client
  • Technical Object Authorization Group
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == T370B.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.AUTHORIZATIONGROUP == T370B.BEGRU
City code for city/street file
  • Country/Region Key
  • City code for city/street file
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.COUNTRY == ADRCITY.COUNTRY
  • I_UTILSBILLINGRELATEDINSTDDVCE.CITYCODE == ADRCITY.CITY_CODE
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == ADRCITY.CLIENT
Controlling Area
  • Client
  • Controlling Area
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TKA01.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • I_UTILSBILLINGRELATEDINSTDDVCE.[column in domain "DATBI"] == CSKS.DATBI
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == CSKS.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.CONTROLLINGAREA == CSKS.KOKRS
  • I_UTILSBILLINGRELATEDINSTDDVCE.COSTCENTER == CSKS.KOSTL
Country key
  • Country/Region Key
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.COUNTRY == T005.LAND1
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == T005.MANDT
Currency Key
  • Client
  • Currency Key
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TCURC.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.CURRENCY == TCURC.WAERS
Equipment category
  • Client
  • Equipment category
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == T370T.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.EQUIPMENTCATEGORY == T370T.EQTYP
Higher-Level Installation I_UTILSBILLINGRELATEDINSTDDVCE.HIGHERLEVELUTILSINSTALLATION == EANL.MANDT
Location of maintenance object
  • Maintenance Plant
  • Client
  • Location of maintenance object
  • Location of maintenance object
  • I_UTILSBILLINGRELATEDINSTDDVCE.MAINTENANCEPLANT == T499S.WERKS
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == T499S.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.ASSETLOCATION == T499S.STAND
  • I_UTILSBILLINGRELATEDINSTDDVCE.MAINTENANCEOBJECTLOCATION == T499S.STAND
Maintenance Plant
  • Maintenance Plant
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.MAINTENANCEPLANT == T001W.WERKS
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == T001W.MANDT
Location and account assignment for technical object
  • Client
  • Location and account assignment for technical object
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == ILOA.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Country/Region of Manufacture
  • Client
  • Country/Region of Manufacture
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == T005.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANUFACTURERCOUNTRY == T005.LAND1
Reason for blocking meter reading
  • Reason for blocking meter reading
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.METERREADINGBLOCKINGREASON == TE119.ABLSPERR
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE119.MANDT
Meter Reading Unit
  • Meter Reading Unit
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.METERREADINGUNIT == TE422.TERMSCHL
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE422.MANDT
Control of perm. number of cust. MRs and autom. estimations
  • Control of perm. number of cust. MRs and autom. estimations
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.NMBROFALLWDMTRRDNGSCNTRLCODE == TE438.ABLESARTST
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE438.MANDT
Plant
  • Client
  • Plant
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == T001W.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.PLANT == T001W.WERKS
Key of Primary Installation I_UTILSBILLINGRELATEDINSTDDVCE.PRIMARYUTILITIESINSTALLATION == EANL.MANDT
Region code
  • Country/Region Key
  • Region (State, Province, County)
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.COUNTRY == T005S.LAND1
  • I_UTILSBILLINGRELATEDINSTDDVCE.REGION == T005S.BLAND
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == T005S.MANDT
Storage location
  • Client
  • Storage location
  • Plant
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == T001L.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.STORAGELOCATION == T001L.LGORT
  • I_UTILSBILLINGRELATEDINSTDDVCE.PLANT == T001L.WERKS
Type of Technical Object
  • Client
  • Type of Technical Object
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == T370K.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.TECHNICALOBJECTTYPE == T370K.EQART
Foreign Key Check for IUID Type I_UTILSBILLINGRELATEDINSTDDVCE.UNIQUEITEMIDENTIFIERSTRUCTYPE == TIUID_TYPE.IUID_TYPE
Billing Class
  • Client
  • Billing Class
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == EAKLASSE.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
Number of the billing schema
  • Number of the billing schema
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILITIESBILLINGSCHEMA == ESCH.SCHEMANR
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == ESCH.MANDT
Equipment Number
  • Client
  • Equipment Number
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == EQUI.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILITIESDEVICE == EQUI.EQUNR
Device category
  • Client
  • Device category
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == MARA.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILITIESDEVICECATEGORY == MARA.MATNR
Installation type
  • Installation type
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILITIESINSTALLATIONTYPE == TE439.ANLART
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE439.MANDT
Gas Pressure Level at Installation Level (Grid)
  • Client
  • Gas Pressure Level at Installation Level (Grid)
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE696.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILITIESINSTGASPRSSRLVL == TE696.DRUCKSTUF
Voltage Level
  • Voltage Level
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILITIESINSTVOLTAGELEVEL == TE369.SPEBENE
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE369.MANDT
Premise
  • Client
  • Premise
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == EVBS.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILITIESPREMISE == EVBS.VSTELLE
Rate Category
  • Client
  • Rate Category
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == ETTA.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILITIESRATECATEGORY == ETTA.TARIFTYP
Service Type
  • Client
  • Service Type
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TECDE.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILITIESSRVCPROVIDERROLE == TECDE.SERVICE
Temperature area
  • Client
  • Temperature area
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE307.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILITIESTEMPERATUREAREA == TE307.TEMP_AREA
Activity reason
  • Activity reason
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSDEVICEACTIVITYREASON == TE401.GERWECHS
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE401.MANDT
Price Class
  • Client
  • Price Class
  • Price Class
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE431.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSDEVICECATEGORYPRICECLASS == TE431.PREISKLA
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSDEVICEPRICECLASS == TE431.PREISKLA
Type of certification
  • Client
  • Type of certification
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE359.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSDEVICECERTFNTYPE == TE359.BGLART
Construction class
  • Construction class
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSDEVICECONSTRUCTIONCLASS == TE237.BAUKLAS
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE237.MANDT
Function class
  • Function class
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSDEVICEFUNCTIONCLASS == TE055.FUNKLAS
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE055.MANDT
Seal code
  • Seal code
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSDEVICELEADSEALINGCODE == TE937.PLOMBE
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE937.MANDT
Loss Determination Group
  • Loss Determination Group
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSDEVICELOSSDETNGROUP == TE1001.LOSSDTGROUP
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE1001.MANDT
Modification reason
  • Modification reason
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSDEVICEMODREASON == TE791.UMBAUGR
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE791.MANDT
Parametrization
  • Parametrization
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSDEVICEPARAMETRIZATIONCODE == TE927.PARAMETR
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE927.MANDT
Price Class
  • Client
  • Price Class
  • Price Class
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE431.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSDEVICECATEGORYPRICECLASS == TE431.PREISKLA
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSDEVICEPRICECLASS == TE431.PREISKLA
Role of an Installation Within the Installation Group
  • Role of an Installation Within the Installation Group
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSINSTALLATIONGROUPROLE == TE673.INSTROLE
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE673.MANDT
Grouping Type for Installation Group
  • Client
  • Grouping Type for Installation Group
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE672.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSINSTALLATIONGROUPTYPE == TE672.INSTGRTYPE
Release Status for Installation Data
  • Release Status for Installation Data
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSINSTDATARELEASESTATUS == TEINFOREL.INFOREL
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TEINFOREL.MANDT
Deregulation status
  • Deregulation status
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSINSTDEREGULATIONSTS == TEDEREGSTAT.DEREGSTAT
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TEDEREGSTAT.MANDT
Reason for guarantee of supply
  • Reason for guarantee of supply
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSINSTGUAROFSUPREASON == TE759.NODISCONCT
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE759.MANDT
Check Time Zone
  • Client
  • Time Zone for EDM Objects
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TTZZ.CLIENT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSINSTTIMEZONE == TTZZ.TZONE
Validation group for dependent validations
  • Client
  • Validation group for dependent validations
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TE413.MANDT
  • I_UTILSBILLINGRELATEDINSTDDVCE.UTILSREGDEPDNTVALDTNGROUP == TE413.PRUEFGR
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Division
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.DIVISION == TESPT.SPARTE
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == TESPT.MANDT
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_UTILSBILLINGRELATEDINSTDDVCE.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_UTILSBILLINGRELATEDINSTDDVCE.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_UTILSBILLINGRELATEDINSTDDVCE.MANDT == T399I.MANDT