I_DELIVERYDOCUMENT

CDS View
119 Fields 67 CDS Views

Delivery Document

I_DELIVERYDOCUMENT is a CDS View in S/4HANA. Delivery Document. It contains 119 fields. 67 CDS views read from this table.

CDS Views using this table (67)

ViewTypeJoinVDMDescription
/VSCEW/C_Disposition_VJ view_entity from Disposition VJ (Deliveries)
A_InbDeliveryHeader view from BASIC CDS View for Inbound Delivery
A_InbDeliveryHeader_1 view from BASIC CDS View for Inbound Delivery
A_OutbDeliveryHeader view from BASIC CDS view for API exposure
A_OutbDeliveryHeader_1 view from BASIC CDS view for API exposure
A_ReturnsDeliveryHeader view from BASIC Returns Delivery Header
A_ReturnsDeliveryHeader_1 view from BASIC Returns Delivery Header
C_BSOrdProcFlwRetDeliv view from CONSUMPTION Return Delivery Attrib for BSOrd Prgrs
C_ChmlCmplncReqDelivCustCntct view from CONSUMPTION Chemical Compliance Request Delivery Customer Contact Card
C_Cust360RecentDeliveryDoc view_entity from CONSUMPTION Customer 360 Recent Delivery
C_CustRetsDeliveryDP view_entity from CONSUMPTION Data Provider for Customer Rets Delivery
C_DeliveryNote view from CONSUMPTION Delivery Note
C_DspDocFlwDeliveryDocAttrib view_entity from CONSUMPTION Delivery Documents Attributes for DDF
C_DspDocFlwDeliveryDocVH view_entity from CONSUMPTION Delivery Documents VH for DDF
C_InboundDeliveryDP view_entity from CONSUMPTION Data Provider for Inbound Delivery
C_InhRepairProcessFlow view inner CONSUMPTION Transaction History of In-House Repair Item
C_OutbDelivProcFlow view inner CONSUMPTION Outbound Delivery Process Flow
C_OutboundDeliveryDP view_entity from CONSUMPTION Data Provider for Outbound Delivery
C_OutboundDeliveryList view from CONSUMPTION Outbound Delivery List
C_PT_DeliveryNote view from CONSUMPTION PT Delivery Note Form
C_RDPDeliveryDocumentDEX view from CONSUMPTION Delivery Documents Extractor for RDP
C_ResvnProcFlwDelivSts view_entity from CONSUMPTION Delivery Item of Resvn Doc Items Status
C_SlsDocFlfmtDelivDoc view from CONSUMPTION Sales Doc Fulfillment: Delivery Document
C_SustDeliveryDocumentDEX view_entity from CONSUMPTION Delivery Documents Extractor
I_ARProcessFlowDocumentVH view union_all COMPOSITE Document Number
I_CreditBlockedDeliveryDoc view from COMPOSITE Credit Blocked Delivery Document
I_CustomerReturnDelivery view from BASIC Customer Returns Delivery Document
I_DeliveryDocumentStdVH view from COMPOSITE Delivery Document
I_DeliveryPickViewHeader view from COMPOSITE Delivery Pick List Header
I_DeliveryStatusValuation view_entity from COMPOSITE Valuation of Document Status
I_DelivWthoutRefQuickCreate view from BASIC Quick Create Delivery w/o reference
I_DelivWthRefQuickCreate view from BASIC Quick Create Deliv with reference TP
I_InboundDelivery view from BASIC Inbound Delivery
I_LatestGIRelatedMatDoc view inner BASIC Latest Goods Issue Material Document
I_OutboundDelivery view from BASIC Outbound Delivery Document
I_PT_DelDocCustAddVers view inner COMPOSITE PT Delivery Doc CustAddr Version
I_PT_DelDocCustAddVers_2 view_entity inner COMPOSITE SAFT Cust Address Version
I_PT_SAFTDeliveryCustDetail view inner COMPOSITE Details of Portugal SAFT Customer
I_PT_SAFTDeliveryHeader view inner COMPOSITE SAFT Movement of Goods Header Portugal
I_PT_SAFTShipFromAddress view from COMPOSITE C view for SAFT Ship From Address
I_ReturnsInspection_2 view_entity inner BASIC Returns Inspection
I_RU_ExprtCstmsDeclnDeliveryVH view from COMPOSITE Delivery Doc for Export Customs Decl
I_SAFTDeliveryCustomer view from BASIC SAF-T Regular Billing Customers
I_SAFTDeliveryOneTimeCustomer view from COMPOSITE SAF-T Delivery OneTimeCustomers
I_SlsOrdFlfmtDeliveryDoc view from COMPOSITE SOFM Delivery Document
P_AR_LengthOfRefDoc view union_all COMPOSITE Private View to find the length of ReferenceDocument
P_ARProcessFlowDeliveryDoc view_entity from COMPOSITE Delivery Document for AR process flow
P_DeliveryDocumentText view_entity inner COMPOSITE Delivery Document Text
P_DeliveryProcFlow view inner CONSUMPTION Delivery Process Flow
P_LogcDocDelivery view_entity from CONSUMPTION Log Doc - Delivery
P_LtstGIReltdMatDoc view inner COMPOSITE Latest Goods Issue Material Document
P_PrdtdDelivProcgDlyTrngData1 view from COMPOSITE Predicted Delivery Processing Delay Training Data 1
P_ReturnsReferenceDocument view_entity inner COMPOSITE Returns Reference Document
P_SalesOrderInDelivDueDate view from COMPOSITE SOFM Due Date Calculation For Sales Orders in Delivery
P_SalesOrderInDelivItmDueDate view from COMPOSITE SOFM Due Date Calculation For Sales Orders in Delivery
P_SchedgAgrmtOrds view left_outer COMPOSITE Demand Driven Products Relevant SA Datas
P_SlsDocFlfmtAIDlvDocHdrCntxt view_entity from COMPOSITE SOFM AI - Delivery Document Header Context
P_SlsOrdDelivdDueDte view inner COMPOSITE SOFM Due Date Calculation For Deliv. Sales Orders
P_SlsOrdDelivdDueDte2 view inner COMPOSITE ReuseView
P_SlsOrdFlfmt1stLvlSDProcSqnc2 view left_outer CONSUMPTION Sales Order Fulfillment First Level SD Process Sequence 2
P_SlsOrdItmDelivdDueDte view inner COMPOSITE SOFM Due Date Calculation For Deliv. Sales Order Items
P_SlsOrdItmDelivdDueDte2 view inner COMPOSITE ReuseView
P_StRpSalesInvoiceItem view left_outer CONSUMPTION Private View for Sales Invoice List
R_CustomerReturnsDeliveryTP view_entity from TRANSACTIONAL Customer Returns Delivery - TP
R_InboundDeliveryTP view_entity from TRANSACTIONAL Inbound Delivery - TP
R_OutboundDeliveryTP view_entity from TRANSACTIONAL Outbound Delivery - TP
R_OutboundDeliveryTP_2 view_entity from TRANSACTIONAL Outbound Delivery - TP

