T5SPP

HR-SE: Information needed to be reported to Alecta | #transactional | Component: Sweden
Column Name Description
MANDT FK Client
PERNR FK Personnel Number
PERPA In-period for payroll
EVNTY Event Type for ALECTA Show values
BEGDA Start Date
Column Name Description
💲 Currency Key (T500C.WAERS):
ANSAL Annual salary
MOSAL Wage Type Amount for Payments
MOBEN Wage Type Amount for Payments
PRVPY Wage Type Amount for Payments
AVEL3 Wage Type Amount for Payments
MNSAL Wage Type Amount for Payments
MRSAL Annual salary
Column Name Description
Column Name Description
BEGDA Start Date
PBEGD Start date of Long term parental leave
Column Name Description
EVNTY Event Type for ALECTA Show values
SPPRI Service Sector Company Show values
ASALD Annual salary decrease for ALECTA Show values
Column Name Description Domain name
RUNDT HR-SE: Date of report run CHAR14
SPPID User-id for ALECTA P23_SPPID
SPPNO SPP number P23_SPPNO
SPPDI Cost Center P23_SPPDI
NACHN Last Name PAD_NACHN
VORNA First Name PAD_VORNM
PERID Personnel ID Number CHAR20
ORGNO Organization number P23_ORGNO
FITWK Employee is Fit for Work
ABSPC Percentage of Absence
IDALE ALECTA Pension Plan Identifier
RLEAV Reason for Leaving
ALTPS EE had Alternative Pension Solution at Previous Employer
Master Data Relations Join Conditions
Benefit area
  • Benefit area
  • Client
  • T5SPP.BAREA == T5UB3.BAREA
  • T5SPP.MANDT == T5UB3.MANDT
Benefit plan
  • Benefit plan
  • Benefit area
  • Client
  • ?
  • T5SPP.BPLAN == T5UBA.BPLAN
  • T5SPP.BAREA == T5UBA.BAREA
  • T5SPP.MANDT == T5UBA.MANDT
  • T5SPP.[column in domain "ENDDA"] == T5UBA.ENDDA
Client T5SPP.MANDT == T000.MANDT
Personnel Number
  • Personnel Number
  • Client
Benefit plan type
  • Benefit area
  • Benefit plan type
  • T5SPP.MANDT == T5UB1.MANDT
  • T5SPP.BAREA == T5UB1.BAREA
  • T5SPP.PLTYP == T5UB1.PLTYP