SAP table PA0011 (HR Master Record: Infotype 0011 (Ext.Bank Transfers))

SAP table PA0011 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
LGART Wage Type CHAR 4 0 T512Z LGART
OPKEN Operation Indicator for Wage Types CHAR 1 0 OPKEN
Payment
A Deduction
BETRG Wage Type Amount for Payments CURR 13 2 PAD_AMT7S
WAERS Currency Key CUKY 5 0 TCURC WAERS
ANZHL Number DEC 7 2 ANZHL
ZEINH Time/Measurement Unit CHAR 3 0 T538A PT_ZEINH
ZDATE First payment date DATS 8 0 DZDATE
ZFPER First payment period NUMC 2 0 DZFPER
ZANZL Number for determining further payment dates DEC 3 0 DZANZL
ZEINZ Time unit for determining next payment CHAR 3 0 T538C DZEINZ
PRITY Priority CHAR 1 0 PPRIO
EMFSL Payee key for bank transfers CHAR 8 0 EMFSL
EMFTX Payee Text CHAR 40 0 EMFTX
BKPLZ Postal Code CHAR 10 0 PSTLZ
BKORT City CHAR 25 0 ORT01
BANKS Country/Region Key CHAR 3 0 T005 LAND1
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
ZWECK Purpose of Bank Transfers CHAR 40 0 DZWECK
ZLSCH Payment Method CHAR 1 0 T042Z PCODE
UWDAT Date of Bank Transfer DATS 8 0 UWDAT
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
IBAN IBAN (International Bank Account Number) CHAR 34 0 IBAN

PA0011 foreign key relationships

Table Field Check Table Check Field
0 PA0011 BANKS T005 Countries MANDT
0 PA0011 BANKS T005 Countries LAND1
1 PA0011 DTAWS T015W Instruction keys BANKS
1 PA0011 DTAWS T015W Instruction keys ZLSCH
1 PA0011 DTAWS T015W Instruction keys DTAWS
0 PA0011 LGART T512Z Permissibility of Wage Types per Infotype MANDT
0 PA0011 LGART T512Z Permissibility of Wage Types per Infotype INFTY
0 PA0011 LGART T512Z Permissibility of Wage Types per Infotype MOLGA
0 PA0011 LGART T512Z Permissibility of Wage Types per Infotype LGART
0 PA0011 LGART T512Z Permissibility of Wage Types per Infotype ENDDA
1 PA0011 MANDT T000 Clients MANDT
0 PA0011 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
0 PA0011 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
1 PA0011 PREAS T530E Reasons for Changes MANDT
1 PA0011 PREAS T530E Reasons for Changes INFTY
1 PA0011 PREAS T530E Reasons for Changes PREAS
0 PA0011 WAERS TCURC Currency Codes MANDT
0 PA0011 WAERS TCURC Currency Codes WAERS
1 PA0011 ZEINH T538A HR Time/Measurement Units MANDT
1 PA0011 ZEINH T538A HR Time/Measurement Units ZEINH
0 PA0011 ZEINZ T538C Permissibility of Time/Measurement Units for Infotypes MANDT
0 PA0011 ZEINZ T538C Permissibility of Time/Measurement Units for Infotypes INFTY
0 PA0011 ZEINZ T538C Permissibility of Time/Measurement Units for Infotypes ZEINH
1 PA0011 ZLSCH T042Z Payment Methods for Automatic Payment MANDT
1 PA0011 ZLSCH T042Z Payment Methods for Automatic Payment LAND1
1 PA0011 ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH