C_ProfitMarginByMonthQuery

Profit Margin by Month | view: CSDPRFTMARGBYMHQ | Extraction: Not supported | Component: Sales Analytics
Tables used: VBRPSCAL_TT_DATE
Column Name Description
BillingDocument FK Billing Document
BillingDocumentItem Billing Item
Column Name Description
💲 Display Currency (DisplayCurrency):
SlsVolumeNetAmtInDspCrcy Net Value of Invoiced Sales
SlsProfitMargNetAmtInDspCrcy Profit Margin Amount in Display Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CalendarMonth Calendar Month NUM2
CalendarMonthName Short Text for Fixed Values DDTEXT
YearMonth Year Month NUM6
BillingDocDateYearMonth Month/Year of Billing NUM6
SoldToParty Sold-to Party KUNNR
DistributionChannel Distribution Channel VTWEG
SalesOrganization Sales Organization VKORG
SalesProfitMargin Profit Margin Ratio
Master Data Relations Join Conditions
Division for order header
  • Division for order header
  • Client
  • C_PROFITMARGINBYMONTHQUERY.ORGANIZATIONDIVISION == TSPA.SPART
  • C_PROFITMARGINBYMONTHQUERY.MANDT == TSPA.MANDT
Product hierarchy
  • Product hierarchy
  • Client
  • C_PROFITMARGINBYMONTHQUERY.PRODUCTHIERARCHYNODE == T179.PRODH
  • C_PROFITMARGINBYMONTHQUERY.MANDT == T179.MANDT
Sales group
  • Client
  • Sales group
  • C_PROFITMARGINBYMONTHQUERY.MANDT == TVKGR.MANDT
  • C_PROFITMARGINBYMONTHQUERY.SALESGROUP == TVKGR.VKGRP
Sales office
  • Sales office
  • Client
  • C_PROFITMARGINBYMONTHQUERY.SALESOFFICE == TVBUR.VKBUR
  • C_PROFITMARGINBYMONTHQUERY.MANDT == TVBUR.MANDT