C_SalesOrderItemOverdueDelivQ

SOFM Sales Order Item With Overdue Delivery Query | view: CSLSORDITEMSO05Q | 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, TVAP, TVAPT, TVST, TVSTT, 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
SalesOrderItemCategoryName Description TEXT20
ProductionPlant Plant (Own or External) WERKS
PlantName Plant Name TEXT30
SalesOrderItemText Short text for sales order item TEXT40
ShippingPointName Description TEXT30
ShipToParty Ship-to Party KUNNR
ShipToPartyName Name of Ship-to Party TEXT80
Master Data Relations Join Conditions
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • C_SALESORDERITEMOVERDUEDELIVQ.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESORDERITEMOVERDUEDELIVQ.MANDT == TVKOV.MANDT
  • C_SALESORDERITEMOVERDUEDELIVQ.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Material: order item
  • Material Number
  • Client
  • C_SALESORDERITEMOVERDUEDELIVQ.MATERIAL == MARA.MATNR
  • C_SALESORDERITEMOVERDUEDELIVQ.MANDT == MARA.MANDT
Sales unit
  • Client
  • Sales unit
  • C_SALESORDERITEMOVERDUEDELIVQ.MANDT == T006.MANDT
  • C_SALESORDERITEMOVERDUEDELIVQ.ORDERQUANTITYUNIT == T006.MSEHI
Division in order header
  • Sales Organization
  • Division
  • Client
  • Distribution Channel
  • C_SALESORDERITEMOVERDUEDELIVQ.SALESORGANIZATION == TVTA.VKORG
  • C_SALESORDERITEMOVERDUEDELIVQ.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESORDERITEMOVERDUEDELIVQ.MANDT == TVTA.MANDT
  • C_SALESORDERITEMOVERDUEDELIVQ.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales document item category
  • Sales document item category
  • Client
  • C_SALESORDERITEMOVERDUEDELIVQ.SALESORDERITEMCATEGORY == TVPT.PSTYV
  • C_SALESORDERITEMOVERDUEDELIVQ.MANDT == TVPT.MANDT
Order type in order header
  • Client
  • Sales Document Type
  • C_SALESORDERITEMOVERDUEDELIVQ.MANDT == TVAK.MANDT
  • C_SALESORDERITEMOVERDUEDELIVQ.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Sales Organization
  • Client
  • C_SALESORDERITEMOVERDUEDELIVQ.SALESORGANIZATION == TVKO.VKORG
  • C_SALESORDERITEMOVERDUEDELIVQ.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_SALESORDERITEMOVERDUEDELIVQ.MANDT == TVST.MANDT
  • C_SALESORDERITEMOVERDUEDELIVQ.SHIPPINGPOINT == TVST.VSTEL
SD Document Currency
  • SD Document Currency
  • Client
  • C_SALESORDERITEMOVERDUEDELIVQ.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_SALESORDERITEMOVERDUEDELIVQ.MANDT == TCURC.MANDT