C_SalesOrderFrequency

Frequency of Sales Orders | view: CSLSORDFRQCY | Extraction: Not supported | Component: Sales
Tables used: SCAL_TT_DATEVBKDVEDAVBAKT247
Column Name Description
SalesOrder Sales Order
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CalendarMonth Calendar Month NUM2
YearMonth Year Month NUM6
SalesOrderDateYearMonth null
NumberOfSalesOrders Number of Sales Orders INT4
AverageSalesOrderValue Average of Sales Order
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_SALESORDERFREQUENCY.MANDT == TVKOV.MANDT
  • C_SALESORDERFREQUENCY.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESORDERFREQUENCY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Division
  • Client
  • Sales Organization
  • Distribution Channel
  • C_SALESORDERFREQUENCY.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESORDERFREQUENCY.MANDT == TVTA.MANDT
  • C_SALESORDERFREQUENCY.SALESORGANIZATION == TVTA.VKORG
  • C_SALESORDERFREQUENCY.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales group
  • Client
  • Sales office
  • Sales group
  • C_SALESORDERFREQUENCY.MANDT == TVBVK.MANDT
  • C_SALESORDERFREQUENCY.SALESOFFICE == TVBVK.VKBUR
  • C_SALESORDERFREQUENCY.SALESGROUP == TVBVK.VKGRP
Order type in order header
  • Sales Order Type
  • Client
  • C_SALESORDERFREQUENCY.SALESORDERTYPE == TVAK.AUART
  • C_SALESORDERFREQUENCY.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • C_SALESORDERFREQUENCY.MANDT == TVKO.MANDT
  • C_SALESORDERFREQUENCY.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • C_SALESORDERFREQUENCY.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESORDERFREQUENCY.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Client
  • Sales office
  • Sales Organization
  • Distribution Channel
  • C_SALESORDERFREQUENCY.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_SALESORDERFREQUENCY.MANDT == TVKBZ.MANDT
  • C_SALESORDERFREQUENCY.SALESOFFICE == TVKBZ.VKBUR
  • C_SALESORDERFREQUENCY.SALESORGANIZATION == TVKBZ.VKORG
  • C_SALESORDERFREQUENCY.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG