What is C_EWM_WarehouseTaskLeanQ in SAP S/4HANA?

C_EWM_WarehouseTaskLeanQ is a consumption CDS view in SAP S/4HANA. Warehouse Task Lean - Query It contains 138 fields.

Which tables does C_EWM_WarehouseTaskLeanQ read from?

C_EWM_WarehouseTaskLeanQ reads data from: I_EWM_WhseTaskItemCube.

What VDM layer is C_EWM_WarehouseTaskLeanQ?

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

C_EWM_WarehouseTaskLeanQ

DDL: C_EWM_WAREHOUSETASKLEANQ SQL: CEWMWTLQ Type: view CONSUMPTION

138 Fields 1 Data Sources

Warehouse Task Lean - Query

C_EWM_WarehouseTaskLeanQ (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_WarehouseTaskLeanQ is a Consumption CDS View that provides data about "Warehouse Task Lean - Query" in SAP S/4HANA. It reads from 1 data source (I_EWM_WhseTaskItemCube) and exposes 138 fields with key fields Warehouse, WarehouseTask, WarehouseTaskItem.

SAP Help Documentation

Category	CDS Views for Cross Processes
Data Category	Query
Status	Released
Corresponding DataSource	2CCEWMWTLQ

Purpose
This CDS view provides the prerequisites for answering the following business questions: How many warehouse tasks are there in my warehouse? How many warehouse task items are there in my warehouse? What is the total volume of warehouse task items? What is the total net weight of warehouse task items? What is the actual product quantity in base or alternative unit of measure (UoM)? What is the difference product quantity in base or alternative UoM? What is the target product quantity in base or alternative UoM?

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 Task Creation Date and Time of Warehouse Task Confirmation Date and Time of Warehouse Task Planned Closing Date of Warehouse Task Measures and Attributes Some important measures and attributes are as follows: Number of Warehouse Tasks Number of Warehouse Task Items Target Quantity in Alternative UoM Target Quantity in Base UoM Actual Quantity in Alternative UoM Actual Quantity in Base UoM Difference Quantity in Base UoM Difference Quantity in Alternative UoM Total Net Volume of Warehouse Task Items Total Net Weight of Warehouse Task Items

Constraints
You can select confirmed warehouse tasks with only the following warehouse process categories: Putaway Stock Removal Internal Warehouse Movement Physical Inventory Cross-Line Stock Putaway

SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you’re 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

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 (16)

Name	Value	Level
AbapCatalog.sqlViewName	CEWMWTLQ	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
EndUserText.label	Warehouse Task Lean - Query	view
Consumption.semanticObject	EWMWarehouseTask	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 (138)

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
	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.
	ExecutingResource	ExecutingResource	Executing Resource (Means of Transport or User)
	WarehouseMovementsReason	WarehouseMovementsReason	Reason for Movements in the Warehouse
	ProductName	ProductName	Product Number
	ProductDescription	ProductDescription	Product Description
	Batch	Batch	Product Batch
	StockType	StockType	Stock Type
	StockDocumentCategory	StockDocumentCategory	Special Stock Document Category
	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
	StockIdentificationOfWhseTask	StockIdentificationOfWhseTask	Stock Identification of Warehouse Task
	ConsolidationGroup	ConsolidationGroup	Consolidation Group
	SourceStorageType	SourceStorageType	Source Storage Type
	SourceStorageTypeName		Description of Source Storage Type
	SourceStorageBin	SourceStorageBin	Source Storage Bin
	SourceHndlgUnitLogicalPosition	SourceHndlgUnitLogicalPosition	Source Logical Position of Handling Unit in Storage Bin
	SourceLocationType	SourceLocationType	Source Location Type
	SourceHandlingUnit	SourceHandlingUnit	Source Handling Unit
	DestinationStorageType	DestinationStorageType	Destination Storage Type
	DestinationStorageTypeName		Description of Destination Storage Type
	DestinationStorageBin	DestinationStorageBin	Destination Storage Bin
	DestHndlgUnitLogicalPosition	DestHndlgUnitLogicalPosition	Destination Logical Position of Handling Unit in Storage Bin
	DestinationLocationType	DestinationLocationType	Destination Location Type
	DestinationHandlingUnit	DestinationHandlingUnit	Destination Handling Unit
	WhseTaskDestStorageBinDtmndBy	WhseTaskDestStorageBinDtmndBy	Destination Storage Bin Determined By
	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
	InboundDeliveryItemType	InboundDeliveryItemType	Inbound Delivery Item Type
	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
	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
	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
	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)
	WarehouseTaskExceptionCode	WarehouseTaskExceptionCode	WT Exception Code
	ExceptionCodeName		Description of WT Exception Code
	BusinessContext	BusinessContext	Business Context
	BusinessContextName		Description of Business Context
	BusinessContextExecutionStep	BusinessContextExecutionStep	Execution Step of Business Context
	BusinessContextExecStepName		Desc. of Business Context Exec. Step
	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
	WrhsOrdStrtUTCDateTime	WrhsOrdStrtUTCDateTime	WO Started On (UTC)
	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
	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
	EWMWhseTaskConfDateIsToday	EWMWhseTaskConfDateIsToday	Confirmation Date of Warehouse Task Is Today
	EWMWhseTaskHasException	EWMWhseTaskHasException	Warehouse Task Has Exceptions

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_WarehouseTaskLeanQ.
-- 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: CEWMWTLQ

