C_SalesVolumeAnalyticsQry

Sales Volume - Query | view: CSDSALESVLMQ | Extraction: Not supported | Component: Sales Analytics
Tables used: VBRP, VBRK, SCAL_TT_DATE, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, /CPD/D_MP_HDR, /CPD/D_MP_ITEM, BUT000, T001, TKA02, TKA01, KNA1, T042Z, T042ZT, T001W, KONA, TVKO, T000, T001L, USR21, PROJ
Column Name Description
BillingDocument FK Billing Document
BillingDocumentItem Billing Document Item
Column Name Description
💲 Display Currency (DisplayCurrency):
NetAmountInDisplayCurrency Net Value in Display Currency
SlsVolumeNetAmtInDspCrcy Net Value of Invoiced Sales
CancldSlsVolumeNetAmtInDspCrcy Canceled Sales Volume Net Amount In Display Currency
SlsProfitMargNetAmtInDspCrcy Profit Margin Amount in Display Currency
CustCrdtMemoNetAmtInDspCrcy Net Value of Credit Memos
CustCrdtMemoPrftMargNetAmtInDC Credit Memo Profit Margin Net Value in Display Currency
NetSlsVolumeNetAmtInDC Net Sales Volume in Display Currency
NetSlsProfitMargNetAmtInDC Net Profit Margin Net Value in Display Currency
NetSalesCostAmountInDC Net Sales Cost Amount in Display Currency
Column Name Description
Column Name Description
LastChangeDate Last Changed On
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
BillingDocumentDate Billing Date
ServicesRenderedDate Date on which services are rendered
PricingDate Date for Pricing and Exchange Rate
FixedValueDate Fixed Value Date
ExchangeRateDate Translation date
Column Name Description
SDDocumentCategory SD Document Category Show values
BillingDocumentCategory Billing Category Show values
SalesDocumentItemType Sales Document Item Type Show values
ReturnItemProcessingType Processing Type of Return Item Show values
ItemIsRelevantForCredit Item Relevant for Credit Check Show values
BillingDocumentIsCancelled Billing Document Is Canceled Show values
ManualInvoiceMaintIsRelevant Manual Invoice Maintenance Show values
BillingPlanRule Rule in billing plan/invoice plan Show values
VATRegistrationOrigin Origin of Sales Tax ID Number Show values
AccountingExchangeRateIsSet Exchange Rate Setting Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SalesSDDocumentCategory Sales SD Document Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallBillingStatus Overall Billing Status Show values
AccountingPostingStatus Posting Status of Billing Document Show values
AccountingTransferStatus Status for Transfer to Accounting Show values
BillingIssueType Billing Document Issue Type Show values
InvoiceListStatus Invoice list status of billing document Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
Column Name Description Domain name
BillingDocumentType Billing Type FKART
SalesDocumentItemCategory Sales Document Item Category PSTYV
SalesProfitMargin Profit Margin Ratio
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreatedByUserName User Description SUIDTECHDESC
LogicalSystem Logical system LOGSYS
CreationDateYear Year of Creation NUM4
CreationDateYearQuarter Year/Quarter of Creation NUM5
CreationDateYearMonth Year/Month of Creation NUM6
BillingDocumentDateYear Year of Billing NUM4
BillingDocDateYearQuarter Quarter/Year of Billing NUM5
BillingDocDateYearMonth Month/Year of Billing NUM6
SoldToParty Sold-to Party KUNNR
Customer Customer Number KUNNR
ShipToParty Ship-to Party KUNNR
BillToParty Bill-to Party KUNNR
PayerParty Payer KUNNR
SalesEmployee Sales Employee PERNR
ResponsibleEmployee Employee Responsible PERNR
PurchaseOrderByCustomer Customer Reference BSTKD
CustomerGroup Customer Group KDGRP
SalesDistrict Sales District BZIRK
CustomerRebateAgreement Customer Rebate Agreement KNUMA
SalesDealDescription Sales Deal Description TEXT40
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
ForeignTrade Number of foreign trade data in MM and SD documents EXNUM
IsExportDelivery Export Delivery Indicator EXPKZ
BillingDocCombinationCriteria Combination criteria in the billing document CHAR40
BillingDocumentItemText Short Text for Billing Document Item TEXT40
BillingToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
BillingToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
BillingPlanItem Item for Billing Plan/Invoice Plan/Payment Cards FPLTR
CustomerPriceGroup Customer Price Group KONDA
TaxDepartureCountry Tax Departure Country/Region LAND1
VATRegistration VAT Registration Number STCEG
VATRegistrationCountry Country/Region of Sales Tax ID Number LAND1
CustomerTaxClassification1 Tax Classification 1 for Customer TAXKD
CustomerTaxClassification2 Tax Classification 2 for Customer TAXKD
CustomerTaxClassification3 Tax Classification 3 for Customer TAXKD
CustomerTaxClassification4 Tax Classification 4 for Customer TAXKD
CustomerTaxClassification5 Tax Classification 5 for Customer TAXKD
CustomerTaxClassification6 Tax Classification 6 for Customer TAXKD
CustomerTaxClassification7 Tax Classification 7 for Customer TAXKD
CustomerTaxClassification8 Tax Classification 8 for Customer TAXKD
CustomerTaxClassification9 Tax Classification 9 for Customer TAXKD
IncotermsTransferLocation Incoterms (Part 2) INCO2
ContractAccount Contract Account Number CORR_VKONT_KK
CustomerPaymentTerms Terms of payment key ZTERM
PaymentReference Payment Reference CHAR30
AdditionalValueDays Additional Value Days TAGE2
EngagementProjectName Customer Project Name /CPD/SHORT_TEXT
FiscalYear Fiscal Year GJAHR
AccountingDocument Journal Entry Number BELNR
FiscalPeriod Posting period POPER
DocumentReferenceID Document Reference ID XBLNR1
AssignmentReference Assignment Number ZUONR
InternalFinancialDocument Financial doc. processing: Internal financial doc. number LCNUM
ProfitCenter Profit Center PRCTR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
CostCenter Cost Center KOSTL
OriginSDDocument Originating Document VBELN
OriginSDDocumentItem Originating SD Document Item POSNR
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVV1.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVV2.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVV3.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVV4.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • C_SALESVOLUMEANALYTICSQRY.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVV5.MANDT
Material Group 1
  • Client
  • Material Group 1
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVM1.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVM2.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVM3.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVM4.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVM5.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T006.MANDT
  • C_SALESVOLUMEANALYTICSQRY.BASEUNIT == T006.MSEHI
