P_SI4_TrainingData00A

SI | view: PSDSI4TD00A | 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
CustomerGroup Customer Group
SalesOrganization Sales Organization
DistributionChannel Distribution Channel
Division FK Division
Material FK Material Number
MaterialGroup FK Material Group
Column Name Description
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
Master Data Relations Join Conditions
Division
  • Division
  • Client
  • P_SI4_TRAININGDATA00A.DIVISION == TSPA.SPART
  • P_SI4_TRAININGDATA00A.MANDT == TSPA.MANDT
Material Number
  • Client
  • Material Number
  • P_SI4_TRAININGDATA00A.MANDT == MARA.MANDT
  • P_SI4_TRAININGDATA00A.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_SI4_TRAININGDATA00A.MANDT == T023.MANDT
  • P_SI4_TRAININGDATA00A.MATERIALGROUP == T023.MATKL