A_WarehouseTask

DDL: A_WAREHOUSETASK Type: view_entity COMPOSITE
68 Fields 1 Data Sources 1 Associations

Warehouse Task

A_WarehouseTask is a Composite CDS View that provides data about "Warehouse Task" in SAP S/4HANA. It reads from 1 data source (P_EWM_WarehouseTask01) and exposes 68 fields with key fields Warehouse, WarehouseTask, WarehouseTaskItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_EWM_WarehouseTask01 P_EWM_WarehouseTask01 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_WhseTaskExceptionCode _WarehouseTaskExceptionCode

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Warehouse Task view

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY Warehouse Warehouse Warehouse No.
KEY WarehouseTask WarehouseTask Warehouse Task
KEY WarehouseTaskItem WarehouseTaskItem
WarehouseOrder WarehouseOrder
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
ConfirmationUTCDateTime ConfirmationUTCDateTime Confirmation Date Time
WhseTaskPlannedClosingDateTime WhseTaskPlannedClosingDateTime
WhseTaskGoodsReceiptDateTime WhseTaskGoodsReceiptDateTime
WarehouseTaskStatus WarehouseTaskStatus
WarehouseTaskStatusName WarehouseTaskStatusName
WarehouseProcessType WarehouseProcessType Whse Proc. Type
WarehouseProcessTypeName WarehouseProcessTypeName
IsHandlingUnitWarehouseTask IsHandlingUnitWarehouseTask
ProductName ProductName Description
ProductDescription ProductDescription Description
Batch Batch Lot No.
BatchChangeIsNotAllowed BatchChangeIsNotAllowed
StockType StockType Stock Type
StockTypeName StockTypeName
StockOwner StockOwner Owner of stock
EntitledToDisposeParty EntitledToDisposeParty Disposal Party
StockDocumentCategory StockDocumentCategory Special Reference Stock Type
StockDocumentNumber StockDocumentNumber
StockItemNumber StockItemNumber
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
SpecialStockIdfgSalesOrder SpecialStockIdfgSalesOrder Stock Ident Header
SpecialStockIdfgSalesOrderItem SpecialStockIdfgSalesOrderItem Stock Ident Item
ExecutingResource ExecutingResource
ProductionOrder ProductionOrder Order
ProductionSupplyArea ProductionSupplyArea Supply Area
Delivery Delivery Delivery Status
DeliveryItem DeliveryItem
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
BaseUnit BaseUnit Unit of Measure
EWMBaseUnitISOCode EWMBaseUnitISOCode
AlternativeUnit AlternativeUnit Base UoM
EWMAlternativeUnitISOCode EWMAlternativeUnitISOCode
TargetQuantityInBaseUnit TargetQuantityInBaseUnit
TargetQuantityInAltvUnit TargetQuantityInAltvUnit
ActualQuantityInBaseUnit ActualQuantityInBaseUnit
ActualQuantityInAltvUnit ActualQuantityInAltvUnit
DifferenceQuantityInBaseUnit DifferenceQuantityInBaseUnit
DifferenceQuantityInAltvUnit DifferenceQuantityInAltvUnit
WhseTaskNetWeightUnitOfMeasure WhseTaskNetWeightUnitOfMeasure
NetWeight NetWeight Net weight
WhseTaskNetVolumeUnitOfMeasure WhseTaskNetVolumeUnitOfMeasure
WhseTaskNetVolume WhseTaskNetVolume
SourceStorageType SourceStorageType
SourceStorageTypeName SourceStorageTypeName
SourceStorageSection SourceStorageSection
SourceStorageBin SourceStorageBin
DestinationStorageType DestinationStorageType
DestinationStorageTypeName DestinationStorageTypeName
DestinationStorageSection DestinationStorageSection
DestinationStorageBin DestinationStorageBin
DestinationResource DestinationResource
ActivityArea ActivityArea
ActivityAreaName ActivityAreaName
SourceHandlingUnit SourceHandlingUnit
DestinationHandlingUnit DestinationHandlingUnit
WarehouseTaskExceptionCode WarehouseTaskExceptionCode
_WarehouseOrder _WarehouseOrder
_WarehouseTaskExceptionCode _WarehouseTaskExceptionCode

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 A_WarehouseTask.
-- 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.

CREATE VIEW A_WarehouseTask AS
SELECT
  Warehouse,
  WarehouseTask,
  WarehouseTaskItem,
  WarehouseOrder,
  CreationDateTime,
  LastChangeDateTime,
  ConfirmationUTCDateTime,
  WhseTaskPlannedClosingDateTime,
  WhseTaskGoodsReceiptDateTime,
  WarehouseTaskStatus,
  WarehouseTaskStatusName,
  WarehouseProcessType,
  WarehouseProcessTypeName,
  IsHandlingUnitWarehouseTask,
  ProductName,
  ProductDescription,
  Batch,
  BatchChangeIsNotAllowed,
  StockType,
  StockTypeName,
  StockOwner,
  EntitledToDisposeParty,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  WBSElementInternalID,
  WBSElementExternalID,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  ExecutingResource,
  ProductionOrder,
  ProductionSupplyArea,
  Delivery,
  DeliveryItem,
  PurchasingDocument,
  PurchasingDocumentItem,
  SalesDocument,
  SalesDocumentItem,
  BaseUnit,
  EWMBaseUnitISOCode,
  AlternativeUnit,
  EWMAlternativeUnitISOCode,
  TargetQuantityInBaseUnit,
  TargetQuantityInAltvUnit,
  ActualQuantityInBaseUnit,
  ActualQuantityInAltvUnit,
  DifferenceQuantityInBaseUnit,
  DifferenceQuantityInAltvUnit,
  WhseTaskNetWeightUnitOfMeasure,
  NetWeight,
  WhseTaskNetVolumeUnitOfMeasure,
  WhseTaskNetVolume,
  SourceStorageType,
  SourceStorageTypeName,
  SourceStorageSection,
  SourceStorageBin,
  DestinationStorageType,
  DestinationStorageTypeName,
  DestinationStorageSection,
  DestinationStorageBin,
  DestinationResource,
  ActivityArea,
  ActivityAreaName,
  SourceHandlingUnit,
  DestinationHandlingUnit,
  WarehouseTaskExceptionCode
FROM P_EWM_WarehouseTask01
LEFT OUTER JOIN A_WhseTaskExceptionCode AS _WarehouseTaskExceptionCode ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More