SAP table KNBK (Customer Master (Bank Details))

SAP table KNBK has 5 primary key fields being MANDT,KUNNR,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
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
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

KNBK foreign key relationships

Table Field Check Table Check Field
0 KNBK BANKS T005 Countries MANDT
0 KNBK BANKS T005 Countries LAND1
1 KNBK KUNNR KNA1 General Data in Customer Master MANDT
1 KNBK KUNNR KNA1 General Data in Customer Master KUNNR
0 KNBK MANDT T000 Clients MANDT