I_DeliveryPickViewItem

Delivery Pick List Item | view: IDELIVERYPICKI | Extraction: Not supported | Component: Basic Functions
Tables used: LIKP, LIPS
Column Name Description
DeliveryDocument FK Delivery
DeliveryDocumentItem Delivery Item
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
ActualDeliveryQuantity Actual quantity delivered (in sales units)
ActualDeliveredQtyInBaseUnit Actual quantity delivered in stockkeeping units
ItemGrossWeight Gross weight
ItemNetWeight Net weight
ItemVolume Volume
Column Name Description
ProductAvailabilityDate Material Staging/Availability Date
ShelfLifeExpirationDate Shelf Life Expiration or Best-Before Date
Column Name Description
PickingControl Indicator for picking control Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
MaterialIsBatchManaged Batch Management Requirement Indicator Show values
MaterialIsIntBatchManaged Batch management indicator (internal) Show values
WarehouseStockCategory Stock Category in the Warehouse Management System Show values
IssgOrRcvgStockCategory Stock Category in the Warehouse Management System Show values
PrimaryPostingSwitch Indicator: UNMAT in main posting Show values
WarehouseActivityStatus Status of Warehouse Management Activities (Item) Show values
PickingStatus Picking Status/Putaway Status (Item) Show values
Column Name Description Domain name
DeliveryDocumentItemText Short text for sales order item TEXT40
MaterialByCustomer Customer Material IDNEX
WarehouseStorageBin Storage Bin CHAR10
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
ReceivingPoint Receiving Point TEXT25
NumberOfSerialNumbers Number of serial numbers INT4
BatchBySupplier Supplier Batch Number LICHN
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
IssgOrRcvgMaterial Receiving/Issuing Material MATNR
IssuingOrReceivingPlant Receiving plant/issuing plant WERKS
IssuingOrReceivingStorageLoc Receiving/issuing storage location LGORT
IssgOrRcvgBatch Receiving/Issuing Batch CHARG
IssgOrRcvgSpclStockInd Special stock indicator for physical stock transfer SOBKZ
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_DELIVERYPICKVIEWITEM.MANDT == T006.MANDT
  • I_DELIVERYPICKVIEWITEM.BASEUNIT == T006.MSEHI
Batch Number
  • Batch Number
  • Client
  • Material Number
  • Plant
  • I_DELIVERYPICKVIEWITEM.BATCH == MCHA.CHARG
  • I_DELIVERYPICKVIEWITEM.MANDT == MCHA.MANDT
  • I_DELIVERYPICKVIEWITEM.MATERIAL == MCHA.MATNR
  • I_DELIVERYPICKVIEWITEM.PLANT == MCHA.WERKS
Sales unit
  • Client
  • Sales unit
  • I_DELIVERYPICKVIEWITEM.MANDT == T006.MANDT
  • I_DELIVERYPICKVIEWITEM.DELIVERYQUANTITYUNIT == T006.MSEHI
Department
  • Department number
  • Client
  • I_DELIVERYPICKVIEWITEM.DEPARTMENTCLASSIFICATIONBYCUST == TSAB.ABTNR
  • I_DELIVERYPICKVIEWITEM.MANDT == TSAB.MANDT
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • I_DELIVERYPICKVIEWITEM.MANDT == T156.MANDT
  • I_DELIVERYPICKVIEWITEM.GOODSMOVEMENTTYPE == T156.BWART
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • I_DELIVERYPICKVIEWITEM.MANDT == T148.MANDT
  • I_DELIVERYPICKVIEWITEM.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Valuation Type
  • Valuation Type
  • Client
  • I_DELIVERYPICKVIEWITEM.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_DELIVERYPICKVIEWITEM.MANDT == T149D.MANDT
Volume unit
  • Volume unit
  • Client
  • I_DELIVERYPICKVIEWITEM.ITEMVOLUMEUNIT == T006.MSEHI
  • I_DELIVERYPICKVIEWITEM.MANDT == T006.MANDT
Weight Unit
  • Client
  • Weight Unit
  • I_DELIVERYPICKVIEWITEM.MANDT == T006.MANDT
  • I_DELIVERYPICKVIEWITEM.ITEMWEIGHTUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • I_DELIVERYPICKVIEWITEM.MANDT == MARA.MANDT
  • I_DELIVERYPICKVIEWITEM.MATERIAL == MARA.MATNR
Order Number
  • Order Number
  • Client
  • I_DELIVERYPICKVIEWITEM.ORDERID == AUFK.AUFNR
  • I_DELIVERYPICKVIEWITEM.MANDT == AUFK.MANDT
Plant
  • Client
  • Plant
  • I_DELIVERYPICKVIEWITEM.MANDT == T001W.MANDT
  • I_DELIVERYPICKVIEWITEM.PLANT == T001W.WERKS
Promotion
  • Promotion
  • Client
  • I_DELIVERYPICKVIEWITEM.RETAILPROMOTION == WAKH.AKTNR
  • I_DELIVERYPICKVIEWITEM.MANDT == WAKH.MANDT
Storage Bin
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • Storage Bin
  • Client
  • I_DELIVERYPICKVIEWITEM.WAREHOUSE == LAGP.LGNUM
  • I_DELIVERYPICKVIEWITEM.STORAGETYPE == LAGP.LGTYP
  • I_DELIVERYPICKVIEWITEM.STORAGEBIN == LAGP.LGPLA
  • I_DELIVERYPICKVIEWITEM.MANDT == LAGP.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • I_DELIVERYPICKVIEWITEM.STORAGELOCATION == T001L.LGORT
  • I_DELIVERYPICKVIEWITEM.MANDT == T001L.MANDT
  • I_DELIVERYPICKVIEWITEM.PLANT == T001L.WERKS
Storage Type
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • Client
  • I_DELIVERYPICKVIEWITEM.WAREHOUSE == T301.LGNUM
  • I_DELIVERYPICKVIEWITEM.STORAGETYPE == T301.LGTYP
  • I_DELIVERYPICKVIEWITEM.MANDT == T301.MANDT
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • I_DELIVERYPICKVIEWITEM.WAREHOUSE == T300.LGNUM
  • I_DELIVERYPICKVIEWITEM.MANDT == T300.MANDT
Staging Area in Warehouse
  • Staging Area for Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • I_DELIVERYPICKVIEWITEM.WAREHOUSESTAGINGAREA == T30C.LGBZO
  • I_DELIVERYPICKVIEWITEM.WAREHOUSE == T30C.LGNUM
  • I_DELIVERYPICKVIEWITEM.MANDT == T30C.MANDT