C_EWM_WarehouseOrderLeanQ

DDL: C_EWM_WAREHOUSEORDERLEANQ SQL: CEWMWOLQ Type: view CONSUMPTION
36 Fields 1 Data Sources

Warehouse Order Lean - Query

C_EWM_WarehouseOrderLeanQ (Consumption)

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

Supply Chain

C_EWM_WarehouseOrderLeanQ is a Consumption CDS View that provides data about "Warehouse Order Lean - Query" in SAP S/4HANA. It reads from 1 data source (I_EWM_WhseOrderCube) and exposes 36 fields with key fields Warehouse, WarehouseOrder.

SAP Help Documentation

CategoryCDS Views for Cross Processes
Data CategoryQuery
StatusReleased
Corresponding DataSource2CCEWMWOLQ
Purpose
This CDS view provides the prerequisites for answering questions about the total number of warehouse orders in your warehouse.

Prerequisites
If you want to run reports using this CDS view, you must have a role based on the business role template listed in the previous table. In this role, the following restrictions must be set to read access: Warehouse Number / Warehouse Complex These restrictions are edited in the Maintain Business Roles app.

Structure
Main CDS Parameters and Filters This view has no mandatory input parameters. The main filters are as follows: Warehouse Order Creation Date and Time of Warehouse Order Confirmation Date and Time of Warehouse Order Measures The important measure is the number of warehouse orders.

SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Application Help SAP Library BI Content .

View on SAP Help Portal →

SAP API Hub

StateDeprecated
Line of BusinessSupply Chain
Application ComponentSCM-EWM-WOP
CapabilitiesAnalytical Query
PackageSupply Chain for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering questions about the total number of warehouse orders in your warehouse.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_EWM_WhseOrderCube I_EWM_WhseOrderCube from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CEWMWOLQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Warehouse Order Lean - Query view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.supportedCapabilities #ANALYTICAL_QUERY view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
OData.publish true view
Analytics.query true view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY Warehouse Warehouse Warehouse Number/Warehouse Complex
KEY WarehouseOrder WarehouseOrder Warehouse Order Number
WarehouseOrderCreationRule WarehouseOrderCreationRule Warehouse Order Creation Rule
WarehouseOrderStatus WarehouseOrderStatus Warehouse Order Status
WarehouseOrderStatusName WarehouseOrderStatusName Description of Warehouse Order Status
WhseOrderOverdueHours WhseOrderOverdueHours Overdue Time (Hour)
WhseOrderLastChgUTCDateTime WhseOrderLastChgUTCDateTime WO Last Changed On (UTC)
LastChangedByUser LastChangedByUser WO Last Changed By
WarehouseOrderHasWhseTask WarehouseOrderHasWhseTask Warehouse Order Contains Warehouse Task
WarehouseOrderHasPhysInvtryDoc WarehouseOrderHasPhysInvtryDoc WO Contains Physical Inventory Document
WhseOrderCrtnWhseTmznDateTime WhseOrderCrtnWhseTmznDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
WhseOrderCrtnWhseTmznYear WhseOrderCrtnWhseTmznYear Creation Date (Year) of Warehouse Order
WhseOrderCrtnWhseTmznMonth WhseOrderCrtnWhseTmznMonth Creation Date (Month) of Warehouse Order
WhseOrderCrtnWhseTmznDate WhseOrderCrtnWhseTmznDate Creation Date of Warehouse Order
WhseOrderCrtnWhseTmznHour WhseOrderCrtnWhseTmznHour Creation Time (Hour) of Warehouse Order
WhseOrderCrtnWhseTmznTime WhseOrderCrtnWhseTmznTime Creation Time of Warehouse Order
WhseOrdLtstStrtWhseTmznDteTme WhseOrdLtstStrtWhseTmznDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
WhseOrdLtstStrtWhseTmznYear WhseOrdLtstStrtWhseTmznYear Latest Start Date (Year) of Whse Order
WhseOrdLtstStrtWhseTmznMonth WhseOrdLtstStrtWhseTmznMonth Latest Start Date (Month) of Whse Order
WhseOrdLtstStrtWhseTmznDate WhseOrdLtstStrtWhseTmznDate Latest Start Date of Whse Order
WhseOrdLtstStrtWhseTmznHour WhseOrdLtstStrtWhseTmznHour Latest Start Time (Hour) of Whse Order
WhseOrdLtstStrtWhseTmznTime WhseOrdLtstStrtWhseTmznTime Latest Start Time of Warehouse Order
WhseOrderConfWhseTmznDateTime WhseOrderConfWhseTmznDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
WhseOrderConfWhseTmznYear WhseOrderConfWhseTmznYear Confirmation Date (Year) of Whse Order
WhseOrderConfWhseTmznMonth WhseOrderConfWhseTmznMonth Confirmation Date (Month) of Whse Order
WhseOrderConfWhseTmznDate WhseOrderConfWhseTmznDate Confirmation Date of Warehouse Order
WhseOrderConfWhseTmznHour WhseOrderConfWhseTmznHour Confirmation Time (Hour) of Whse Order
WhseOrderConfWhseTmznTime WhseOrderConfWhseTmznTime Confirmation Time of Warehouse Order
WrhsOrdStrtUTCDateTime WrhsOrdStrtUTCDateTime WO Started On (UTC)
WhseOrderConfUTCDateTime WhseOrderConfUTCDateTime WO Confirmed On (UTC)
WarehouseOrderConfirmedBy WarehouseOrderConfirmedBy WO Confirmed By
ActivityArea ActivityArea Activity Area
ActivityAreaName Description of Activity Area
WrhsOrdCrtnUTCDateTime WrhsOrdCrtnUTCDateTime WO Created On (UTC)
CreatedByUser CreatedByUser WO Created By
NumberOfWarehouseOrders NumberOfWarehouseOrders Number of Warehouse Orders

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_EWM_WarehouseOrderLeanQ.
-- 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: CEWMWOLQ

