C_EWM_WrkldFcstOvPgQ

DDL: C_EWM_WRKLDFCSTOVPGQ SQL: CWRKLDFCSTOVPGQ Type: view CONSUMPTION
9 Fields 1 Data Sources 1 Fiori Apps

Workload Forecast Overview Page - Query

C_EWM_WrkldFcstOvPgQ is a Consumption CDS View that provides data about "Workload Forecast Overview Page - Query" in SAP S/4HANA. It reads from 1 data source (C_EWM_LDPWrkldMergedFcstCube) and exposes 9 fields with key fields EWMWarehouse, EWMWorkloadCombineDate. It is used in 1 Fiori application: Warehouse KPIs - Operations.

Data Sources (1)

SourceAliasJoin Type
C_EWM_LDPWrkldMergedFcstCube C_EWM_LDPWrkldMergedFcstCube from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CWRKLDFCSTOVPGQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Workload Forecast Overview Page - Query view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
VDM.viewType #CONSUMPTION view
OData.publish true view
Analytics.query true view

Fiori Apps (1)

App IDApp NameTypeDescription
F4024 Warehouse KPIs - Operations Analytical

Warehouse KPIs - Operations

Business Role: Warehouse Clerk (Extended Warehouse Management)

With this feature, you can navigate from the outbound delivery order in the drill-down page of the Warehouse KPIs - Operations app directly to the Run Outbound Process - Deliveries app.

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY EWMWarehouse EWMWarehouse Warehouse No.
KEY EWMWorkloadCombineDate EWMWorkloadCombineDate
ActivityArea ActivityArea
InternalStorageProcessStep InternalStorageProcessStep
ExternalStorageProcessStep ExternalStorageProcessStep
DisplayTimeUnit DisplayTimeUnit
DisplayVolumeUnit DisplayVolumeUnit
DisplayWeightUnit DisplayWeightUnit
EWMWrkldTotFcstCapCnsmpnVal EWMWrkldTotFcstCapCnsmpnVal

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_WrkldFcstOvPgQ.
-- 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: CWRKLDFCSTOVPGQ

CREATE VIEW C_EWM_WrkldFcstOvPgQ AS
SELECT
  EWMWarehouse,
  EWMWorkloadCombineDate,
  ActivityArea,
  InternalStorageProcessStep,
  ExternalStorageProcessStep,
  DisplayTimeUnit,
  DisplayVolumeUnit,
  DisplayWeightUnit,
  EWMWrkldTotFcstCapCnsmpnVal
FROM C_EWM_LDPWrkldMergedFcstCube
;

Learn More