SAP Table BNKA
Bank master record
BNKA (Bank master record) 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 BNKA to other SAP tables.
BNKA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
BANKS
Bank country key
|
BANKS | T005 |
CHAR
|
3 | 0 | |||||||
|
BANKL
Bank Keys
|
BANKK |
CHAR
|
15 | 0 | ||||||||
|
ERDAT
Date on which the record was created
|
ERDAT_BF |
DATS
|
8 | 0 | ||||||||
|
ERNAM
Name of person who created the object
|
ERNAM_BF |
CHAR
|
12 | 0 | ||||||||
|
BANKA
Name of bank
|
BANKA |
CHAR
|
60 | 0 | ||||||||
|
PROVZ
Region (State, Province, County)
|
REGIO | T005S |
CHAR
|
3 | 0 | |||||||
|
STRAS
House number and street
|
STRAS_GP |
CHAR
|
35 | 0 | ||||||||
|
ORT01
City
|
ORT01_GP |
CHAR
|
35 | 0 | ||||||||
|
SWIFT
SWIFT/BIC for International Payments
|
SWIFT |
CHAR
|
11 | 0 | ||||||||
|
BGRUP
Bank group (bank network)
|
BGRUP |
CHAR
|
2 | 0 | ||||||||
|
XPGRO
Post Office Bank Current Account
|
XPGRO |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
LOEVM
Deletion Indicator
|
LOEVM |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
BNKLZ
Bank number
|
BANKL |
CHAR
|
15 | 0 | ||||||||
|
PSKTO
Post office bank current account number
|
PSKTO_CH |
CHAR
|
16 | 0 | ||||||||
|
ADRNR
Address number
|
AD_ADDRNUM |
CHAR
|
10 | 0 | ||||||||
|
BRNCH
Bank Branch
|
BRNCH |
CHAR
|
40 | 0 | ||||||||
|
CHKME
Check digit calculation method
|
CHECKMETH |
CHAR
|
4 | 0 | ||||||||
|
VERS
Format of File with Bank Data
|
VERS_BF |
CHAR
|
3 | 0 | ||||||||
|
BICKY
Key of a BIC+ data record (Swift)
|
PRQ_BICKY |
CHAR
|
12 | 0 | ||||||||
|
RCCODE
Routing control code
|
PRQ_RCC |
CHAR
|
15 | 0 | ||||||||
BNKA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| BNKA | BANKS | BNKA | MANDT |
T005
Countries
|
MANDT |
| BNKA | BANKS | BNKA | BANKS |
T005
Countries
|
LAND1 |
| BNKA | MANDT | BNKA | MANDT |
T000
Clients
|
MANDT |
| BNKA | PROVZ | BNKA | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| BNKA | PROVZ | BNKA | BANKS |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| BNKA | PROVZ | BNKA | PROVZ |
T005S
Taxes: Region (Province) Key
|
BLAND |