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 are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
BNKA columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||
| KeyBANKS | Country/Region Key of Bank | CHAR | 3 | 0 | T005 | BANKS | |||||||||||
| KeyBANKL | 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 | ||||||||||||
|
|||||||||||||||||
| SDD_COR1 | Support of SEPA COR1 Direct Debit | NUMC | 1 | 0 | SDD_COR1 | ||||||||||||
|
|||||||||||||||||
| SDD_RTRANS | Support of SEPA Returned Debits (R Transactions) | NUMC | 1 | 0 | SDD_RTRANS | ||||||||||||
|
|||||||||||||||||
| 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 | ||||||||||||