Batch Number
  • Client
  • Plant
  • Batch Number
  • Product Number
  • Material Number
  • C_SALESVOLUMEANALYTICSQRY.MANDT == MCHA.MANDT
  • C_SALESVOLUMEANALYTICSQRY.PLANT == MCHA.WERKS
  • C_SALESVOLUMEANALYTICSQRY.BATCH == MCHA.CHARG
  • C_SALESVOLUMEANALYTICSQRY.PRODUCT == MCHA.MATNR
  • C_SALESVOLUMEANALYTICSQRY.MATERIAL == MCHA.MATNR
Sales unit
  • Client
  • Sales unit
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T006.MANDT
  • C_SALESVOLUMEANALYTICSQRY.BILLINGQUANTITYUNIT == T006.MSEHI
Destination Country/Region of Sales Order
  • Client
  • Destination Country/Region of Sales Order
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T005.MANDT
  • C_SALESVOLUMEANALYTICSQRY.BILLTOPARTYCOUNTRY == T005.LAND1
Region of Sales Order
  • Client
  • Region of Sales Order
  • Destination Country/Region of Sales Order
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T005S.MANDT
  • C_SALESVOLUMEANALYTICSQRY.BILLTOPARTYREGION == T005S.BLAND
  • C_SALESVOLUMEANALYTICSQRY.BILLTOPARTYCOUNTRY == T005S.LAND1
Business Area
  • Client
  • Business Area
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TGSB.MANDT
  • C_SALESVOLUMEANALYTICSQRY.BUSINESSAREA == TGSB.GSBER
City Code
  • Destination Country/Region
  • Client
  • Region (State, Province, County)
  • City Code
  • C_SALESVOLUMEANALYTICSQRY.COUNTRY == T005G.LAND1
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T005G.MANDT
  • C_SALESVOLUMEANALYTICSQRY.REGION == T005G.REGIO
  • C_SALESVOLUMEANALYTICSQRY.CITYCODE == T005G.CITYC
