C_SlsOrdFlfmtScheduleLineQ

SOFM Sales Order Scheduleline Query | view: CSOFSCHEDLINEQ | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAPVBKDVEDAVBAKVBAKVBAPVBKDVEDAVBEPTVLSTVLST
Column Name Description
SalesOrder Sales Order
SalesOrderItem Sales Order Item
ScheduleLine Schedule Line Number
Column Name Description
Column Name Description
📏 Sales unit (OrderQuantityUnit):
ScheduleLineOrderQuantity Order Quantity in Sales Units
ConfdOrderQtyByMatlAvailCheck Confirmed Quantity
OpenConfdDelivQtyInOrdQtyUnit Open Confirmed Delivery Quantity
DeliveredQtyInOrderQtyUnit Delivered Quantity
Column Name Description
RequestedDeliveryDate Requested Delivery Date
ConfirmedDeliveryDate Confirmed Delivery Date
ProductAvailabilityDate Material Staging/Availability Date
DeliveryDate Delivery Date
Column Name Description
IsRequestedDelivSchedLine Schedule Line Requested for Delivery Show values
IsConfirmedDelivSchedLine Schedule Line Requested for Delivery Show values
Column Name Description Domain name
DeliveryBlockReasonText Description TEXT20
Master Data Relations Join Conditions
Schedule Line Blocked for Delivery
  • Schedule Line Blocked for Delivery
  • Client
  • C_SLSORDFLFMTSCHEDULELINEQ.DELIVBLOCKREASONFORSCHEDLINE == TVLS.LIFSP
  • C_SLSORDFLFMTSCHEDULELINEQ.MANDT == TVLS.MANDT
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_SLSORDFLFMTSCHEDULELINEQ.MANDT == TVKOV.MANDT
  • C_SLSORDFLFMTSCHEDULELINEQ.SALESORGANIZATION == TVKOV.VKORG
  • C_SLSORDFLFMTSCHEDULELINEQ.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Sales unit
  • Client
  • Sales unit
  • C_SLSORDFLFMTSCHEDULELINEQ.MANDT == T006.MANDT
  • C_SLSORDFLFMTSCHEDULELINEQ.ORDERQUANTITYUNIT == T006.MSEHI
Division in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • Division
  • C_SLSORDFLFMTSCHEDULELINEQ.MANDT == TVTA.MANDT
  • C_SLSORDFLFMTSCHEDULELINEQ.SALESORGANIZATION == TVTA.VKORG
  • C_SLSORDFLFMTSCHEDULELINEQ.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SLSORDFLFMTSCHEDULELINEQ.ORGANIZATIONDIVISION == TVTA.SPART
Order type in order header
  • Client
  • Sales Document Type
  • C_SLSORDFLFMTSCHEDULELINEQ.MANDT == TVAK.MANDT
  • C_SLSORDFLFMTSCHEDULELINEQ.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • C_SLSORDFLFMTSCHEDULELINEQ.MANDT == TVKO.MANDT
  • C_SLSORDFLFMTSCHEDULELINEQ.SALESORGANIZATION == TVKO.VKORG