1. Home
  2. Resources
  3. SAP Tables
  4. HRF_BT - HR Forms: Payroll Table BT Plus Check Number and IBAN

SAP Table HRF_BT

HR Forms: Payroll Table BT Plus Check Number and IBAN

HRF_BT (HR Forms: Payroll Table BT Plus Check Number and IBAN) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link HRF_BT to other SAP tables.

HRF_BT table fields

Field Data element Checktable Datatype Length Decimals
GROUPING_REASON Grouping Reason for Personnel Assignments PCCE_GPRSN CHAR 4 0
GROUPING_VALUE Grouping Value for Personnel Assignments PCCE_GPVAL CHAR 4 0
BTZNR Assignment of Transfers BTZNR RAW 1 0
LGART Wage Type LGART CHAR 4 0
BETRG HR Payroll: Amount MAXBT CURR 15 2
ZLSCH Payment Method DZLSCH T042Z CHAR 1 0
EMFTX Payee Text EMFTX CHAR 40 0
BKPLZ Postal Code PSTLZ CHAR 10 0
BKORT City ORT01 CHAR 25 0
BANKS Country Key LAND1 T005 CHAR 3 0
BANKL Bank number BANKL CHAR 15 0
BANKN Bank account number BANKN CHAR 18 0
EMFSL Payee key for bank transfers EMFSL CHAR 8 0
ZWECK Purpose of Bank Transfers DZWECK CHAR 40 0
VBAFM Type of investment/asset for capital formation VBAFM CHAR 1 0
DTADT Transfer date DTADT_D DATS 8 0
DTATI Transfer time DATTI TIMS 6 0
DTAID Transfer identification DTATX CHAR 20 0
BTTYP PBS Transfer Type P09_BTTYP NUMC 2 0
PSKTO Account Number of Bank Account At Post Office PSKTO CHAR 16 0
WAERS Currency Key WAERS CUKY 5 0
STRAS House number and street STRAS CHAR 30 0
BKONT Bank Control Key BKONT CHAR 2 0
FBETR HR Payroll: Amount MAXBT CURR 15 2
STATE Region (State, Province, County) REGIO T005S CHAR 3 0
ESRNR ISR Subscriber Number ESRNR CHAR 11 0
ESRRE ISR Reference Number ESRRE CHAR 27 0
ESRPZ ISR Check Digit ESRPZ CHAR 2 0
BKREF Reference specifications for bank details BKREF CHAR 20 0
CTRNS Coll. Bank Transfer Indicator HRPAY00_COLDME_CTRNS CHAR 1 0
X Yes
NULL No
IBAN IBAN (International Bank Account Number) IBAN CHAR 34 0
CRDID Creditor Identification Number HRPAY00_SEPA_CRDID CHAR 35 0
MNDID SEPA Mandate: Unique Reference to Mandate per Creditor HRPAY00_SEPA_MNDID CHAR 35 0
CHECKNO Reference Document Number XBLNR CHAR 16 0

HRF_BT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
HRF_BT BANKS SYST MANDT T005 Countries MANDT
HRF_BT BANKS HRF_BT BANKS T005 Countries LAND1
HRF_BT STATE HRF_BT BANKS T005S Taxes: Region (Province) Key LAND1
HRF_BT STATE HRF_BT STATE T005S Taxes: Region (Province) Key BLAND
HRF_BT STATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
HRF_BT ZLSCH SYST MANDT T042Z Payment Methods for Automatic Payment MANDT
HRF_BT ZLSCH SYST LAND1 T042Z Payment Methods for Automatic Payment LAND1
HRF_BT ZLSCH HRF_BT ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH