_DELIVERYITEM

17 Fields

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

Fields (17)

KeyField CDS FieldsUsed in Views
ActualDeliveryQuantity ActualDeliveryQuantity,Quantity 3
DeliveryDocument DeliveryDocument,InboundDelivery 2
DeliveryDocumentBySupplier DeliveryDocumentBySupplier 1
DeliveryDocumentItemText DeliveryDocumentItemText,ItemDescription,MaterialName 3
DeliveryQuantityUnit BaseUnit,DeliveryQuantityUnit 3
DistrStatusByDecentralizedWrhs DistrStatusByDecentralizedWrhs 1
FldLogsStatus FldLogsStatus 1
GoodsMovementStatus GoodsMovementStatus 1
GoodsMovementType GoodsMovementType 1
LoadingPoint LoadingPoint 1
Material Material 3
PickingStatus PickingStatus 1
Plant FldLogsSrcePlnt 1
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
StorageBin StorageBin 1
UnloadingPointName UnloadingPointName 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,
    DELIVERYDOCUMENTITEMTEXT,
    DELIVERYQUANTITYUNIT,
    DISTRSTATUSBYDECENTRALIZEDWRHS,
    FLDLOGSSTATUS,
    GOODSMOVEMENTSTATUS,
    GOODSMOVEMENTTYPE,
    LOADINGPOINT,
    MATERIAL,
    PICKINGSTATUS,
    PLANT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    STORAGEBIN,
    UNLOADINGPOINTNAME
);

Learn More