SAP table LFBK (Vendor Master (Bank Details))

SAP table LFBK has 5 primary key fields being MANDT,LIFNR,BANKS,BANKL,BANKN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
BANKS Country/Region Key of Bank CHAR 3 0 T005 BANKS
BANKL Bank Keys CHAR 15 0 BANKK
BANKN Bank account number CHAR 18 0 BANKN
BKONT Bank Control Key CHAR 2 0 BKONT
BVTYP Partner bank type CHAR 4 0 BVTYP
XEZER Indicator: Is there collection authorization ? CHAR 1 0 XEZER
BKREF Reference Details for Bank Details CHAR 20 0 BKREF
KOINH Account Holder Name CHAR 60 0 KOINH_FI
BANK_GUID BP: Bank Account Alias GUID RAW 16 0 BU_BP_BANK_GUID
TECH_RECTYP Type of Bank Account when Bank GUID is referenced CHAR 1 0 CVMD_BANKACC_TECH_RECTYP
A Bank Account Alias
EBPP_ACCNAME User-Defined Name of Bank Details CHAR 40 0 EBPP_ACCNAME
EBPP_BVSTATUS Status of Bank Details in Biller Direct CHAR 1 0 EBPP_BVSTATUS
Can be Displayed/Used in Biller Direct, Used in Standard
A Can be Displayed/Used in Biller Direct, Not Used in Standard
B Can be Changed/Used in Biller Direct, Used in Standard
C Can be Changed/Used in Biller Direct, Not Used in Standard
D Can Only be Used in Standard
KOVON Bank Details Valid From DATS 8 0 KOVON
KOBIS Bank details valid to DATS 8 0 KOBIS

LFBK foreign key relationships

Table Field Check Table Check Field
0 LFBK BANKS T005 Countries MANDT
0 LFBK BANKS T005 Countries LAND1
1 LFBK LIFNR LFA1 Supplier Master (General Section) MANDT
1 LFBK LIFNR LFA1 Supplier Master (General Section) LIFNR
0 LFBK MANDT T000 Clients MANDT