I_SalesOrderItemOverdueDeliv

SOFM Sales Order Item With Overdue Delivery | view: ISLSORDITEMSO05 | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAP, VBEP, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, T001W, CVI_VEND_LINK
Column Name Description
SalesOrder FK Sales Order
SalesOrderItem Sales Order Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
Column Name Description
DueDate Due Date
Column Name Description
Column Name Description Domain name
DueDays Next Action in Days DUE_DAYS
Plant Plant (Own or External) WERKS
PlantName Plant Name TEXT30
SalesOrderItemText Short text for sales order item TEXT40
ShipToParty Ship-to Party KUNNR
ShipToPartyName Name of Ship-to Party TEXT80
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • I_SALESORDERITEMOVERDUEDELIV.MANDT == TVKOV.MANDT
  • I_SALESORDERITEMOVERDUEDELIV.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SALESORDERITEMOVERDUEDELIV.SALESORGANIZATION == TVKOV.VKORG
Material: order item
  • Client
  • Material Number
  • I_SALESORDERITEMOVERDUEDELIV.MANDT == MARA.MANDT
  • I_SALESORDERITEMOVERDUEDELIV.MATERIAL == MARA.MATNR
Sales unit
  • Client
  • Sales unit
  • I_SALESORDERITEMOVERDUEDELIV.MANDT == T006.MANDT
  • I_SALESORDERITEMOVERDUEDELIV.ORDERQUANTITYUNIT == T006.MSEHI
Division in order header
  • Client
  • Division
  • Distribution Channel
  • Sales Organization
  • I_SALESORDERITEMOVERDUEDELIV.MANDT == TVTA.MANDT
  • I_SALESORDERITEMOVERDUEDELIV.ORGANIZATIONDIVISION == TVTA.SPART
  • I_SALESORDERITEMOVERDUEDELIV.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SALESORDERITEMOVERDUEDELIV.SALESORGANIZATION == TVTA.VKORG
Sales document item category
  • Client
  • Sales document item category
  • I_SALESORDERITEMOVERDUEDELIV.MANDT == TVPT.MANDT
  • I_SALESORDERITEMOVERDUEDELIV.SALESORDERITEMCATEGORY == TVPT.PSTYV
Order type in order header
  • Client
  • Sales Document Type
  • I_SALESORDERITEMOVERDUEDELIV.MANDT == TVAK.MANDT
  • I_SALESORDERITEMOVERDUEDELIV.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • I_SALESORDERITEMOVERDUEDELIV.MANDT == TVKO.MANDT
  • I_SALESORDERITEMOVERDUEDELIV.SALESORGANIZATION == TVKO.VKORG
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_SALESORDERITEMOVERDUEDELIV.MANDT == TVST.MANDT
  • I_SALESORDERITEMOVERDUEDELIV.SHIPPINGPOINT == TVST.VSTEL
SD Document Currency
  • Client
  • SD Document Currency
  • I_SALESORDERITEMOVERDUEDELIV.MANDT == TCURC.MANDT
  • I_SALESORDERITEMOVERDUEDELIV.TRANSACTIONCURRENCY == TCURC.WAERS