cancel
Showing results for 
Search instead for 
Did you mean: 

How to extract IBAN accounts for only those vendors that has maintained IBAN from vendor master

0 Kudos
757

Hi All,

I am trying to pull together a database that is good for regular vendor audit. I am struggling with IBAN though.

I know that LFBK table contains bank key /bank account/ country which I can concatenate and generate IBAN, not sure if vendor number included should be embedded to a key through which I could get my existing IBANS from another table. the issue is that not ALL of my suppliers need to have IBAN. My key objective is to extract IBANs where they are maintained.

I can use TIBAN table, however this table extracts the "potential combination of IBAN numbers" on the basis of the information available using bank keys and bank accounts -> I can have multiple IBANs on the basis of the bank key from the bank master.

In the TIBAN table there is a parameter "key to origin table" that I am wondering where it leads me (?),

I assume should be the key to some other tables (T012K?) that could help me to generate a key from LFBK -> and match to to find those IBAN numbers that are uploaded onto the system in reality.

house banks are not used for vendors - so that info is not useful for me...

Could you please help?

Accepted Solutions (0)

Answers (0)