S018E

S018 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
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
Column Name Description
Column Name Description Domain name
PLOBJ Planning object CHAR18
PERKZ Period indicator PERVR
PLTKZ Indicator: element used in planning CHAR01
ANTEI Proportional factor (%) for disaggregation of product group FLTP
Master Data Relations Join Conditions
Industry code 1
  • S018E.MANDT == TBRC.MANDT
  • S018E.BRAN1 == TBRC.BRACO
Industry key
  • Industry key
  • Client
  • S018E.BRSCH == T016.BRSCH
  • S018E.MANDT == T016.MANDT
Customer Account Group
  • S018E.MANDT == T077D.MANDT
  • S018E.KTOKD == T077D.KTOKD
Customer Classification
  • S018E.MANDT == TKUKL.MANDT
  • S018E.KUKLA == TKUKL.KUKLA
Client S018E.MANDT == T000.MANDT
Nielsen ID
  • S018E.MANDT == TNLS.MANDT
  • S018E.NIELS == TNLS.NIELS
Contact person function
  • S018E.MANDT == TPFK.MANDT
  • S018E.PAFKT == TPFK.PAFKT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S018E.PERIV == T009.PERIV
  • S018E.MANDT == T009.MANDT