C_SalesVolumeAnalysisQuery

Analytics - Sales Volume Detailed Analysis | view: CSDSLSVOLANLYSQ | Extraction: Not supported | Component: Sales Analytics
Column Name Description
BillingDocument FK Billing Document
BillingDocumentItem Billing Document Item
Column Name Description
💲 Display Currency (DisplayCurrency):
SlsVolumeNetAmtInDspCrcy Net Value of Invoiced Sales
Column Name Description
📏 Base Unit of Measure (BaseUnit):
SalesVolumeQuantity Sales Volume Quantity
Column Name Description
BillingDocumentDate Billing Date
Column Name Description
Column Name Description Domain name
BillingDocumentType Billing Type FKART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
CustomerGroup Customer Group KDGRP
Customer Sold-to Party KUNNR
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
BusinessSolutionOrderItem Solution Order Item CRMS4_NUMBER_INT
BillingDocumentDateYear Year of Billing NUM4
BillingDocDateYearQuarter Quarter/Year of Billing NUM5
BillingDocDateYearMonth Month/Year of Billing NUM6
SalesVolumePercentage null
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_SALESVOLUMEANALYSISQUERY.BASEUNIT == T006.MSEHI
  • C_SALESVOLUMEANALYSISQUERY.MANDT == T006.MANDT
Division
  • Division
  • Client
  • C_SALESVOLUMEANALYSISQUERY.DIVISION == TSPA.SPART
  • C_SALESVOLUMEANALYSISQUERY.MANDT == TSPA.MANDT
Material Number
  • Material Number
  • Product Number
  • Client
  • C_SALESVOLUMEANALYSISQUERY.MATERIAL == MARA.MATNR
  • C_SALESVOLUMEANALYSISQUERY.PRODUCT == MARA.MATNR
  • C_SALESVOLUMEANALYSISQUERY.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Product Group
  • Client
  • C_SALESVOLUMEANALYSISQUERY.MATERIALGROUP == T023.MATKL
  • C_SALESVOLUMEANALYSISQUERY.PRODUCTGROUP == T023.MATKL
  • C_SALESVOLUMEANALYSISQUERY.MANDT == T023.MANDT
Organization Division
  • Organization Division
  • Client
  • C_SALESVOLUMEANALYSISQUERY.ORGANIZATIONDIVISION == TSPA.SPART
  • C_SALESVOLUMEANALYSISQUERY.MANDT == TSPA.MANDT
Product Number
  • Material Number
  • Product Number
  • Client
  • C_SALESVOLUMEANALYSISQUERY.MATERIAL == MARA.MATNR
  • C_SALESVOLUMEANALYSISQUERY.PRODUCT == MARA.MATNR
  • C_SALESVOLUMEANALYSISQUERY.MANDT == MARA.MANDT
Product Group
  • Material Group
  • Product Group
  • Client
  • C_SALESVOLUMEANALYSISQUERY.MATERIALGROUP == T023.MATKL
  • C_SALESVOLUMEANALYSISQUERY.PRODUCTGROUP == T023.MATKL
  • C_SALESVOLUMEANALYSISQUERY.MANDT == T023.MANDT