SAP table PA0009 (HR Master Record: Infotype 0009 (Bank Details))

SAP table PA0009 has 8 primary key fields being MANDT,PERNR,SUBTY,OBJPS,SPRPS,ENDDA,BEGDA,SEQNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PERNR Personnel Number NUMC 8 0 PA0003 PERSNO
SUBTY Subtype CHAR 4 0 SUBTY
OBJPS Object Identification CHAR 2 0 OBJPS
SPRPS Lock Indicator for HR Master Data Record CHAR 1 0 SPRPS
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
SEQNR Number of Infotype Record With Same Key NUMC 3 0 SEQNR
AEDTM Last Changed On DATS 8 0 AEDAT
UNAME Name of Person Who Changed Object CHAR 12 0 AENAM
HISTO Historical Record Flag CHAR 1 0 HISTO
ITXEX Text Exists for Infotype CHAR 1 0 ITXEX
REFEX Reference Fields Exist (Primary/Secondary Costs) CHAR 1 0 PRFEX
ORDEX Confirmation Fields Exist CHAR 1 0 ORDEX
ITBLD Infotype Screen Control CHAR 2 0 ITBLD
PREAS Reason for Changing Master Data CHAR 2 0 T530E PREAS
FLAG1 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG2 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG3 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG4 Reserved Field/Unused Field CHAR 1 0 NUSED
RESE1 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
RESE2 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
GRPVL Grouping Value for Personnel Assignments CHAR 4 0 PCCE_GPVAL
OPKEN Operation Indicator for Wage Types CHAR 1 0 OPKEN
Payment
A Deduction
BETRG Standard value CURR 13 2 PAD_VGBTR
WAERS Payment Currency CUKY 5 0 TCURC PAD_WAERS
ANZHL Standard Percentage DEC 5 2 VGPRO
ZEINH Time/Measurement Unit CHAR 3 0 T538A PT_ZEINH
BNKSA Type of Bank Details Record CHAR 4 0 * BNKSA
ZLSCH Payment Method CHAR 1 0 T042Z PCODE
EMFTX Payee Text CHAR 40 0 EMFTX
BKPLZ Postal Code CHAR 10 0 BKPLZ
BKORT City CHAR 25 0 ORT01
BANKS Country/Region Key of Bank CHAR 3 0 T005 BANKS
BANKL Bank Keys CHAR 15 0 BANKK
BANKN Bank account number CHAR 18 0 BANKN
BANKP Check Digit for Bank No./Account CHAR 2 0 BANKP
BKONT Bank Control Key CHAR 2 0 BKONT
SWIFT SWIFT/BIC for International Payments CHAR 11 0 SWIFT
DTAWS Instruction Key for Data Medium Exchange CHAR 2 0 T015W DTAWS
DTAMS Report key for data medium exchange CHAR 1 0 DTAMS
Use house bank default value
0 Single data record can be forwarded to the Bundesbank
1 Single data record not to be forwarded to the Bundesbank
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
PSKTO PO Bank Current Acct No. or Building Society Ref. No. CHAR 16 0 PSKTO
ESRNR ISR subscriber number CHAR 11 0 ESRNR
ESRRE ISR/QR Reference Number CHAR 27 0 ESRRE
ESRPZ POR check digit CHAR 2 0 ESRPZ
EMFSL Payee key for bank transfers CHAR 8 0 EMFSL
ZWECK Purpose of Bank Transfers CHAR 40 0 DZWECK
BTTYP PBS Transfer Type NUMC 2 0 T5M3T P09_BTTYP
PAYTY Payroll type CHAR 1 0 PAYTY
Regular payroll run
A Bonus payment
B Correction accounting
C Manual check
S Additional payment
PAYID Payroll Identifier CHAR 1 0 PAYID
OCRSN Reason for Off-Cycle Payroll CHAR 4 0 * PAY_OCRSN
BONDT Off-cycle payroll payment date DATS 8 0 BONDT
BKREF Reference Details for Bank Details CHAR 20 0 BKREF
STRAS Street and House Number CHAR 30 0 STRAS
STATE Region (State, Province, County) CHAR 3 0 * REGIO
DEBIT Automatic Debit Authorization Indicator CHAR 1 0 P00_XDEBIT_INFTY
IBAN IBAN (International Bank Account Number) CHAR 34 0 IBAN
ADRS_BANKS Country/Region Key CHAR 3 0 T005 LAND1

PA0009 foreign key relationships

Table Field Check Table Check Field
0 PA0009 ADRS_BANKS T005 Countries MANDT
0 PA0009 ADRS_BANKS T005 Countries LAND1
1 PA0009 BANKS T005 Countries MANDT
1 PA0009 BANKS T005 Countries LAND1
0 PA0009 BTTYP T5M3T Texts for Transfer Types (Denmark) MANDT
0 PA0009 BTTYP T5M3T Texts for Transfer Types (Denmark) BTTYP
1 PA0009 DTAWS T015W Instruction keys BANKS
1 PA0009 DTAWS T015W Instruction keys ZLSCH
1 PA0009 DTAWS T015W Instruction keys DTAWS
0 PA0009 MANDT T000 Clients MANDT
1 PA0009 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
1 PA0009 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
0 PA0009 PREAS T530E Reasons for Changes MANDT
0 PA0009 PREAS T530E Reasons for Changes INFTY
0 PA0009 PREAS T530E Reasons for Changes PREAS
1 PA0009 WAERS TCURC Currency Codes MANDT
1 PA0009 WAERS TCURC Currency Codes WAERS
0 PA0009 ZEINH T538A HR Time/Measurement Units MANDT
0 PA0009 ZEINH T538A HR Time/Measurement Units ZEINH
1 PA0009 ZLSCH T042Z Payment Methods for Automatic Payment MANDT
1 PA0009 ZLSCH T042Z Payment Methods for Automatic Payment LAND1
1 PA0009 ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH