I_UtilsDeviceStock

Device Stock | view: IEDEVICESTOCK | TRAN | Extraction: Not supported | Component: Device Management
Tables used: EGERH, EQUI, EQBS, EQUZ, T001W, T001L, EGERS, ETYP
Column Name Description
UtilitiesDevice FK Equipment Number
Column Name Description
💲 Currency Key (Currency):
AcquisitionValue Acquisition Value
Column Name Description
Column Name Description
UtilsDeviceValidityEndDate Validity End Date of Device
UtilsDeviceValidityStartDate Validity Start Date of Device
UtilsDeviceInstallationDate Installation date
UtilsDeviceRemovalDate Device removal date
AcquisitionDate Acquisition date
UtilsDeviceLastLeadSealingDate Date of last lead sealing
UtilsDeviceModificationDate Modification date
LastChangeDate Last Changed On
Column Name Description
UtilsDeviceCertfnStatus Certification status Show values
SampleUtilsDeviceStatus Status of sample device 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
UtilsDeviceBscCatCombination Combination of a device category KOMBINAT
UtilitiesLogicalDeviceNumber Logical device number LOGIKNR
UtilitiesRegisterGroup Register Group GEGST
UtilsDeviceLocation Device Location TPLNR
UtilsDeviceGroup Device group DEVGRP
UtilsDeviceWindingGroup Winding group GEGST
UtilitiesPrepaymentMeterType Prepayment Meter PPM_METER
AdvancedMeteringSystem Advanced Metering System E_AMI_AMS
AdvancedMeterCapabilityGroup Advanced Meter Capability Group (AMCG) E_AMI_CAP_GRP
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerSerialNumber Manufacturer's Serial Number CHAR30
ManufacturerPartTypeName Manufacturer model number TYPBZ
ConstructionYear Device Construction Year
SerialNumber Device GERNR
UniqueItemIdentifier Unique Item Identifier UII_CHAR72
UniqueItemIdentifierRespPlant Plant Responsible for UII WERKS
UtilsDeviceInOutGroup Input/output group GEGST
UtilsDeviceARCRCommandGroup ARCR Command Group GEGST
UtilsDeviceSampleLot Sample lot GEGST
UtilsDeviceMeasuredPressure Measured Pressure (Outlet Pressure) in Bars MESSDRCK
UtilsDeviceTransformationRatio Transformation ratio UEBERV
UtilsDeviceInspRelevanceCode Inspection relevance of device BESITZ
UtilsDeviceCertificationYear Certification Year JAHR
UtilsDeviceAdvncRplcmtYear Advance replacement year JAHR
UtilsDeviceCertificationNumber Certification number CHAR15
UtilsDeviceLastChangedByUser Name of Person Who Changed Object USNAM
UtilsDeviceInspPointGroup Inspection point group GEGST
UtilsDeviceInspectionNumber Device inspection number CHAR15
DvceIndivCertfnValdtyInYrs Individual cal. validity (years) of dev. subject to certif. ALLGVLZEIT
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
UtilsDeviceNominalLoadValue Nominal load NENNBEL
Batch Batch Number CHARG
PlantName Plant Name TEXT30
StorageLocationName Storage Location Name TEXT16
NmbrOfStockDevices Number of Devices in Stock
Master Data Relations Join Conditions
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • I_UTILSDEVICESTOCK.AUTHORIZATIONGROUP == T370B.BEGRU
  • I_UTILSDEVICESTOCK.MANDT == T370B.MANDT
Currency Key
  • Currency Key
  • Client
  • I_UTILSDEVICESTOCK.CURRENCY == TCURC.WAERS
  • I_UTILSDEVICESTOCK.MANDT == TCURC.MANDT
Division
  • Client
  • Division
  • I_UTILSDEVICESTOCK.MANDT == TSPA.MANDT
  • I_UTILSDEVICESTOCK.DIVISION == TSPA.SPART
Equipment category
  • Equipment category
  • Client
  • I_UTILSDEVICESTOCK.EQUIPMENTCATEGORY == T370T.EQTYP
  • I_UTILSDEVICESTOCK.MANDT == T370T.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • I_UTILSDEVICESTOCK.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • I_UTILSDEVICESTOCK.MANDT == T148.MANDT
