S017

SIS: Sales promotions | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
VBELN FK SD document no. of a sales activity in sales support
KTAST FK Status of sales activity
KTAGR FK Reason for sales activity
Column Name Description
Column Name Description
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
CNT_CAS Counter: number of sales activities/promotions INT4
Master Data Relations Join Conditions
Reason for sales activity
  • Reason for sales activity
  • Client
  • S017.KTAGR == TVC2.KTAGR
  • S017.MANDT == TVC2.MANDT
Status of sales activity
  • S017.MANDT == TVC3.MANDT
  • S017.KTAST == TVC3.KTAST
Client S017.MANDT == T000.MANDT