Deprecated
This CDS view is deprecated in S/4HANA. Use I_EWM_WarehouseOrderT_2 instead. View all deprecated CDS views →

I_EWM_WarehouseOrderT

DDL: I_EWM_WAREHOUSEORDERT SQL: IEWMWHSEORDERT Type: view COMPOSITE
37 Fields 1 Data Sources 1 Associations

Warehouse Order with Status Name

I_EWM_WarehouseOrderT is a Composite CDS View that provides data about "Warehouse Order with Status Name" in SAP S/4HANA. It reads from 1 data source (I_EWM_WarehouseOrder) and exposes 37 fields with key fields Warehouse, WarehouseOrder. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_EWM_WarehouseOrder I_EWM_WarehouseOrder from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EWM_WarehouseOrderStatusText _WhseOrderStatusTxt $projection.WarehouseOrderStatus = _WhseOrderStatusTxt.WarehouseOrderStatus and _WhseOrderStatusTxt.Language = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IEWMWHSEORDERT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Warehouse Order with Status Name view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_EWM_WarehouseOrderT_2 view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY Warehouse Warehouse Warehouse No.
KEY WarehouseOrder WarehouseOrder
WarehouseOrderCreationRule WarehouseOrderCreationRule WO Creatn Rule
WhseOrderCreationRuleCategory WhseOrderCreationRuleCategory Worklist Type
WhseProcessTypeDocumentHdr WhseProcessTypeDocumentHdr Hdr WhsePT
Wave Wave Wave
WarehouseOrderStatus WarehouseOrderStatus Workflow Status
WarehouseOrderStatusName _WhseOrderStatusTxt WarehouseOrderStatusName
ActivityArea ActivityArea WO Activty Area
StorageType StorageType Storage Type
StorageBin StorageBin Storage Bin
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
Queue Queue Queue
WarehouseOrderStartDateTime WarehouseOrderStartDateTime
WarehouseOrderStartTimeIsFixed WarehouseOrderStartTimeIsFixed Start Time Fix.
WhseOrderConfirmedDateTime WhseOrderConfirmedDateTime
WarehouseOrderConfirmedBy WarehouseOrderConfirmedBy Confirmed By
Processor Processor User Name
ExecutingResource ExecutingResource Resource
ProcessorIsManualAssigned ProcessorIsManualAssigned Manually
WarehouseOrderHasPhysInvtryDoc WarehouseOrderHasPhysInvtryDoc Phys. Inv. Doc.
WhseOrderForSplitWhseOrder WhseOrderForSplitWhseOrder
WarehouseOrderIsSplit WarehouseOrderIsSplit Split
ResourceStartBin ResourceStartBin Starting Point
WhseOrderLatestStartDateTime WhseOrderLatestStartDateTime
WarehouseOrderPlannedDuration WarehouseOrderPlannedDuration Plnd Exec. Time
WhseOrderPlanDurationTimeUnit WhseOrderPlanDurationTimeUnit Time Unit
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
WhseOrderHigherLevelWhseOrder WhseOrderHigherLevelWhseOrder
WhseOrderSubsequentWhseOrder WhseOrderSubsequentWhseOrder
WhseOrderHasSubsqntWhseOrder WhseOrderHasSubsqntWhseOrder Warehouse Order
WarehouseOrderHasWhseTask WarehouseOrderHasWhseTask Contains WT
WarehouseOrderLogicalNumber WarehouseOrderLogicalNumber WO Log Number
HzdsSubstanceIsRlvtForStorage HzdsSubstanceIsRlvtForStorage Hazardous Subs.
WarehouseOrderUUID WarehouseOrderUUID Warehouse Order

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 I_EWM_WarehouseOrderT.
-- 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: IEWMWHSEORDERT

CREATE VIEW I_EWM_WarehouseOrderT AS
SELECT
  Warehouse,
  WarehouseOrder,
  WarehouseOrderCreationRule,
  WhseOrderCreationRuleCategory,
  WhseProcessTypeDocumentHdr,
  Wave,
  WarehouseOrderStatus,
  _WhseOrderStatusTxt.WarehouseOrderStatusName AS WarehouseOrderStatusName,
  ActivityArea,
  StorageType,
  StorageBin,
  CreationDateTime,
  CreatedByUser,
  Queue,
  WarehouseOrderStartDateTime,
  WarehouseOrderStartTimeIsFixed,
  WhseOrderConfirmedDateTime,
  WarehouseOrderConfirmedBy,
  Processor,
  ExecutingResource,
  ProcessorIsManualAssigned,
  WarehouseOrderHasPhysInvtryDoc,
  WhseOrderForSplitWhseOrder,
  WarehouseOrderIsSplit,
  ResourceStartBin,
  WhseOrderLatestStartDateTime,
  WarehouseOrderPlannedDuration,
  WhseOrderPlanDurationTimeUnit,
  LastChangeDateTime,
  LastChangedByUser,
  WhseOrderHigherLevelWhseOrder,
  WhseOrderSubsequentWhseOrder,
  WhseOrderHasSubsqntWhseOrder,
  WarehouseOrderHasWhseTask,
  WarehouseOrderLogicalNumber,
  HzdsSubstanceIsRlvtForStorage,
  WarehouseOrderUUID
FROM I_EWM_WarehouseOrder
LEFT OUTER JOIN I_EWM_WarehouseOrderStatusText AS _WhseOrderStatusTxt ON WarehouseOrderStatus = _WhseOrderStatusTxt.WarehouseOrderStatus AND _WhseOrderStatusTxt.Language = $session.system_language  -- association [0..1]
;

Learn More