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

Customer company code data migrated to Business Partner. KNB1 exists as compatibility view.

View all S/4HANA migration mappings →

KNB1

Transparent Table Application Table
92 Fields 20 CDS Views

Customer Master (Company Code)

KNB1 is an SAP database table in S/4HANA. Customer Master (Company Code). It contains 92 fields. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
/dmbe/i_Shipto_With_Admin_Data view left_outer Ship To View Contaning Admin Data
/dmbe/i_Shipto_Without_Adm_Dat view left_outer Ship To View With Empty Admin Data
/SCMTMS/CV_SupplCustOrg view left_outer View to get supplier and cust org data
E_CUSCO_D view from EXTENSION Extensibility Customer Company Code Core
ESH_N_KNA1_KNB1_KNB1_CUSTOMER view from Customer Master (Company Code)
fac_ad_cds_account_buv view union Help View for Account in Trans-Key BUV
FISVD_OPNIT_01 view left_outer Open Items of Manual Clearing
FISVD_OPNITM_01 view left_outer Open Items of Manual Clearing
FNDEI_KNB1_BLOCKINGINFO view from Blocking Info View for table KNB1
FNDEI_KNB1_FILTER view from Filter View for table KNB1
I_ACMCustCo view_entity from BASIC Customer Company Code
I_ACMCustomerCompanyCode view from BASIC Customer Company Code
I_BalanceAuditTrailCustomer view inner BASIC Customers for Balance Audit Trail
I_CustomerCompany view from BASIC Customer Company
I_DisputeCaseCompanyCodeVH view from BASIC Dispute Case Company Code
I_PlndOrdCustCoByPlant view_entity inner BASIC Planned Order Customer Company By Plant
J2G_SHSM_DEBI2 view inner
m_v_eop_customer view inner EOP Check CDS View: Customer Master
SHSM_FAR_CUSTOMER_COMPANY view left_outer Value-Help for Customers in Company Code
SHSM_FAR_DBUKA view from Value-Help for Company Code with regard to customer

