I_UTILSDEVICESTOCK

CDS View
20 Fields 1 CDS Views

Device Stock

I_UTILSDEVICESTOCK is a CDS View in S/4HANA. Device Stock. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_UtilsDeviceStockQuery view from CONSUMPTION Device Stock - Query

Fields (20)

KeyField CDS FieldsUsed in Views
AdvancedMeteringSystem AdvancedMeteringSystem 1
AssetManufacturerName AssetManufacturerName 1
Batch Batch 1
ConstructionYear ConstructionYear 1
Division Division 1
GoodsMovementStockType GoodsMovementStockType 1
InventorySpecialStockType InventorySpecialStockType 1
ManufacturerPartTypeName ManufacturerPartTypeName 1
NmbrOfStockDevices NmbrOfStockDevices 1
Plant Plant 1
PlantName PlantName 1
SerialNumber SerialNumber 1
StorageLocation StorageLocation 1
StorageLocationName StorageLocationName 1
UtilitiesDevice UtilitiesDevice 1
UtilitiesDeviceCategory UtilitiesDeviceCategory 1
UtilsDeviceAdvncdMeterCat UtilsDeviceAdvncdMeterCat 1
UtilsDeviceCategoryDescription UtilsDeviceCategoryDescription 1
UtilsDeviceConstructionClass UtilsDeviceConstructionClass 1
UtilsDeviceFunctionClass UtilsDeviceFunctionClass 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Device Stock
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILSDEVICESTOCK (
    ADVANCEDMETERINGSYSTEM,
    ASSETMANUFACTURERNAME,
    BATCH,
    CONSTRUCTIONYEAR,
    DIVISION,
    GOODSMOVEMENTSTOCKTYPE,
    INVENTORYSPECIALSTOCKTYPE,
    MANUFACTURERPARTTYPENAME,
    NMBROFSTOCKDEVICES,
    PLANT,
    PLANTNAME,
    SERIALNUMBER,
    STORAGELOCATION,
    STORAGELOCATIONNAME,
    UTILITIESDEVICE,
    UTILITIESDEVICECATEGORY,
    UTILSDEVICEADVNCDMETERCAT,
    UTILSDEVICECATEGORYDESCRIPTION,
    UTILSDEVICECONSTRUCTIONCLASS,
    UTILSDEVICEFUNCTIONCLASS
);

Learn More