T5S0P

Swedish attributes of org. structure (level pers. subarea) | #other | Component: Sweden
Column Name Description
MANDT FK Client
WERKS FK Personnel Area
BTRTL Personnel Subarea
ENDDA End Date
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
COREC Corporate reduction of employers contribution indicator Show values
REGEC Regional reduction of employers contribution indicator Show values
SPPRI Service Sector Company Show values
Column Name Description Domain name
ORGNO Organization number P23_ORGNO
LANKD Region Key P23_LANKD
KOMKD Municipality key P23_KOMKD
SCBWP SCB work place number P23_SCBWP
CFARN CFAR number P23_CFARN
SPPID User-id for ALECTA P23_SPPID
SPPNO SPP number P23_SPPNO
SPPDI Cost Center P23_SPPDI
SPPCO ALECTA code P23_SPPCO
SAFNO SN number (Svenskt Näringsliv) P23_SAFNO
SAFWP SN work place number P23_SAFWP
SAFUN Union SN P23_SAFUN
METNR Union department CHAR04
METPC Union due percentage P23_PROZS
SIFNR SIF number NUM10
AAREA Agreement area ('Avtalsområde') P23_AAREA
BUSIN Not used P23_BUSIN
AMFNR AMF number P23_AMFNR
IDAL1 ALECTA department 1 Pension Plan Identifier
IDAL2 ALECTA department 2 Pension Plan Identifier
Master Data Relations | to Other Relations ↓ Join Conditions
Compulsory pension insurance status
  • Compulsory pension insurance status
  • Client
  • T5S0P.CPIS == T5SPA.CPIS
  • T5S0P.MANDT == T5SPA.MANDT
Client T5S0P.MANDT == T000.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Tax Table Number
  • Tax Table Number
  • Client
  • T5S0P.TABKD == T5S3A.TABKD
  • T5S0P.MANDT == T5S3A.MANDT
Tax column
  • Tax column
  • Client
  • T5S0P.TAKKD == T5S3B.TAKKD
  • T5S0P.MANDT == T5S3B.MANDT
Personnel Area
  • Personnel Subarea
  • Personnel Area
  • T5S0P.MANDT == T001P.MANDT
  • T5S0P.BTRTL == T001P.BTRTL
  • T5S0P.WERKS == T001P.WERKS