C_ESJIOutboundDeliveryQuery

Outbound Deliveries | view: CESJILEOUTBDELIV | Extraction: Not supported | Component: Integration of SAP SD with SAP Jam
Tables used: LIKPTVFSTVFSTKNA1TVLSTVLSTTVLKTVLKTTINCTINCTTVSTTVSTTT300T300T
Column Name Description
OutboundDelivery Outbound Delivery
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
CreationTime Entry time
LastChangeDate Last Changed On
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)
BillingDocumentDate Billing Date
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallPickingConfStatus Status of Pick Confirmation Show values
OverallPickingStatus Picking Status/Putaway Status (All Items) Show values
OverallGoodsMovementStatus Goods Movement Status (All Items) Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallDelivConfStatus Delivery Confirmation Status (All Items) Show values
OverallDelivReltdBillgStatus Delivery-Related Billing Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
TransportationPlanningStatus Transportation Planning Status (Header) Show values
OverallWarehouseActivityStatus Status of Warehouse Management Activities (All Items) Show values
OverallPackingStatus Packing Status (All Items) Show values
Column Name Description Domain name
ObjectType null
DeliveryDocumentTypeName Description TEXT20
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
ShippingPointName Description TEXT30
StorageType null
DeliveryBlockReasonText Description TEXT20
ShipToPartyName Name of Customer TEXT80
IncotermsClassificationName Description TEXT30
BillingBlockReasonDescription Billing Block Description TEXT20
WarehouseName Warehouse Number Description TEXT25
Master Data Relations Join Conditions
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • C_ESJIOUTBOUNDDELIVERYQUERY.MANDT == TVLS.MANDT
  • C_ESJIOUTBOUNDDELIVERYQUERY.DELIVERYBLOCKREASON == TVLS.LIFSP
Delivery Type
  • Client
  • Delivery Type
  • C_ESJIOUTBOUNDDELIVERYQUERY.MANDT == TVLK.MANDT
  • C_ESJIOUTBOUNDDELIVERYQUERY.DELIVERYDOCUMENTTYPE == TVLK.LFART
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • C_ESJIOUTBOUNDDELIVERYQUERY.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_ESJIOUTBOUNDDELIVERYQUERY.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_ESJIOUTBOUNDDELIVERYQUERY.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_ESJIOUTBOUNDDELIVERYQUERY.MANDT == TINC.MANDT
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_ESJIOUTBOUNDDELIVERYQUERY.MANDT == TVST.MANDT
  • C_ESJIOUTBOUNDDELIVERYQUERY.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Client
  • Shipping Type
  • C_ESJIOUTBOUNDDELIVERYQUERY.MANDT == T173.MANDT
  • C_ESJIOUTBOUNDDELIVERYQUERY.SHIPPINGTYPE == T173.VSART
Ship-to Party
  • Client
  • Ship-to Party
  • C_ESJIOUTBOUNDDELIVERYQUERY.MANDT == KNA1.MANDT
  • C_ESJIOUTBOUNDDELIVERYQUERY.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Sold-to Party
  • Client
  • C_ESJIOUTBOUNDDELIVERYQUERY.SOLDTOPARTY == KNA1.KUNNR
  • C_ESJIOUTBOUNDDELIVERYQUERY.MANDT == KNA1.MANDT
Warehouse Number / Warehouse Complex
  • Client
  • Warehouse Number / Warehouse Complex
  • C_ESJIOUTBOUNDDELIVERYQUERY.MANDT == T300.MANDT
  • C_ESJIOUTBOUNDDELIVERYQUERY.WAREHOUSE == T300.LGNUM