I_EWM_OUTBDELIVORDITEMBASIC
Outbound Delivery Order Item Basic
I_EWM_OUTBDELIVORDITEMBASIC is a CDS View in S/4HANA. Outbound Delivery Order Item Basic. It contains 41 fields. 19 CDS views read from this table.
CDS Views using this table (19)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_EWM_LoadListOutbDelivItem | view_entity | from | CONSUMPTION | Form Prvdr for Loading Instruction Item |
| I_EWM_OutbDelivOrdItem | view_entity | from | COMPOSITE | Warehouse Outbound Delivery Order Item |
| I_EWM_OutbDelivOrdItemSrlNmbr | view_entity | inner | COMPOSITE | Warehouse Outb Dlv Ord Itm Serial Number |
| I_EWM_SingleOutbDelivOrder | view | from | COMPOSITE | EWM Single Outbound Delivery Order |
| I_FldLogsOutboundDelivIdEWM | view | from | COMPOSITE | EWM Ref DocID for Outbound Delivery |
| P_EWM_HandlingUnitHistory16 | view_entity | inner | COMPOSITE | |
| P_EWM_HandlingUnitHistory17 | view_entity | inner | COMPOSITE | |
| P_EWM_HandlingUnitHistory18 | view_entity | inner | COMPOSITE | |
| P_EWM_HandlingUnitHistory19 | view_entity | inner | COMPOSITE | |
| P_EWM_HandlingUnitHistory20 | view_entity | inner | COMPOSITE | |
| P_EWM_HandlingUnitHistory21 | view_entity | inner | COMPOSITE | |
| P_EWM_ODOItemLabel | view_entity | from | COMPOSITE | |
| P_EWM_ODONoParam_2 | view | from | COMPOSITE | |
| P_EWM_OutbDelivOrdNoParam | view | from | COMPOSITE | |
| P_EWM_OutbDlvOrdHdrCountItm01 | view_entity | from | COMPOSITE | |
| P_EWM_OutbDlvOrdItmSerialNo01 | view | from | COMPOSITE | |
| P_EWM_OutbDlvOrdItmSrlNo01_2 | view_entity | inner | COMPOSITE | |
| P_EWM_OutboundDlvOrderItem01 | view | from | COMPOSITE | |
| P_EWM_WhseTaskRefDocNumber01 | view | from | COMPOSITE |
Fields (41)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | EWMDeliveryDocumentCategory | EWMDeliveryDocumentCategory,EWMReferenceDocumentCategory | 7 |
| KEY | EWMOutboundDeliveryOrder | EWMOutboundDeliveryOrder,EWMReferenceDocument | 9 |
| KEY | EWMOutboundDeliveryOrderItem | EWMOutboundDeliveryOrderItem,EWMReferenceDocumentItem | 9 |
| KEY | OutboundDeliveryOrderItemUUID | OutboundDeliveryOrderItemUUID | 6 |
| KEY | OutboundDeliveryOrderUUID | OutboundDeliveryOrderUUID | 6 |
| ActivityArea | ActivityArea | 1 | |
| CompletionStatus | CompletionStatus | 1 | |
| DeliveryCategory | DeliveryCategory,EWMDeliveryDocumentCategory | 2 | |
| EntitledToDisposeParty | EntitledToDisposeParty | 1 | |
| EWMDeliveryCreationUTCDateTime | ReferenceDocCrtnUTCDateTime | 6 | |
| EWMDelivLastChangeUTCDateTime | ReferenceDocLastChgUTCDateTime | 6 | |
| EWMWarehouse | EWMWarehouse | 2 | |
| GoodsIssueStatus | GoodsIssueStatus | 1 | |
| MeansOfTransportType | MeansOfTransportType | 1 | |
| OutbDeliveryOrderItemCategory | OutbDeliveryOrderItemCategory | 1 | |
| OutboundDeliveryOrder | OutboundDeliveryOrder | 1 | |
| OutboundDeliveryOrderItem | OutboundDeliveryOrderItem | 1 | |
| OutboundDeliveryOrderItemType | OutboundDeliveryOrderItemType | 1 | |
| PlannedPickingStatus | PlannedPickingStatus | 1 | |
| PlndGoodsIssueStartUTCDateTime | PlndGoodsIssueStartUTCDateTime | 1 | |
| Product | Product | 1 | |
| ProductBatch | ProductBatch | 1 | |
| ProductQuantity | ProductQuantity | 1 | |
| QuantityUnit | QuantityUnit | 1 | |
| RouteSchedule | RouteSchedule | 1 | |
| SalesOrder | SalesOrder | 1 | |
| ShippingCondition | ShippingCondition | 1 | |
| StagingArea | StagingArea | 1 | |
| StagingAreaGroup | StagingAreaGroup | 1 | |
| StorageBin | StorageBin | 1 | |
| StorageSection | StorageSection | 1 | |
| StorageType | StorageType | 1 | |
| Warehouse | Warehouse | 1 | |
| WarehouseDoor | WarehouseDoor | 1 | |
| WarehouseProcessType | WarehouseProcessType | 1 | |
| WrhsTimeZoneActualGIDate | WrhsTimeZoneActualGIDate | 1 | |
| WrhsTimeZoneActualGITime | WrhsTimeZoneActualGITime | 1 | |
| WrhsTimeZonePlannedGIDate | WrhsTimeZonePlannedGIDate | 1 | |
| WrhsTimeZonePlannedGITime | WrhsTimeZonePlannedGITime | 1 | |
| WrhsTmznActlGIStrtDateTime | WrhsTmznActlGIStrtDateTime | 1 | |
| WrhsTmznPlndGIStrtDateTime | WrhsTmznPlndGIStrtDateTime | 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.
-- Outbound Delivery Order Item Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EWM_OUTBDELIVORDITEMBASIC (
EWMDELIVERYDOCUMENTCATEGORY,
EWMOUTBOUNDDELIVERYORDER,
EWMOUTBOUNDDELIVERYORDERITEM,
OUTBOUNDDELIVERYORDERITEMUUID,
OUTBOUNDDELIVERYORDERUUID,
ACTIVITYAREA,
COMPLETIONSTATUS,
DELIVERYCATEGORY,
ENTITLEDTODISPOSEPARTY,
EWMDELIVERYCREATIONUTCDATETIME,
EWMDELIVLASTCHANGEUTCDATETIME,
EWMWAREHOUSE,
GOODSISSUESTATUS,
MEANSOFTRANSPORTTYPE,
OUTBDELIVERYORDERITEMCATEGORY,
OUTBOUNDDELIVERYORDER,
OUTBOUNDDELIVERYORDERITEM,
OUTBOUNDDELIVERYORDERITEMTYPE,
PLANNEDPICKINGSTATUS,
PLNDGOODSISSUESTARTUTCDATETIME,
PRODUCT,
PRODUCTBATCH,
PRODUCTQUANTITY,
QUANTITYUNIT,
ROUTESCHEDULE,
SALESORDER,
SHIPPINGCONDITION,
STAGINGAREA,
STAGINGAREAGROUP,
STORAGEBIN,
STORAGESECTION,
STORAGETYPE,
WAREHOUSE,
WAREHOUSEDOOR,
WAREHOUSEPROCESSTYPE,
WRHSTIMEZONEACTUALGIDATE,
WRHSTIMEZONEACTUALGITIME,
WRHSTIMEZONEPLANNEDGIDATE,
WRHSTIMEZONEPLANNEDGITIME,
WRHSTMZNACTLGISTRTDATETIME,
WRHSTMZNPLNDGISTRTDATETIME,
PRIMARY KEY (EWMDELIVERYDOCUMENTCATEGORY, EWMOUTBOUNDDELIVERYORDER, EWMOUTBOUNDDELIVERYORDERITEM, OUTBOUNDDELIVERYORDERITEMUUID, OUTBOUNDDELIVERYORDERUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA