P_SPP_TrainingData07

Training Data 07 | view: PSDSPPTDA07 | 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 Division
SoldToParty Sold-to Party
CustomerGroup Customer Group
Material Material Number
MaterialGroup Material Group
BillingDocumentType Billing Type
Column Name Description
TargetAmount null
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_TRAININGDATA07.COMPANYCODE == T001.BUKRS
  • P_SPP_TRAININGDATA07.MANDT == T001.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • P_SPP_TRAININGDATA07.MANDT == T005.MANDT
  • P_SPP_TRAININGDATA07.COUNTRY == T005.LAND1
Customer Account Group
  • Client
  • Customer Account Group
  • P_SPP_TRAININGDATA07.MANDT == T077D.MANDT
  • P_SPP_TRAININGDATA07.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Customer Classification
  • Customer Classification
  • Client
  • P_SPP_TRAININGDATA07.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • P_SPP_TRAININGDATA07.MANDT == TKUKL.MANDT
Industry key
  • Client
  • Industry key
  • P_SPP_TRAININGDATA07.MANDT == T016.MANDT
  • P_SPP_TRAININGDATA07.INDUSTRY == T016.BRSCH
Product Type
  • Client
  • Product Type
  • P_SPP_TRAININGDATA07.MANDT == T134.MANDT
  • P_SPP_TRAININGDATA07.PRODUCTTYPE == T134.MTART