Need IBAN from BP - pls someone can confirm the SQL-Select-Statement

[Former Member]

Hi guys,

I need to know the IBAN from some BP and I would like to use the TX: ST04 for that. I have build this SQL-Statement. Pls can someone confirm, that this is the correct way:

SELECT a.partner as GP,
               a.banks as Bankland,   
               a.bankl as Bankschluessel,   
               a.bankn as Bankkontonummer,   
               b.iban as IBAN
FROM but0bk as a INNER JOIN tiban as b
ON a.banks = b.banks AND a.bankl = b.bankl AND a.bankn = b.bankn
WHERE a.bkvid = '0001'

Especially the ON condition

Thx for help!

Best regards
Jens

[Former Member]

Additionally: A Quick View wouldnt work, because I can`t JOIN the BANKN. They are CHARS with different length I read in another post. But my question is, is it the right way to map These 3 Parameters (BANKS, BANKL, BANKN) to get a unique IBAN for the bank of the BP. Thx