I_EWM_INBDELIVERYITEMBASIC

CDS View

Inbound Delivery Item Basic

I_EWM_INBDELIVERYITEMBASIC is a CDS View in S/4HANA. Inbound Delivery Item Basic. It contains 13 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
I_EWM_InbDeliveryItem view_entity from COMPOSITE Warehouse Inbound Delivery Item
I_EWM_InbDeliveryItemSrlNmbr view_entity inner COMPOSITE Warehouse Inb Deliv Item Serial Number
I_FldLogsEWMDelivDocItem view from COMPOSITE EWM Delivery Document Item
I_FldLogsEWMInboundDelivID view from COMPOSITE EWM Ref DocID for Inbound Delivery
I_FldLogsInbDelivWhseTsk view from COMPOSITE Field Logistics : Inbound del. Whr. Task
P_EWM_HandlingUnitHistory12 view_entity inner COMPOSITE
P_EWM_HandlingUnitHistory13 view_entity inner COMPOSITE
P_EWM_HandlingUnitHistory14 view_entity inner COMPOSITE
P_EWM_InbDlvItemSerialNo01 view from COMPOSITE
P_EWM_InbDlvItemSerialNo01_2 view_entity inner COMPOSITE
P_EWM_InboundDeliveryItem view from COMPOSITE
P_EWM_InboundDlvItem01 view from COMPOSITE
P_EWM_InboundDlvItem01_2 view_entity from COMPOSITE
P_EWM_PhysStkRefDocNumberItm01 view_entity from COMPOSITE
P_EWM_WhseTaskRefDocNumber01 view union COMPOSITE

Fields (13)

KeyField CDS FieldsUsed in Views
KEY DeliveryDocumentCategory EWMDeliveryDocumentCategory,EWMReferenceDocumentCategory 4
KEY EWMInboundDelivery EWMDelivery,EWMInboundDelivery,EWMReferenceDocument 5
KEY EWMInboundDeliveryItem EWMDeliveryItem,EWMInboundDeliveryItem,EWMReferenceDocumentItem 3
KEY InboundDelivery EWMReferenceDocument 1
KEY InboundDeliveryItem EWMInboundDeliveryItem,EWMReferenceDocumentItem 3
KEY InboundDeliveryItemUUID InboundDeliveryItemUUID 2
KEY InboundDeliveryUUID InboundDeliveryUUID 2
EWMDelivLastChangeUTCDateTime ReferenceDocLastChgUTCDateTime 3
EWMStockType EWMStockType 1
EWMWarehouse EWMWarehouse 2
FldLogsStatus FldLogsStatus 1
InbDelivItemCrtnUTCDateTime ReferenceDocCrtnUTCDateTime 3
Warehouse EWMWarehouse 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.

-- Inbound Delivery Item Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EWM_INBDELIVERYITEMBASIC (
    DELIVERYDOCUMENTCATEGORY,
    EWMINBOUNDDELIVERY,
    EWMINBOUNDDELIVERYITEM,
    INBOUNDDELIVERY,
    INBOUNDDELIVERYITEM,
    INBOUNDDELIVERYITEMUUID,
    INBOUNDDELIVERYUUID,
    EWMDELIVLASTCHANGEUTCDATETIME,
    EWMSTOCKTYPE,
    EWMWAREHOUSE,
    FLDLOGSSTATUS,
    INBDELIVITEMCRTNUTCDATETIME,
    WAREHOUSE,
    PRIMARY KEY (DELIVERYDOCUMENTCATEGORY, EWMINBOUNDDELIVERY, EWMINBOUNDDELIVERYITEM, INBOUNDDELIVERY, INBOUNDDELIVERYITEM, INBOUNDDELIVERYITEMUUID, INBOUNDDELIVERYUUID)
);