CREATE VIEW C_EWM_WarehouseTaskLeanQ 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,
  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,
  ExecutingResource,
  WarehouseMovementsReason,
  ProductName,
  ProductDescription,
  Batch,
  StockType,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  DocumentCategory,
  StockUsage,
  StockOwner,
  StockOwnerPartnerRole,
  EntitledToDisposeParty,
  EntitledToDisposePartnerRole,
  CounterForStockSeparation,
  WhseTaskRetentionQuantity,
  HandlingUnitType,
  WhseTaskCapacityConsumption,
  PutAwayPhysInventoryIsPlanned,
  WhseTaskLowStockCheckIsPlanned,
  ShelfLifeExpirationDate,
  CountryOfOrigin,
  StockIdentificationOfWhseTask,
  ConsolidationGroup,
  SourceStorageType,
  _SourceStorageType._Text[1:Language = $parameters.P_Language].StorageTypeName AS SourceStorageTypeName,
  SourceStorageBin,
  SourceHndlgUnitLogicalPosition,
  SourceLocationType,
  SourceHandlingUnit,
  DestinationStorageType,
  _DestStorageType._Text[1:Language = $parameters.P_Language].StorageTypeName AS DestinationStorageTypeName,
  DestinationStorageBin,
  DestHndlgUnitLogicalPosition,
  DestinationLocationType,
  DestinationHandlingUnit,
  WhseTaskDestStorageBinDtmndBy,
  WhseTaskRefToValueAddedService,
  BatchChangeIsNotAllowed,
  ReferenceDocumentCategory,
  EWMReferenceDeliveryDocType,
  ReferenceDocumentNumber,
  ReferenceDocumentItemNumber,
  InboundDeliveryItemType,
  WhseTaskTwoStepPickingType,
  WhseTaskTwoStepPickingRlvnce,
  KitItemIsCreatedAutomatically,
  IsDocumentaryBatch,
  ProductionSupplyArea,
  ProductionOrder,
  WhseTaskCrtnWhseTmznDateTime,
  WhseTaskCrtnWhseTmznYear,
  WhseTaskCrtnWhseTmznMonth,
  WhseTaskCrtnWhseTmznDate,
  WhseTaskCrtnWhseTmznHour,
  WhseTaskCrtnWhseTmznTime,
  WhseTaskConfWhseTmznDateTime,
  WhseTaskConfWhseTmznYear,
  WhseTaskConfWhseTmznMonth,
  WhseTaskConfWhseTmznDate,
  WhseTaskConfWhseTmznHour,
  WhseTaskConfWhseTmznTime,
  WhseTskPlndClsgWhseTmznDteTme,
  WhseTskPlndClsgWhseTmznYear,
  WhseTskPlndClsgWhseTmznMonth,
  WhseTskPlndClsgWhseTmznDate,
  WhseTskPlndClsgWhseTmznHour,
  WhseTskPlndClsgWhseTmznTime,
  Kanban,
  WhseTaskLastChgUTCDateTime,
  ConfirmedByUser,
  WhseTaskConfUTCDateTime,
  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,
  WarehouseOrderCreationRule,
  _WhseOrderCtnRule._Text[1:Language = $parameters.P_Language].WarehouseOrderCreationRuleName AS WarehouseOrderCreationRuleName,
  WhseTaskOverdueHours,
  WhseTaskOverdueHoursDesc,
  HigherLevelWarehouseOrder,
  WrhsOrdStrtUTCDateTime,
  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,
  WhseTaskNetWeightUnitOfMeasure,
  WhseTaskNetWeight,
  WhseTaskNetVolumeUnitOfMeasure,
  WhseTaskNetVolume,
  DisplayWeightUnit,
  DisplayVolumeUnit,
  EWMWhseTaskConfDateIsToday,
  EWMWhseTaskHasException
FROM I_EWM_WhseTaskItemCube
;

Depth:

C_EWM_WarehouseTaskLeanQ view

I_EWM_WhseTaskItemCube view