I_DeliveryDocument

Delivery Document | view: ILEDELIVDOC | ATTR | Extraction: Full or Incremental | Component: Basic Functions
Tables used: LIKP
Column Name Description
DeliveryDocument Delivery
Column Name Description
💲 Currency key of credit control area (ControllingAreaCurrency):
ReleasedCreditAmount Released credit value of the document
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
📏 Weight Unit (HeaderWeightUnit):
HeaderGrossWeight Total Weight
HeaderNetWeight Net weight
📏 Volume unit (HeaderVolumeUnit):
HeaderVolume Volume
Column Name Description
CreationDate Date on which the record was created
CreationTime Entry time
LastChangeDate Last Changed On
DocumentDate Document Date in Document
PickingDate Picking Date
PickingTime Picking Time (Local Time, with Reference to a Plant)
LoadingDate Loading Date
LoadingTime Loading Time (Local Time Relating to a Shipping Point)
DeliveryDate Delivery Date
DeliveryTime Time of delivery
TransportationPlanningDate Transportation Planning Date
TransportationPlanningTime Transp. Planning Time (Local, Relating to a Shipping Point)
PlannedGoodsIssueDate Planned Goods Movement Date
GoodsIssueTime Time of Goods Issue (Local, Relating to a Plant)
ActualGoodsMovementDate Actual Goods Movement Date
ActualGoodsMovementTime Time of Goods Issue (Local, Relating to a Plant)
ProofOfDeliveryDate Date (Proof of Delivery)
ConfirmationTime Confirmation Time
IntercompanyBillingDate Billing Date for Intercompany Billing
BillingDocumentDate Billing Date
NextShippingDate Next date
CreditBlockReleaseDate Release date of the document determined by credit management
Column Name Description
SDDocumentCategory SD Document Category Show values
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
OrderCombinationIsAllowed Order Combination Indicator Show values
DeliveryIsInPlant Delivery has Status 'In Plant' Show values
IsDeliveryForSingleWarehouse Delivery Within one Warehouse Show values
ExternalIdentificationType Type of External Identification Show values
HandlingUnitInStock Handling Unit Placed in Stock Show values
CentralCreditChkTechErrSts Status of Technical Error SAP Credit Management Show values
OverallIntcoBillingStatus Intercompany Billing Status (All Items) Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallDelivConfStatus Delivery Confirmation Status (All Items) Show values
TransportationPlanningStatus Transportation Planning Status (Header) Show values
OverallPickingConfStatus Status of Pick Confirmation Show values
OverallPickingStatus Picking Status/Putaway Status (All Items) Show values
OverallPackingStatus Packing Status (All Items) Show values
OverallWarehouseActivityStatus Status of Warehouse Management Activities (All Items) Show values
DistrStatusByDecentralizedWrhs Distribution Status (Decentralized Warehouse Processing) Show values
OverallGoodsMovementStatus Goods Movement Status (All Items) Show values
OverallDelivReltdBillgStatus Delivery-Related Billing Status (All Items) Show values
OverallProofOfDeliveryStatus POD Status on Header Level Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
HeaderPickgIncompletionStatus Picking/Putaway Incompletion Status (Header) Show values
HeaderPackingIncompletionSts Packing Incompletion Status (Header) Show values
HdrGoodsMvtIncompletionStatus Goods Movement Incompletion Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OvrlItmPackingIncompletionSts Packing Incompletion Status (All Items) Show values
OvrlItmPickingIncompletionSts Picking/Putaway Incompletion Status (All Items) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
OvrlItmGdsMvtIncompletionSts Goods Movement Incompletion Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
FinDocCreditCheckStatus Status of Credit Check Against Financial Document Show values
PaytAuthsnCreditCheckSts Status of Credit Check Against Payment Card Authorization Show values
CentralCreditCheckStatus Status of Credit Check SAP Credit Management Show values
ExprtInsurCreditCheckStatus Status of Credit Check Against Export Credit Insurance Show values
MaxDocValueCreditCheckStatus Status of Credit Check Against Maximum Document Value Show values
PaymentTermCreditCheckStatus Status of Credit Check Against Terms of Payment Show values
DeletionIndicator Document deletion indicator Show values
OverallChmlCmplncStatus Total Product Marketability Check Status Show values
OverallDangerousGoodsStatus Total Dangerous Goods Check Status Show values
OverallSafetyDataSheetStatus Total Safety Data Sheet Check Status Show values
OverallTrdCmplncEmbargoSts Embargo Status (All Items) Show values
OvrlTrdCmplncSnctndListChkSts Screening Status (All Items) Show values
OvrlTrdCmplncLegalCtrlChkSts Legal Control Status Show values
IsCorrectionDelivery Correction delivery Show values
ReadyForWarehouseExecStatus Warehouse Execution Status Show values
DelivAdvncdShipgRcvgRlvnce Advanced Shipping and Receiving Relevance Show values
DelivIsQtyCrrtnAdvncShipgRcvg Quantity Correction After Goods Receipt in Advanced SR Show values
EU_DeliveryARCStatus Excise Tax Total ARC Status (on Delivery Header Level) Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
Supplier Supplier LIFNR
DeliveryDocumentBySupplier External Identification of Delivery Note TEXT35
IsExportDelivery Export indicator EXPKZ
GoodsIssueOrReceiptSlipNumber Goods Receipt/Issue Slip Number BELNR
DeliveryVersion Delivery Version DLV_VERSION
PickedItemsLocation Picked Items Location BEROT
TotalNumberOfPackage Total Number of Packages in Delivery ANZPK
BillOfLading Bill of Lading CHAR35
IncotermsTransferLocation Incoterms (Part 2) INCO2
MeansOfTransport Means of Transport ID TRAID
UnloadingPointName Unloading Point TEXT25
ShippingLocationTimeZone Time zone of delivering location TZNZONE
ReceivingLocationTimeZone Time zone of recipient location TZNZONE
InternalFinancialDocument Financial doc. processing: Internal financial doc. number LCNUM
DepreciationPercentage Depreciation percentage for financial document processing PRZ32
ShippingGroupNumber PSST Group RFM_PSST_GROUP_ID
PricingDocument Number of the Document Condition KNUMV
DeliveryDocumentCondition Number of document condition - pricing KNUMV
ReferenceDocumentNumber Reference Document Number XBLNR_LIKP
IntcoExtActlTransfOfCtrlDteTme External Actual Transfer of Control Date TZNTSTMPS
IntcoExtPlndTransfOfCtrlDteTme External Planned Transfer of Control Date TZNTSTMPS
IntcoExtTransfOfCtrlDteTmeTmzn Time zone for external Transfer of Control Date TZNZONE
IntcoIntActlTransfOfCtrlDteTme Internal Actual Transfer of Control Date TZNTSTMPS
IntcoIntPlndTransfOfCtrlDteTme Internal Planned Transfer of Control Date TZNTSTMPS
IntcoIntTransfOfCtrlDteTmeTmzn Time zone for internal Transfer of Control Date TZNZONE
Master Data Relations Join Conditions
Route
  • Client
  • Route
  • I_DELIVERYDOCUMENT.MANDT == TVRO.MANDT
  • I_DELIVERYDOCUMENT.ACTUALDELIVERYROUTE == TVRO.ROUTE
