P_SI4_TrainingData11B

Sales Performance Prediction | view: PSDSI4TD11B | Extraction: Not supported | Component: Sales Planning
Tables used: VBRPSCAL_TT_DATEMARAKNA1MARATVKO
Column Name Description
YearMonth Year Month
PartOfMonth Part of Month
SoldToParty Sold-to Party
SalesOrganization Sales Organization
DistributionChannel Distribution Channel
Division Division
Material Material Number
Column Name Description
TargetAmount Net Value in Document Currency
SumAmtByPOM Net Value in Document Currency
MaxAmtByPOM Net Value in Document Currency
MinAmtByPOM Net Value in Document Currency
AvgAmtByPOM Net Value in Document Currency
SumAmtByPOQ Net Value in Document Currency
MaxAmtByPOQ Net Value in Document Currency
MinAmtByPOQ Net Value in Document Currency
AvgAmtByPOQ Net Value in Document Currency
AvgCountByPOM Net Value in Document Currency
AvgCountByPOQ Net Value in Document Currency
SumAmtByPre1Month Net Value in Document Currency
MaxAmtByPre1Month Net Value in Document Currency
MinAmtByPre1Month Net Value in Document Currency
AvgAmtByPre1Month Net Value in Document Currency
SumAmtByPre2Month Net Value in Document Currency
SumAmtByPre3Month Net Value in Document Currency
SumAmtByPre4Month Net Value in Document Currency
SumAmtByPre5Month Net Value in Document Currency
SumAmtByPre6Month Net Value in Document Currency
DeltaAmtByMoM1 Net Value in Document Currency
DeltaAmtByMoM2 Net Value in Document Currency
DeltaAmtByMoM3 Net Value in Document Currency
DeltaAmtByMoM4 Net Value in Document Currency
DeltaAmtByMoM5 Net Value in Document Currency
DeltaAmtByMoM6 Net Value in Document Currency
DeltaAmtByYoY1 Net Value in Document Currency
DeltaAmtByYoY2 Net Value in Document Currency
DeltaAmtByYoY3 Net Value in Document Currency
DeltaAmtByYoY4 Net Value in Document Currency
DeltaAmtByYoY5 Net Value in Document Currency
DeltaAmtByYoY6 Net Value in Document Currency
AvgAmtByLast2Month Net Value in Document Currency
AvgAmtByLast3Month Net Value in Document Currency
SumAmtRatioByLast3Month1 Net Value in Document Currency
SumAmtRatioByLast3Month2 Net Value in Document Currency
SumAmtRatioByLast3Month3 Net Value in Document Currency
DiffSumAmtByPOM Net Value in Document Currency
DiffMaxAmtByPOM Net Value in Document Currency
DiffMinAmtByPOM Net Value in Document Currency
DiffAmtByPOM1 Net Value in Document Currency
DiffAmtByPOM2 Net Value in Document Currency
SumAmtByPre1Quarter Net Value in Document Currency
AvgAmtByPre1Quarter Net Value in Document Currency
MaxAmtByPre1Quarter Net Value in Document Currency
MinAmtByPre1Quarter 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
CustomerName Name of Customer TEXT80
CreatedByUser Name of Person who Created the Object USNAM
CityName City TEXT35
CustomerGroup Customer Group KDGRP
MaterialGroup Material Group MATKL
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
PartOfQuarter Part of Quarter INT1
CountByPOM 4 Byte Signed Integer INT4
CountByPOQ 4 Byte Signed Integer INT4
CountByPre1Month 4 Byte Signed Integer INT4
DiffCountByPOM 4 Byte Signed Integer INT4
CountByPre1Quarter 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_SI4_TRAININGDATA11B.COMPANYCODE == T001.BUKRS
  • P_SI4_TRAININGDATA11B.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_SI4_TRAININGDATA11B.COUNTRY == T005.LAND1
  • P_SI4_TRAININGDATA11B.MANDT == T005.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • P_SI4_TRAININGDATA11B.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • P_SI4_TRAININGDATA11B.MANDT == T077D.MANDT
Customer Classification
  • Customer Classification
  • Client
  • P_SI4_TRAININGDATA11B.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • P_SI4_TRAININGDATA11B.MANDT == TKUKL.MANDT
Industry key
  • Industry key
  • Client
  • P_SI4_TRAININGDATA11B.INDUSTRY == T016.BRSCH
  • P_SI4_TRAININGDATA11B.MANDT == T016.MANDT
Customer number for intercompany billing
  • Customer number for intercompany billing
  • Client
  • P_SI4_TRAININGDATA11B.INTERCOMPANYBILLINGCUSTOMER == KNA1.KUNNR
  • P_SI4_TRAININGDATA11B.MANDT == KNA1.MANDT
Product Type
  • Client
  • Product Type
  • P_SI4_TRAININGDATA11B.MANDT == T134.MANDT
  • P_SI4_TRAININGDATA11B.PRODUCTTYPE == T134.MTART