I_UtilsDvcePerdcRplcmntFcst

Device Periodic Replacement Forecast | view: IEDVCEPRPLCMTF | TRAN | Extraction: Not supported | Component: Periodic Replacement
Tables used: EGERH, ADCP, ADRC, EQUI, EQUZ, IFLOT, ILOA, EGERS, ETYP, TE271, EGTUR_HEAD, EGTUR
Column Name Description
UtilitiesDevice FK Equipment Number
Column Name Description
Column Name Description
Column Name Description
UtilsDeviceValidityEndDate Validity End Date of Device
UtilsDeviceValidityStartDate Validity Start Date of Device
UtilsDeviceInstallationDate Installation date
UtilsPerdcRplcmtCreationDate Date on which the record was created
UtilsPerdcRplcmtLastChangeDate Last Changed On
UtilsDeviceRemovalDate Device removal date
Column Name Description
UtilsDeviceCertfnStatus Certification status Show values
UtilsDeviceCalibrnValdtyIsUsed Use calibration validity Show values
InstdUtilsDeviceIsCertifiable Certify installed devices 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
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerPartTypeName Manufacturer model number TYPBZ
ConstructionYear Device Construction Year
SerialNumber Device GERNR
UtilsDeviceBscCatCombination Combination of a device category KOMBINAT
UtilitiesLogicalDeviceNumber Logical device number LOGIKNR
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
UtilsDeviceInspectionNumber Device inspection number CHAR15
DvceIndivCertfnValdtyInYrs Individual cal. validity (years) of dev. subject to certif. ALLGVLZEIT
ManufacturerSerialNumber Manufacturer's Serial Number CHAR30
DvceAdvancedRplcmtYear null
DvceSampleLotNextDueYear null
DvceInternalCertfnRplcmtYear null
DvceOldCertfnRplcmtYear null
DvceLostCertfnRplcmtYear null
DvceIndividualCertfnRplcmtYear null
DvceExternalCertfnRplcmtYear null
NextRplcmtYear Device Next Replacement Year
NmbrOfDevicesToBeReplaced Number of Devices to be Replaced
NmbrOfDevicesInPerdcRplcmtList Number of Devices in Periodic Replacement List
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
UtilsDeviceTransformationRatio Transformation ratio UEBERV
UtilsDeviceNominalLoadValue Nominal load NENNBEL
UtilsPerdcRplcmtCreatedByUser Name of Person Responsible for Creating the Object USNAM
UtilsPerdcRplcmtLastChgdByUser Name of Person Who Changed Object USNAM
UtilsPerdcRplcmtYear Periodic replacement year JAHR
FunctionalLocation Functional Location TPLNR
AddressID Address Number AD_ADDRNUM
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
CountyCode County code for county CNTY_CODE
Master Data Relations | to Other Relations ↓ Join Conditions
Location of maintenance object
  • Maintenance Plant
  • Client
  • Location of maintenance object
  • I_UTILSDVCEPERDCRPLCMNTFCST.MAINTENANCEPLANT == T499S.WERKS
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == T499S.MANDT
  • I_UTILSDVCEPERDCRPLCMNTFCST.ASSETLOCATION == T499S.STAND
Technical Object Authorization Group
  • Client
  • Technical Object Authorization Group
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == T370B.MANDT
  • I_UTILSDVCEPERDCRPLCMNTFCST.AUTHORIZATIONGROUP == T370B.BEGRU
City code for city/street file
  • City code for city/street file
  • Client
  • Country/Region Key
  • I_UTILSDVCEPERDCRPLCMNTFCST.CITYCODE == ADRCITY.CITY_CODE
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == ADRCITY.CLIENT
  • I_UTILSDVCEPERDCRPLCMNTFCST.COUNTRY == ADRCITY.COUNTRY
Controlling Area
  • Client
  • Controlling Area
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == TKA01.MANDT
  • I_UTILSDVCEPERDCRPLCMNTFCST.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Cost Center
  • Client
  • Controlling Area
  • ?
  • I_UTILSDVCEPERDCRPLCMNTFCST.COSTCENTER == CSKS.KOSTL
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == CSKS.MANDT
  • I_UTILSDVCEPERDCRPLCMNTFCST.CONTROLLINGAREA == CSKS.KOKRS
  • I_UTILSDVCEPERDCRPLCMNTFCST.[column in domain "DATBI"] == CSKS.DATBI
Country key
  • Client
  • Country/Region Key
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == T005.MANDT
  • I_UTILSDVCEPERDCRPLCMNTFCST.COUNTRY == T005.LAND1
Foreign Key Check for Division
  • Client
  • Division
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == TSPA.MANDT
  • I_UTILSDVCEPERDCRPLCMNTFCST.DIVISION == TSPA.SPART
Maintenance Plant
  • Maintenance Plant
  • Client
  • I_UTILSDVCEPERDCRPLCMNTFCST.MAINTENANCEPLANT == T001W.WERKS
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == T001W.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • I_UTILSDVCEPERDCRPLCMNTFCST.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == ILOA.MANDT
Country/Region of Manufacture
  • Client
  • Country/Region of Manufacture
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == T005.MANDT
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANUFACTURERCOUNTRY == T005.LAND1
Plant
  • Client
  • Plant
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == T001W.MANDT
  • I_UTILSDVCEPERDCRPLCMNTFCST.PLANT == T001W.WERKS
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == T005S.MANDT
  • I_UTILSDVCEPERDCRPLCMNTFCST.COUNTRY == T005S.LAND1
  • I_UTILSDVCEPERDCRPLCMNTFCST.REGION == T005S.BLAND
Storage location
  • Client
  • Plant
  • Storage location
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == T001L.MANDT
  • I_UTILSDVCEPERDCRPLCMNTFCST.PLANT == T001L.WERKS
  • I_UTILSDVCEPERDCRPLCMNTFCST.STORAGELOCATION == T001L.LGORT
Equipment Number
  • Equipment Number
  • Client
  • I_UTILSDVCEPERDCRPLCMNTFCST.UTILITIESDEVICE == EQUI.EQUNR
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == EQUI.MANDT
Device category
  • Device category
  • Client
  • I_UTILSDVCEPERDCRPLCMNTFCST.UTILITIESDEVICECATEGORY == MARA.MATNR
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == MARA.MANDT
Activity reason
  • Client
  • Activity reason
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == TE401.MANDT
  • I_UTILSDVCEPERDCRPLCMNTFCST.UTILSDEVICEACTIVITYREASON == TE401.GERWECHS
Price Class
  • Price Class
  • Client
  • I_UTILSDVCEPERDCRPLCMNTFCST.UTILSDEVICECATEGORYPRICECLASS == TE431.PREISKLA
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == TE431.MANDT
Construction class
  • Client
  • Construction class
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == TE237.MANDT
  • I_UTILSDVCEPERDCRPLCMNTFCST.UTILSDEVICECONSTRUCTIONCLASS == TE237.BAUKLAS
Function class
  • Function class
  • Client
  • I_UTILSDVCEPERDCRPLCMNTFCST.UTILSDEVICEFUNCTIONCLASS == TE055.FUNKLAS
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == TE055.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Client
  • Planner Group for Customer Service and Plant Maintenance
  • I_UTILSDVCEPERDCRPLCMNTFCST.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == T024I.MANDT
  • I_UTILSDVCEPERDCRPLCMNTFCST.MAINTENANCEPLANNERGROUP == T024I.INGRP
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_UTILSDVCEPERDCRPLCMNTFCST.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_UTILSDVCEPERDCRPLCMNTFCST.MANDT == T399I.MANDT