Currency key of credit control area
  • Currency key of credit control area
  • Client
  • I_DELIVERYDOCUMENT.CONTROLLINGAREACURRENCY == TCURC.WAERS
  • I_DELIVERYDOCUMENT.MANDT == TCURC.MANDT
Customer's Account Number with Credit Limit Reference
  • Customer's Account Number with Credit Limit Reference
  • Client
  • I_DELIVERYDOCUMENT.CUSTOMERCREDITACCOUNT == KNA1.KUNNR
  • I_DELIVERYDOCUMENT.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • I_DELIVERYDOCUMENT.MANDT == T151.MANDT
  • I_DELIVERYDOCUMENT.CUSTOMERGROUP == T151.KDGRP
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • I_DELIVERYDOCUMENT.DELIVERYBLOCKREASON == TVLS.LIFSP
  • I_DELIVERYDOCUMENT.MANDT == TVLS.MANDT
Delivery Type
  • Delivery Type
  • Client
  • I_DELIVERYDOCUMENT.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • I_DELIVERYDOCUMENT.MANDT == TVLK.MANDT
Delivery Priority
  • Client
  • Delivery Priority
  • I_DELIVERYDOCUMENT.MANDT == TPRIO.MANDT
  • I_DELIVERYDOCUMENT.DELIVERYPRIORITY == TPRIO.LPRIO
