C_UtilsTechlyInstdDeviceQuery

Technically Installed Device Query | view: CETECHLYIDVCEQ | Extraction: Not supported | Component: Device Management
Tables used: EGERH, EASTL, ADCP, ADRC, TSPA, TSPAT, EQUI, EQUZ, IFLOT, IFLOTX, ILOA, T001W, EGERS, ETYP, TE055, TE055T, TE237, TE237T, TEPRREL, TEPRRELT, TE927, TE927T
Column Name Description
Column Name Description
Column Name Description
Column Name Description
UtilsDeviceValidityStartDate Validity Start Date of Device
UtilsDeviceValidityEndDate Validity End Date of Device
UtilsDeviceInstallationDate Installation date
Column Name Description
UtilsDeviceMeasurementType Type of measurement Show values
UtilsDeviceCertfnStatus Certification status Show values
SampleUtilsDeviceStatus Status of sample device Show values
InstdUtilsDeviceIsCertifiable Certify installed devices Show values
Column Name Description Domain name
UtilsDeviceCategoryDescription Device Category Name TEXT30
DivisionName Division Description TEXT20
UtilitiesRegisterGroup Register Group GEGST
AdvancedMeteringSystem Advanced Metering System E_AMI_AMS
UtilsDeviceFunctionClassName Text for function class TEXT30
UtilsDvceConstructionClassName Text (30 Characters) TEXT30
UtilsDeviceMeasurementTypeName Short Text for Fixed Values DDTEXT
UtilsDeviceSampleLot Sample lot GEGST
ConstructionYear Device Construction Year
SerialNumber Device GERNR
UtilsDeviceBscCatCombination Combination of a device category KOMBINAT
UtilsDeviceLocation Device Location TPLNR
UtilsDeviceGroup Device group DEVGRP
UtilsDeviceWindingGroup Winding group GEGST
UtilitiesPrepaymentMeterType Prepayment Meter PPM_METER
AdvancedMeterCapabilityGroup Advanced Meter Capability Group (AMCG) E_AMI_CAP_GRP
UtilsDeviceInOutGroup Input/output group GEGST
UtilsDeviceARCRCommandGroup ARCR Command Group GEGST
UtilsDeviceInspRelevanceCode Inspection relevance of device BESITZ
UtilsDeviceInspRelevanceName Text Field TEXT50
UtilsDeviceCertificationYear Certification Year JAHR
SampleUtilsDeviceStatusName Short Text for Fixed Values DDTEXT
UtilsDeviceParametrizationName Text (30 Characters) TEXT30
DvceIndivCertfnValdtyInYrs Individual cal. validity (years) of dev. subject to certif. ALLGVLZEIT
PlantName Plant Name TEXT30
PlantName2 Plant Name TEXT30
FunctionalLocation Functional Location TPLNR
FunctionalLocationName Description of functional location TEXT40
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
NmbrOfInstalledUtilsDevices Number of Installed Devices
Master Data Relations Join Conditions
City code for city/street file
  • Client
  • City code for city/street file
  • Country/Region Key
  • C_UTILSTECHLYINSTDDEVICEQUERY.MANDT == ADRCITY.CLIENT
  • C_UTILSTECHLYINSTDDEVICEQUERY.CITYCODE == ADRCITY.CITY_CODE
  • C_UTILSTECHLYINSTDDEVICEQUERY.COUNTRY == ADRCITY.COUNTRY
Country key
  • Client
  • Country/Region Key
  • C_UTILSTECHLYINSTDDEVICEQUERY.MANDT == T005.MANDT
  • C_UTILSTECHLYINSTDDEVICEQUERY.COUNTRY == T005.LAND1
Division
  • Client
  • Division
  • C_UTILSTECHLYINSTDDEVICEQUERY.MANDT == TSPA.MANDT
  • C_UTILSTECHLYINSTDDEVICEQUERY.DIVISION == TSPA.SPART
Location of maintenance object
  • Location of maintenance object
  • Client
  • Maintenance Plant
  • C_UTILSTECHLYINSTDDEVICEQUERY.MAINTENANCEOBJECTLOCATION == T499S.STAND
  • C_UTILSTECHLYINSTDDEVICEQUERY.MANDT == T499S.MANDT
  • C_UTILSTECHLYINSTDDEVICEQUERY.MAINTENANCEPLANT == T499S.WERKS
Maintenance Plant
  • Client
  • Maintenance Plant
  • C_UTILSTECHLYINSTDDEVICEQUERY.MANDT == T001W.MANDT
  • C_UTILSTECHLYINSTDDEVICEQUERY.MAINTENANCEPLANT == T001W.WERKS
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • C_UTILSTECHLYINSTDDEVICEQUERY.MANDT == T005S.MANDT
  • C_UTILSTECHLYINSTDDEVICEQUERY.REGION == T005S.BLAND
  • C_UTILSTECHLYINSTDDEVICEQUERY.COUNTRY == T005S.LAND1
Device category
  • Device category
  • Client
  • C_UTILSTECHLYINSTDDEVICEQUERY.UTILITIESDEVICECATEGORY == MARA.MATNR
  • C_UTILSTECHLYINSTDDEVICEQUERY.MANDT == MARA.MANDT
Activity reason
  • Activity reason
  • Client
  • C_UTILSTECHLYINSTDDEVICEQUERY.UTILSDEVICEACTIVITYREASON == TE401.GERWECHS
  • C_UTILSTECHLYINSTDDEVICEQUERY.MANDT == TE401.MANDT
Construction class
  • Construction class
  • Client
  • C_UTILSTECHLYINSTDDEVICEQUERY.UTILSDEVICECONSTRUCTIONCLASS == TE237.BAUKLAS
  • C_UTILSTECHLYINSTDDEVICEQUERY.MANDT == TE237.MANDT
Function class
  • Function class
  • Client
  • C_UTILSTECHLYINSTDDEVICEQUERY.UTILSDEVICEFUNCTIONCLASS == TE055.FUNKLAS
  • C_UTILSTECHLYINSTDDEVICEQUERY.MANDT == TE055.MANDT
Parametrization
  • Client
  • Parametrization
  • C_UTILSTECHLYINSTDDEVICEQUERY.MANDT == TE927.MANDT
  • C_UTILSTECHLYINSTDDEVICEQUERY.UTILSDEVICEPARAMETRIZATIONCODE == TE927.PARAMETR
Other Relations | to Master Data Relations ↑ Join Conditions
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_UTILSTECHLYINSTDDEVICEQUERY.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_UTILSTECHLYINSTDDEVICEQUERY.MANDT == T399I.MANDT