Company Code
  • Client
  • Company Code
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T001.MANDT
  • C_SALESVOLUMEANALYTICSQRY.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TKA01.MANDT
  • C_SALESVOLUMEANALYTICSQRY.CONTROLLINGAREA == TKA01.KOKRS
Destination Country/Region
  • Destination Country/Region
  • Client
  • C_SALESVOLUMEANALYTICSQRY.COUNTRY == T005.LAND1
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T005.MANDT
County Code
  • County Code
  • Destination Country/Region
  • Client
  • Region (State, Province, County)
  • C_SALESVOLUMEANALYTICSQRY.COUNTY == T005E.COUNC
  • C_SALESVOLUMEANALYTICSQRY.COUNTRY == T005E.LAND1
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T005E.MANDT
  • C_SALESVOLUMEANALYTICSQRY.REGION == T005E.REGIO
Credit control area
  • Client
  • Credit control area
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T014.MANDT
  • C_SALESVOLUMEANALYTICSQRY.CREDITCONTROLAREA == T014.KKBER
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVKT.MANDT
  • C_SALESVOLUMEANALYTICSQRY.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
Division
  • Client
  • Division
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TSPA.MANDT
  • C_SALESVOLUMEANALYTICSQRY.DIVISION == TSPA.SPART
Dunning Area
  • Client
  • Company Code
  • Dunning Area
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T047M.MANDT
  • C_SALESVOLUMEANALYTICSQRY.COMPANYCODE == T047M.BUKRS
  • C_SALESVOLUMEANALYTICSQRY.DUNNINGAREA == T047M.MABER
Dunning Block
  • Client
  • Dunning Block
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T040S.MANDT
  • C_SALESVOLUMEANALYTICSQRY.DUNNINGBLOCKINGREASON == T040S.MANSP
Dunning Key
  • Client
  • Dunning Key
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T040.MANDT
  • C_SALESVOLUMEANALYTICSQRY.DUNNINGKEY == T040.MSCHL
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TCURV.MANDT
  • C_SALESVOLUMEANALYTICSQRY.EXCHANGERATETYPE == TCURV.KURST
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TINC.MANDT
  • C_SALESVOLUMEANALYTICSQRY.INCOTERMSCLASSIFICATION == TINC.INCO1
Volume unit
  • Client
  • Volume unit
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T006.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T006.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ITEMWEIGHTUNIT == T006.MSEHI
Material Number
  • Client
  • Product Number
  • Material Number
  • C_SALESVOLUMEANALYTICSQRY.MANDT == MARA.MANDT
  • C_SALESVOLUMEANALYTICSQRY.PRODUCT == MARA.MATNR
  • C_SALESVOLUMEANALYTICSQRY.MATERIAL == MARA.MATNR
Commission Group
  • Client
  • Commission Group
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVPR.MANDT
  • C_SALESVOLUMEANALYTICSQRY.MATERIALCOMMISSIONGROUP == TVPR.PROVG
Material Group
  • Client
  • Product Group
  • Material Group
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T023.MANDT
  • C_SALESVOLUMEANALYTICSQRY.PRODUCTGROUP == T023.MATKL
  • C_SALESVOLUMEANALYTICSQRY.MATERIALGROUP == T023.MATKL
Order Number
  • Client
  • Order Number
  • C_SALESVOLUMEANALYTICSQRY.MANDT == AUFK.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ORDERID == AUFK.AUFNR
Organization Division
  • Client
  • Organization Division
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TSPA.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ORGANIZATIONDIVISION == TSPA.SPART
Material Entered
  • Client
  • Material Entered
  • C_SALESVOLUMEANALYTICSQRY.MANDT == MARA.MANDT
  • C_SALESVOLUMEANALYTICSQRY.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T880.MANDT
  • C_SALESVOLUMEANALYTICSQRY.PARTNERCOMPANY == T880.RCOMP
Payment Method
  • Destination Country/Region
  • Client
  • Payment Method
  • C_SALESVOLUMEANALYTICSQRY.COUNTRY == T042Z.LAND1
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T042Z.MANDT
  • C_SALESVOLUMEANALYTICSQRY.PAYMENTMETHOD == T042Z.ZLSCH
Plant
  • Client
  • Plant
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T001W.MANDT
  • C_SALESVOLUMEANALYTICSQRY.PLANT == T001W.WERKS
Price List Type
  • Client
  • Price List Type
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T189.MANDT
  • C_SALESVOLUMEANALYTICSQRY.PRICELISTTYPE == T189.PLTYP
