P_SalesOrderCnvrtdAmount

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