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.

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
X Yes
NULL No
REFEX Reference Fields Exist (Primary/Secondary Costs) PRFEX CHAR 1 0
X Yes
NULL No
ORDEX Confirmation Fields Exist ORDEX CHAR 1 0
X Yes
NULL No
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
NULL Reference
A Deduction
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
1 Single data record not to be forwarded to the Bundesbank
0 Single data record can be forwarded to the Bundesbank
NULL Use house bank default value
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
X Yes
NULL No
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 SYST MANDT T005 Countries MANDT
P0009 BANKS P0009 BANKS T005 Countries LAND1
P0009 BNKSA SYST MANDT T591A Subtype Characteristics MANDT
P0009 BNKSA P0009 INFTY T591A Subtype Characteristics INFTY
P0009 BNKSA P0009 BNKSA T591A Subtype Characteristics SUBTY
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 SYST MANDT T015W Instruction keys MANDT
P0009 DTAWS P0009 BANKS T015W Instruction keys BANKS
P0009 INFTY P0009 INFTY T582A Infotypes: Customer-Specific Settings INFTY
P0009 INFTY SYST MANDT T582A Infotypes: Customer-Specific Settings MANDT
P0009 PREAS P0009 INFTY T530E Reasons for Changes INFTY
P0009 PREAS P0009 PREAS T530E Reasons for Changes PREAS
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