P_SPP_TrainingData02

Training Data 02 | view: PSDSPPTDA02 | Extraction: Not supported | Component: Sales Planning
Tables used: VBRPSCAL_TT_DATE
Column Name Description
BillingDocument FK Billing Document
BillingDocumentItem Billing Item
Column Name Description
Amount Net Value of Invoiced Sales
Column Name Description
Column Name Description
BillingDocumentDate Billing Date
Column Name Description
Column Name Description Domain name
YearMonth Year Month NUM6
PartOfMonth Part of Month INT1
YearQuarter Year Quarter NUM5
PartOfQuarter Part of Quarter INT1
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
SoldToParty Sold-to Party KUNNR
CustomerGroup Customer Group KDGRP
BillingDocumentType Billing Type FKART
Master Data Relations Join Conditions
Division
  • Division
  • Client
  • P_SPP_TRAININGDATA02.DIVISION == TSPA.SPART
  • P_SPP_TRAININGDATA02.MANDT == TSPA.MANDT
Material Number
  • Client
  • Material Number
  • P_SPP_TRAININGDATA02.MANDT == MARA.MANDT
  • P_SPP_TRAININGDATA02.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_SPP_TRAININGDATA02.MANDT == T023.MANDT
  • P_SPP_TRAININGDATA02.MATERIALGROUP == T023.MATKL