_DELIVERYDOCUMENTITEM

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

Fields (19)

KeyField CDS FieldsUsed in Views
KEY DeliveryDocumentItem DeliveryDocumentItem,OutboundDeliveryItem 4
_DeliveryQuantityUnit _DeliveryQuantityUnit 3
_DistributionChannel _DistributionChannel 1
_Division _Division 1
_ReferenceSDDocument _ReferenceSDDocument 1
ActualDeliveryQuantity ActualDeliveryQuantity,FldLogsDelivQty 4
DeliveryBlockReason DeliveryBlockReason 1
DeliveryDocument DeliveryDocument 1
DeliveryDocumentItemCategory DeliveryDocumentItemCategory 1
DeliveryDocumentItemText DeliveryDocumentItemText 4
DeliveryQuantityUnit DeliveryQuantityUnit 3
DistributionChannel DistributionChannel 2
Division Division 2
HigherLvlItmOfBatSpltItm HigherLvlItmOfBatSpltItm 2
Material Material 2
PickingStatus PickingStatus 1
Plant Plant 2
ReferenceSDDocument ReferenceDocument 1
StorageLocation StorageLocation 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 _DELIVERYDOCUMENTITEM (
    DELIVERYDOCUMENTITEM,
    _DELIVERYQUANTITYUNIT,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _REFERENCESDDOCUMENT,
    ACTUALDELIVERYQUANTITY,
    DELIVERYBLOCKREASON,
    DELIVERYDOCUMENT,
    DELIVERYDOCUMENTITEMCATEGORY,
    DELIVERYDOCUMENTITEMTEXT,
    DELIVERYQUANTITYUNIT,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    HIGHERLVLITMOFBATSPLTITM,
    MATERIAL,
    PICKINGSTATUS,
    PLANT,
    REFERENCESDDOCUMENT,
    STORAGELOCATION,
    PRIMARY KEY (DELIVERYDOCUMENTITEM)
);