P_SalesVolume

Sales Performance: SalesVolume | view: PSDSLSVOL | Extraction: Not supported | Component: Sales Planning
Tables used: VBRP, SCAL_TT_DATE, SALESPLAN, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, CVI_VEND_LINK
Column Name Description
SDDocument FK Billing Document
SDDocumentItem Billing Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Sales Plan Actual Amount
NetSalesVolumeNetAmount Net Sales Volume
Column Name Description
📏 Base Unit of Measure (BaseUnit):
SalesVolumeQuantity Sales Volume Quantity
Column Name Description
DocumentDate Billing Date
Column Name Description
SalesPlanPurpose Purposes of Sales Planning Show values
Column Name Description Domain name
BillingDocumentType Billing Type FKART
SalesPlan Sales Plan TEXT40
SalesPlanVersion Sales Plan Version TEXT40
CreatedByUser Name of Person Responsible for Creating the Object USNAM
SalesPlanPeriodName Sales Plan Period Name CHAR20
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
SalesDistrict Sales District BZIRK
Customer Sold-to Party KUNNR
CustomerGroup Customer Group KDGRP
ShipToParty Ship-to Party KUNNR
BillToParty Bill-to Party KUNNR
PayerParty Payer KUNNR
SalesEmployee Sales Employee PERNR
ShippingType Shipping Type VERSART
ProfitCenter Profit Center PRCTR
CostCenter Cost Center KOSTL
CompanyCode Company Code BUKRS
Country Destination Country/Region LAND1
Region Region (State, Province, County) REGIO
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • P_SALESVOLUME.MANDT == TVV1.MANDT
  • P_SALESVOLUME.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • P_SALESVOLUME.MANDT == TVV2.MANDT
  • P_SALESVOLUME.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • P_SALESVOLUME.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • P_SALESVOLUME.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • P_SALESVOLUME.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • P_SALESVOLUME.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • P_SALESVOLUME.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • P_SALESVOLUME.MANDT == TVV5.MANDT
Material Group 1
  • Material Group 1
  • Client
  • P_SALESVOLUME.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • P_SALESVOLUME.MANDT == TVM1.MANDT
Material Group 2
  • Client
  • Material Group 2
  • P_SALESVOLUME.MANDT == TVM2.MANDT
  • P_SALESVOLUME.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Material Group 3
  • Client
  • P_SALESVOLUME.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • P_SALESVOLUME.MANDT == TVM3.MANDT
Material Group 4
  • Material Group 4
  • Client
  • P_SALESVOLUME.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • P_SALESVOLUME.MANDT == TVM4.MANDT
Material Group 5
  • Material Group 5
  • Client
  • P_SALESVOLUME.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • P_SALESVOLUME.MANDT == TVM5.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_SALESVOLUME.MANDT == T006.MANDT
  • P_SALESVOLUME.BASEUNIT == T006.MSEHI
Destination Country/Region of Sales Order
  • Client
  • Destination Country/Region of Sales Order
  • P_SALESVOLUME.MANDT == T005.MANDT
  • P_SALESVOLUME.BILLTOPARTYCOUNTRY == T005.LAND1
Region of Sales Order
  • Region of Sales Order
  • Client
  • Destination Country/Region of Sales Order
  • P_SALESVOLUME.BILLTOPARTYREGION == T005S.BLAND
  • P_SALESVOLUME.MANDT == T005S.MANDT
  • P_SALESVOLUME.BILLTOPARTYCOUNTRY == T005S.LAND1
Business Area
  • Business Area
  • Client
  • P_SALESVOLUME.BUSINESSAREA == TGSB.GSBER
  • P_SALESVOLUME.MANDT == TGSB.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_SALESVOLUME.MANDT == TKA01.MANDT
  • P_SALESVOLUME.CONTROLLINGAREA == TKA01.KOKRS
Division
  • Client
  • Division
  • Division
  • P_SALESVOLUME.MANDT == TSPA.MANDT
  • P_SALESVOLUME.ORGANIZATIONDIVISION == TSPA.SPART
  • P_SALESVOLUME.DIVISION == TSPA.SPART
Material Number
  • Client
  • Material Number
  • P_SALESVOLUME.MANDT == MARA.MANDT
  • P_SALESVOLUME.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • P_SALESVOLUME.MATERIALGROUP == T023.MATKL
  • P_SALESVOLUME.MANDT == T023.MANDT
Division
  • Client
  • Division
  • Division
  • P_SALESVOLUME.MANDT == TSPA.MANDT
  • P_SALESVOLUME.ORGANIZATIONDIVISION == TSPA.SPART
  • P_SALESVOLUME.DIVISION == TSPA.SPART
Plant
  • Plant
  • Client
  • P_SALESVOLUME.PLANT == T001W.WERKS
  • P_SALESVOLUME.MANDT == T001W.MANDT
Sales group
  • Sales group
  • Client
  • P_SALESVOLUME.SALESGROUP == TVKGR.VKGRP
  • P_SALESVOLUME.MANDT == TVKGR.MANDT
Sales office
  • Client
  • Sales office
  • P_SALESVOLUME.MANDT == TVBUR.MANDT
  • P_SALESVOLUME.SALESOFFICE == TVBUR.VKBUR