C_SalesOrderNetValue

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