_OUTBOUNDDELIVERY

_OUTBOUNDDELIVERY is an SAP database table in S/4HANA. It contains 41 fields.

Fields (41)

KeyField CDS FieldsUsed in Views
KEY Supplier Supplier 3
_DeliveryBlockReason _DeliveryBlockReason 1
_DeliveryDocumentType _DeliveryDocumentType 1
_DeliveryPriority _DeliveryPriority 1
_IncotermsVersion _IncotermsVersion 2
_OverallSDProcessStatus _OverallSDProcessStatus 2
_SDDocumentCategory _SDDocumentCategory 1
_ShippingPoint _ShippingPoint 1
_ShipToParty _ShipToParty 3
_SoldToParty _SoldToParty 1
ActualGoodsMovementDate ActualGoodsMovementDate 2
CompleteDeliveryIsDefined CompleteDeliveryIsDefined 1
CreationDate CreationDate 1
CustomerGroup CustomerGroup 3
DeliveryBlockReason DeliveryBlockReason 3
DeliveryDate DeliveryDate,RequestedDeliveryDate 4
DeliveryDocumentType DeliveryDocumentType,DeliveryType 3
DeliveryPriority DeliveryPriority 3
DocumentDate DocumentDate 1
HeaderDelivIncompletionStatus LastMileExternalDocumentStatus 1
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 2
IncotermsTransferLocation IncotermsTransferLocation 2
IncotermsVersion IncotermsVersion 2
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 2
LoadingDate RequestedLoadingDate 1
OverallGoodsMovementStatus OverallGoodsMovementStatus 3
OverallPackingStatus OverallPackingStatus 2
OverallPickingStatus OverallPickingStatus 1
OverallSDProcessStatus OverallSDProcessStatus 2
PlannedGoodsIssueDate PlannedGoodsIssueDate,RequestedGoodsIssueDate 6
ProposedDeliveryRoute ProposedDeliveryRoute 2
ReceivingPlant ReceivingPlant 2
SalesOrganization SalesOrganization 3
SDDocumentCategory SDDocumentCategory 2
ShippingPoint ShippingPoint 4
ShipToParty Customer,ShipToParty 5
SoldToParty SoldToParty 2
TotalNumberOfPackage TotalNumberOfPackage 2
UnloadingPointName UnloadingPointName 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 _OUTBOUNDDELIVERY (
    SUPPLIER,
    _DELIVERYBLOCKREASON,
    _DELIVERYDOCUMENTTYPE,
    _DELIVERYPRIORITY,
    _INCOTERMSVERSION,
    _OVERALLSDPROCESSSTATUS,
    _SDDOCUMENTCATEGORY,
    _SHIPPINGPOINT,
    _SHIPTOPARTY,
    _SOLDTOPARTY,
    ACTUALGOODSMOVEMENTDATE,
    COMPLETEDELIVERYISDEFINED,
    CREATIONDATE,
    CUSTOMERGROUP,
    DELIVERYBLOCKREASON,
    DELIVERYDATE,
    DELIVERYDOCUMENTTYPE,
    DELIVERYPRIORITY,
    DOCUMENTDATE,
    HEADERDELIVINCOMPLETIONSTATUS,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    ISENDOFPURPOSEBLOCKED,
    LOADINGDATE,
    OVERALLGOODSMOVEMENTSTATUS,
    OVERALLPACKINGSTATUS,
    OVERALLPICKINGSTATUS,
    OVERALLSDPROCESSSTATUS,
    PLANNEDGOODSISSUEDATE,
    PROPOSEDDELIVERYROUTE,
    RECEIVINGPLANT,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SHIPPINGPOINT,
    SHIPTOPARTY,
    SOLDTOPARTY,
    TOTALNUMBEROFPACKAGE,
    UNLOADINGPOINTNAME,
    PRIMARY KEY (SUPPLIER)
);