Replaced in S/4HANA
This table is replaced by BUT0BK

Customer bank details replaced by Business Partner bank data (BUT0BK).

View all S/4HANA migration mappings →

KNBK

Transparent Table Application Table
16 Fields 3 CDS Views

Customer Master (Bank Details)

KNBK is an SAP database table in S/4HANA. Customer Master (Bank Details). It contains 16 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CustomerBankDetails view from BASIC Customer Bank Details Core
P_ARBSITMCUSTBANKDATA view from BASIC
P_RO_SAFTCustomerBankDetails view from BASIC

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kunnr KUNNR Customer
KEY banks BANKS Bank Ctry/Reg.
KEY bankl BANKK Bank Key
KEY bankn BANKN Bank Account
bkont BKONT Control Key
bvtyp BVTYP Part.bank type
xezer XEZER Collect.author.
bkref BKREF Reference
koinh KOINH_FI Account holder
bank_guid BU_BP_BANK_GUID BP Bank GUID
tech_rectyp CVMD_BANKACC_TECH_RECTYP Bank Acc. type
ebpp_accname EBPP_ACCNAME Account Name
ebpp_bvstatus EBPP_BVSTATUS Status Bk Det.
kovon KOVON Valid from
kobis KOBIS Eff.to

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Customer Master (Bank Details)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNBK (
    MANDT,          -- Client [MANDT]
    KUNNR,          -- Customer [KUNNR]
    BANKS,          -- Bank Ctry/Reg. [BANKS]
    BANKL,          -- Bank Key [BANKK]
    BANKN,          -- Bank Account [BANKN]
    BKONT,          -- Control Key [BKONT]
    BVTYP,          -- Part.bank type [BVTYP]
    XEZER,          -- Collect.author. [XEZER]
    BKREF,          -- Reference [BKREF]
    KOINH,          -- Account holder [KOINH_FI]
    BANK_GUID,      -- BP Bank GUID [BU_BP_BANK_GUID]
    TECH_RECTYP,    -- Bank Acc. type [CVMD_BANKACC_TECH_RECTYP]
    EBPP_ACCNAME,   -- Account Name [EBPP_ACCNAME]
    EBPP_BVSTATUS,  -- Status Bk Det. [EBPP_BVSTATUS]
    KOVON,          -- Valid from [KOVON]
    KOBIS,          -- Eff.to [KOBIS]
    PRIMARY KEY (MANDT, KUNNR, BANKS, BANKL, BANKN)
);

Learn More