C_UtilsDvcePerdcRplcmntQuery

Device Periodic Replacement Forecast Query | view: CEDVCEPRPLCMTFQ | Extraction: Not supported | Component: Periodic Replacement
Tables used: EGERH, ADCP, ADRC, T005G, T005H, T005, T005T, TSPA, TSPAT, EQUI, EQKT, EQUZ, IFLOT, IFLOTX, ILOA, T001W, T005S, T005U, EGERS, ETYP, TE055, TE055T, TE271, TE237, TE237T, TEPRREL, TEPRRELT, EGTUR_HEAD, EGTUR
Column Name Description
Column Name Description
Column Name Description
Column Name Description
UtilsDeviceInstallationDate Installation date
Column Name Description
UtilsDeviceCertfnRqmtType Type of certification requirement Show values
UtilsDeviceMeasurementType Type of measurement Show values
UtilsDeviceCertfnStatus Certification status Show values
UtilsDeviceCalibrnValdtyIsUsed Use calibration validity Show values
Column Name Description Domain name
EquipmentName Description of technical object TEXT40
DivisionName Division Description TEXT20
UtilsDeviceCategoryDescription Device Category Name TEXT30
UtilsDeviceFunctionClassName Text for function class TEXT30
UtilsDvceConstructionClassName Text (30 Characters) TEXT30
UtilsDeviceCertfnRqmtTypeName Short Text for Fixed Values DDTEXT
UtilsDeviceMeasurementTypeName Short Text for Fixed Values DDTEXT
ConstructionYear Device Construction Year
SerialNumber Device GERNR
PlantName Plant Name TEXT30
UtilsDeviceBscCatCombination Combination of a device category KOMBINAT
UtilsDeviceGroup Device group DEVGRP
UtilitiesPrepaymentMeterType Prepayment Meter PPM_METER
AdvancedMeteringSystem Advanced Metering System E_AMI_AMS
UtilsDeviceInOutGroup Input/output group GEGST
UtilsDeviceSampleLot Sample lot GEGST
UtilsDeviceCertificationYear Certification Year JAHR
UtilsDeviceInspRelevanceCode Inspection relevance of device BESITZ
UtilsDeviceInspRelevanceName Text Field TEXT50
UtilsDeviceCertfnStatusName Short Text for Fixed Values DDTEXT
UtilsDeviceInspectionNumber Device inspection number CHAR15
DvceIndivCertfnValdtyInYrs Individual cal. validity (years) of dev. subject to certif. ALLGVLZEIT
UtilitiesLogicalDeviceNumber Logical device number LOGIKNR
FunctionalLocation Functional Location TPLNR
FunctionalLocationName Description of functional location TEXT40
MaintenancePlantName Plant Name TEXT30
PlantName2 Plant Name TEXT30
NextRplcmtYear Device Next Replacement Year
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
CountryName Country/Region Name TEXT50
RegionName Description TEXT20
CityCodeName Description TEXT20
NmbrOfDevicesToBeReplaced Number of Devices to be Replaced
NmbrOfDevicesInPerdcRplcmtList Number of Devices in Periodic Replacement List
Master Data Relations Join Conditions
City code for city/street file
  • Client
  • City code for city/street file
  • Country/Region Key
  • C_UTILSDVCEPERDCRPLCMNTQUERY.MANDT == ADRCITY.CLIENT
  • C_UTILSDVCEPERDCRPLCMNTQUERY.CITYCODE == ADRCITY.CITY_CODE
  • C_UTILSDVCEPERDCRPLCMNTQUERY.COUNTRY == ADRCITY.COUNTRY
Country key
  • Client
  • Country/Region Key
  • C_UTILSDVCEPERDCRPLCMNTQUERY.MANDT == T005.MANDT
  • C_UTILSDVCEPERDCRPLCMNTQUERY.COUNTRY == T005.LAND1
Foreign Key Check for Division
  • Client
  • Division
  • C_UTILSDVCEPERDCRPLCMNTQUERY.MANDT == TSPA.MANDT
  • C_UTILSDVCEPERDCRPLCMNTQUERY.DIVISION == TSPA.SPART
Maintenance Plant
  • Maintenance Plant
  • Client
  • C_UTILSDVCEPERDCRPLCMNTQUERY.MAINTENANCEPLANT == T001W.WERKS
  • C_UTILSDVCEPERDCRPLCMNTQUERY.MANDT == T001W.MANDT
Plant
  • Client
  • Plant
  • C_UTILSDVCEPERDCRPLCMNTQUERY.MANDT == T001W.MANDT
  • C_UTILSDVCEPERDCRPLCMNTQUERY.PLANT == T001W.WERKS
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • C_UTILSDVCEPERDCRPLCMNTQUERY.MANDT == T005S.MANDT
  • C_UTILSDVCEPERDCRPLCMNTQUERY.COUNTRY == T005S.LAND1
  • C_UTILSDVCEPERDCRPLCMNTQUERY.REGION == T005S.BLAND
Equipment Number
  • Equipment Number
  • Client
  • C_UTILSDVCEPERDCRPLCMNTQUERY.UTILITIESDEVICE == EQUI.EQUNR
  • C_UTILSDVCEPERDCRPLCMNTQUERY.MANDT == EQUI.MANDT
Device category
  • Client
  • Device category
  • C_UTILSDVCEPERDCRPLCMNTQUERY.MANDT == MARA.MANDT
  • C_UTILSDVCEPERDCRPLCMNTQUERY.UTILITIESDEVICECATEGORY == MARA.MATNR
Construction class
  • Client
  • Construction class
  • C_UTILSDVCEPERDCRPLCMNTQUERY.MANDT == TE237.MANDT
  • C_UTILSDVCEPERDCRPLCMNTQUERY.UTILSDEVICECONSTRUCTIONCLASS == TE237.BAUKLAS
Function class
  • Client
  • Function class
  • C_UTILSDVCEPERDCRPLCMNTQUERY.MANDT == TE055.MANDT
  • C_UTILSDVCEPERDCRPLCMNTQUERY.UTILSDEVICEFUNCTIONCLASS == TE055.FUNKLAS
Other Relations | to Master Data Relations ↑ Join Conditions
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • C_UTILSDVCEPERDCRPLCMNTQUERY.MANDT == T399I.MANDT
  • C_UTILSDVCEPERDCRPLCMNTQUERY.MAINTENANCEPLANNINGPLANT == T399I.IWERK