Fields (92)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kunnr KUNNR Customer
KEY bukrs BUKRS Company Code
pernr PERNR_D Personnel No.
knb1_eew_cc KNB1_EEW_CC Extensibility enabled for Company Code
erdat ERDAT_RF Created On
ernam ERNAM_RF Created by
sperr SPERB_B Co.code post.block
loevm LOEVM_B Co.Cde Deletion Flag
zuawa DZUAWA Sort key
busab BUSAB Clerk Abbrev.
akont AKONT Recon. account
begru BRGRU Authorization
knrze KNRZE Head Office
knrzb KNRZB Alternat.payer
zamim DZAMIM Cust.(with CI)
zamiv DZAMIV Sales
zamir DZAMIR Legal Departmnt
zamib DZAMIB Accounting
zamio DZAMIO Cust.(W/o CI)
zwels DZWELS Payment Methods
xverr XVERR_KNB1 Clrg with vend.
zahls DZAHLS Payment Block
zterm DZTERM Pyt Terms
wakon WAKON BoE Chrges Trms
vzskz VZSKZ Interest Indic.
zindt DZINDT Last Key Date
zinrt DZINRT Int.Calc.Freq.
eikto EIKTO_D Acct at cust.
zsabe DZSABE_D Customer user
kverm KVERM Account Memo
fdgrv FDGRV Planning Group
vrbkz VRBKZ Institution No.
vlibb VLIBB_CS Amount Insured
vrszl VRSZL Lead Months
vrspr VRSPR Deductible
vrsnr VRSNR Policy No.
verdt VERDT Valid To
perkz PERKZ_KNB1 Coll.Invce.Var.
xdezv XDEZV Local Process.
xausz XAUSZ Acct Statement
webtr WEBTR_CS Bill/Ex. Limit
remit REMIT Next payee
datlz DATLZ Last Int. Calc.
xzver XZVER Rec.Payt Hist.
togru TOGRU Tolerance Group
kultg KULTG Chk cashng time
hbkid HBKID House Bank
xpore XPORE Individual Payt
blnkz BLNKZ Subs.ind.
altkn ALTKN Prev.Acct No.
zgrup DZGRUP Grouping key
urlid URLID Known/Neg.Leave
mgrup MGRUP Grouping Key
lockb LOCKB Lockbox
uzawe UZAWE Pmnt Meth. Sup.
ekvbd EKVBD Buying Group
sregl SREGL Selection Rule
xedip XEDIP Pmt adv. by EDI
frgrp FRGRP Release Group
vrsdg VRSDG Rsn Code Conv.
tlfxs TLFXS Clerk's fax
intad INTAD Clrk's internet
xknzb XKNZB Alt.Payer(Doc.)
guzte GUZTE Cr Memo Terms
gricd J_1AGICD_D Activity Code
gridt J_1ADTYP_D Distr. Type
wbrsl WBRSL Value Adj. Key
confs CONFS_B ConfirmSt (CCd)
updat UPDAT_RF Confirm.date
uptim UPTIM_RF Confirm.time
nodel NODEL_B CoCd del.block
tlfns TLFNS Act.clk tel.no.
cession_kz CESSION_KZ AR Pledging Ind
avsnd AVSND PmtAdv. XML
ad_hash ADHASH E-Mail for Avis
qland QLAND WTax C/R Key
cvp_xblck_b CVP_XBLCK Purpose Completed
ciiucode CIIUCODE main economic act.
paymentclearinggrpid FAR_PAYMENT_CLEARING_GROUP Payment Clrg Grp ID
paytrsn FARP_PAYT_RSN Payment Reason
gmvkzd GMVKZD Execution
us_rec_country LAND1 Country/Reg.
us_giin FIWTUS_RECIPIENT_GIIN US Recipient GIIN
us_ftid FIWTUS_RECIPIENT_FTID US Recipient FTID
us_lob_code FIWTUS_LOB_CODE LOB Treaty Code
us_w8_recvdate FIWTUS_W8_RECV_DATE W8 Form Rec Date
us_w9_recvdate FIWTUS_W9_RECV_DATE W9 Form Rec Date
us_tin_notice FIWTUS_SECOND_TIN_NOTICE Second TIN Notice
us_partnership_ind FIWTUS_PARTNERSHIP_IND Partnership Int Ind
us_fatca_ind FIWTUS_FATCA_IND FATCA Ind
us_chap4_status_code FIWTUS_CHAP4_STATUS_CODE Chaptr 4 Status Code

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 (Company Code)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNB1 (
    MANDT,                 -- Client [MANDT]
    KUNNR,                 -- Customer [KUNNR]
    BUKRS,                 -- Company Code [BUKRS]
    PERNR,                 -- Personnel No. [PERNR_D]
    KNB1_EEW_CC,           -- Extensibility enabled for Company Code [KNB1_EEW_CC]
    ERDAT,                 -- Created On [ERDAT_RF]
    ERNAM,                 -- Created by [ERNAM_RF]
    SPERR,                 -- Co.code post.block [SPERB_B]
    LOEVM,                 -- Co.Cde Deletion Flag [LOEVM_B]
    ZUAWA,                 -- Sort key [DZUAWA]
    BUSAB,                 -- Clerk Abbrev. [BUSAB]
    AKONT,                 -- Recon. account [AKONT]
    BEGRU,                 -- Authorization [BRGRU]
    KNRZE,                 -- Head Office [KNRZE]
    KNRZB,                 -- Alternat.payer [KNRZB]
    ZAMIM,                 -- Cust.(with CI) [DZAMIM]
    ZAMIV,                 -- Sales [DZAMIV]
    ZAMIR,                 -- Legal Departmnt [DZAMIR]
    ZAMIB,                 -- Accounting [DZAMIB]
    ZAMIO,                 -- Cust.(W/o CI) [DZAMIO]
    ZWELS,                 -- Payment Methods [DZWELS]
    XVERR,                 -- Clrg with vend. [XVERR_KNB1]
    ZAHLS,                 -- Payment Block [DZAHLS]
    ZTERM,                 -- Pyt Terms [DZTERM]
    WAKON,                 -- BoE Chrges Trms [WAKON]
    VZSKZ,                 -- Interest Indic. [VZSKZ]
    ZINDT,                 -- Last Key Date [DZINDT]
    ZINRT,                 -- Int.Calc.Freq. [DZINRT]
    EIKTO,                 -- Acct at cust. [EIKTO_D]
    ZSABE,                 -- Customer user [DZSABE_D]
    KVERM,                 -- Account Memo [KVERM]
    FDGRV,                 -- Planning Group [FDGRV]
    VRBKZ,                 -- Institution No. [VRBKZ]
    VLIBB,                 -- Amount Insured [VLIBB_CS]
    VRSZL,                 -- Lead Months [VRSZL]
    VRSPR,                 -- Deductible [VRSPR]
    VRSNR,                 -- Policy No. [VRSNR]
    VERDT,                 -- Valid To [VERDT]
    PERKZ,                 -- Coll.Invce.Var. [PERKZ_KNB1]
    XDEZV,                 -- Local Process. [XDEZV]
    XAUSZ,                 -- Acct Statement [XAUSZ]
    WEBTR,                 -- Bill/Ex. Limit [WEBTR_CS]
    REMIT,                 -- Next payee [REMIT]
    DATLZ,                 -- Last Int. Calc. [DATLZ]
    XZVER,                 -- Rec.Payt Hist. [XZVER]
    TOGRU,                 -- Tolerance Group [TOGRU]
    KULTG,                 -- Chk cashng time [KULTG]
    HBKID,                 -- House Bank [HBKID]
    XPORE,                 -- Individual Payt [XPORE]
    BLNKZ,                 -- Subs.ind. [BLNKZ]
    ALTKN,                 -- Prev.Acct No. [ALTKN]
    ZGRUP,                 -- Grouping key [DZGRUP]
    URLID,                 -- Known/Neg.Leave [URLID]
    MGRUP,                 -- Grouping Key [MGRUP]
    LOCKB,                 -- Lockbox [LOCKB]
    UZAWE,                 -- Pmnt Meth. Sup. [UZAWE]
    EKVBD,                 -- Buying Group [EKVBD]
    SREGL,                 -- Selection Rule [SREGL]
    XEDIP,                 -- Pmt adv. by EDI [XEDIP]
    FRGRP,                 -- Release Group [FRGRP]
    VRSDG,                 -- Rsn Code Conv. [VRSDG]
    TLFXS,                 -- Clerk's fax [TLFXS]
    INTAD,                 -- Clrk's internet [INTAD]
    XKNZB,                 -- Alt.Payer(Doc.) [XKNZB]
    GUZTE,                 -- Cr Memo Terms [GUZTE]
    GRICD,                 -- Activity Code [J_1AGICD_D]
    GRIDT,                 -- Distr. Type [J_1ADTYP_D]
    WBRSL,                 -- Value Adj. Key [WBRSL]
    CONFS,                 -- ConfirmSt (CCd) [CONFS_B]
    UPDAT,                 -- Confirm.date [UPDAT_RF]
    UPTIM,                 -- Confirm.time [UPTIM_RF]
    NODEL,                 -- CoCd del.block [NODEL_B]
    TLFNS,                 -- Act.clk tel.no. [TLFNS]
    CESSION_KZ,            -- AR Pledging Ind [CESSION_KZ]
    AVSND,                 -- PmtAdv. XML [AVSND]
    AD_HASH,               -- E-Mail for Avis [ADHASH]
    QLAND,                 -- WTax C/R Key [QLAND]
    CVP_XBLCK_B,           -- Purpose Completed [CVP_XBLCK]
    CIIUCODE,              -- main economic act. [CIIUCODE]
    PAYMENTCLEARINGGRPID,  -- Payment Clrg Grp ID [FAR_PAYMENT_CLEARING_GROUP]
    PAYTRSN,               -- Payment Reason [FARP_PAYT_RSN]
    GMVKZD,                -- Execution [GMVKZD]
    US_REC_COUNTRY,        -- Country/Reg. [LAND1]
    US_GIIN,               -- US Recipient GIIN [FIWTUS_RECIPIENT_GIIN]
    US_FTID,               -- US Recipient FTID [FIWTUS_RECIPIENT_FTID]
    US_LOB_CODE,           -- LOB Treaty Code [FIWTUS_LOB_CODE]
    US_W8_RECVDATE,        -- W8 Form Rec Date [FIWTUS_W8_RECV_DATE]
    US_W9_RECVDATE,        -- W9 Form Rec Date [FIWTUS_W9_RECV_DATE]
    US_TIN_NOTICE,         -- Second TIN Notice [FIWTUS_SECOND_TIN_NOTICE]
    US_PARTNERSHIP_IND,    -- Partnership Int Ind [FIWTUS_PARTNERSHIP_IND]
    US_FATCA_IND,          -- FATCA Ind [FIWTUS_FATCA_IND]
    US_CHAP4_STATUS_CODE,  -- Chaptr 4 Status Code [FIWTUS_CHAP4_STATUS_CODE]
    PRIMARY KEY (MANDT, KUNNR, BUKRS)
);

Learn More