Pricing Reference Material
  • Client
  • Pricing Reference Material
  • C_SALESVOLUMEANALYTICSQRY.MANDT == MARA.MANDT
  • C_SALESVOLUMEANALYTICSQRY.PRICINGREFERENCEMATERIAL == MARA.MATNR
Product Number
  • Client
  • Product Number
  • Material Number
  • C_SALESVOLUMEANALYTICSQRY.MANDT == MARA.MANDT
  • C_SALESVOLUMEANALYTICSQRY.PRODUCT == MARA.MATNR
  • C_SALESVOLUMEANALYTICSQRY.MATERIAL == MARA.MATNR
Product Group
  • Client
  • Product Group
  • Material Group
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T023.MANDT
  • C_SALESVOLUMEANALYTICSQRY.PRODUCTGROUP == T023.MATKL
  • C_SALESVOLUMEANALYTICSQRY.MATERIALGROUP == T023.MATKL
Product hierarchy
  • Client
  • Product hierarchy
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T179.MANDT
  • C_SALESVOLUMEANALYTICSQRY.PRODUCTHIERARCHYNODE == T179.PRODH
Region (State, Province, County)
  • Destination Country/Region
  • Client
  • Region (State, Province, County)
  • C_SALESVOLUMEANALYTICSQRY.COUNTRY == T005S.LAND1
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T005S.MANDT
  • C_SALESVOLUMEANALYTICSQRY.REGION == T005S.BLAND
Retail Promotion
  • Retail Promotion
  • Client
  • C_SALESVOLUMEANALYTICSQRY.RETAILPROMOTION == WAKH.AKTNR
  • C_SALESVOLUMEANALYTICSQRY.MANDT == WAKH.MANDT
Sales Deal
  • Client
  • Sales Deal
  • C_SALESVOLUMEANALYTICSQRY.MANDT == KONA.MANDT
  • C_SALESVOLUMEANALYTICSQRY.SALESDEAL == KONA.KNUMA
Sales group
  • Client
  • Sales group
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVKGR.MANDT
  • C_SALESVOLUMEANALYTICSQRY.SALESGROUP == TVKGR.VKGRP
Sales office
  • Client
  • Sales office
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVBUR.MANDT
  • C_SALESVOLUMEANALYTICSQRY.SALESOFFICE == TVBUR.VKBUR
Sales Promotion
  • Client
  • Sales Promotion
  • C_SALESVOLUMEANALYTICSQRY.MANDT == KONA.MANDT
  • C_SALESVOLUMEANALYTICSQRY.SALESPROMOTION == KONA.KNUMA
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVAU.MANDT
  • C_SALESVOLUMEANALYTICSQRY.SDDOCUMENTREASON == TVAU.AUGRU
Pricing Procedure in Pricing
  • Client
  • ?
  • ?
  • Pricing Procedure in Pricing
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T683.MANDT
  • C_SALESVOLUMEANALYTICSQRY.[column in domain "KAPPL"] == T683.KAPPL
  • C_SALESVOLUMEANALYTICSQRY.[column in domain "KVEWE"] == T683.KVEWE
  • C_SALESVOLUMEANALYTICSQRY.SDPRICINGPROCEDURE == T683.KALSM
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVSB.MANDT
  • C_SALESVOLUMEANALYTICSQRY.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVST.MANDT
  • C_SALESVOLUMEANALYTICSQRY.SHIPPINGPOINT == TVST.VSTEL
Customer Classification
  • Customer Classification
  • Client
  • C_SALESVOLUMEANALYTICSQRY.SOLDTOPARTYCLASSIFICATION == TKUKL.KUKLA
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TKUKL.MANDT
Storage location
  • Client
  • Plant
  • Storage location
  • C_SALESVOLUMEANALYTICSQRY.MANDT == T001L.MANDT
  • C_SALESVOLUMEANALYTICSQRY.PLANT == T001L.WERKS
  • C_SALESVOLUMEANALYTICSQRY.STORAGELOCATION == T001L.LGORT
Volume rebate group
  • Client
  • Volume rebate group
  • C_SALESVOLUMEANALYTICSQRY.MANDT == TVBO.MANDT
  • C_SALESVOLUMEANALYTICSQRY.VOLUMEREBATEGROUP == TVBO.BONUS