S018

SIS: Address list for sales promotion | #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
VERSION Version number
NIELS FK Nielsen ID
PSTL_LIS Postal code of city or PO box
KTOKD FK Customer Account Group
BRSCH FK Industry key
BRAN1 FK Industry code 1
KUKLA FK Customer Classification
PAFKT FK Contact person function
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_ADR_TO Counter: Total no. addresses in address list INT4
Master Data Relations Join Conditions
Industry code 1
  • S018.MANDT == TBRC.MANDT
  • S018.BRAN1 == TBRC.BRACO
Industry key
  • Industry key
  • Client
  • S018.BRSCH == T016.BRSCH
  • S018.MANDT == T016.MANDT
Customer Account Group
  • S018.MANDT == T077D.MANDT
  • S018.KTOKD == T077D.KTOKD
Customer Classification
  • S018.MANDT == TKUKL.MANDT
  • S018.KUKLA == TKUKL.KUKLA
Client S018.MANDT == T000.MANDT
Nielsen ID
  • S018.MANDT == TNLS.MANDT
  • S018.NIELS == TNLS.NIELS
Contact person function
  • S018.MANDT == TPFK.MANDT
  • S018.PAFKT == TPFK.PAFKT