KNBK
Customer Master (Bank Details)
KNBK is an SAP database table in S/4HANA. Customer Master (Bank Details). It contains 12 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CustomerBankDetails | view | from | BASIC | Customer Bank Details Core |
| P_ARBSITMCUSTBANKDATA | view | from | BASIC | |
| P_RO_SAFTCustomerBankDetails | view | from | BASIC |
Fields (12)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 |
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]
PRIMARY KEY (MANDT, KUNNR, BANKS, BANKL, BANKN)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA