P2RX_BT - Payroll Results: Bank Transfers

Payroll Results: Bank Transfers information is stored in SAP table P2RX_BT.
It is part of development package PCDCT in software component PY-XX-PYP. This development package consists of objects that can be grouped under "HR Declustering Tools".

Fields for table P2RX_BT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		HRDCT_S_PAYKEY	0
MANDT	Client	X	MANDT	CLNT	6	*
.INCLUDE	PCLKEY	X		HRDCT_S_PYPCL2KEY	0
DCT_PERNR	Personnel Number	X	P_PERNR	NUMC	16
DCT_SEQNR	Sequence Number	X	CDSEQ	NUMC	10	HRPY_RGDIR
DCT_ROWID	Unique Row Number	X	HRDCT_ROWID	NUMC	10
.INCLUDE				PC209	0
BTZNR	Assignment of Transfers		BTZNR	RAW	1
LGART	Wage Type		LGART	CHAR	8	T512W
BETRG	HR Payroll: Amount		MAXBT	CURR	8
EMFTX	Payee Text		EMFTX	CHAR	80
BKPLZ	Postal Code		PSTLZ	CHAR	20
BKORT	City		ORT01	CHAR	50
BANKS	Country/Region Key		LAND1	CHAR	6	T005
BANKL	Bank Number		BANKL	CHAR	30
BANKN	Bank account number		BANKN	CHAR	36
EMFSL	Payee key for bank transfers		EMFSL	CHAR	16
VBAFM	Type of investment/asset for capital formation		VBAFM	CHAR	2	*
DTADT	Transfer date		DTADT_D	DATS	16
DTATI	Transfer time		DATTI	TIMS	12
DTAID	Transfer identification		DTATX	CHAR	40
BTTYP	PBS Transfer Type		P09_BTTYP	NUMC	4	*
PSKTO	PO Bank Current Acct No. or Building Society Ref. No.		PSKTO	CHAR	32
WAERS	Currency Key		WAERS	CUKY	10	*
STRAS	Street and House Number		STRAS	CHAR	60
BKONT	Bank Control Key		BKONT	CHAR	4
FBETR	HR Payroll: Amount		MAXBT	CURR	8
STATE	Region (State, Province, County)		REGIO	CHAR	6	T005S
ESRNR	ISR subscriber number		ESRNR	CHAR	22
ESRRE	ISR/QR Reference Number		ESRRE	CHAR	54
ESRPZ	POR check digit		ESRPZ	CHAR	4
BKREF	Reference Details for Bank Details		BKREF	CHAR	40
CTRNS	Coll. Bank Transfer Indicator		HRPAY00_COLDME_CTRNS	CHAR	2
IBAN	IBAN (International Bank Account Number)		IBAN	CHAR	68
CRDID	Creditor Identification Number		HRPAY00_SEPA_CRDID	CHAR	70
MNDID	SEPA Mandate: Unique Reference to Mandate per Creditor		HRPAY00_SEPA_MNDID	CHAR	70
DD_DUEDATE_SEPA	Requested Date for Collection of the SEPA Direct Debit		HRDME_DD_DUEDATE_SEPA	DATS	16
ADRS_BANKS	Country/Region Key		LAND1	CHAR	6	T005