Distribution channel for intercompany billing
  • Client
  • Distribution channel for intercompany billing
  • I_DELIVERYDOCUMENT.MANDT == TVTW.MANDT
  • I_DELIVERYDOCUMENT.DISTRCHNLFORINTCOBILLING == TVTW.VTWEG
Division for intercompany billing
  • Client
  • Division for intercompany billing
  • I_DELIVERYDOCUMENT.MANDT == TSPA.MANDT
  • I_DELIVERYDOCUMENT.DIVISIONFORINTCOBILLING == TSPA.SPART
Customer Factory Calendar I_DELIVERYDOCUMENT.FACTORYCALENDARBYCUSTOMER == TFACD.IDENT
Date for intercompany billing I_DELIVERYDOCUMENT.FACTORYCALENDARFORINTCOBILLING == TFACD.IDENT
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • I_DELIVERYDOCUMENT.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • I_DELIVERYDOCUMENT.MANDT == TVFS.MANDT
Volume unit
  • Client
  • Volume unit
  • I_DELIVERYDOCUMENT.MANDT == T006.MANDT
  • I_DELIVERYDOCUMENT.HEADERVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • I_DELIVERYDOCUMENT.MANDT == T006.MANDT
  • I_DELIVERYDOCUMENT.HEADERWEIGHTUNIT == T006.MSEHI
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_DELIVERYDOCUMENT.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_DELIVERYDOCUMENT.MANDT == TINC.MANDT
Customer number for intercompany billing
  • Customer number for intercompany billing
  • Client
  • I_DELIVERYDOCUMENT.INTERCOMPANYBILLINGCUSTOMER == KNA1.KUNNR
  • I_DELIVERYDOCUMENT.MANDT == KNA1.MANDT
Billing type for intercompany billing
  • Client
  • Billing type for intercompany billing
  • I_DELIVERYDOCUMENT.MANDT == TVFK.MANDT
  • I_DELIVERYDOCUMENT.INTERCOMPANYBILLINGTYPE == TVFK.FKART
Loading Point
  • Loading Point
  • Client
  • Shipping Point / Receiving Point
  • I_DELIVERYDOCUMENT.LOADINGPOINT == TVLA.LSTEL
  • I_DELIVERYDOCUMENT.MANDT == TVLA.MANDT
  • I_DELIVERYDOCUMENT.SHIPPINGPOINT == TVLA.VSTEL
Means of Transport
  • Means of Transport
  • Client
  • I_DELIVERYDOCUMENT.MEANSOFTRANSPORTREFMATERIAL == MARA.MATNR
  • I_DELIVERYDOCUMENT.MANDT == MARA.MANDT
Means-of-Transport Type
  • Client
  • Means-of-Transport Type
  • I_DELIVERYDOCUMENT.MANDT == TVTY.MANDT
  • I_DELIVERYDOCUMENT.MEANSOFTRANSPORTTYPE == TVTY.TRATY
Order Number
  • Client
  • Order Number
  • I_DELIVERYDOCUMENT.MANDT == AUFK.MANDT
  • I_DELIVERYDOCUMENT.ORDERID == AUFK.AUFNR
Foreign Key Check: Payment Guarantee Procedure
  • Payment Guarantee Procedure
  • Client
  • I_DELIVERYDOCUMENT.PAYMENTGUARANTEEPROCEDURE == T691M.ABSSC
  • I_DELIVERYDOCUMENT.MANDT == T691M.MANDT
Route
  • Client
  • Route
  • I_DELIVERYDOCUMENT.MANDT == TVRO.MANDT
  • I_DELIVERYDOCUMENT.PROPOSEDDELIVERYROUTE == TVRO.ROUTE
Receiving Plant for Deliveries
  • Receiving Plant for Deliveries
  • Client
  • I_DELIVERYDOCUMENT.RECEIVINGPLANT == T001W.WERKS
  • I_DELIVERYDOCUMENT.MANDT == T001W.MANDT
Route Schedule
  • Route Schedule
  • Client
  • I_DELIVERYDOCUMENT.ROUTESCHEDULE == VALW.AULWE
  • I_DELIVERYDOCUMENT.MANDT == VALW.MANDT
