DELIVERY

29 Fields

DELIVERY is an SAP database table in S/4HANA. It contains 29 fields.

Fields (29)

KeyField CDS FieldsUsed in Views
KEY DeliveryDocument DeliveryDocument 3
KEY ReceivingPlant ReceivingPlant,Store 2
KEY Store Store 1
_DeliveryDocumentType _DeliveryDocumentType 1
_DeliveryPriority _DeliveryPriority 1
_OverallGoodsMovementStatus _OverallGoodsMovementStatus 1
_ProposedDeliveryRoute _ProposedDeliveryRoute 1
_ReceivingPlant _ReceivingPlant 1
_ShippingCondition _ShippingCondition 1
_ShippingPoint _ShippingPoint 1
ActualGoodsMovementDate ActualGoodsMovementDate 1
CreationDate CreationDate 1
DeliveryDate DeliveryDate 2
DeliveryDocumentItem DeliveryDocumentItem 1
DeliveryDocumentType DeliveryDocumentType 2
DeliveryPriority DeliveryPriority 1
HandlingUnitPackingObjectType HandlingUnitPackingObjectType 1
OverallGoodsMovementStatus OverallGoodsMovementStatus 4
PlannedGoodsIssueDate PlannedGoodsIssueDate 1
ProposedDeliveryRoute ProposedDeliveryRoute 1
PurchaseOrder PurchaseOrder 1
ReferenceDocument ReferenceDocument 1
RefPurchaseRequisitionItem RefPurchaseRequisitionItem 1
ShippingCondition ShippingCondition 1
ShippingPoint ShippingPoint 1
ShipToParty ShipToParty 1
SoldToParty SoldToParty 1
Supplier Supplier 2
SupplyingSite SupplyingSite 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 DELIVERY (
    DELIVERYDOCUMENT,
    RECEIVINGPLANT,
    STORE,
    _DELIVERYDOCUMENTTYPE,
    _DELIVERYPRIORITY,
    _OVERALLGOODSMOVEMENTSTATUS,
    _PROPOSEDDELIVERYROUTE,
    _RECEIVINGPLANT,
    _SHIPPINGCONDITION,
    _SHIPPINGPOINT,
    ACTUALGOODSMOVEMENTDATE,
    CREATIONDATE,
    DELIVERYDATE,
    DELIVERYDOCUMENTITEM,
    DELIVERYDOCUMENTTYPE,
    DELIVERYPRIORITY,
    HANDLINGUNITPACKINGOBJECTTYPE,
    OVERALLGOODSMOVEMENTSTATUS,
    PLANNEDGOODSISSUEDATE,
    PROPOSEDDELIVERYROUTE,
    PURCHASEORDER,
    REFERENCEDOCUMENT,
    REFPURCHASEREQUISITIONITEM,
    SHIPPINGCONDITION,
    SHIPPINGPOINT,
    SHIPTOPARTY,
    SOLDTOPARTY,
    SUPPLIER,
    SUPPLYINGSITE,
    PRIMARY KEY (DELIVERYDOCUMENT, RECEIVINGPLANT, STORE)
);

Learn More