Fields (119)

KeyField CDS FieldsUsed in Views
KEY DeliveryDocument AccountingDocument,DeliveryDocument,OutboundDelivery,UI5NetworkGraphAttributeValue 22
KEY ReferenceDocumentNumber DocumentReferenceID 1
KEY SDDocumentCategory SDDocumentCategory 10
KEY ShipToParty Customer,ShipToParty,SoldToParty 12
KEY SoldToParty SoldToParty 8
_DeliveryDocumentType _DeliveryDocumentType 1
_Item _Item 1
_OverallSDProcessStatus _OverallSDProcessStatus 1
_ReceivingPlant _ReceivingPlant 1
_ShippingPoint _ShippingPoint 1
_ShipToParty _ShipToParty 3
_SoldToParty _SoldToParty 1
ActualDeliveryRoute ActualDeliveryRoute 6
ActualGoodsMovementDate ActualGoodsMovementDate 5
ActualGoodsMovementTime ActualGoodsMovementTime 4
BillingDocumentDate BillingDocumentDate 9
BillOfLading BillOfLading 6
CompleteDeliveryIsDefined CompleteDeliveryIsDefined 7
ConfirmationTime ConfirmationTime 5
CreatedByUser CreatedByUser 8
CreationDate CreationDate 5
CreationTime CreationTime 4
CustomerGroup CustomerGroup 6
DeliveryBlockReason DeliveryBlockReason 10
DeliveryDate DeliveryDate,DocumentDate 8
DeliveryDocumentBySupplier DeliveryDocumentBySupplier 7
DeliveryDocumentType DeliveryDocumentType,DocumentType 11
DeliveryIsInPlant DeliveryIsInPlant 6
DeliveryPriority DeliveryPriority 8
DeliveryTime DeliveryTime 4
DeliveryVersion DeliveryVersion 6
DepreciationPercentage DepreciationPercentage 6
DistrStatusByDecentralizedWrhs DistrStatusByDecentralizedWrhs 6
DocumentDate DocumentDate 7
ExprtInsurCreditCheckStatus ExprtInsurCreditCheckStatus 1
ExternalIdentificationType ExternalIdentificationType 6
ExternalTransportSystem ExternalTransportSystem 6
FactoryCalendarByCustomer FactoryCalendarByCustomer 6
FinDocCreditCheckStatus FinDocCreditCheckStatus 1
GoodsIssueOrReceiptSlipNumber GoodsIssueOrReceiptSlipNumber 6
GoodsIssueTime GoodsIssueTime 6
HandlingUnitInStock HandlingUnitInStock 6
HdrGeneralIncompletionStatus HdrGeneralIncompletionStatus 8
HdrGoodsMvtIncompletionStatus HdrGoodsMvtIncompletionStatus 7
HeaderBillgIncompletionStatus HeaderBillgIncompletionStatus 7
HeaderBillingBlockReason HeaderBillingBlockReason 6
HeaderDelivIncompletionStatus HeaderDelivIncompletionStatus 8
HeaderGrossWeight HeaderGrossWeight 8
HeaderNetWeight HeaderNetWeight 6
HeaderPackingIncompletionSts HeaderPackingIncompletionSts 8
HeaderPickgIncompletionStatus HeaderPickgIncompletionStatus 7
HeaderVolume HeaderVolume 7
HeaderVolumeUnit HeaderVolumeUnit 7
HeaderWeightUnit HeaderWeightUnit 8
IncotermsClassification IncotermsClassification 6
IncotermsTransferLocation IncotermsTransferLocation 6
IntercompanyBillingDate IntercompanyBillingDate 6
InternalFinancialDocument InternalFinancialDocument 6
IsDeliveryForSingleWarehouse IsDeliveryForSingleWarehouse 6
IsExportDelivery IsExportDelivery 6
LastChangeDate LastChangeDate 6
LastChangedByUser LastChangedByUser 6
LoadingDate LoadingDate 7
LoadingPoint LoadingPoint 6
LoadingTime LoadingTime 5
MeansOfTransport MeansOfTransport 6
MeansOfTransportRefMaterial MeansOfTransportRefMaterial 6
MeansOfTransportType MeansOfTransportType 6
OrderCombinationIsAllowed OrderCombinationIsAllowed 6
OrderID OrderID 6
OverallDelivConfStatus OverallDelivConfStatus 6
OverallDelivReltdBillgStatus OverallDelivReltdBillgStatus 8
OverallGoodsMovementStatus OverallGoodsMovementStatus 11
OverallIntcoBillingStatus OverallIntcoBillingStatus 6
OverallPackingStatus OverallPackingStatus 8
OverallPickingConfStatus OverallPickingConfStatus 6
OverallPickingStatus OverallPickingStatus 11
OverallProofOfDeliveryStatus OverallProofOfDeliveryStatus 7
OverallSDProcessStatus OverallSDProcessStatus 8
OverallWarehouseActivityStatus OverallWarehouseActivityStatus 7
OvrlItmDelivIncompletionSts OvrlItmDelivIncompletionSts 7
OvrlItmGdsMvtIncompletionSts OvrlItmGdsMvtIncompletionSts 6
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts 7
OvrlItmPackingIncompletionSts OvrlItmPackingIncompletionSts 7
OvrlItmPickingIncompletionSts OvrlItmPickingIncompletionSts 6
PaymentGuaranteeProcedure PaymentGuaranteeProcedure 6
PaytAuthsnCreditCheckSts PaytAuthsnCreditCheckSts 1
PickedItemsLocation PickedItemsLocation 7
PickingDate PickingDate 7
PickingTime PickingTime 5
PlannedGoodsIssueDate PlannedGoodsIssueDate 10
ProofOfDeliveryDate ProofOfDeliveryDate 5
ProposedDeliveryRoute ProposedDeliveryRoute 7
ReceivingLocationTimeZone ReceivingLocationTimeZone 4
ReceivingPlant ReceivingPlant 7
RouteSchedule RouteSchedule 6
SalesDistrict SalesDistrict 6
SalesOffice SalesOffice 6
SalesOrganization SalesOrganization 10
ShipmentBlockReason ShipmentBlockReason 6
ShippingCondition ShippingCondition 7
ShippingLocationTimeZone ShippingLocationTimeZone 2
ShippingPoint ShippingPoint 14
ShippingType ShippingType 7
SpecialProcessingCode SpecialProcessingCode 6
StatisticsCurrency StatisticsCurrency 6
Supplier Supplier 7
TotalBlockStatus TotalBlockStatus 6
TotalCreditCheckStatus TotalCreditCheckStatus 8
TotalNumberOfPackage TotalNumberOfPackage 7
TransactionCurrency TransactionCurrency 7
TransportationGroup TransportationGroup 6
TransportationPlanningDate TransportationPlanningDate 5
TransportationPlanningStatus TransportationPlanningStatus 8
TransportationPlanningTime TransportationPlanningTime 4
UnloadingPointName UnloadingPointName 6
Warehouse Warehouse 6
WarehouseGate WarehouseGate 7
WarehouseStagingArea WarehouseStagingArea 7

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.

