I_EWM_WAREHOUSEORDER

CDS View
36 Fields 5 CDS Views

EWM Warehouse Order

I_EWM_WAREHOUSEORDER is a CDS View in S/4HANA. EWM Warehouse Order. It contains 36 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_EWM_WarehouseOrder view from CONSUMPTION Form Data Provider: EWM Warehouse Order
C_EWM_WhseOrderParamDet view from CONSUMPTION Whse Order OM BRF+ Parameter Determination
I_EWM_WarehouseOrderT view from COMPOSITE Warehouse Order with Status Name
P_EWM_WarehouseOrder view from COMPOSITE
P_EWM_WarehouseTaskItem view left_outer COMPOSITE

Fields (36)

KeyField CDS FieldsUsed in Views
KEY Warehouse Warehouse 2
KEY WarehouseOrder WarehouseOrder 2
ActivityArea ActivityArea 2
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime,WrhsOrdCrtnUTCDateTime 2
ExecutingResource ExecutingResource 1
HzdsSubstanceIsRlvtForStorage HzdsSubstanceIsRlvtForStorage 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
Processor Processor 1
ProcessorIsManualAssigned ProcessorIsManualAssigned 1
Queue Queue,WarehouseOrderQueue 2
ResourceStartBin ResourceStartBin 1
StorageBin StorageBin 1
StorageType StorageType 2
WarehouseOrderConfirmedBy WarehouseOrderConfirmedBy 1
WarehouseOrderCreationRule WarehouseOrderCreationRule 2
WarehouseOrderHasPhysInvtryDoc WarehouseOrderHasPhysInvtryDoc 2
WarehouseOrderHasWhseTask WarehouseOrderHasWhseTask 2
WarehouseOrderIsSplit WarehouseOrderIsSplit 2
WarehouseOrderLogicalNumber WarehouseOrderLogicalNumber 1
WarehouseOrderPlannedDuration WarehouseOrderPlannedDuration 1
WarehouseOrderStartDateTime WarehouseOrderStartDateTime 2
WarehouseOrderStartTimeIsFixed WarehouseOrderStartTimeIsFixed 1
WarehouseOrderStatus WarehouseOrderStatus 3
WarehouseOrderUUID WarehouseOrderUUID 1
Wave Wave 1
WhseOrderConfirmedDateTime WhseOrderConfirmedDateTime 1
WhseOrderCreationRuleCategory WhseOrderCreationRuleCategory 1
WhseOrderForSplitWhseOrder WhseOrderForSplitWhseOrder 1
WhseOrderHasSubsqntWhseOrder WhseOrderHasSubsqntWhseOrder 1
WhseOrderHigherLevelWhseOrder WhseOrderHigherLevelWhseOrder 2
WhseOrderLatestStartDateTime WhseOrderLatestStartDateTime 2
WhseOrderPlanDurationTimeUnit WhseOrderPlanDurationTimeUnit 1
WhseOrderSubsequentWhseOrder WhseOrderSubsequentWhseOrder 1
WhseProcessTypeDocumentHdr WhseProcessTypeDocumentHdr 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- EWM Warehouse Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EWM_WAREHOUSEORDER (
    WAREHOUSE,
    WAREHOUSEORDER,
    ACTIVITYAREA,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EXECUTINGRESOURCE,
    HZDSSUBSTANCEISRLVTFORSTORAGE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PROCESSOR,
    PROCESSORISMANUALASSIGNED,
    QUEUE,
    RESOURCESTARTBIN,
    STORAGEBIN,
    STORAGETYPE,
    WAREHOUSEORDERCONFIRMEDBY,
    WAREHOUSEORDERCREATIONRULE,
    WAREHOUSEORDERHASPHYSINVTRYDOC,
    WAREHOUSEORDERHASWHSETASK,
    WAREHOUSEORDERISSPLIT,
    WAREHOUSEORDERLOGICALNUMBER,
    WAREHOUSEORDERPLANNEDDURATION,
    WAREHOUSEORDERSTARTDATETIME,
    WAREHOUSEORDERSTARTTIMEISFIXED,
    WAREHOUSEORDERSTATUS,
    WAREHOUSEORDERUUID,
    WAVE,
    WHSEORDERCONFIRMEDDATETIME,
    WHSEORDERCREATIONRULECATEGORY,
    WHSEORDERFORSPLITWHSEORDER,
    WHSEORDERHASSUBSQNTWHSEORDER,
    WHSEORDERHIGHERLEVELWHSEORDER,
    WHSEORDERLATESTSTARTDATETIME,
    WHSEORDERPLANDURATIONTIMEUNIT,
    WHSEORDERSUBSEQUENTWHSEORDER,
    WHSEPROCESSTYPEDOCUMENTHDR,
    PRIMARY KEY (WAREHOUSE, WAREHOUSEORDER)
);

Learn More