P_SPP_PredictionData

SPP Prediction Data | view: PSDSPPPDA | Extraction: Not supported | Component: Sales Planning
Tables used: VBRPSCAL_TT_DATEMARAKNA1MARATVKO
Column Name Description
YearMonth Year Month
PartOfMonth Part of 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
TargetAmount Net Value in Document Currency
SumAmtByPOM null
MaxAmtByPOM null
MinAmtByPOM null
SumAmtByPOQ null
MaxAmtByPOQ null
MinAmtByPOQ null
SumAmtByPre1Month null
MaxAmtByPre1Month null
MinAmtByPre1Month null
SumAmtByPre1Quarter null
MaxAmtByPre1Quarter null
MinAmtByPre1Quarter null
DiffSumAmtByPOM Net Value in Document Currency
DiffMaxAmtByPOM Net Value in Document Currency
DiffMinAmtByPOM Net Value in Document Currency
DiffSumAmtByPOQ Net Value in Document Currency
DiffMaxAmtByPOQ Net Value in Document Currency
DiffMinAmtByPOQ Net Value in Document Currency
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
PartOfQuarter Part of Quarter INT1
CalendarWeek Calendar Week NUM2
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CityName City TEXT35
CntByPOM null
CntByPOQ null
CntByPre1Month null
CntByPre1Quarter null
DiffCountByPOM 4 Byte Signed Integer INT4
DiffCountByPOQ 4 Byte Signed Integer INT4
Master Data Relations Join Conditions
Company code of the sales organization
  • Company code of the sales organization
  • Client
  • P_SPP_PREDICTIONDATA.COMPANYCODE == T001.BUKRS
  • P_SPP_PREDICTIONDATA.MANDT == T001.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • P_SPP_PREDICTIONDATA.MANDT == T005.MANDT
  • P_SPP_PREDICTIONDATA.COUNTRY == T005.LAND1
Customer Account Group
  • Customer Account Group
  • Client
  • P_SPP_PREDICTIONDATA.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • P_SPP_PREDICTIONDATA.MANDT == T077D.MANDT
Customer Classification
  • Client
  • Customer Classification
  • P_SPP_PREDICTIONDATA.MANDT == TKUKL.MANDT
  • P_SPP_PREDICTIONDATA.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Division
  • Client
  • Division
  • P_SPP_PREDICTIONDATA.MANDT == TSPA.MANDT
  • P_SPP_PREDICTIONDATA.DIVISION == TSPA.SPART
Industry key
  • Industry key
  • Client
  • P_SPP_PREDICTIONDATA.INDUSTRY == T016.BRSCH
  • P_SPP_PREDICTIONDATA.MANDT == T016.MANDT
Material Number
  • Material Number
  • Client
  • P_SPP_PREDICTIONDATA.MATERIAL == MARA.MATNR
  • P_SPP_PREDICTIONDATA.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_SPP_PREDICTIONDATA.MATERIALGROUP == T023.MATKL
  • P_SPP_PREDICTIONDATA.MANDT == T023.MANDT
Product Type
  • Client
  • Product Type
  • P_SPP_PREDICTIONDATA.MANDT == T134.MANDT
  • P_SPP_PREDICTIONDATA.PRODUCTTYPE == T134.MTART