What is C_EWM_WarehouseTaskQ in SAP S/4HANA?

C_EWM_WarehouseTaskQ is a consumption CDS view in SAP S/4HANA. Warehouse Task - Query It contains 187 fields.

Which tables does C_EWM_WarehouseTaskQ read from?

C_EWM_WarehouseTaskQ reads data from: I_EWM_WhseTaskItemCube.

What VDM layer is C_EWM_WarehouseTaskQ?

C_EWM_WarehouseTaskQ is classified as a Consumption view optimized for specific business scenarios and reporting.

C_EWM_WarehouseTaskQ

DDL: C_EWM_WAREHOUSETASKQ SQL: CEWMWTQ Type: view CONSUMPTION

187 Fields 1 Data Sources 1 Fiori Apps

Warehouse Task - Query

C_EWM_WarehouseTaskQ (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_WarehouseTaskQ is a Consumption CDS View that provides data about "Warehouse Task - Query" in SAP S/4HANA. It reads from 1 data source (I_EWM_WhseTaskItemCube) and exposes 187 fields with key fields Warehouse, WarehouseTask, WarehouseTaskItem. It is used in 1 Fiori application: Warehouse KPIs - Operations.

SAP API Hub

State	Deprecated
Line of Business	Supply Chain
Application Component	SCM-EWM-WOP
Capabilities	Analytical Query
Package	Supply Chain for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>How many warehouse tasks are there in my warehouse?</p></li> <li><p>How many warehouse task items are there in my warehouse?</p></li> <li><p>What is the total volume of warehouse task items?</p></li> <li><p>What is the total net weight of warehouse task items?</p></li> <li><p>What is the actual product quantity in base or alternative unit of measure (UoM)?</p></li> <li><p>What is the difference product quantity in base or alternative UoM?</p></li> <li><p>What is the target product quantity in base or alternative UoM?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_EWM_WhseTaskItemCube	I_EWM_WhseTaskItemCube	from

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	CEWMWTQ	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
EndUserText.label	Warehouse Task - Query	view
ClientHandling.type	#INHERITED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	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
VDM.viewType	#CONSUMPTION	view
OData.publish	true	view
Analytics.query	true	view

Fiori Apps (1)

App ID	App Name	Type	Description
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 (187)

Key	Field	Source Field	Description
KEY	Warehouse	Warehouse	Warehouse Number/Warehouse Complex
KEY	WarehouseTask	WarehouseTask	Warehouse Task
KEY	WarehouseTaskItem	WarehouseTaskItem	Warehouse Task Item
	WarehouseName		Warehouse Description
	IsHandlingUnitWarehouseTask	IsHandlingUnitWarehouseTask	Handling Unit Warehouse Task
	WarehouseProcessType	WarehouseProcessType	Warehouse Process Type
	WarehouseProcessTypeName		Description of Warehouse Process Type
	WarehouseProcessCategory	WarehouseProcessCategory	Warehouse Process Category
	WarehouseProcessCategoryName		Desc. of Warehouse Process Category
	StorageProcess	StorageProcess	Storage Process
	StorageProcessName		Description of Storage Process
	ExternalStorageProcessStep	ExternalStorageProcessStep	External Storage Process Step
	ExternalStorageProcessStepName		Desc. of External Storage Process Step
	WarehouseTaskStatus	WarehouseTaskStatus	Warehouse Task Status
	WarehouseTaskStatusName	WarehouseTaskStatusName	Description of Warehouse Task Status
	WarehouseOrder	WarehouseOrder	Warehouse Order Number
	WarehouseOrderStatus	WarehouseOrderStatus	Warehouse Order Status
	WarehouseOrderStatusName	WarehouseOrderStatusName	Description of Warehouse Order Status
	ActivityArea	ActivityArea	Activity Area
	ActivityAreaName		Description of Activity Area
	Activity	Activity	Activity
	ActivityName		Activity Description
	CreatedByUser	CreatedByUser	WT Created By
	WhseTaskCrtnUTCDateTime	WhseTaskCrtnUTCDateTime	WT Created On (UTC)
	WarehouseTaskCodes	WarehouseTaskCodes	Calling Application/Special Function for WT Creation/Conf.
	WarehouseTaskCodesName	WarehouseTaskCodesName	Description of Warehouse Task Code
	ExecutingResource	ExecutingResource	Executing Resource (Means of Transport or User)
	WarehouseMovementsReason	WarehouseMovementsReason	Reason for Movements in the Warehouse
	PriorityCode	PriorityCode	Priority
	ProductName	ProductName	Product Number
	ProductDescription	ProductDescription	Product Description
	Batch	Batch	Product Batch
	StockType	StockType	Stock Type
	StockDocumentCategory	StockDocumentCategory	Document Category of Special Stock
	StockDocumentNumber	StockDocumentNumber	Sales Order or Project for Special Stock
	StockItemNumber	StockItemNumber	Sales Order Item for Special Stock
	DocumentCategory	DocumentCategory	Doc. Category for Doc. Reference and Doc.-Related Stock
	StockUsage	StockUsage	Stock Usage
	StockOwner	StockOwner	Stock Owner
	StockOwnerPartnerRole	StockOwnerPartnerRole	Partner Role of Stock Owner
	EntitledToDisposeParty	EntitledToDisposeParty	Party Entitled to Dispose
	EntitledToDisposePartnerRole	EntitledToDisposePartnerRole	Partner Role of Party Entitled to Dispose
	CounterForStockSeparation	CounterForStockSeparation	Counter for Stock Separation
	WhseTaskRetentionQuantity	WhseTaskRetentionQuantity	WT Retention Quantity
	HandlingUnitType	HandlingUnitType	Handling Unit Type
	WhseTaskCapacityConsumption	WhseTaskCapacityConsumption	Capacity Consumption
	PutAwayPhysInventoryIsPlanned	PutAwayPhysInventoryIsPlanned	Truth Value: True/False
	WhseTaskLowStockCheckIsPlanned	WhseTaskLowStockCheckIsPlanned	Low Stock Check Planned
	ShelfLifeExpirationDate	ShelfLifeExpirationDate	Shelf Life Expiration Date
	CountryOfOrigin	CountryOfOrigin	Country or Region of Origin
	HazardousSubstanceIndicator	HazardousSubstanceIndicator	Hazardous Substance
	StockIdentificationOfWhseTask	StockIdentificationOfWhseTask	Stock Identification of Warehouse Task
	ConsolidationGroup	ConsolidationGroup	Consolidation Group
	SourceStorageType	SourceStorageType	Source Storage Type
	SourceStorageTypeName		Description of Source Storage Type
	SourceStorageSection	SourceStorageSection	Source Storage Section
	SourceStorageSectionName		Description of Source Storage Section
	SourceStorageBin	SourceStorageBin	Source Storage Bin
	SourceHndlgUnitLogicalPosition	SourceHndlgUnitLogicalPosition	Source Logical Position of Handling Unit in Storage Bin
	SourceResource	SourceResource	Source Resource (Means of Transport or User)
	SourceTransportationUnit	SourceTransportationUnit	Source Transportation Unit (Internal)
	SourceLocationType	SourceLocationType	Source Location Type
	SourceHandlingUnit	SourceHandlingUnit	Source Handling Unit
	DestinationStorageType	DestinationStorageType	Destination Storage Type
	DestinationStorageTypeName		Description of Destination Storage Type
	DestinationStorageSection	DestinationStorageSection	Destination Storage Section
	StorageSectionName		Desc. of Destination Storage Section
	DestinationStorageBin	DestinationStorageBin	Destination Storage Bin
	DestHndlgUnitLogicalPosition	DestHndlgUnitLogicalPosition	Destination Logical Position of Handling Unit in Storage Bin
	DestinationResource	DestinationResource	Destination Resource (Means of Transport or User)
	DestinationTransportationUnit	DestinationTransportationUnit	Destination Transportation Unit (Internal)
	DestinationLocationType	DestinationLocationType	Destination Location Type
	DestinationHandlingUnit	DestinationHandlingUnit	Destination Handling Unit
	WhseTaskDestStorageBinDtmndBy	WhseTaskDestStorageBinDtmndBy	Destination Storage Bin Determined By
	WrhsTaskSubsystemTransmn	WrhsTaskSubsystemTransmn	Indicator: Pass on Warehouse Task to Subsystem
	WrhsTaskSubsystemTransmnName	WrhsTaskSubsystemTransmnName	Description of WT to Subsystem Code
	WhseTaskPlannedProcessingTime	WhseTaskPlannedProcessingTime	Planned Proc. Time in Warehouse Task
	WhseTaskProcgTimeDetnTimeUnit	WhseTaskProcgTimeDetnTimeUnit	Time Unit for Planned Process
	WhseTaskRefToValueAddedService	WhseTaskRefToValueAddedService	WT with Reference to a VAS
	BatchChangeIsNotAllowed	BatchChangeIsNotAllowed	Changing the Batch is not Allowed
	ReferenceDocumentCategory	ReferenceDocumentCategory	Doc. Category for Doc. Reference and Doc.-Related Stock
	EWMReferenceDeliveryDocType	EWMReferenceDeliveryDocType	Reference Delivery Document Type
	ReferenceDocumentNumber	ReferenceDocumentNumber	Reference Document Number
	ReferenceDocumentItemNumber	ReferenceDocumentItemNumber	Reference Document Item Number
	Wave	Wave	Numeric Character Field, Length 10
	WaveItem	WaveItem	Wave Item
	PlndLoadCompletionUTCDateTime	PlndLoadCompletionUTCDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	PlndPackCompletionUTCDateTime	PlndPackCompletionUTCDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	PlndPickCompltnUTCDateTime	PlndPickCompltnUTCDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	PlndStagingCompltnUTCDateTime	PlndStagingCompltnUTCDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	WaveActlReleasedUTCDateTime	WaveActlReleasedUTCDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	WaveCutoffWhseTmznDateTime	WaveCutoffWhseTmznDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	WavePlndRelWhseTmznDateTime	WavePlndRelWhseTmznDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	PlndPickCmpltWhseTmznDateTime	PlndPickCmpltWhseTmznDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	PlndPackCmpltWhseTmznDateTime	PlndPackCmpltWhseTmznDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	PlndStggCmpltWhseTmznDateTime	PlndStggCmpltWhseTmznDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	WaveCompletionWhseTmznDateTime	WaveCompletionWhseTmznDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	WaveActualReldWhseTmznDateTime	WaveActualReldWhseTmznDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	WaveActualReldWhseTmznYear	WaveActualReldWhseTmznYear	Actual Release Date (Year) of Wave
	WaveActualReldWhseTmznMonth	WaveActualReldWhseTmznMonth	Actual Release Date (Month) of Wave
	WaveActualReldWhseTmznDate	WaveActualReldWhseTmznDate	Actual Release Date of Wave
	WaveActualReldWhseTmznHour	WaveActualReldWhseTmznHour	Actual Release Time (Hour) of Wave
	WaveActualReldWhseTmznTime	WaveActualReldWhseTmznTime	Actual Release Time of Wave
	WaveTemplate	WaveTemplate	Numeric Character Field, Length 10
	WaveTemplateName	WaveTemplateName	Description of Wave Template
	WhseTaskTwoStepPickingType	WhseTaskTwoStepPickingType	Warehouse Task Type Within Two-Step Picking
	WhseTaskTwoStepPickingRlvnce	WhseTaskTwoStepPickingRlvnce	Relevance for Two-Step Picking
	KitItemIsCreatedAutomatically	KitItemIsCreatedAutomatically	Create Kit Item in HU Automatically During Picking
	IsDocumentaryBatch	IsDocumentaryBatch	Truth Value: True/False
	ProductionSupplyArea	ProductionSupplyArea	Production Supply Area
	ProductionOrder	ProductionOrder	Manufacturing Order
	WhseTaskCrtnWhseTmznDateTime	WhseTaskCrtnWhseTmznDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	WhseTaskCrtnWhseTmznYear	WhseTaskCrtnWhseTmznYear	Creation Date (Year) of Warehouse Task
	WhseTaskCrtnWhseTmznMonth	WhseTaskCrtnWhseTmznMonth	Creation Date (Month) of Warehouse Task
	WhseTaskCrtnWhseTmznDate	WhseTaskCrtnWhseTmznDate	Creation Date of Warehouse Task
	WhseTaskCrtnWhseTmznHour	WhseTaskCrtnWhseTmznHour	Creation Time (Hour) of Warehouse Task
	WhseTaskCrtnWhseTmznTime	WhseTaskCrtnWhseTmznTime	Creation Time of Warehouse Task
	WhseTaskCrtnRnddTo10MinsTime	WhseTaskCrtnRnddTo10MinsTime	Crtn Time of WT Down to Nearest 10 Mins
	WhseTaskConfWhseTmznDateTime	WhseTaskConfWhseTmznDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	WhseTaskConfWhseTmznYear	WhseTaskConfWhseTmznYear	Confirmation Date (Year) of Whse Task
	WhseTaskConfWhseTmznMonth	WhseTaskConfWhseTmznMonth	Confirmation Date (Month) of Whse Task
	WhseTaskConfWhseTmznDate	WhseTaskConfWhseTmznDate	Confirmation Date of Warehouse Task
	WhseTaskConfWhseTmznHour	WhseTaskConfWhseTmznHour	Confirmation Time (Hour) of Whse Task
	WhseTaskConfWhseTmznTime	WhseTaskConfWhseTmznTime	Confirmation Time of Warehouse Task
	WhseTaskConfRnddTo10MinsTime	WhseTaskConfRnddTo10MinsTime	Conf. Time of WT Down to Nearest 10 Mins
	WhseTskPlndClsgWhseTmznDteTme	WhseTskPlndClsgWhseTmznDteTme	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	WhseTskPlndClsgWhseTmznYear	WhseTskPlndClsgWhseTmznYear	Planned Closing Date (Year) of Whse Task
	WhseTskPlndClsgWhseTmznMonth	WhseTskPlndClsgWhseTmznMonth	Planned Closing Date (Month) of WT
	WhseTskPlndClsgWhseTmznDate	WhseTskPlndClsgWhseTmznDate	Planned Closing Date of Whse Task
	WhseTskPlndClsgWhseTmznHour	WhseTskPlndClsgWhseTmznHour	Planned Closing Time (Hour) of Whse Task
	WhseTskPlndClsgWhseTmznTime	WhseTskPlndClsgWhseTmznTime	Planned Closing Time of Whse Task
	WhseTskPlndClsgRnddTo10MinsTme	WhseTskPlndClsgRnddTo10MinsTme	WT Plnd Cl. Tme Down to Nearest 10 Mins
	Kanban	Kanban	Unique Kanban ID
	WhseTaskLastChgUTCDateTime	WhseTaskLastChgUTCDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	ConfirmedByUser	ConfirmedByUser	WT Confirmed By
	WhseTaskConfUTCDateTime	WhseTaskConfUTCDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	Processor	Processor	Processor
	WarehouseTaskExceptionCode	WarehouseTaskExceptionCode	WT Exception Code
	ExceptionCodeName		Description of WT Exception Code
	BusinessContext	BusinessContext	Business Context
	BusinessContextName		Description of Business Context
	BusinessContextExecutionStep	BusinessContextExecutionStep	Business Context Execution Step
	BusinessContextExecStepName		Desc. of Business Context Exec. Step
	ExecutingResourceGroup	ExecutingResourceGroup	Executing Resource Group
	ExecutingResourceGroupName		Description of Executing Resource Group
	ExecutingResourceType	ExecutingResourceType	Executing Resource Type
	ExecutingResourceTypeName		Description of Executing Resource Type
	WarehouseOrderCreationRule	WarehouseOrderCreationRule	Warehouse Order Creation Rule
	WarehouseOrderCreationRuleName		Description of WO Creation Rule
	WhseTaskOverdueHours	WhseTaskOverdueHours	Overdue Time (Hour)
	WhseTaskOverdueHoursDesc	WhseTaskOverdueHoursDesc	Overdue Time Desc.(Hour)
	HigherLevelWarehouseOrder	HigherLevelWarehouseOrder	Warehouse Order Number of Higher-Level Warehouse Order
	WarehouseOrderIsSplit	WarehouseOrderIsSplit	Warehouse Order Splitting
	WrhsOrdStrtUTCDateTime	WrhsOrdStrtUTCDateTime	Warehouse Order Started On (UTC)
	PickCompltnUTCDateTime	PickCompltnUTCDateTime	Planned WT Closing Time (UTC)
	WarehouseOrderQueue	WarehouseOrderQueue	Warehouse Order Queue
	WarehouseOrderQueueName		Description of Warehouse Order Queue
	SourceStorageBinType	SourceStorageBinType	Source Storage Bin Type
	SourceStorageBinTypeName		Description of Source Storage Bin Type
	SourceStorageBinAisle	SourceStorageBinAisle	Aisle of Source Storage Bin
	SourceStorageBinStack	SourceStorageBinStack	Stack of Source Storage Bin
	SourceStorageBinLevel	SourceStorageBinLevel	Level of Source Storage Bin
	SourceStorageBinAccessType	SourceStorageBinAccessType	Access Type of Source Storage Bin
	DestinationStorageBinType	DestinationStorageBinType	Type of Destination Storage Bin
	DestinationStorageBinTypeName		Desc. of Destination Storage Bin Type
	DestinationStorageBinAisle	DestinationStorageBinAisle	Aisle of Destination Storage Bin
	DestinationStorageBinStack	DestinationStorageBinStack	Stack of Destination Storage Bin
	DestinationStorageBinLevel	DestinationStorageBinLevel	Level of Destination Storage Bin
	DestinationStorageBinAccType	DestinationStorageBinAccType	Access Type of Destination Storage Bin
	BaseUnit	BaseUnit	Base Unit of Measure
	TargetQuantityInBaseUnit	TargetQuantityInBaseUnit	Target Quantity in Base Unit of Measure
	ActualQuantityInBaseUnit	ActualQuantityInBaseUnit	Actual Quantity in Base UoM
	DifferenceQuantityInBaseUnit	DifferenceQuantityInBaseUnit	Difference Quantity in Base UoM
	AlternativeUnit	AlternativeUnit	Alternative Unit of Measure for Stockkeeping Unit
	TargetQuantityInAltvUnit	TargetQuantityInAltvUnit	Target Quantity in Alternative Unit of Measure
	ActualQuantityInAltvUnit	ActualQuantityInAltvUnit	Actual Quantity in Alternative UoM
	DifferenceQuantityInAltvUnit	DifferenceQuantityInAltvUnit	Difference Quantity in Alternative UoM
	NumberOfWarehouseTasks	NumberOfWarehouseTasks	Number of Warehouse Tasks
	NumberOfWarehouseTaskItems	NumberOfWarehouseTaskItems	Number of Warehouse Task Items
	NumberOfWaves	1	Number of Waves
	NumberOfWaveItems	1	Number of Wave Items
	WhseTaskNetWeightUnitOfMeasure	WhseTaskNetWeightUnitOfMeasure	Net Weight UoM
	WhseTaskNetWeight	WhseTaskNetWeight	Loading or Net Weight
	WhseTaskNetVolumeUnitOfMeasure	WhseTaskNetVolumeUnitOfMeasure	Net Volume UoM
	WhseTaskNetVolume	WhseTaskNetVolume	Loading or Net Volume
	DisplayWeightUnit	DisplayWeightUnit	Weight Unit
	DisplayVolumeUnit	DisplayVolumeUnit	Volume Unit

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_WarehouseTaskQ.
-- 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: CEWMWTQ

CREATE VIEW C_EWM_WarehouseTaskQ AS
SELECT
  Warehouse,
  WarehouseTask,
  WarehouseTaskItem,
  _Warehouse._Text[1:Language = $parameters.P_Language].WarehouseName AS WarehouseName,
  IsHandlingUnitWarehouseTask,
  WarehouseProcessType,
  _WarehouseProcessType._Text[1:Language = $parameters.P_Language].WarehouseProcessTypeName AS WarehouseProcessTypeName,
  WarehouseProcessCategory,
  _WarehouseProcessCategory._Text[1:Language = $parameters.P_Language].WarehouseProcessCategoryName AS WarehouseProcessCategoryName,
  StorageProcess,
  _StorageProcess._Text[1:Language = $parameters.P_Language].StorageProcessName AS StorageProcessName,
  ExternalStorageProcessStep,
  _ExtStorageProcessStep._Text[1:Language = $parameters.P_Language].ExternalStorageProcessStepName AS ExternalStorageProcessStepName,
  WarehouseTaskStatus,
  WarehouseTaskStatusName,
  WarehouseOrder,
  WarehouseOrderStatus,
  WarehouseOrderStatusName,
  ActivityArea,
  _ActivityArea._Text[1:Language = $parameters.P_Language].ActivityAreaName AS ActivityAreaName,
  Activity,
  _WarehouseActivity._Text[1:Language = $parameters.P_Language].ActivityName AS ActivityName,
  CreatedByUser,
  WhseTaskCrtnUTCDateTime,
  WarehouseTaskCodes,
  WarehouseTaskCodesName,
  ExecutingResource,
  WarehouseMovementsReason,
  PriorityCode,
  ProductName,
  ProductDescription,
  Batch,
  StockType,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  DocumentCategory,
  StockUsage,
  StockOwner,
  StockOwnerPartnerRole,
  EntitledToDisposeParty,
  EntitledToDisposePartnerRole,
  CounterForStockSeparation,
  WhseTaskRetentionQuantity,
  HandlingUnitType,
  WhseTaskCapacityConsumption,
  PutAwayPhysInventoryIsPlanned,
  WhseTaskLowStockCheckIsPlanned,
  ShelfLifeExpirationDate,
  CountryOfOrigin,
  HazardousSubstanceIndicator,
  StockIdentificationOfWhseTask,
  ConsolidationGroup,
  SourceStorageType,
  _SourceStorageType._Text[1:Language = $parameters.P_Language].StorageTypeName AS SourceStorageTypeName,
  SourceStorageSection,
  _SrceStorageSection._Text[1:Language = $parameters.P_Language].StorageSectionName AS SourceStorageSectionName,
  SourceStorageBin,
  SourceHndlgUnitLogicalPosition,
  SourceResource,
  SourceTransportationUnit,
  SourceLocationType,
  SourceHandlingUnit,
  DestinationStorageType,
  _DestStorageType._Text[1:Language = $parameters.P_Language].StorageTypeName AS DestinationStorageTypeName,
  DestinationStorageSection,
  _DestStorageSection._Text[1:Language = $parameters.P_Language].StorageSectionName AS StorageSectionName,
  DestinationStorageBin,
  DestHndlgUnitLogicalPosition,
  DestinationResource,
  DestinationTransportationUnit,
  DestinationLocationType,
  DestinationHandlingUnit,
  WhseTaskDestStorageBinDtmndBy,
  WrhsTaskSubsystemTransmn,
  WrhsTaskSubsystemTransmnName,
  WhseTaskPlannedProcessingTime,
  WhseTaskProcgTimeDetnTimeUnit,
  WhseTaskRefToValueAddedService,
  BatchChangeIsNotAllowed,
  ReferenceDocumentCategory,
  EWMReferenceDeliveryDocType,
  ReferenceDocumentNumber,
  ReferenceDocumentItemNumber,
  Wave,
  WaveItem,
  PlndLoadCompletionUTCDateTime,
  PlndPackCompletionUTCDateTime,
  PlndPickCompltnUTCDateTime,
  PlndStagingCompltnUTCDateTime,
  WaveActlReleasedUTCDateTime,
  WaveCutoffWhseTmznDateTime,
  WavePlndRelWhseTmznDateTime,
  PlndPickCmpltWhseTmznDateTime,
  PlndPackCmpltWhseTmznDateTime,
  PlndStggCmpltWhseTmznDateTime,
  WaveCompletionWhseTmznDateTime,
  WaveActualReldWhseTmznDateTime,
  WaveActualReldWhseTmznYear,
  WaveActualReldWhseTmznMonth,
  WaveActualReldWhseTmznDate,
  WaveActualReldWhseTmznHour,
  WaveActualReldWhseTmznTime,
  WaveTemplate,
  WaveTemplateName,
  WhseTaskTwoStepPickingType,
  WhseTaskTwoStepPickingRlvnce,
  KitItemIsCreatedAutomatically,
  IsDocumentaryBatch,
  ProductionSupplyArea,
  ProductionOrder,
  WhseTaskCrtnWhseTmznDateTime,
  WhseTaskCrtnWhseTmznYear,
  WhseTaskCrtnWhseTmznMonth,
  WhseTaskCrtnWhseTmznDate,
  WhseTaskCrtnWhseTmznHour,
  WhseTaskCrtnWhseTmznTime,
  WhseTaskCrtnRnddTo10MinsTime,
  WhseTaskConfWhseTmznDateTime,
  WhseTaskConfWhseTmznYear,
  WhseTaskConfWhseTmznMonth,
  WhseTaskConfWhseTmznDate,
  WhseTaskConfWhseTmznHour,
  WhseTaskConfWhseTmznTime,
  WhseTaskConfRnddTo10MinsTime,
  WhseTskPlndClsgWhseTmznDteTme,
  WhseTskPlndClsgWhseTmznYear,
  WhseTskPlndClsgWhseTmznMonth,
  WhseTskPlndClsgWhseTmznDate,
  WhseTskPlndClsgWhseTmznHour,
  WhseTskPlndClsgWhseTmznTime,
  WhseTskPlndClsgRnddTo10MinsTme,
  Kanban,
  WhseTaskLastChgUTCDateTime,
  ConfirmedByUser,
  WhseTaskConfUTCDateTime,
  Processor,
  WarehouseTaskExceptionCode,
  _ExceptionCode._Text[1:Language = $parameters.P_Language].ExceptionCodeName AS ExceptionCodeName,
  BusinessContext,
  _BusinessContext._Text[1:Language = $parameters.P_Language].BusinessContextName AS BusinessContextName,
  BusinessContextExecutionStep,
  _BusinessContextExecStep._Text[1:Language = $parameters.P_Language].BusinessContextExecStepName AS BusinessContextExecStepName,
  ExecutingResourceGroup,
  _ResourceGroup._Text[1:Language = $parameters.P_Language].ResourceGroupName AS ExecutingResourceGroupName,
  ExecutingResourceType,
  _ResourceType._Text[1:Language = $parameters.P_Language].ResourceTypeName AS ExecutingResourceTypeName,
  WarehouseOrderCreationRule,
  _WhseOrderCtnRule._Text[1:Language = $parameters.P_Language].WarehouseOrderCreationRuleName AS WarehouseOrderCreationRuleName,
  WhseTaskOverdueHours,
  WhseTaskOverdueHoursDesc,
  HigherLevelWarehouseOrder,
  WarehouseOrderIsSplit,
  WrhsOrdStrtUTCDateTime,
  PickCompltnUTCDateTime,
  WarehouseOrderQueue,
  _WarehouseOrderQueue._Text[1:Language = $parameters.P_Language].WarehouseOrderQueueName AS WarehouseOrderQueueName,
  SourceStorageBinType,
  _SrceStorageBinType._Text[1:Language = $parameters.P_Language].StorageBinTypeName AS SourceStorageBinTypeName,
  SourceStorageBinAisle,
  SourceStorageBinStack,
  SourceStorageBinLevel,
  SourceStorageBinAccessType,
  DestinationStorageBinType,
  _DestStorageBinType._Text[1:Language = $parameters.P_Language].StorageBinTypeName AS DestinationStorageBinTypeName,
  DestinationStorageBinAisle,
  DestinationStorageBinStack,
  DestinationStorageBinLevel,
  DestinationStorageBinAccType,
  BaseUnit,
  TargetQuantityInBaseUnit,
  ActualQuantityInBaseUnit,
  DifferenceQuantityInBaseUnit,
  AlternativeUnit,
  TargetQuantityInAltvUnit,
  ActualQuantityInAltvUnit,
  DifferenceQuantityInAltvUnit,
  NumberOfWarehouseTasks,
  NumberOfWarehouseTaskItems,
  1 AS NumberOfWaves,
  1 AS NumberOfWaveItems,
  WhseTaskNetWeightUnitOfMeasure,
  WhseTaskNetWeight,
  WhseTaskNetVolumeUnitOfMeasure,
  WhseTaskNetVolume,
  DisplayWeightUnit,
  DisplayVolumeUnit
FROM I_EWM_WhseTaskItemCube
;

Depth:

C_EWM_WarehouseTaskQ view

I_EWM_WhseTaskItemCube view