SAP Table PA0009
HR Master Record: Infotype 0009 (Bank Details)
PA0009 (HR Master Record: Infotype 0009 (Bank Details)) 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 PA0009 to other SAP tables.
PA0009 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
PERNR
Personnel number
|
PERSNO | PA0003 |
NUMC
|
8 | 0 | |||||||||
|
SUBTY
Subtype
|
SUBTY |
CHAR
|
4 | 0 | ||||||||||
|
OBJPS
Object Identification
|
OBJPS |
CHAR
|
2 | 0 | ||||||||||
|
SPRPS
Lock Indicator for HR Master Data Record
|
SPRPS |
CHAR
|
1 | 0 | ||||||||||
|
ENDDA
End Date
|
ENDDA |
DATS
|
8 | 0 | ||||||||||
|
BEGDA
Start Date
|
BEGDA |
DATS
|
8 | 0 | ||||||||||
|
SEQNR
Number of Infotype Record with Same Key
|
SEQNR |
NUMC
|
3 | 0 | ||||||||||
|
AEDTM
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||
|
UNAME
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||
|
HISTO
Historical Record Flag
|
HISTO |
CHAR
|
1 | 0 | ||||||||||
|
ITXEX
Text Exists for Infotype
|
ITXEX |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
REFEX
Reference Fields Exist (Primary/Secondary Costs)
|
PRFEX |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
ORDEX
Confirmation Fields Exist
|
ORDEX |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
ITBLD
Infotype Screen Control
|
ITBLD |
CHAR
|
2 | 0 | ||||||||||
|
PREAS
Reason for Changing Master Data
|
PREAS | T530E |
CHAR
|
2 | 0 | |||||||||
|
FLAG1
Reserved Field/Unused Field
|
NUSED |
CHAR
|
1 | 0 | ||||||||||
|
FLAG2
Reserved Field/Unused Field
|
NUSED |
CHAR
|
1 | 0 | ||||||||||
|
FLAG3
Reserved Field/Unused Field
|
NUSED |
CHAR
|
1 | 0 | ||||||||||
|
FLAG4
Reserved Field/Unused Field
|
NUSED |
CHAR
|
1 | 0 | ||||||||||
|
RESE1
Reserved Field/Unused Field of Length 2
|
NUSED2 |
CHAR
|
2 | 0 | ||||||||||
|
RESE2
Reserved Field/Unused Field of Length 2
|
NUSED2 |
CHAR
|
2 | 0 | ||||||||||
|
GRPVL
Grouping Value for Personnel Assignments
|
PCCE_GPVAL |
CHAR
|
4 | 0 | ||||||||||
|
OPKEN
Operation Indicator for Wage Types
|
OPKEN |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
BETRG
Standard value
|
PAD_VGBTR |
CURR
|
13 | 2 | ||||||||||
|
WAERS
Payment Currency
|
PAD_WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||
|
ANZHL
Standard Percentage
|
VGPRO |
DEC
|
5 | 2 | ||||||||||
|
ZEINH
Time/Measurement Unit
|
PT_ZEINH | T538A |
CHAR
|
3 | 0 | |||||||||
|
BNKSA
Type of Bank Details Record
|
BNKSA |
CHAR
|
4 | 0 | ||||||||||
|
ZLSCH
Payment Method
|
PCODE | T042Z |
CHAR
|
1 | 0 | |||||||||
|
EMFTX
Payee Text
|
EMFTX |
CHAR
|
40 | 0 | ||||||||||
|
BKPLZ
Postal Code
|
BKPLZ |
CHAR
|
10 | 0 | ||||||||||
|
BKORT
City
|
ORT01 |
CHAR
|
25 | 0 | ||||||||||
|
BANKS
Bank country key
|
BANKS | T005 |
CHAR
|
3 | 0 | |||||||||
|
BANKL
Bank Keys
|
BANKK |
CHAR
|
15 | 0 | ||||||||||
|
BANKN
Bank account number
|
BANKN |
CHAR
|
18 | 0 | ||||||||||
|
BANKP
Check Digit for Bank No./Account
|
BANKP |
CHAR
|
2 | 0 | ||||||||||
|
BKONT
Bank Control Key
|
BKONT |
CHAR
|
2 | 0 | ||||||||||
|
SWIFT
SWIFT/BIC for International Payments
|
SWIFT |
CHAR
|
11 | 0 | ||||||||||
|
DTAWS
Instruction key for data medium exchange
|
DTAWS | T015W |
CHAR
|
2 | 0 | |||||||||
|
DTAMS
Indicator for Data Medium Exchange
|
DTAMS |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
STCD1
Tax Number 1
|
STCD1 |
CHAR
|
16 | 0 | ||||||||||
|
STCD2
Tax Number 2
|
STCD2 |
CHAR
|
11 | 0 | ||||||||||
|
PSKTO
Account Number of Bank Account At Post Office
|
PSKTO |
CHAR
|
16 | 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 | ||||||||||
|
EMFSL
Payee key for bank transfers
|
EMFSL |
CHAR
|
8 | 0 | ||||||||||
|
ZWECK
Purpose of Bank Transfers
|
DZWECK |
CHAR
|
40 | 0 | ||||||||||
|
BTTYP
PBS Transfer Type
|
P09_BTTYP | T5M3T |
NUMC
|
2 | 0 | |||||||||
|
PAYTY
Payroll type
|
PAYTY |
CHAR
|
1 | 0 | ||||||||||
|
PAYID
Payroll Identifier
|
PAYID |
CHAR
|
1 | 0 | ||||||||||
|
OCRSN
Reason for Off-Cycle Payroll
|
PAY_OCRSN |
CHAR
|
4 | 0 | ||||||||||
|
BONDT
Off-cycle payroll payment date
|
BONDT |
DATS
|
8 | 0 | ||||||||||
|
BKREF
Reference specifications for bank details
|
BKREF |
CHAR
|
20 | 0 | ||||||||||
|
STRAS
House number and street
|
STRAS |
CHAR
|
30 | 0 | ||||||||||
|
STATE
Region (State, Province, County)
|
REGIO |
CHAR
|
3 | 0 | ||||||||||
|
DEBIT
Automatic Debit Authorization Indicator
|
P00_XDEBIT_INFTY |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
IBAN
IBAN (International Bank Account Number)
|
IBAN |
CHAR
|
34 | 0 | ||||||||||
PA0009 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| PA0009 | BANKS | PA0009 | MANDT |
T005
Countries
|
MANDT |
| PA0009 | BANKS | PA0009 | BANKS |
T005
Countries
|
LAND1 |
| PA0009 | BTTYP | SYST | MANDT |
T5M3T
Texts for Transfer Types (Denmark)
|
MANDT |
| PA0009 | BTTYP | PA0009 | BTTYP |
T5M3T
Texts for Transfer Types (Denmark)
|
BTTYP |
| PA0009 | DTAWS | PA0009 | BANKS |
T015W
Instruction keys
|
BANKS |
| PA0009 | DTAWS | PA0009 | ZLSCH |
T015W
Instruction keys
|
ZLSCH |
| PA0009 | DTAWS | PA0009 | DTAWS |
T015W
Instruction keys
|
DTAWS |
| PA0009 | DTAWS | PA0009 | MANDT |
T015W
Instruction keys
|
MANDT |
| PA0009 | MANDT | PA0009 | MANDT |
T000
Clients
|
MANDT |
| PA0009 | PERNR | SYST | MANDT |
PA0003
HR Master Record: Infotype 0003 (Payroll Status)
|
MANDT |
| PA0009 | PERNR | PA0009 | PERNR |
PA0003
HR Master Record: Infotype 0003 (Payroll Status)
|
PERNR |
| PA0009 | PREAS | SYST | MANDT |
T530E
Reasons for Changes
|
MANDT |
| PA0009 | PREAS | PSKEY | INFTY |
T530E
Reasons for Changes
|
INFTY |
| PA0009 | PREAS | PA0009 | PREAS |
T530E
Reasons for Changes
|
PREAS |
| PA0009 | WAERS | PA0009 | MANDT |
TCURC
Currency Codes
|
MANDT |
| PA0009 | WAERS | PA0009 | WAERS |
TCURC
Currency Codes
|
WAERS |
| PA0009 | ZEINH | PA0009 | ZEINH |
T538A
HR Time/Measurement Units
|
ZEINH |
| PA0009 | ZEINH | PA0009 | MANDT |
T538A
HR Time/Measurement Units
|
MANDT |
| PA0009 | ZLSCH | PA0009 | ZLSCH |
T042Z
Payment Methods for Automatic Payment
|
ZLSCH |
| PA0009 | ZLSCH | PA0009 | MANDT |
T042Z
Payment Methods for Automatic Payment
|
MANDT |
| PA0009 | ZLSCH | PSYST | LAND |
T042Z
Payment Methods for Automatic Payment
|
LAND1 |