C_ESJIOtbndDlvryItemQuery

Outbound Delivery Item | view: CESJIOTBDLIVITM | Extraction: Not supported | Component: Integration of SAP SD with SAP Jam
Tables used: LIKP, LIPS
Column Name Description
OutboundDelivery FK Delivery
OutboundDeliveryItem Delivery Item
Column Name Description
Column Name Description
📏 Sales unit (DeliveryQuantityUnit):
ActualDeliveryQuantity Actual quantity delivered (in sales units)
OriginalDeliveryQuantity Original Quantity of Delivery Item
📏 Base Unit of Measure (BaseUnit):
ActualDeliveredQtyInBaseUnit Actual quantity delivered in stockkeeping units
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross weight
ItemNetWeight Net weight
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume
Column Name Description
CreationDate Date on which the record was created
CreationTime Entry time
LastChangeDate Last Changed On
ProductAvailabilityDate Material Staging/Availability Date
Column Name Description
SalesDocumentItemType Item Type Show values
PickingControl Indicator for picking control Show values
ItemIsBillingRelevant Relevant for Billing Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
Column Name Description Domain name
ObjectType null
CreatedByUser Name of Person Responsible for Creating the Object USNAM
DeliveryDocumentItemText Short text for sales order item TEXT40
DeliveryToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
DeliveryToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == T006.MANDT
  • C_ESJIOTBNDDLVRYITEMQUERY.BASEUNIT == T006.MSEHI
Delivery item category
  • Client
  • Delivery item category
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == TVPT.MANDT
  • C_ESJIOTBNDDLVRYITEMQUERY.DELIVERYDOCUMENTITEMCATEGORY == TVPT.PSTYV
Sales unit
  • Client
  • Sales unit
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == T006.MANDT
  • C_ESJIOTBNDDLVRYITEMQUERY.DELIVERYQUANTITYUNIT == T006.MSEHI
Distribution Channel
  • Client
  • Distribution Channel
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == TVTW.MANDT
  • C_ESJIOTBNDDLVRYITEMQUERY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • C_ESJIOTBNDDLVRYITEMQUERY.DIVISION == TSPA.SPART
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == TSPA.MANDT
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • C_ESJIOTBNDDLVRYITEMQUERY.GOODSMOVEMENTTYPE == T156.BWART
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == T156.MANDT
Billing Block
  • Billing Block
  • Client
  • C_ESJIOTBNDDLVRYITEMQUERY.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == TVFS.MANDT
Volume unit
  • Client
  • Volume unit
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == T006.MANDT
  • C_ESJIOTBNDDLVRYITEMQUERY.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == T006.MANDT
  • C_ESJIOTBNDDLVRYITEMQUERY.ITEMWEIGHTUNIT == T006.MSEHI
Loading Group
  • Loading Group
  • Client
  • C_ESJIOTBNDDLVRYITEMQUERY.LOADINGGROUP == TLGR.LADGR
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == TLGR.MANDT
Material Number
  • Client
  • Material Number
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == MARA.MANDT
  • C_ESJIOTBNDDLVRYITEMQUERY.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == T001W.MANDT
  • C_ESJIOTBNDDLVRYITEMQUERY.PLANT == T001W.WERKS
Sales group
  • Sales group
  • Client
  • C_ESJIOTBNDDLVRYITEMQUERY.SALESGROUP == TVKGR.VKGRP
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == TVKGR.MANDT
Sales office
  • Sales office
  • Client
  • C_ESJIOTBNDDLVRYITEMQUERY.SALESOFFICE == TVBUR.VKBUR
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == TVBUR.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_ESJIOTBNDDLVRYITEMQUERY.SHIPPINGPOINT == TVST.VSTEL
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == TVST.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • C_ESJIOTBNDDLVRYITEMQUERY.STORAGELOCATION == T001L.LGORT
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == T001L.MANDT
  • C_ESJIOTBNDDLVRYITEMQUERY.PLANT == T001L.WERKS
Storage Type
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • Client
  • C_ESJIOTBNDDLVRYITEMQUERY.WAREHOUSE == T301.LGNUM
  • C_ESJIOTBNDDLVRYITEMQUERY.STORAGETYPE == T301.LGTYP
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == T301.MANDT
Transportation Group
  • Client
  • Transportation Group
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == TTGR.MANDT
  • C_ESJIOTBNDDLVRYITEMQUERY.TRANSPORTATIONGROUP == TTGR.TRAGR
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • C_ESJIOTBNDDLVRYITEMQUERY.WAREHOUSE == T300.LGNUM
  • C_ESJIOTBNDDLVRYITEMQUERY.MANDT == T300.MANDT