SAP Table KNBK
Customer Master (Bank Details)
KNBK (Customer Master (Bank Details)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link KNBK to other SAP tables.
KNBK table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
KUNNR
Customer Number
|
KUNNR | KNA1 |
CHAR
|
10 | 0 | |||||||||||||
|
BANKS
Bank country key
|
BANKS | T005 |
CHAR
|
3 | 0 | |||||||||||||
|
BANKL
Bank Keys
|
BANKK |
CHAR
|
15 | 0 | ||||||||||||||
|
BANKN
Bank account number
|
BANKN |
CHAR
|
18 | 0 | ||||||||||||||
|
BKONT
Bank Control Key
|
BKONT |
CHAR
|
2 | 0 | ||||||||||||||
|
BVTYP
Partner Bank Type
|
BVTYP |
CHAR
|
4 | 0 | ||||||||||||||
|
XEZER
Indicator: Is there collection authorization ?
|
XEZER |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BKREF
Reference specifications for bank details
|
BKREF |
CHAR
|
20 | 0 | ||||||||||||||
|
KOINH
Account Holder Name
|
KOINH_FI |
CHAR
|
60 | 0 | ||||||||||||||
|
EBPP_ACCNAME
User-Defined Name of Bank Details
|
EBPP_ACCNAME |
CHAR
|
40 | 0 | ||||||||||||||
|
EBPP_BVSTATUS
Status of Bank Details in Biller Direct
|
EBPP_BVSTATUS |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
KOVON
Bank Details Valid From
|
KOVON |
DATS
|
8 | 0 | ||||||||||||||
|
KOBIS
Bank details valid to
|
KOBIS |
DATS
|
8 | 0 | ||||||||||||||
KNBK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| KNBK | BANKS | KNBK | MANDT |
T005
Countries
|
MANDT |
| KNBK | BANKS | KNBK | BANKS |
T005
Countries
|
LAND1 |
| KNBK | KUNNR | KNBK | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNBK | KUNNR | KNBK | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| KNBK | MANDT | KNBK | MANDT |
T000
Clients
|
MANDT |