_DELIVERYDOCUMENTITEM

21 Fields

_DELIVERYDOCUMENTITEM is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
KEY DeliveryDocument DeliveryDocument 3
KEY DeliveryDocumentItem DeliveryDocumentItem,OutboundDeliveryItem 6
KEY Plant Plant 4
KEY StorageLocation StorageLocation 3
_DeliveryQuantityUnit _DeliveryQuantityUnit 3
_DistributionChannel _DistributionChannel 1
_Division _Division 1
_ReferenceSDDocument _ReferenceSDDocument 1
ActualDeliveryQuantity ActualDeliveryQuantity,FldLogsDelivQty 4
DeliveryBlockReason DeliveryBlockReason 1
DeliveryDocumentItemCategory DeliveryDocumentItemCategory 2
DeliveryDocumentItemText DeliveryDocumentItemText 3
DeliveryQuantityUnit DeliveryQuantityUnit 3
DistributionChannel DistributionChannel 2
Division Division 2
GoodsMovementStatus GoodsMovementStatus 1
HigherLvlItmOfBatSpltItm HigherLvlItmOfBatSpltItm 2
Material Material 2
PickingStatus PickingStatus 1
ReferenceSDDocument ReferenceDocument 1
SDDocumentCategory SDDocumentCategory 2

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 _DELIVERYDOCUMENTITEM (
    DELIVERYDOCUMENT,
    DELIVERYDOCUMENTITEM,
    PLANT,
    STORAGELOCATION,
    _DELIVERYQUANTITYUNIT,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _REFERENCESDDOCUMENT,
    ACTUALDELIVERYQUANTITY,
    DELIVERYBLOCKREASON,
    DELIVERYDOCUMENTITEMCATEGORY,
    DELIVERYDOCUMENTITEMTEXT,
    DELIVERYQUANTITYUNIT,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    GOODSMOVEMENTSTATUS,
    HIGHERLVLITMOFBATSPLTITM,
    MATERIAL,
    PICKINGSTATUS,
    REFERENCESDDOCUMENT,
    SDDOCUMENTCATEGORY,
    PRIMARY KEY (DELIVERYDOCUMENT, DELIVERYDOCUMENTITEM, PLANT, STORAGELOCATION)
);

Learn More