_DELIVERYDOCUMENT

_DELIVERYDOCUMENT is an SAP database table in S/4HANA. It contains 44 fields.

Fields (44)

KeyField CDS FieldsUsed in Views
KEY DeliveryDocument PrecedingDocument 2
KEY SDDocumentCategory PrecedingDocumentCategory,SDDocumentCategory 3
_CustomerGroup _CustomerGroup 1
_DeliveryDocumentType _DeliveryDocumentType 5
_DeliveryPriority _DeliveryPriority 2
_OverallGoodsMovementStatus _OverallGoodsMovementStatus 2
_OverallPickingStatus _OverallPickingStatus 2
_ProposedDeliveryRoute _DeliveryRoute 2
_SalesOrganization _SalesOrganization 2
_ShippingCondition _ShippingCondition 2
_ShippingPoint _ShippingPoint 5
_ShipToParty _ShipToParty 3
_SoldToParty _SoldToParty 3
_TransportationGroup _TransportationGroup 2
_Warehouse _Warehouse 2
ActualGoodsMovementDate ActualGoodsMovementDate 3
ActualGoodsMovementTime ActualGoodsMovementTime 1
CreatedByUser CreatedByUser 1
Customer Customer 1
CustomerGroup CustomerGroup 1
DeliveryBlockReason DeliveryBlockReason 1
DeliveryDate DeliveryDate 2
DeliveryDocumentType DelivDocType,DeliveryDocumentType 10
DeliveryPriority DelivPrio 2
DeliveryVersion DeliveryVersion 1
DocumentDate DocumentDate 1
GoodsIssueTime GoodsIssueTime 1
IncotermsClassification IncotermsClassification 2
OverallGoodsMovementStatus OverallGoodsMovementStatus 4
OverallPickingStatus OverallPickingStatus 2
OverallSDProcessStatus OverallSDProcessStatus 2
PlannedGoodsIssueDate PlannedGoodsIssueDate 1
ProposedDeliveryRoute DeliveryRoute,ProposedDeliveryRoute 3
ReceivingLocationTimeZone ReceivingLocationTimeZone 1
ReceivingPlant ReceivingPlant 1
SalesOrganization SalesOrganization 4
ShippingCondition DelivShpCondt,ShippingCondition 3
ShippingLocationTimeZone ShippingLocationTimeZone 1
ShippingPoint DelivShpPoint,ShippingPoint 14
ShipToParty ShipToParty 6
SoldToParty SoldToParty 4
Supplier Supplier 2
TransportationGroup DelivTransGroup 2
Warehouse DelivWarehouse,Warehouse 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 _DELIVERYDOCUMENT (
    DELIVERYDOCUMENT,
    SDDOCUMENTCATEGORY,
    _CUSTOMERGROUP,
    _DELIVERYDOCUMENTTYPE,
    _DELIVERYPRIORITY,
    _OVERALLGOODSMOVEMENTSTATUS,
    _OVERALLPICKINGSTATUS,
    _PROPOSEDDELIVERYROUTE,
    _SALESORGANIZATION,
    _SHIPPINGCONDITION,
    _SHIPPINGPOINT,
    _SHIPTOPARTY,
    _SOLDTOPARTY,
    _TRANSPORTATIONGROUP,
    _WAREHOUSE,
    ACTUALGOODSMOVEMENTDATE,
    ACTUALGOODSMOVEMENTTIME,
    CREATEDBYUSER,
    CUSTOMER,
    CUSTOMERGROUP,
    DELIVERYBLOCKREASON,
    DELIVERYDATE,
    DELIVERYDOCUMENTTYPE,
    DELIVERYPRIORITY,
    DELIVERYVERSION,
    DOCUMENTDATE,
    GOODSISSUETIME,
    INCOTERMSCLASSIFICATION,
    OVERALLGOODSMOVEMENTSTATUS,
    OVERALLPICKINGSTATUS,
    OVERALLSDPROCESSSTATUS,
    PLANNEDGOODSISSUEDATE,
    PROPOSEDDELIVERYROUTE,
    RECEIVINGLOCATIONTIMEZONE,
    RECEIVINGPLANT,
    SALESORGANIZATION,
    SHIPPINGCONDITION,
    SHIPPINGLOCATIONTIMEZONE,
    SHIPPINGPOINT,
    SHIPTOPARTY,
    SOLDTOPARTY,
    SUPPLIER,
    TRANSPORTATIONGROUP,
    WAREHOUSE,
    PRIMARY KEY (DELIVERYDOCUMENT, SDDOCUMENTCATEGORY)
);