I_PrdtdSlsPerfTrainingData

Sales Perf Prediction Training Data | view: ISDPSPTD | 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 Division
SoldToParty Sold-to Party
CustomerGroup Customer Group
Material Material Number
MaterialGroup 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
  • Client
  • Company code of the sales organization
  • I_PRDTDSLSPERFTRAININGDATA.MANDT == T001.MANDT
  • I_PRDTDSLSPERFTRAININGDATA.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • I_PRDTDSLSPERFTRAININGDATA.MANDT == T005.MANDT
  • I_PRDTDSLSPERFTRAININGDATA.COUNTRY == T005.LAND1
Customer Account Group
  • Customer Account Group
  • Client
  • I_PRDTDSLSPERFTRAININGDATA.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • I_PRDTDSLSPERFTRAININGDATA.MANDT == T077D.MANDT
Customer Classification
  • Customer Classification
  • Client
  • I_PRDTDSLSPERFTRAININGDATA.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • I_PRDTDSLSPERFTRAININGDATA.MANDT == TKUKL.MANDT
Industry key
  • Client
  • Industry key
  • I_PRDTDSLSPERFTRAININGDATA.MANDT == T016.MANDT
  • I_PRDTDSLSPERFTRAININGDATA.INDUSTRY == T016.BRSCH
Product Type
  • Client
  • Product Type
  • I_PRDTDSLSPERFTRAININGDATA.MANDT == T134.MANDT
  • I_PRDTDSLSPERFTRAININGDATA.PRODUCTTYPE == T134.MTART