P_SI4_TrainingData06

Sales Performance Prediction | view: PSDSI4TD06 | Extraction: Not supported | Component: Sales Planning
Tables used: VBRPSCAL_TT_DATE
Column Name Description
YearMonth Year Month
PartOfMonth Part of Month
SoldToParty Sold-to Party
SalesOrganization Sales Organization
DistributionChannel Distribution Channel
Division FK Division
Material FK Material Number
MaterialGroup FK Material Group
CustomerGroup Customer Group
Column Name Description
SumAmtByPOM Net Value in Document Currency
MaxAmtByPOM Net Value in Document Currency
MinAmtByPOM Net Value in Document Currency
SumAmtByPOQ Net Value in Document Currency
MaxAmtByPOQ Net Value in Document Currency
MinAmtByPOQ Net Value in Document Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
YearQuarter Year Quarter NUM5
PartOfQuarter Part of Quarter INT1
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
Previous1YearQuarter Year Quarter NUM5
Previous1YearMonth null
CntByPOM 4 Byte Signed Integer INT4
CntByPOQ 4 Byte Signed Integer INT4
Master Data Relations Join Conditions
Division
  • Client
  • Division
  • P_SI4_TRAININGDATA06.MANDT == TSPA.MANDT
  • P_SI4_TRAININGDATA06.DIVISION == TSPA.SPART
Material Number
  • Client
  • Material Number
  • P_SI4_TRAININGDATA06.MANDT == MARA.MANDT
  • P_SI4_TRAININGDATA06.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_SI4_TRAININGDATA06.MANDT == T023.MANDT
  • P_SI4_TRAININGDATA06.MATERIALGROUP == T023.MATKL