CREATE VIEW C_EWM_WarehouseOrderLeanQ AS
SELECT
  Warehouse,
  WarehouseOrder,
  WarehouseOrderCreationRule,
  WarehouseOrderStatus,
  WarehouseOrderStatusName,
  WhseOrderOverdueHours,
  WhseOrderLastChgUTCDateTime,
  LastChangedByUser,
  WarehouseOrderHasWhseTask,
  WarehouseOrderHasPhysInvtryDoc,
  WhseOrderCrtnWhseTmznDateTime,
  WhseOrderCrtnWhseTmznYear,
  WhseOrderCrtnWhseTmznMonth,
  WhseOrderCrtnWhseTmznDate,
  WhseOrderCrtnWhseTmznHour,
  WhseOrderCrtnWhseTmznTime,
  WhseOrdLtstStrtWhseTmznDteTme,
  WhseOrdLtstStrtWhseTmznYear,
  WhseOrdLtstStrtWhseTmznMonth,
  WhseOrdLtstStrtWhseTmznDate,
  WhseOrdLtstStrtWhseTmznHour,
  WhseOrdLtstStrtWhseTmznTime,
  WhseOrderConfWhseTmznDateTime,
  WhseOrderConfWhseTmznYear,
  WhseOrderConfWhseTmznMonth,
  WhseOrderConfWhseTmznDate,
  WhseOrderConfWhseTmznHour,
  WhseOrderConfWhseTmznTime,
  WrhsOrdStrtUTCDateTime,
  WhseOrderConfUTCDateTime,
  WarehouseOrderConfirmedBy,
  ActivityArea,
  _ActivityArea._Text[1:Language = $parameters.P_Language].ActivityAreaName AS ActivityAreaName,
  WrhsOrdCrtnUTCDateTime,
  CreatedByUser,
  NumberOfWarehouseOrders
FROM I_EWM_WhseOrderCube
;

Learn More