SAP Table IBNKA

Table of bank addresses

IBNKA (Table of bank addresses) 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 IBNKA to other SAP tables.

IBNKA table fields

Field Data element Checktable Datatype Length Decimals
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
X Yes
NULL No
LOEVM Deletion Indicator LOEVM CHAR 1 0
X Yes
NULL No
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
KZ Single-Character Indicator CHAR1 CHAR 1 0
AD Single-Character Indicator CHAR1 CHAR 1 0

IBNKA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
IBNKA BANKS IBNKA MANDT T005 Countries MANDT
IBNKA BANKS IBNKA BANKS T005 Countries LAND1
IBNKA MANDT IBNKA MANDT T000 Clients MANDT
IBNKA PROVZ IBNKA BANKS T005S Taxes: Region (Province) Key LAND1
IBNKA PROVZ IBNKA PROVZ T005S Taxes: Region (Province) Key BLAND
IBNKA PROVZ IBNKA MANDT T005S Taxes: Region (Province) Key MANDT