C_SlsDocFlfmtDelivDocItem

Sales Doc Fulfillment: Delivery Doc Item | view: CSOFDELIVDOCITEM | Extraction: Not supported | Component: Sales Analytics
Tables used: LIKP, LIPS, MARA, MAKT, T300, T30C, T30CT, T300T
Column Name Description
DeliveryDocument FK Delivery
DeliveryDocumentItem Delivery Item
Column Name Description
Column Name Description
📏 Sales unit (DeliveryQuantityUnit):
ActualDeliveryQuantity Actual quantity delivered (in sales units)
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross weight
ItemNetWeight Net weight
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume
Column Name Description
Column Name Description
StockType Stock Type Show values
PickingStatus Picking Status/Putaway Status (Item) Show values
DeliveryRelatedBillingStatus Delivery-Related Billing Status (Item) Show values
PackingStatus Packing Status (Item) Show values
PickingConfirmationStatus Confirmation Status of Picking/Putaway Show values
WarehouseActivityStatus Status of Warehouse Management Activities (Item) Show values
GoodsMovementStatus Goods Movement Status (Item) Show values
ChmlCmplncStatus Product Marketability Status (Item) Show values
DangerousGoodsStatus Dangerous Goods Status (Item) Show values
SafetyDataSheetStatus Safety Data Sheet Status (Item) Show values
TrdCmplncEmbargoSts Embargo Status (Item) Show values
TrdCmplncSnctndListChkSts Screening Status (Item) Show values
TrdCmplncLegalControlSts Legal Control Status Show values
Column Name Description Domain name
DeliveryDocumentItemText Short text for sales order item TEXT40
MaterialName Material Description TEXT40
MaterialByCustomer Customer Material IDNEX
WarehouseName Warehouse Number Description TEXT25
WarehouseStagingAreaName Text for matl staging area TEXT25
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
Master Data Relations Join Conditions
Batch Number
  • Plant
  • Batch Number
  • Product Number
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.PLANT == MCHA.WERKS
  • C_SLSDOCFLFMTDELIVDOCITEM.BATCH == MCHA.CHARG
  • C_SLSDOCFLFMTDELIVDOCITEM.MATERIAL == MCHA.MATNR
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == MCHA.MANDT
Delivery item category
  • Delivery item category
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.DELIVERYDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == TVPT.MANDT
Sales unit
  • Client
  • Sales unit
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == T006.MANDT
  • C_SLSDOCFLFMTDELIVDOCITEM.DELIVERYQUANTITYUNIT == T006.MSEHI
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.GOODSMOVEMENTTYPE == T156.BWART
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == T156.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == T148.MANDT
Billing Block
  • Billing Block
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == TVFS.MANDT
Volume unit
  • Volume unit
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.ITEMVOLUMEUNIT == T006.MSEHI
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == T006.MANDT
Weight Unit
  • Weight Unit
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.ITEMWEIGHTUNIT == T006.MSEHI
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == T006.MANDT
Loading Group
  • Loading Group
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.LOADINGGROUP == TLGR.LADGR
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == TLGR.MANDT
Product Number
  • Product Number
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.MATERIAL == MARA.MATNR
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.MATERIALGROUP == T023.MATKL
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.PLANT == T001W.WERKS
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == T001W.MANDT
Storage location
  • Plant
  • Storage location
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.PLANT == T001L.WERKS
  • C_SLSDOCFLFMTDELIVDOCITEM.STORAGELOCATION == T001L.LGORT
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == T001L.MANDT
Transportation Group
  • Transportation Group
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.TRANSPORTATIONGROUP == TTGR.TRAGR
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == TTGR.MANDT
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.WAREHOUSE == T300.LGNUM
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == T300.MANDT
Staging Area in Warehouse
  • Warehouse Number / Warehouse Complex
  • Staging Area for Warehouse Complex
  • Client
  • C_SLSDOCFLFMTDELIVDOCITEM.WAREHOUSE == T30C.LGNUM
  • C_SLSDOCFLFMTDELIVDOCITEM.WAREHOUSESTAGINGAREA == T30C.LGBZO
  • C_SLSDOCFLFMTDELIVDOCITEM.MANDT == T30C.MANDT