_DELIVERYITEM

16 Fields

_DELIVERYITEM is an SAP database table in S/4HANA. It contains 16 fields.

Fields (16)

KeyField CDS FieldsUsed in Views
ActualDeliveryQuantity ActualDeliveryQuantity,Quantity 3
DeliveryDocument DeliveryDocument,InboundDelivery 2
DeliveryDocumentBySupplier DeliveryDocumentBySupplier 1
DeliveryDocumentItem DeliveryDocumentItem 1
DeliveryDocumentItemText ItemDescription,MaterialName 2
DeliveryQuantityUnit BaseUnit,DeliveryQuantityUnit 3
DistrStatusByDecentralizedWrhs DistrStatusByDecentralizedWrhs 1
FldLogsStatus FldLogsStatus 1
GoodsMovementStatus GoodsMovementStatus 1
GoodsMovementType GoodsMovementType 1
LoadingPoint LoadingPoint 1
Material Material 2
PickingStatus PickingStatus 1
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
StorageBin StorageBin 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _DELIVERYITEM (
    ACTUALDELIVERYQUANTITY,
    DELIVERYDOCUMENT,
    DELIVERYDOCUMENTBYSUPPLIER,
    DELIVERYDOCUMENTITEM,
    DELIVERYDOCUMENTITEMTEXT,
    DELIVERYQUANTITYUNIT,
    DISTRSTATUSBYDECENTRALIZEDWRHS,
    FLDLOGSSTATUS,
    GOODSMOVEMENTSTATUS,
    GOODSMOVEMENTTYPE,
    LOADINGPOINT,
    MATERIAL,
    PICKINGSTATUS,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    STORAGEBIN
);

Learn More