How to find the BIC code from IBAN id

Hello All,

I have IBAN id (FR7615629002560002012400354).

How Can I find the respective BIC code for this IBAN id.

I have used CALL getBICfromIBAN(IbanId, BicCode, Error)

But sometimes I didnt get BIC code for some IBAN ids.

I have checked the IN.IBAN.PLUS table with National ID from the IBAN (FR7615629002560002012400354)
National Id is IBAN[5,10]

But I iddnt found any IN.IBAN.PLUS / DE.BIC records for this national ID.

Any other way to get BIC code from IBAN ???

Please let me know if you guys have any clue ...

Thanks in advance.

Hello Baskarjay

This will be difficult because the DE.BIC table is normally loded from a databse file got from SWIFT, based on the IBAN structure BIC can be deduced from COUNTRY CODE + BANK ID + BRANCH ID.

I suggest you create a routine to do this, at the only condition you DE.BIC is up to date.


Regards