P_SalesOrderFrequency

Sales Order Frequency | view: PSLSORDFRQCY | Extraction: Not supported | Component: Sales
Tables used: SCAL_TT_DATEVBKDVEDAVBAK
Column Name Description
SalesOrder Sales Order
Column Name Description
💲 SD Document Currency (TransactionCurrency):
IncomingSalesOrdersNetAmount null
Column Name Description
Column Name Description
CreationDate Date on which the record was created
Column Name Description
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser User Who Last Changed the Business Document USNAM
CalendarMonth Calendar Month NUM2
CalendarYear Calendar Year NUM4
YearMonth Year Month NUM6
Master Data Relations Join Conditions
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • P_SALESORDERFREQUENCY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SALESORDERFREQUENCY.MANDT == TVKOV.MANDT
  • P_SALESORDERFREQUENCY.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Distribution Channel
  • Client
  • Division
  • Sales Organization
  • P_SALESORDERFREQUENCY.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SALESORDERFREQUENCY.MANDT == TVTA.MANDT
  • P_SALESORDERFREQUENCY.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SALESORDERFREQUENCY.SALESORGANIZATION == TVTA.VKORG
Sales group
  • Sales office
  • Sales group
  • Client
  • P_SALESORDERFREQUENCY.SALESOFFICE == TVBVK.VKBUR
  • P_SALESORDERFREQUENCY.SALESGROUP == TVBVK.VKGRP
  • P_SALESORDERFREQUENCY.MANDT == TVBVK.MANDT
Order type in order header
  • Sales Order Type
  • Client
  • P_SALESORDERFREQUENCY.SALESORDERTYPE == TVAK.AUART
  • P_SALESORDERFREQUENCY.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • P_SALESORDERFREQUENCY.MANDT == TVKO.MANDT
  • P_SALESORDERFREQUENCY.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • P_SALESORDERFREQUENCY.MANDT == KNA1.MANDT
  • P_SALESORDERFREQUENCY.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • P_SALESORDERFREQUENCY.MANDT == TCURC.MANDT
  • P_SALESORDERFREQUENCY.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Distribution Channel
  • Sales office
  • Client
  • Division
  • Sales Organization
  • P_SALESORDERFREQUENCY.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_SALESORDERFREQUENCY.SALESOFFICE == TVKBZ.VKBUR
  • P_SALESORDERFREQUENCY.MANDT == TVKBZ.MANDT
  • P_SALESORDERFREQUENCY.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_SALESORDERFREQUENCY.SALESORGANIZATION == TVKBZ.VKORG