I_PrdtdSlsPerfApplyingData

Sales Perf Prediction Applying Data | view: ISDPSPAD | Extraction: Not supported | Component: Sales Planning
Tables used: VBRPSCAL_TT_DATEMARAKNA1MARATVKO
Column Name Description
YearMonth Year Month
SalesVolumePartOfMonth Three ten-day periods within one month
SalesOrganization Sales Organization
DistributionChannel Distribution Channel
Division FK Division
SoldToParty Sold-to Party
CustomerGroup Customer Group
Material FK Material Number
MaterialGroup FK Material Group
BillingDocumentType Billing Type
Column Name Description
💲 Display Currency (DisplayCurrency):
SalesVolumeTargetAmtInDC Predicted sales volume on a monthly basis
SlsVolPrtOfMnthSumAmtInDC Sum of sales volume of month parts
SlsVolPrtOfMnthMaxAmtInDC The maximum sales volume of all three parts within one month
SlsVolPrtOfMnthMinAmtInDC The minimum sales volume of all three parts within one month
SlsVolPrtOfQtrSumAmtInDC Sum of sales volume of quarter parts
SlsVolPrtOfQtrMaxAmtInDC The maximum sales volume of all nine quarter parts
SlsVolPrtOfQtrMinAmtInDC The minimum sales volume of all nine quarter parts
SlsVolPrevMnthSumAmtInDC Sum of sales volume of previous month parts
SlsVolPrevMnthMaxAmtInDC Maximum sales volume of all three parts of previous month
SlsVolPrevMnthMinAmtInDC Minimum sales volume of all three parts of previous month
SlsVolPrevQtrSumAmtInDC Sum of sales volume of previous quarter parts
SlsVolPrevQtrMaxAmtInDC Maximum sales volume of all nine parts of previous quarter
SlsVolPrevQtrMinAmtInDC Minimum sales volume of all nine parts of previous quarter
SlsVolDiffMnthSumAmtInDC Sales volume sum difference between current and prev.month
SlsVolDiffMnthMaxAmtInDC Max.sales volume difference between current and prev. months
SlsVolDiffMnthMinAmtInDC Min. sales volume difference between current and prev.months
SlsVolDiffQtrSumAmtInDC Sls volume sum difference between current and prev.quarters
SlsVolDiffQtrMaxAmtInDC Max.sls volume difference between current and prev.quarters
SlsVolDiffQtrMinAmtInDC Min.sls volume difference between current and prev.quarters
Column Name Description
Column Name Description
Column Name Description
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
YearQuarter Year Quarter NUM5
SalesVolumePrtOfQtr Part of Quarter SPP_INT1
CalendarWeek Calendar Week NUM2
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CityName City TEXT35
NumberOfSlsVolByPrtOfMnth Number of month parts for which the sales volume is not 0 SPP_INT4
NumberOfSlsVolByPrtOfQtr Number of quarter parts for which the sales volume is not 0 SPP_INT4
NumberOfSlsVolByPrevMnth No. of previous month parts for which sales volume is not 0 SPP_INT4
NumberOfSlsVolByPrevQtr No.of previous quarter parts for which sales volume is not 0 SPP_INT4
NumberOfSlsVolDiffByMonth Month part difference between current and previous months SPP_INT4
NumberOfSlsVolDiffByQtr Quarter part difference between current and prev. quarters SPP_INT4
Master Data Relations Join Conditions
Company code of the sales organization
  • Company code of the sales organization
  • Client
  • I_PRDTDSLSPERFAPPLYINGDATA.COMPANYCODE == T001.BUKRS
  • I_PRDTDSLSPERFAPPLYINGDATA.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_PRDTDSLSPERFAPPLYINGDATA.COUNTRY == T005.LAND1
  • I_PRDTDSLSPERFAPPLYINGDATA.MANDT == T005.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • I_PRDTDSLSPERFAPPLYINGDATA.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • I_PRDTDSLSPERFAPPLYINGDATA.MANDT == T077D.MANDT
Customer Classification
  • Customer Classification
  • Client
  • I_PRDTDSLSPERFAPPLYINGDATA.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • I_PRDTDSLSPERFAPPLYINGDATA.MANDT == TKUKL.MANDT
Division
  • Division
  • Client
  • I_PRDTDSLSPERFAPPLYINGDATA.DIVISION == TSPA.SPART
  • I_PRDTDSLSPERFAPPLYINGDATA.MANDT == TSPA.MANDT
Industry key
  • Industry key
  • Client
  • I_PRDTDSLSPERFAPPLYINGDATA.INDUSTRY == T016.BRSCH
  • I_PRDTDSLSPERFAPPLYINGDATA.MANDT == T016.MANDT
Material Number
  • Material Number
  • Client
  • I_PRDTDSLSPERFAPPLYINGDATA.MATERIAL == MARA.MATNR
  • I_PRDTDSLSPERFAPPLYINGDATA.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_PRDTDSLSPERFAPPLYINGDATA.MATERIALGROUP == T023.MATKL
  • I_PRDTDSLSPERFAPPLYINGDATA.MANDT == T023.MANDT
Product Type
  • Product Type
  • Client
  • I_PRDTDSLSPERFAPPLYINGDATA.PRODUCTTYPE == T134.MTART
  • I_PRDTDSLSPERFAPPLYINGDATA.MANDT == T134.MANDT