SAP table BNKA (Bank master record)
SAP table BNKA stores master data related to banks. It includes essential information such as bank key, bank name, branch details, country, and bank address. This table is primarily used in financial and payment processing within SAP systems, serving as a reference for bank-related transactions, such as vendor and customer payments, and enabling efficient handling of banking operations across various SAP modules.
SAP table BNKA has 3 primary key fields being MANDT,BANKS,BANKL.
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
Client
CLNT
3
0
T000
MANDT
Country/Region Key of Bank
CHAR
3
0
T005
BANKS
Bank Keys
CHAR
15
0
BANKK
ERDAT
Date on which the record was created
DATS
8
0
ERDAT_BF
ERNAM
Name of person who created the object
CHAR
12
0
ERNAM_BF
BANKA
Name of Financial Institution
CHAR
60
0
BANKA
PROVZ
Region (State, Province, County)
CHAR
3
0
T005S
REGIO
STRAS
Street and House Number
CHAR
35
0
STRAS_GP
ORT01
City
CHAR
35
0
ORT01_GP
SWIFT
SWIFT/BIC for International Payments
CHAR
11
0
SWIFT
BGRUP
Bank group (bank network)
CHAR
2
0
BGRUP
XPGRO
Post Office Bank Current Account
CHAR
1
0
XPGRO
LOEVM
Deletion Indicator
CHAR
1
0
LOEVM
BNKLZ
Bank Number
CHAR
15
0
BANKL
PSKTO
Post office bank current account number
CHAR
16
0
PSKTO_CH
ADRNR
Address Number
CHAR
10
0
AD_ADDRNUM
BRNCH
Bank Branch
CHAR
40
0
BRNCH
CHKME
Check digit calculation method
CHAR
4
0
CHECKMETH
VERS
Format of File with Bank Data
CHAR
3
0
VERS_BF
IBAN_RULE
IBAN Rule
CHAR
6
0
IBAN_RULE
SDD_B2B
Support of SEPA B2B Direct Debit
NUMC
1
0
SDD_B2B
Possible values
0
Unknown
1
SDD B2B Supported
9
SDD B2B Not Supported
SDD_COR1
Support of SEPA COR1 Direct Debit
NUMC
1
0
SDD_COR1
Possible values
0
Unknown
1
SDD COR1 Supported
9
SDD COR1 Not Supported
SDD_RTRANS
Support of SEPA Returned Debits (R Transactions)
NUMC
1
0
SDD_RTRANS
Possible values
0
Unknown
1
R Transactions Supported for SDD B2B and SDD Core
2
R Transactions Supported for SDD B2B
3
R Transactions Supported for SDD Core
9
R Transactions Not Supported
ZNOCHECK
Flag for not checking the bank account
CHAR
1
0
/ATL/LNOCHECK
ZACC_LEN
Account length for checking
CHAR
9
0
/ATL/LACC_LEN
ZRES1
Residue
NUMC
3
0
/ATL/LRESIDUE
ZRES2
Residue
NUMC
3
0
/ATL/LRESIDUE
ZRES3
Residue
NUMC
3
0
/ATL/LRESIDUE
ZRES4
Residue
NUMC
3
0
/ATL/LRESIDUE
ZRES5
Residue
NUMC
3
0
/ATL/LRESIDUE
ZRES6
Residue
NUMC
3
0
/ATL/LRESIDUE
ZRES7
Residue
NUMC
3
0
/ATL/LRESIDUE
ZRES8
Residue
NUMC
3
0
/ATL/LRESIDUE
ZRES9
Residue
NUMC
3
0
/ATL/LRESIDUE
ZRES10
Residue
NUMC
3
0
/ATL/LRESIDUE
BICKY
Key of a BIC+ data record (Swift)
CHAR
12
0
PRQ_BICKY
RCCODE
Routing control code
CHAR
15
0
PRQ_RCC
BNKA foreign key relationships
Table
Field
Check Table
Check Field
0 BNKA
BANKS
T005 Countries
MANDT
0 BNKA
BANKS
T005 Countries
LAND1
1 BNKA
MANDT
T000 Clients
MANDT
0 BNKA
PROVZ
T005S Taxes: Region (Province) Key
LAND1