T77PAYKZBT

Bank Transfer Table Image (BTKZ) | #masterdata | Component: Kazakhstan
Column Name Description
MANDT Client
PERNR Personnel Number
SEQNR Sequence Number
BTQNR Assignment of Transfers
GPVAL Grouping Value for Personnel Assignments
SRTZA Indicator: Status of record Show values
IPERM Period modifier
INPER In-period for payroll
FPPER For-Period for Payroll (YYYYMM)
JUPER Legal Person
ABKRS Payroll Area
PAYTY Payroll type Show values
PAYID Payroll Identifier
BONDT Off-cycle payroll payment date
Column Name Description
💲 Currency Key (WAERS):
BETRG HR Payroll: Amount
FBETR HR Payroll: Amount
Column Name Description
Column Name Description
BONDT Off-cycle payroll payment date
LAUFD Date on Which the Program Is to Be Run
FPBEG Start date of payroll period (FOR period)
IPEND End of payroll period (IN period)
ENDDA End Date
PAYDT Pay date for awards
AUSFD Due date of the paid items
DTADT Transfer date
DTATI Transfer time
DD_DUEDATE_SEPA Requested Date for Collection of the SEPA Direct Debit
Column Name Description
SRTZA Indicator: Status of record Show values
PAYTY Payroll type Show values
CTRNS Coll. Bank Transfer Indicator Show values
Column Name Description Domain name
LAUFI Additional Identification LAUFI
BTZNR Assignment of Transfers RAW1
LGART Wage Type LGART
EMFTX Payee Text TEXT40
BKPLZ Postal Code PSTLZ
BKORT City TEXT25
BANKL Bank Number BANKL
BANKN Bank account number BANKN
EMFSL Payee key for bank transfers EMFSL
ZWECK Purpose of Bank Transfers TEXT40
VBAFM Type of investment/asset for capital formation VBAFM
DTAID Transfer identification TEXT20
BTTYP PBS Transfer Type P09_BTTYP
PSKTO PO Bank Current Acct No. or Building Society Ref. No. PSKTO
STRAS Street and House Number TEXT30
BKONT Bank Control Key BKONT
ESRNR ISR subscriber number ESRNR
ESRRE ISR/QR Reference Number ESRRE
ESRPZ POR check digit CHAR2
BKREF Reference Details for Bank Details CHAR20
IBAN IBAN (International Bank Account Number) IBAN
CRDID Creditor Identification Number ID035
MNDID SEPA Mandate: Unique Reference to Mandate per Creditor ID035
ADRS_BANKS Country/Region Key LAND1
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • T77PAYKZBT.BANKS == T005.LAND1
  • T77PAYKZBT.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • T77PAYKZBT.MANDT == T005S.MANDT
  • T77PAYKZBT.BANKS == T005S.LAND1
  • T77PAYKZBT.STATE == T005S.BLAND
Payment Method
  • Payment Method
  • ?
  • T77PAYKZBT.MANDT == T042Z.MANDT
  • T77PAYKZBT.ZLSCH == T042Z.ZLSCH
  • T77PAYKZBT.[column in domain "LAND1"] == T042Z.LAND1