C_UtilsDeviceStockQuery

Device Stock Query | view: CEDEVICESTOCKQ | Extraction: Not supported | Component: Device Management
Tables used: EGERHTSPATSPATEQUIEQBSEQUZT001WT001LEGERSETYP
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description
UtilsDeviceAdvncdMeterCat Advanced Meter Show values
Column Name Description Domain name
DivisionName Division Description TEXT20
PlantName Plant Name TEXT30
StorageLocationName Storage Location Name TEXT16
UtilsDeviceCategoryDescription Device Category Name TEXT30
UtilsDeviceAdvncdMeterCatName Short Text for Fixed Values DDTEXT
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerPartTypeName Manufacturer model number TYPBZ
SerialNumber Device GERNR
ConstructionYear Device Construction Year
AdvancedMeteringSystem Advanced Metering System E_AMI_AMS
Batch Batch Number CHARG
NmbrOfStockDevices Number of Devices in Stock
Master Data Relations Join Conditions
Division
  • Division
  • Client
  • C_UTILSDEVICESTOCKQUERY.DIVISION == TSPA.SPART
  • C_UTILSDEVICESTOCKQUERY.MANDT == TSPA.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • C_UTILSDEVICESTOCKQUERY.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • C_UTILSDEVICESTOCKQUERY.MANDT == T148.MANDT
Plant
  • Plant
  • Client
  • C_UTILSDEVICESTOCKQUERY.PLANT == T001W.WERKS
  • C_UTILSDEVICESTOCKQUERY.MANDT == T001W.MANDT
Storage location
  • Plant
  • Storage location
  • Client
  • C_UTILSDEVICESTOCKQUERY.PLANT == T001L.WERKS
  • C_UTILSDEVICESTOCKQUERY.STORAGELOCATION == T001L.LGORT
  • C_UTILSDEVICESTOCKQUERY.MANDT == T001L.MANDT
Equipment Number
  • Equipment Number
  • Client
  • C_UTILSDEVICESTOCKQUERY.UTILITIESDEVICE == EQUI.EQUNR
  • C_UTILSDEVICESTOCKQUERY.MANDT == EQUI.MANDT
Device category
  • Client
  • Device category
  • C_UTILSDEVICESTOCKQUERY.MANDT == MARA.MANDT
  • C_UTILSDEVICESTOCKQUERY.UTILITIESDEVICECATEGORY == MARA.MATNR
Construction class
  • Construction class
  • Client
  • C_UTILSDEVICESTOCKQUERY.UTILSDEVICECONSTRUCTIONCLASS == TE237.BAUKLAS
  • C_UTILSDEVICESTOCKQUERY.MANDT == TE237.MANDT
Function class
  • Function class
  • Client
  • C_UTILSDEVICESTOCKQUERY.UTILSDEVICEFUNCTIONCLASS == TE055.FUNKLAS
  • C_UTILSDEVICESTOCKQUERY.MANDT == TE055.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Stock Type of Goods Movement (Primary Posting)
  • Stock Type of Goods Movement (Primary Posting)
  • Special Stock Indicator
  • C_UTILSDEVICESTOCKQUERY.GOODSMOVEMENTSTOCKTYPE == T156C.LBBSA
  • C_UTILSDEVICESTOCKQUERY.INVENTORYSPECIALSTOCKTYPE == T156C.SOBKZ