_DELIVERYDOCUMENT
_DELIVERYDOCUMENT is an SAP database table in S/4HANA. It contains 44 fields.
Fields (44)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA