T7FITELME

TEL messages | #transactional | Component: Finland
Column Name Description
MANDT FK Client
PERNR Personnel Number
RDATE Run date
RTIME Run time
Column Name Description
💲 Currency Key (T500C.WAERS):
REPAY TEL earnings amount
FRBEN TEL fringe benefit amount
PAYLY TEL earnings in year prior to termination
FRBLY TEL fringe benefits in year prior to termination
Column Name Description
Column Name Description
RDATE Run date
RTIME Run time
TELDT Start date of active TEL employment
TRMDT Date of TEL employment termination
LELDT Begin date of active LEL employment
CHGDT Change date to new insurance
CINGRDT Change date to new insurance group
CINDPDT Change date to new insurance department
Column Name Description
MTYPE Message type for TEL reporting Show values
TRMCS Termination Reason Show values
CURID Currency pension insurance ID Show values
SOHNR Indicator for employee pension contribution Show values
Column Name Description Domain name
PERID Social insurance number
NAME Employee's name
CONNR Pension insurance contract number P44_CONNR
PAYAN TEL reporting year
NCONNR Pension insurance contract number P44_CONNR
Master Data Relations Join Conditions
Pension insurance department
  • Pension insurance department
  • Client
  • T7FITELME.CINDP == T7FI04.INDP
  • T7FITELME.MANDT == T7FI04.MANDT
Pension insurance group
  • T7FITELME.MANDT == T7FI03.MANDT
  • T7FITELME.CINGR == T7FI03.INGR
Pension insurance department
  • Pension insurance department
  • Client
  • T7FITELME.INDP == T7FI04.INDP
  • T7FITELME.MANDT == T7FI04.MANDT
Pension insurance group
  • T7FITELME.MANDT == T7FI03.MANDT
  • T7FITELME.INGR == T7FI03.INGR
Client T7FITELME.MANDT == T000.MANDT
Pension insurance department
  • Pension insurance department
  • Client
  • T7FITELME.NINDP == T7FI04.INDP
  • T7FITELME.MANDT == T7FI04.MANDT
Pension insurance group
  • T7FITELME.MANDT == T7FI03.MANDT
  • T7FITELME.NINGR == T7FI03.INGR
Other Relations | to Master Data Relations ↑ Join Conditions
Payee key for bank transfers
  • ?
  • Client
  • Payee key for bank transfers
  • T7FITELME.[column in domain "ENDDA"] == T521B.ENDDA
  • T7FITELME.MANDT == T521B.MANDT
  • T7FITELME.EMFSL == T521B.EMFSL