HRPADNLP_P2RX_BT

Payroll Results: Bank Transfers | #transactional | Component: The Netherlands
Column Name Description
MANDT Client
DCT_PERNR Personnel Number
DCT_SEQNR FK Sequence Number
DCT_ROWID Unique Row Number
HRPADNLP_SEQNR Sequence Number
HRPADNLP_RUNDT Date of payroll run
HRPADNLP_RUNTM Time of payroll run
Column Name Description
💲 Currency Key (WAERS):
BETRG HR Payroll: Amount
FBETR HR Payroll: Amount
BETRG_ORIG HR Payroll: Amount
Column Name Description
Column Name Description
HRPADNLP_RUNDT Date of payroll run
HRPADNLP_RUNTM Time of payroll run
DTADT Transfer date
DTATI Transfer time
DD_DUEDATE_SEPA Requested Date for Collection of the SEPA Direct Debit
ERDAT Date on which the record was created
ERZEIT Time at Which Record Was Added
AEDAT Last Changed On
AEZEIT Time of Change
Column Name Description
CTRNS Coll. Bank Transfer Indicator Show values
Column Name Description Domain name
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
OPBEL_REF Document reference number CHAR12
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • HRPADNLP_P2RX_BT.BANKS == T005.LAND1
  • HRPADNLP_P2RX_BT.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • HRPADNLP_P2RX_BT.MANDT == T005S.MANDT
  • HRPADNLP_P2RX_BT.BANKS == T005S.LAND1
  • HRPADNLP_P2RX_BT.STATE == T005S.BLAND
Payment Method
  • Payment Method
  • ?
  • HRPADNLP_P2RX_BT.MANDT == T042Z.MANDT
  • HRPADNLP_P2RX_BT.ZLSCH == T042Z.ZLSCH
  • HRPADNLP_P2RX_BT.[column in domain "LAND1"] == T042Z.LAND1