Sales District
  • Sales District
  • Client
  • I_DELIVERYDOCUMENT.SALESDISTRICT == T171.BZIRK
  • I_DELIVERYDOCUMENT.MANDT == T171.MANDT
Sales office
  • Client
  • Sales office
  • I_DELIVERYDOCUMENT.MANDT == TVBUR.MANDT
  • I_DELIVERYDOCUMENT.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Sales Organization
  • Client
  • I_DELIVERYDOCUMENT.SALESORGANIZATION == TVKO.VKORG
  • I_DELIVERYDOCUMENT.MANDT == TVKO.MANDT
Sales Organization for Intercompany Billing
  • Client
  • Sales Organization for Intercompany Billing
  • I_DELIVERYDOCUMENT.MANDT == TVKO.MANDT
  • I_DELIVERYDOCUMENT.SALESORGFORINTCOBILLING == TVKO.VKORG
Shipment Blocking Reason
  • Client
  • Shipment Blocking Reason
  • I_DELIVERYDOCUMENT.MANDT == TTSG.MANDT
  • I_DELIVERYDOCUMENT.SHIPMENTBLOCKREASON == TTSG.TRSPG
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_DELIVERYDOCUMENT.MANDT == TVSB.MANDT
  • I_DELIVERYDOCUMENT.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_DELIVERYDOCUMENT.MANDT == TVST.MANDT
  • I_DELIVERYDOCUMENT.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Client
  • Shipping Type
  • I_DELIVERYDOCUMENT.MANDT == T173.MANDT
  • I_DELIVERYDOCUMENT.SHIPPINGTYPE == T173.VSART
Ship-to Party
  • Client
  • Ship-to Party
  • I_DELIVERYDOCUMENT.MANDT == KNA1.MANDT
  • I_DELIVERYDOCUMENT.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Sold-to Party
  • Client
  • I_DELIVERYDOCUMENT.SOLDTOPARTY == KNA1.KUNNR
  • I_DELIVERYDOCUMENT.MANDT == KNA1.MANDT
Special Processing Indicator
  • Client
  • Special Processing Indicator
  • I_DELIVERYDOCUMENT.MANDT == TVSAK.MANDT
  • I_DELIVERYDOCUMENT.SPECIALPROCESSINGCODE == TVSAK.SDABW
Statistics Currency
  • Client
  • Statistics Currency
  • I_DELIVERYDOCUMENT.MANDT == TCURC.MANDT
  • I_DELIVERYDOCUMENT.STATISTICSCURRENCY == TCURC.WAERS
SD Document Currency
  • Client
  • SD Document Currency
  • I_DELIVERYDOCUMENT.MANDT == TCURC.MANDT
  • I_DELIVERYDOCUMENT.TRANSACTIONCURRENCY == TCURC.WAERS
Transportation Group
  • Client
  • Transportation Group
  • I_DELIVERYDOCUMENT.MANDT == TTGR.MANDT
  • I_DELIVERYDOCUMENT.TRANSPORTATIONGROUP == TTGR.TRAGR
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • I_DELIVERYDOCUMENT.WAREHOUSE == T300.LGNUM
  • I_DELIVERYDOCUMENT.MANDT == T300.MANDT
Door for Warehouse Number
  • Warehouse Number / Warehouse Complex
  • Client
  • Door for Warehouse Number
  • I_DELIVERYDOCUMENT.WAREHOUSE == T30B.LGNUM
  • I_DELIVERYDOCUMENT.MANDT == T30B.MANDT
  • I_DELIVERYDOCUMENT.WAREHOUSEGATE == T30B.LGTOR
Staging Area in Warehouse
  • Warehouse Number / Warehouse Complex
  • Client
  • Staging Area for Warehouse Complex
  • I_DELIVERYDOCUMENT.WAREHOUSE == T30C.LGNUM
  • I_DELIVERYDOCUMENT.MANDT == T30C.MANDT
  • I_DELIVERYDOCUMENT.WAREHOUSESTAGINGAREA == T30C.LGBZO
Other Relations | to Master Data Relations ↑ Join Conditions
ID for External Transport System I_DELIVERYDOCUMENT.EXTERNALTRANSPORTSYSTEM == TQCOM.COMMN