on 2021 Apr 30 5:52 PM
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?
Request clarification before answering.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.