T5TA1

Source data for external transfers | #transactional | Component: Czech Republic
Column Name Description
MANDT FK Client
LAUFD Date on Which the Program Is to Be Run
LAUFI Additional Identification
PERNR Personnel Number
BTZNR Sequential number (field)
Column Name Description
💲 Currency Key (WAERS):
BETRG Wage Type Amount for Payments
FBETR HR payroll: Maximum amount
Column Name Description
Column Name Description
LAUFD Date on Which the Program Is to Be Run
AUSFD Due date of the paid items
ZALDT Posting Date of Payment Document
Column Name Description
CTRAN Collective transfer Show values
Column Name Description Domain name
PERID Personnel ID Number CHAR20
NACHN Last Name NACHN
VORNA First Name VORNM
ABKRS Payroll Area ABKRS
JUPER Legal Person JUPER
GSBER Business Area GSBER
KOSTL Cost Center KOSTL
VDSK1 Organizational Key VDSK1
VBAFM Indicator CHAR1
SEQNR Sequential number of cluster directory DEC5
SACHA Payroll Administrator SACHA
EMFTX Payee Text TEXT40
BKONT Bank Control Key BKONT
BANKL Bank Number BANKL
BANKN Bank account number BANKN
BKPLZ Postal Code PSTLZ
STRAS Street and House Number TEXT30
BKORT City TEXT25
PSKTO PO Bank Current Acct No. or Building Society Ref. No. PSKTO
ESRNR ISR subscriber number ESRNR
ESRRE ISR/QR Reference Number ESRRE
ZWECK Purpose of Bank Transfers TEXT40
MODIF3 HR CZ modifier 3 for transfer into FI/CO CHAR1
FI_CO1 HR CZ - assignment flag FI/CO CHAR2
SUCET1 HR CZ - symbolic account for FI/CO CHAR2
FI_CO2 HR CZ - assignment flag FI/CO CHAR2
SUCET2 HR CZ - symbolic account for FI/CO CHAR2
FI_CO3 HR CZ - assignment flag FI/CO CHAR2
SUCET3 HR CZ - symbolic account for FI/CO CHAR2
PR_BANKN HR CZ - registry account CHAR10
PR_ESRRE HR CZ - subaccount of registry account CHAR10
PR_JMENO C/O Name NACHN
PR_ULICE Street and House Number TEXT30
PR_CORIENT House Number NUMC6
PR_CPOPIS Identification of an Apartment in a Building TEXT6
PR_UCEL 2nd Address Line TEXT30
PR_PSC Postal Code PSTLZ
PR_OBEC City TEXT25
PR_CASTOBC District TEXT25
ZBUKR Paying company code BUKRS
HKTID ID for Account Details HKTID
HBKID Short Key for a House Bank HBKID
PLATNY Indicator: active/inactive CHAR1
IBAN IBAN (International Bank Account Number) IBAN
PR_CORIENT_NEW Identification of an apartment in a building PAD_HSNMR
PR_CPOPIS_NEW House Number PAD_HSNMR
Master Data Relations | to Other Relations ↓ Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • T5TA1.BANKS == T005.LAND1
  • T5TA1.MANDT == T005.MANDT
Company Code
  • T5TA1.MANDT == T001.MANDT
  • T5TA1.BUKRS == T001.BUKRS
Wage Type
  • ?
  • ?
  • Client
  • Wage Type
  • T5TA1.[column in domain "MOLGA"] == T512W.MOLGA
  • T5TA1.[column in domain "ENDDA"] == T512W.ENDDA
  • T5TA1.MANDT == T512W.MANDT
  • T5TA1.LGART == T512W.LGART
Client T5TA1.MANDT == T000.MANDT
Employee Group
  • Employee Group
  • Client
  • T5TA1.PERSG == T501.PERSG
  • T5TA1.MANDT == T501.MANDT
Employee Subgroup
  • Employee Subgroup
  • Client
  • T5TA1.PERSK == T503K.PERSK
  • T5TA1.MANDT == T503K.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • T5TA1.PR_STAT == T005.LAND1
  • T5TA1.MANDT == T005.MANDT
Currency key
  • T5TA1.MANDT == TCURC.MANDT
  • T5TA1.WAERS == TCURC.WAERS
Payment Method
  • Payment Method
  • Country/Region Key
  • T5TA1.MANDT == T042Z.MANDT
  • T5TA1.ZLSCH == T042Z.ZLSCH
  • T5TA1.BANKS == T042Z.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Personnel Subarea
  • Personnel Subarea
  • Personnel Area
  • T5TA1.MANDT == T001P.MANDT
  • T5TA1.BTRTL == T001P.BTRTL
  • T5TA1.WERKS == T001P.WERKS
Payee key for bank transfers
  • ?
  • Client
  • Payee key for bank transfers
  • T5TA1.[column in domain "ENDDA"] == T521B.ENDDA
  • T5TA1.MANDT == T521B.MANDT
  • T5TA1.EMFSL == T521B.EMFSL
Personnel Area
  • T5TA1.MANDT == T500P.MANDT
  • T5TA1.WERKS == T500P.PERSA