I_ProfitMarginByMonthCube

Profit Margin by Month Cube | view: ISDPRFTMARGBYMHC | TRAN | 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
Column Name Description Domain name
BillingDocumentType Billing Type FKART
BillingDocDateYearMonth Month/Year of Billing NUM6
YearMonth Year Month NUM6
CalendarMonth Calendar Month NUM2
SoldToParty Sold-to Party KUNNR
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Master Data Relations Join Conditions
Division for order header
  • Division for order header
  • Client
  • I_PROFITMARGINBYMONTHCUBE.ORGANIZATIONDIVISION == TSPA.SPART
  • I_PROFITMARGINBYMONTHCUBE.MANDT == TSPA.MANDT
Product hierarchy
  • Product hierarchy
  • Client
  • I_PROFITMARGINBYMONTHCUBE.PRODUCTHIERARCHYNODE == T179.PRODH
  • I_PROFITMARGINBYMONTHCUBE.MANDT == T179.MANDT
Sales group
  • Client
  • Sales group
  • I_PROFITMARGINBYMONTHCUBE.MANDT == TVKGR.MANDT
  • I_PROFITMARGINBYMONTHCUBE.SALESGROUP == TVKGR.VKGRP
Sales office
  • Sales office
  • Client
  • I_PROFITMARGINBYMONTHCUBE.SALESOFFICE == TVBUR.VKBUR
  • I_PROFITMARGINBYMONTHCUBE.MANDT == TVBUR.MANDT