I_UtilitiesDeviceHistory

Device History | view: IEDEVICEHISTORY | ATTR | Extraction: Not supported | Component: Device Management
Tables used: EGERH
Column Name Description
Equipment FK Equipment Number
UtilsDeviceValidityEndDate Validity End Date of Device
Column Name Description
Column Name Description
Column Name Description
UtilsDeviceValidityEndDate Validity End Date of Device
UtilsDeviceValidityStartDate Validity Start Date of Device
UtilsDeviceInstallationDate Installation date
UtilsDeviceRemovalDate Device removal date
Column Name Description
Column Name Description Domain name
UtilsDeviceBscCatCombination Combination of a device category KOMBINAT
UtilitiesLogicalDeviceNumber Logical device number LOGIKNR
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
Master Data Relations Join Conditions
Equipment Number
  • Client
  • Equipment Number
  • I_UTILITIESDEVICEHISTORY.MANDT == EQUI.MANDT
  • I_UTILITIESDEVICEHISTORY.EQUIPMENT == EQUI.EQUNR
Activity reason
  • Activity reason
  • Client
  • I_UTILITIESDEVICEHISTORY.UTILSDEVICEACTIVITYREASON == TE401.GERWECHS
  • I_UTILITIESDEVICEHISTORY.MANDT == TE401.MANDT
Loss Determination Group
  • Loss Determination Group
  • Client
  • I_UTILITIESDEVICEHISTORY.UTILSDEVICELOSSDETNGROUP == TE1001.LOSSDTGROUP
  • I_UTILITIESDEVICEHISTORY.MANDT == TE1001.MANDT