P_SPP_TrainingData06

Training Data 06 | view: PSDSPPTDA06 | 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
SumAmtByPOM null
MaxAmtByPOM null
MinAmtByPOM null
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
Previous1YearMonth null
Previous1YearQuarter Year Quarter NUM5
CityName City TEXT35
CntByPOM null
Master Data Relations Join Conditions
Company code of the sales organization
  • Client
  • Company code of the sales organization
  • P_SPP_TRAININGDATA06.MANDT == T001.MANDT
  • P_SPP_TRAININGDATA06.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • P_SPP_TRAININGDATA06.MANDT == T005.MANDT
  • P_SPP_TRAININGDATA06.COUNTRY == T005.LAND1
Customer Account Group
  • Customer Account Group
  • Client
  • P_SPP_TRAININGDATA06.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • P_SPP_TRAININGDATA06.MANDT == T077D.MANDT
Customer Classification
  • Customer Classification
  • Client
  • P_SPP_TRAININGDATA06.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • P_SPP_TRAININGDATA06.MANDT == TKUKL.MANDT
Division
  • Client
  • Division
  • P_SPP_TRAININGDATA06.MANDT == TSPA.MANDT
  • P_SPP_TRAININGDATA06.DIVISION == TSPA.SPART
Industry key
  • Industry key
  • Client
  • P_SPP_TRAININGDATA06.INDUSTRY == T016.BRSCH
  • P_SPP_TRAININGDATA06.MANDT == T016.MANDT
Material Number
  • Client
  • Material Number
  • P_SPP_TRAININGDATA06.MANDT == MARA.MANDT
  • P_SPP_TRAININGDATA06.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_SPP_TRAININGDATA06.MANDT == T023.MANDT
  • P_SPP_TRAININGDATA06.MATERIALGROUP == T023.MATKL
Product Type
  • Client
  • Product Type
  • P_SPP_TRAININGDATA06.MANDT == T134.MANDT
  • P_SPP_TRAININGDATA06.PRODUCTTYPE == T134.MTART