-- Delivery Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DELIVERYDOCUMENT (
    DELIVERYDOCUMENT,
    REFERENCEDOCUMENTNUMBER,
    SDDOCUMENTCATEGORY,
    SHIPTOPARTY,
    SOLDTOPARTY,
    _DELIVERYDOCUMENTTYPE,
    _ITEM,
    _OVERALLSDPROCESSSTATUS,
    _RECEIVINGPLANT,
    _SHIPPINGPOINT,
    _SHIPTOPARTY,
    _SOLDTOPARTY,
    ACTUALDELIVERYROUTE,
    ACTUALGOODSMOVEMENTDATE,
    ACTUALGOODSMOVEMENTTIME,
    BILLINGDOCUMENTDATE,
    BILLOFLADING,
    COMPLETEDELIVERYISDEFINED,
    CONFIRMATIONTIME,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CUSTOMERGROUP,
    DELIVERYBLOCKREASON,
    DELIVERYDATE,
    DELIVERYDOCUMENTBYSUPPLIER,
    DELIVERYDOCUMENTTYPE,
    DELIVERYISINPLANT,
    DELIVERYPRIORITY,
    DELIVERYTIME,
    DELIVERYVERSION,
    DEPRECIATIONPERCENTAGE,
    DISTRSTATUSBYDECENTRALIZEDWRHS,
    DOCUMENTDATE,
    EXPRTINSURCREDITCHECKSTATUS,
    EXTERNALIDENTIFICATIONTYPE,
    EXTERNALTRANSPORTSYSTEM,
    FACTORYCALENDARBYCUSTOMER,
    FINDOCCREDITCHECKSTATUS,
    GOODSISSUEORRECEIPTSLIPNUMBER,
    GOODSISSUETIME,
    HANDLINGUNITINSTOCK,
    HDRGENERALINCOMPLETIONSTATUS,
    HDRGOODSMVTINCOMPLETIONSTATUS,
    HEADERBILLGINCOMPLETIONSTATUS,
    HEADERBILLINGBLOCKREASON,
    HEADERDELIVINCOMPLETIONSTATUS,
    HEADERGROSSWEIGHT,
    HEADERNETWEIGHT,
    HEADERPACKINGINCOMPLETIONSTS,
    HEADERPICKGINCOMPLETIONSTATUS,
    HEADERVOLUME,
    HEADERVOLUMEUNIT,
    HEADERWEIGHTUNIT,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    INTERCOMPANYBILLINGDATE,
    INTERNALFINANCIALDOCUMENT,
    ISDELIVERYFORSINGLEWAREHOUSE,
    ISEXPORTDELIVERY,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LOADINGDATE,
    LOADINGPOINT,
    LOADINGTIME,
    MEANSOFTRANSPORT,
    MEANSOFTRANSPORTREFMATERIAL,
    MEANSOFTRANSPORTTYPE,
    ORDERCOMBINATIONISALLOWED,
    ORDERID,
    OVERALLDELIVCONFSTATUS,
    OVERALLDELIVRELTDBILLGSTATUS,
    OVERALLGOODSMOVEMENTSTATUS,
    OVERALLINTCOBILLINGSTATUS,
    OVERALLPACKINGSTATUS,
    OVERALLPICKINGCONFSTATUS,
    OVERALLPICKINGSTATUS,
    OVERALLPROOFOFDELIVERYSTATUS,
    OVERALLSDPROCESSSTATUS,
    OVERALLWAREHOUSEACTIVITYSTATUS,
    OVRLITMDELIVINCOMPLETIONSTS,
    OVRLITMGDSMVTINCOMPLETIONSTS,
    OVRLITMGENERALINCOMPLETIONSTS,
    OVRLITMPACKINGINCOMPLETIONSTS,
    OVRLITMPICKINGINCOMPLETIONSTS,
    PAYMENTGUARANTEEPROCEDURE,
    PAYTAUTHSNCREDITCHECKSTS,
    PICKEDITEMSLOCATION,
    PICKINGDATE,
    PICKINGTIME,
    PLANNEDGOODSISSUEDATE,
    PROOFOFDELIVERYDATE,
    PROPOSEDDELIVERYROUTE,
    RECEIVINGLOCATIONTIMEZONE,
    RECEIVINGPLANT,
    ROUTESCHEDULE,
    SALESDISTRICT,
    SALESOFFICE,
    SALESORGANIZATION,
    SHIPMENTBLOCKREASON,
    SHIPPINGCONDITION,
    SHIPPINGLOCATIONTIMEZONE,
    SHIPPINGPOINT,
    SHIPPINGTYPE,
    SPECIALPROCESSINGCODE,
    STATISTICSCURRENCY,
    SUPPLIER,
    TOTALBLOCKSTATUS,
    TOTALCREDITCHECKSTATUS,
    TOTALNUMBEROFPACKAGE,
    TRANSACTIONCURRENCY,
    TRANSPORTATIONGROUP,
    TRANSPORTATIONPLANNINGDATE,
    TRANSPORTATIONPLANNINGSTATUS,
    TRANSPORTATIONPLANNINGTIME,
    UNLOADINGPOINTNAME,
    WAREHOUSE,
    WAREHOUSEGATE,
    WAREHOUSESTAGINGAREA,
    PRIMARY KEY (DELIVERYDOCUMENT, REFERENCEDOCUMENTNUMBER, SDDOCUMENTCATEGORY, SHIPTOPARTY, SOLDTOPARTY)
);

Learn More