P_ProfitMarginByMonth

Profit Margin by Month | view: PSDPRFTMRGNBYMH | Extraction: Not supported | Component: Sales Analytics
Tables used: VBRPSCAL_TT_DATE
Column Name Description
BillingDocument FK Billing Document
BillingDocumentItem Billing Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
SalesVolumeNetAmount Net Value in Document Currency
SalesProfitMarginNetAmount Net Amount of Profit Margin
Column Name Description
Column Name Description
BillingDocumentDate Billing Date
Column Name Description
SDDocumentCategory SD Document Category Show values
Column Name Description Domain name
BillingDocumentType Billing Type FKART
BillingDocDateYearMonth Month/Year of Billing NUM6
SoldToParty Sold-to Party KUNNR
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Master Data Relations Join Conditions
Division for order header
  • Client
  • Division for order header
  • P_PROFITMARGINBYMONTH.MANDT == TSPA.MANDT
  • P_PROFITMARGINBYMONTH.ORGANIZATIONDIVISION == TSPA.SPART
Product hierarchy
  • Client
  • Product hierarchy
  • P_PROFITMARGINBYMONTH.MANDT == T179.MANDT
  • P_PROFITMARGINBYMONTH.PRODUCTHIERARCHYNODE == T179.PRODH
Sales group
  • Sales group
  • Client
  • P_PROFITMARGINBYMONTH.SALESGROUP == TVKGR.VKGRP
  • P_PROFITMARGINBYMONTH.MANDT == TVKGR.MANDT
Sales office
  • Client
  • Sales office
  • P_PROFITMARGINBYMONTH.MANDT == TVBUR.MANDT
  • P_PROFITMARGINBYMONTH.SALESOFFICE == TVBUR.VKBUR