C_UtilsDeviceStockQuery

DDL: C_UTILSDEVICESTOCKQUERY SQL: CEDEVICESTOCKQ Type: view CONSUMPTION
22 Fields 1 Data Sources

Device Stock Query

Device Stock - Query

C_UtilsDeviceStockQuery (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Utilities

C_UtilsDeviceStockQuery is a Consumption CDS View that provides data about "Device Stock Query" in SAP S/4HANA. It reads from 1 data source (I_UtilsDeviceStock) and exposes 22 fields.

SAP API Hub

StateC1
Line of BusinessUtilities
Application ComponentIS-U-DM
CapabilitiesAnalytical Query
PackageUtilities for SAP S/4HANA

Documentation

Data Sources (1)

SourceAliasJoin Type
I_UtilsDeviceStock I_UtilsDeviceStock from

Parameters (2)

NameTypeDefault
P_Language sylangu
P_KeyDate e_keydate_vdm

Annotations (10)

NameValueLevelField
EndUserText.label Device Stock Query view
Analytics.query true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName CEDEVICESTOCKQ view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view

Fields (22)

KeyFieldSource TableSource FieldDescription
UtilitiesDeviceCategory I_UtilsDeviceStock UtilitiesDeviceCategory Device Category
UtilsDeviceFunctionClass I_UtilsDeviceStock UtilsDeviceFunctionClass Function class
UtilsDeviceConstructionClass I_UtilsDeviceStock UtilsDeviceConstructionClass Construction class
Division I_UtilsDeviceStock Division Internal Division ID
DivisionName Division Description
Plant I_UtilsDeviceStock Plant Valuation Area
PlantName I_UtilsDeviceStock PlantName Plant Name
StorageLocation I_UtilsDeviceStock StorageLocation Storage Location
StorageLocationName I_UtilsDeviceStock StorageLocationName Storage Location Name
UtilsDeviceCategoryDescription I_UtilsDeviceStock UtilsDeviceCategoryDescription Device Category Name
UtilsDeviceAdvncdMeterCat I_UtilsDeviceStock UtilsDeviceAdvncdMeterCat Advanced Meter
UtilsDeviceAdvncdMeterCatName Short Text for Fixed Values
AssetManufacturerName I_UtilsDeviceStock AssetManufacturerName Manufacturer of Asset
ManufacturerPartTypeName I_UtilsDeviceStock ManufacturerPartTypeName Manufacturer model number
UtilitiesDevice I_UtilsDeviceStock UtilitiesDevice Equipment Number
SerialNumber I_UtilsDeviceStock SerialNumber Serial Number
ConstructionYear I_UtilsDeviceStock ConstructionYear Device Construction Year
AdvancedMeteringSystem I_UtilsDeviceStock AdvancedMeteringSystem Advanced Metering System
GoodsMovementStockType I_UtilsDeviceStock GoodsMovementStockType Stock Type of Goods Movement (Primary Posting)
InventorySpecialStockType I_UtilsDeviceStock InventorySpecialStockType Special Stock Indicator
Batch I_UtilsDeviceStock Batch Batch Number
NmbrOfStockDevices I_UtilsDeviceStock NmbrOfStockDevices Number of Devices in Stock

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_UtilsDeviceStockQuery.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CEDEVICESTOCKQ
-- Parameters: P_Language : sylangu, P_KeyDate : e_keydate_vdm

CREATE VIEW C_UtilsDeviceStockQuery AS
SELECT
  I_UtilsDeviceStock.UtilitiesDeviceCategory AS UtilitiesDeviceCategory,
  I_UtilsDeviceStock.UtilsDeviceFunctionClass AS UtilsDeviceFunctionClass,
  I_UtilsDeviceStock.UtilsDeviceConstructionClass AS UtilsDeviceConstructionClass,
  I_UtilsDeviceStock.Division AS Division,
  I_UtilsDeviceStock._Division._Text[1: Language=$parameters.P_Language].DivisionName AS DivisionName,
  I_UtilsDeviceStock.Plant AS Plant,
  I_UtilsDeviceStock.PlantName AS PlantName,
  I_UtilsDeviceStock.StorageLocation AS StorageLocation,
  I_UtilsDeviceStock.StorageLocationName AS StorageLocationName,
  I_UtilsDeviceStock.UtilsDeviceCategoryDescription AS UtilsDeviceCategoryDescription,
  I_UtilsDeviceStock.UtilsDeviceAdvncdMeterCat AS UtilsDeviceAdvncdMeterCat,
  I_UtilsDeviceStock._UtilsDvceAdvncdMeterCat._UtilsDvceAdvncdMeterCatText[1: Language=$parameters.P_Language].UtilsDeviceAdvncdMeterCatName AS UtilsDeviceAdvncdMeterCatName,
  I_UtilsDeviceStock.AssetManufacturerName AS AssetManufacturerName,
  I_UtilsDeviceStock.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  I_UtilsDeviceStock.UtilitiesDevice AS UtilitiesDevice,
  I_UtilsDeviceStock.SerialNumber AS SerialNumber,
  I_UtilsDeviceStock.ConstructionYear AS ConstructionYear,
  I_UtilsDeviceStock.AdvancedMeteringSystem AS AdvancedMeteringSystem,
  I_UtilsDeviceStock.GoodsMovementStockType AS GoodsMovementStockType,
  I_UtilsDeviceStock.InventorySpecialStockType AS InventorySpecialStockType,
  I_UtilsDeviceStock.Batch AS Batch,
  I_UtilsDeviceStock.NmbrOfStockDevices AS NmbrOfStockDevices
FROM I_UtilsDeviceStock
;

Learn More