S016

SIS: Sales activities | #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
VKORG FK Sales Organization
VKBUR FK Sales office
VKGRP FK Sales group
KTAAR FK Sales Activity Type for Sales Support
KTAGR FK Reason for sales activity
KTAER FK Outcome of sales activities
KTAEB FK Analysis of sales activity outcome
PKUNAG FK Sold-to Party
PARNR_AP Number of Contact Person
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
Sales Activity Type for Sales Support
  • S016.MANDT == TVKK.MANDT
  • S016.KTAAR == TVKK.KTAAR
Analysis of sales activity outcome
  • Analysis of sales activity outcome
  • Client
  • S016.KTAEB == TVC4.KTAEB
  • S016.MANDT == TVC4.MANDT
Outcome of sales activities
  • S016.MANDT == TVC1.MANDT
  • S016.KTAER == TVC1.KTAER
Reason for sales activity
  • Reason for sales activity
  • Client
  • S016.KTAGR == TVC2.KTAGR
  • S016.MANDT == TVC2.MANDT
Client S016.MANDT == T000.MANDT
Sold-to Party
  • S016.MANDT == KNA1.MANDT
  • S016.PKUNAG == KNA1.KUNNR
Sales office
  • Sales office
  • Client
  • S016.VKBUR == TVBUR.VKBUR
  • S016.MANDT == TVBUR.MANDT
Sales group
  • S016.MANDT == TVKGR.MANDT
  • S016.VKGRP == TVKGR.VKGRP
Sales Organization
  • S016.MANDT == TVKO.MANDT
  • S016.VKORG == TVKO.VKORG