P2RX_BT_PERSON

Payment-Related Information (Person) | #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
GROUPING_REASON Grouping Reason for Personnel Assignments PCCE_GPRSN
GROUPING_VALUE Grouping Value for Personnel Assignments PCCE_GPVAL
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
  • P2RX_BT_PERSON.BANKS == T005.LAND1
  • P2RX_BT_PERSON.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • P2RX_BT_PERSON.MANDT == T005S.MANDT
  • P2RX_BT_PERSON.BANKS == T005S.LAND1
  • P2RX_BT_PERSON.STATE == T005S.BLAND
Payment Method
  • Payment Method
  • ?
  • P2RX_BT_PERSON.MANDT == T042Z.MANDT
  • P2RX_BT_PERSON.ZLSCH == T042Z.ZLSCH
  • P2RX_BT_PERSON.[column in domain "LAND1"] == T042Z.LAND1