Table name from which to extract bank name and swift code by key field as vendor code

[Former Member]

Please help with the table name from which we can extract the bank name and swift code of vendors with the key input as vendor numbers

[Former Member]

Hello All,

Can we extract the data related to bank name and swift code from BNKA table ?

but this wont work for many vendors.

Is there any other way out ?

Can we use any combination of table like LFA1 with BNKA to fetch these details?

[Former Member]

Use a join of LFA1 and BKNA in SQVI with LIFNR as a selection criteria.

[Former Member]

Hi Manosij,

Thanks for the reply.

But can u pls guide me thru how do I go about it ?

If possible , tell me the process to follow .

Regards,

Subhadra

[Former Member]

I tried to do it , but the field LIFNR is appearing in LFA1 table only and not in BNKA table.

What should be the join conditions for joining these two tables LFA1 and BNKA?

[Former Member]

Hello Subhadra, I'm sorry, I should've said join of LFBK and BNKA. The fields for the join will be the bank country(BANKS) and bank key (BANKL).

If you have not found a docu on SQVI already, you can refer to this:

This is how your join should look in BASIS mode, your selection parameter should be vendor code LIFNR; output fields with be bank name BANKA and swift code SWIFT.

[Former Member]

Hi ,

Thanks a lot ! for this doc.

However, there seems some problem while defining the join.

The joined table is picking all data from the first table i.e. LFA1 but it is not picking any data from the second table, while I tried to link LFA1 with LFB1.

Firstly, is there any way where we can define the type of join , whether Union, Intersection or so ?

Secondly, whats the difference between List Fields and Selection fields?

Regards,

Subhadra.

[Former Member]

Try using table LFBK

[Former Member]

Hi ,

In this table LFBK , there is no option to get the swift code and bank name.

Only the bank details like bank key, account etc are available.