I_EWM_OUTBDELIVORDITEMBASIC

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);