I_UtilsDvceIntCertfnRplcmtYear

Device Internal Certification Replacement Year | view: IEDVCEINCERTFNRY | Extraction: Not supported | Component: Periodic Replacement
Tables used: EGERHEQUIEQUZEGERSETYP
Column Name Description
UtilitiesDevice 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
Column Name Description
UtilsDeviceCertfnStatus Certification status Show values
UtilsDeviceCalibrnValdtyIsUsed Use calibration validity Show values
InstdUtilsDeviceIsCertifiable Certify installed devices 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
DvceInternalCertfnRplcmtYear null
DvceSampleLotNextDueYear null
DvceOldCertfnRplcmtYear null
DvceLostCertfnRplcmtYear null
DvceIndividualCertfnRplcmtYear null
DvceExternalCertfnRplcmtYear null
DvceAdvancedRplcmtYear null
Master Data Relations Join Conditions
Technical Object Authorization Group
  • Client
  • Technical Object Authorization Group
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.MANDT == T370B.MANDT
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.AUTHORIZATIONGROUP == T370B.BEGRU
Country/Region of Manufacture
  • Country/Region of Manufacture
  • Client
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.MANUFACTURERCOUNTRY == T005.LAND1
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.MANDT == T005.MANDT
Plant
  • Client
  • Plant
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.MANDT == T001W.MANDT
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.PLANT == T001W.WERKS
Storage location
  • Client
  • Plant
  • Storage location
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.MANDT == T001L.MANDT
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.PLANT == T001L.WERKS
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.STORAGELOCATION == T001L.LGORT
Equipment Number
  • Equipment Number
  • Client
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.UTILITIESDEVICE == EQUI.EQUNR
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.MANDT == EQUI.MANDT
Device category
  • Client
  • Device category
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.MANDT == MARA.MANDT
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.UTILITIESDEVICECATEGORY == MARA.MATNR
Activity reason
  • Client
  • Activity reason
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.MANDT == TE401.MANDT
  • I_UTILSDVCEINTCERTFNRPLCMTYEAR.UTILSDEVICEACTIVITYREASON == TE401.GERWECHS