SAP Table P0009
HR Master Record: Infotype 0009 (Bank Details)
P0009 (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 P0009 to other SAP tables.
Source: P0009 (HR Master Record: Infotype 0009 (Bank Details))
P0009 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||||
INFTY | Infotype | INFTY | T582A | CHAR | 4 | 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 |
Possible values
|
||||||||
REFEX | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | 0 |
Possible values
|
||||||||
ORDEX | Confirmation Fields Exist | ORDEX | CHAR | 1 | 0 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
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 | T591A | 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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | 0 |
P0009 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
P0009 | BANKS | P0009 | BANKS | T005 | Countries | LAND1 |
P0009 | BANKS | SYST | MANDT | T005 | Countries | MANDT |
P0009 | BNKSA | P0009 | BNKSA | T591A | Subtype Characteristics | SUBTY |
P0009 | BNKSA | P0009 | INFTY | T591A | Subtype Characteristics | INFTY |
P0009 | BNKSA | SYST | MANDT | T591A | Subtype Characteristics | MANDT |
P0009 | BTTYP | P0009 | BTTYP | T5M3T | Texts for Transfer Types (Denmark) | BTTYP |
P0009 | BTTYP | SYST | MANDT | T5M3T | Texts for Transfer Types (Denmark) | MANDT |
P0009 | DTAWS | P0009 | ZLSCH | T015W | Instruction keys | ZLSCH |
P0009 | DTAWS | P0009 | DTAWS | T015W | Instruction keys | DTAWS |
P0009 | DTAWS | P0009 | BANKS | T015W | Instruction keys | BANKS |
P0009 | DTAWS | SYST | MANDT | T015W | Instruction keys | MANDT |
P0009 | INFTY | P0009 | INFTY | T582A | Infotypes: Customer-Specific Settings | INFTY |
P0009 | INFTY | SYST | MANDT | T582A | Infotypes: Customer-Specific Settings | MANDT |
P0009 | PREAS | P0009 | PREAS | T530E | Reasons for Changes | PREAS |
P0009 | PREAS | P0009 | INFTY | T530E | Reasons for Changes | INFTY |
P0009 | PREAS | SYST | MADNT | T530E | Reasons for Changes | MANDT |
P0009 | WAERS | SYST | MANDT | TCURC | Currency Codes | MANDT |
P0009 | WAERS | P0009 | WAERS | TCURC | Currency Codes | WAERS |
P0009 | ZEINH | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
P0009 | ZEINH | P0009 | ZEINH | T538A | HR Time/Measurement Units | ZEINH |
P0009 | ZLSCH | SYST | MANDT | T042Z | Payment Methods for Automatic Payment | MANDT |
P0009 | ZLSCH | PSYST | LAND | T042Z | Payment Methods for Automatic Payment | LAND1 |
P0009 | ZLSCH | P0009 | ZLSCH | T042Z | Payment Methods for Automatic Payment | ZLSCH |