Country/Region of Manufacture
  • Country/Region of Manufacture
  • Client
  • I_UTILSDEVICESTOCK.MANUFACTURERCOUNTRY == T005.LAND1
  • I_UTILSDEVICESTOCK.MANDT == T005.MANDT
Plant
  • Client
  • Plant
  • I_UTILSDEVICESTOCK.MANDT == T001W.MANDT
  • I_UTILSDEVICESTOCK.PLANT == T001W.WERKS
Storage location
  • Storage location
  • Client
  • Plant
  • I_UTILSDEVICESTOCK.STORAGELOCATION == T001L.LGORT
  • I_UTILSDEVICESTOCK.MANDT == T001L.MANDT
  • I_UTILSDEVICESTOCK.PLANT == T001L.WERKS
Type of Technical Object
  • Type of Technical Object
  • Client
  • I_UTILSDEVICESTOCK.TECHNICALOBJECTTYPE == T370K.EQART
  • I_UTILSDEVICESTOCK.MANDT == T370K.MANDT
Foreign Key Check for IUID Type I_UTILSDEVICESTOCK.UNIQUEITEMIDENTIFIERSTRUCTYPE == TIUID_TYPE.IUID_TYPE
Equipment Number
  • Equipment Number
  • Client
  • I_UTILSDEVICESTOCK.UTILITIESDEVICE == EQUI.EQUNR
  • I_UTILSDEVICESTOCK.MANDT == EQUI.MANDT
Device category
  • Device category
  • Client
  • I_UTILSDEVICESTOCK.UTILITIESDEVICECATEGORY == MARA.MATNR
  • I_UTILSDEVICESTOCK.MANDT == MARA.MANDT
Activity reason
  • Client
  • Activity reason
  • I_UTILSDEVICESTOCK.MANDT == TE401.MANDT
  • I_UTILSDEVICESTOCK.UTILSDEVICEACTIVITYREASON == TE401.GERWECHS
Price Class
  • Price Class
  • Client
  • I_UTILSDEVICESTOCK.UTILSDEVICECATEGORYPRICECLASS == TE431.PREISKLA
  • I_UTILSDEVICESTOCK.MANDT == TE431.MANDT
Type of certification
  • Client
  • Type of certification
  • I_UTILSDEVICESTOCK.MANDT == TE359.MANDT
  • I_UTILSDEVICESTOCK.UTILSDEVICECERTFNTYPE == TE359.BGLART
Construction class
  • Construction class
  • Client
  • I_UTILSDEVICESTOCK.UTILSDEVICECONSTRUCTIONCLASS == TE237.BAUKLAS
  • I_UTILSDEVICESTOCK.MANDT == TE237.MANDT
Function class
  • Function class
  • Client
  • I_UTILSDEVICESTOCK.UTILSDEVICEFUNCTIONCLASS == TE055.FUNKLAS
  • I_UTILSDEVICESTOCK.MANDT == TE055.MANDT
Seal code
  • Client
  • Seal code
  • I_UTILSDEVICESTOCK.MANDT == TE937.MANDT
  • I_UTILSDEVICESTOCK.UTILSDEVICELEADSEALINGCODE == TE937.PLOMBE
Loss Determination Group
  • Loss Determination Group
  • Client
  • I_UTILSDEVICESTOCK.UTILSDEVICELOSSDETNGROUP == TE1001.LOSSDTGROUP
  • I_UTILSDEVICESTOCK.MANDT == TE1001.MANDT
Modification reason
  • Client
  • Modification reason
  • I_UTILSDEVICESTOCK.MANDT == TE791.MANDT
  • I_UTILSDEVICESTOCK.UTILSDEVICEMODREASON == TE791.UMBAUGR
Parametrization
  • Client
  • Parametrization
  • I_UTILSDEVICESTOCK.MANDT == TE927.MANDT
  • I_UTILSDEVICESTOCK.UTILSDEVICEPARAMETRIZATIONCODE == TE927.PARAMETR
Other Relations | to Master Data Relations ↑ Join Conditions
Stock Type of Goods Movement (Primary Posting)
  • Special Stock Indicator
  • Stock Type of Goods Movement (Primary Posting)
  • I_UTILSDEVICESTOCK.INVENTORYSPECIALSTOCKTYPE == T156C.SOBKZ
  • I_UTILSDEVICESTOCK.GOODSMOVEMENTSTOCKTYPE == T156C.LBBSA