C_UtilsDvcePerdcRplcmntListQ

Device Periodic Replacement List Query | view: CEDVCEPERDCRLQ | Extraction: Not supported | Component: Periodic Replacement
Tables used: EGERH, ADCP, ADRC, T005G, T005H, T005, T005T, TSPA, TSPAT, EQUI, EQUZ, IFLOT, ILOA, T005S, T005U, EGERS, ETYP, TE055, TE055T, TE237, TE237T, EGTUR_HEAD, EGTUR
Column Name Description
Column Name Description
Column Name Description
Column Name Description
UtilsDeviceInstallationDate Installation date
UtilsDeviceRemovalDate Device removal date
UtilsDeviceLastLeadSealingDate Date of last lead sealing
UtilsPerdcRplcmtCreationDate Date on which the record was created
UtilsPerdcRplcmtLastChangeDate Last Changed On
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
InstdUtilsDeviceIsCertifiable Certify installed devices Show values
Column Name Description Domain name
UtilsPerdcRplcmtYear Periodic replacement year JAHR
UtilsDeviceFunctionClassName Text for function class TEXT30
UtilsDvceConstructionClassName Text (30 Characters) TEXT30
DivisionName Division Description TEXT20
UtilsDeviceCategoryDescription Device Category Name TEXT30
UtilsDeviceCertfnRqmtTypeName Short Text for Fixed Values DDTEXT
UtilsDvceCalibrnValdtylnYears Calibration validity (yrs) for ext. devs subject to certif. ALLGVLZEIT
UtilsDvceCalcNextRplcmtInYears Old cal. validity/int. cert. period (yrs) until prod. year ALLGVLZEIT
UtilsDvceIntCertfnPerdInYears Internal certification period (years) ALLGVLZEIT
UtilsDeviceOldCertfnInYears Prod. yr until which old calib. valid./int.insp.per.is valid JAHR
UtilsDeviceMeasurementTypeName Short Text for Fixed Values DDTEXT
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerPartTypeName Manufacturer model number TYPBZ
ConstructionYear Device Construction Year
SerialNumber Device GERNR
UtilsDeviceBscCatCombination Combination of a device category KOMBINAT
UtilsDeviceLocation Device Location TPLNR
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
UtilsDeviceInspRelevanceCode Inspection relevance of device BESITZ
UtilsDeviceCertificationYear Certification Year JAHR
UtilsDeviceAdvncRplcmtYear Advance replacement year JAHR
UtilsDeviceCertfnStatusName Short Text for Fixed Values DDTEXT
UtilsDeviceInspectionNumber Device inspection number CHAR15
DvceIndivCertfnValdtyInYrs Individual cal. validity (years) of dev. subject to certif. ALLGVLZEIT
FunctionalLocation Functional Location TPLNR
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
UtilsPerdcRplcmtCreatedByUser Name of Person Responsible for Creating the Object USNAM
UtilsPerdcRplcmtLastChgdByUser Name of Person Who Changed Object USNAM
MaintenanceOrder Order Number AUFNR
MaintenanceNotification Notification Number QMNUM
MeterReadingUnit Meter Reading Unit ABLEINHEIT
RegionalStructureGrouping Regional structure grouping REGIOGROUP
NmbrOfDevicesToBeReplaced Number of Devices to be Replaced
NmbrOfRemovedDevices Number of Removed Devices
Master Data Relations Join Conditions
City code for city/street file
  • Country/Region Key
  • City code for city/street file
  • Client
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.COUNTRY == ADRCITY.COUNTRY
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.CITYCODE == ADRCITY.CITY_CODE
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MANDT == ADRCITY.CLIENT
Country key
  • Country/Region Key
  • Client
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.COUNTRY == T005.LAND1
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MANDT == T005.MANDT
Division
  • Division
  • Client
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.DIVISION == TSPA.SPART
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MANDT == TSPA.MANDT
Location of maintenance object
  • Maintenance Plant
  • Client
  • Location of maintenance object
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MAINTENANCEPLANT == T499S.WERKS
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MANDT == T499S.MANDT
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MAINTENANCEOBJECTLOCATION == T499S.STAND
Maintenance Plant
  • Maintenance Plant
  • Client
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MAINTENANCEPLANT == T001W.WERKS
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MANDT == T001W.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MANDT == ILOA.MANDT
Country/Region of Manufacture
  • Country/Region of Manufacture
  • Client
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MANUFACTURERCOUNTRY == T005.LAND1
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MANDT == T005.MANDT
Region code
  • Country/Region Key
  • Region (State, Province, County)
  • Client
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.COUNTRY == T005S.LAND1
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.REGION == T005S.BLAND
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MANDT == T005S.MANDT
Equipment Number
  • Equipment Number
  • Client
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.UTILITIESDEVICE == EQUI.EQUNR
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MANDT == EQUI.MANDT
Device category
  • Client
  • Device category
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MANDT == MARA.MANDT
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.UTILITIESDEVICECATEGORY == MARA.MATNR
Construction class
  • Construction class
  • Client
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.UTILSDEVICECONSTRUCTIONCLASS == TE237.BAUKLAS
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MANDT == TE237.MANDT
Function class
  • Function class
  • Client
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.UTILSDEVICEFUNCTIONCLASS == TE055.FUNKLAS
  • C_UTILSDVCEPERDCRPLCMNTLISTQ.MANDT == TE055.MANDT