P2RX_BT

Payroll Results: Bank Transfers | #transactional | Component: Payroll Process
Column Name Description
MANDT Client
DCT_PERNR Personnel Number
DCT_SEQNR FK Sequence Number
DCT_ROWID Unique Row Number
Column Name Description
💲 Currency Key (WAERS):
BETRG HR Payroll: Amount
FBETR HR Payroll: Amount
Column Name Description
Column Name Description
DTADT Transfer date
DTATI Transfer time
DD_DUEDATE_SEPA Requested Date for Collection of the SEPA Direct Debit
Column Name Description
CTRNS Coll. Bank Transfer Indicator Show values
Column Name Description Domain name
BTZNR Assignment of Transfers RAW1
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
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • P2RX_BT.ADRS_BANKS == T005.LAND1
  • P2RX_BT.MANDT == T005.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P2RX_BT.BANKS == T005.LAND1
  • P2RX_BT.MANDT == T005.MANDT
Wage Type
  • ?
  • ?
  • Client
  • Wage Type
  • P2RX_BT.[column in domain "MOLGA"] == T512W.MOLGA
  • P2RX_BT.[column in domain "ENDDA"] == T512W.ENDDA
  • P2RX_BT.MANDT == T512W.MANDT
  • P2RX_BT.LGART == T512W.LGART
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • P2RX_BT.MANDT == T005S.MANDT
  • P2RX_BT.BANKS == T005S.LAND1
  • P2RX_BT.STATE == T005S.BLAND
Payment Method
  • Payment Method
  • ?
  • P2RX_BT.MANDT == T042Z.MANDT
  • P2RX_BT.ZLSCH == T042Z.ZLSCH
  • P2RX_BT.[column in domain "LAND1"] == T042Z.LAND1