SE11 ABAP Dictionary SE11 KNB1

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

KNB1

Customer Master (Company Code)

SAP SAP Transparent Table 74 Fields

Primary Key:

MANDT KUNNR BUKRS

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	KUNNR	KEY	Customer	CHAR	10	-	KNA1	Customer Number 1
3	BUKRS	KEY	CoCode	CHAR	4	-	T001	Company Code
4	PERNR	-	Pers.No.	NUMC	8	-	-	Personnel Number
5	ERDAT	-	Creat.date	DATS	8	-	-	Date on which the Record Was Created
6	ERNAM	-	Created by	CHAR	12	-	-	Name of Person who Created the Object
7	SPERR	-	Pstg block	CHAR	1	-	-	Posting block for company code
8	LOEVM	-	Del.flag	CHAR	1	-	-	Deletion Flag for Master Record (Company Code Level)
9	ZUAWA	-	Sort key	CHAR	3	-	-	Key for sorting according to assignment numbers
10	BUSAB	-	Clerk	CHAR	2	-	-	Accounting clerk
11	AKONT	-	Recon.acct	CHAR	10	-	-	Reconciliation Account in General Ledger
12	BEGRU	-	Authoriz.	CHAR	4	-	-	Authorization Group
13	KNRZE	-	Hd office	CHAR	10	-	-	Head office account number (in branch accounts)
14	KNRZB	-	Alt.payer	CHAR	10	-	-	Account number of an alternative payer
15	ZAMIM	-	Cust(w.CI)	CHAR	1	-	-	Indicator: Payment notice to customer (with cleared items)?
16	ZAMIV	-	Sales	CHAR	1	-	-	Indicator: payment notice to sales department?
17	ZAMIR	-	Legal dept	CHAR	1	-	-	Indicator: payment notice to legal department?
18	ZAMIB	-	Accounting	CHAR	1	-	-	Indicator: Payment notice to the accounting department ?
19	ZAMIO	-	Cst(w/oCI)	CHAR	1	-	-	Indicator: payment notice to customer (w/o cleared items)?
20	ZWELS	-	Pmt meths	CHAR	10	-	-	List of the Payment Methods to be Considered
21	XVERR	-	Vend.clrg	CHAR	1	-	-	Indicator: Clearing between customer and vendor ?
22	ZAHLS	-	Pymt block	CHAR	1	-	-	Block key for payment
23	ZTERM	-	Payt Terms	CHAR	4	-	-	Terms of Payment Key
24	WAKON	-	B/e ch.trm	CHAR	4	-	-	Terms of payment key for bill of exchange charges
25	VZSKZ	-	Int ID	CHAR	2	-	-	Interest calculation indicator
26	ZINDT	-	Lst key dt	DATS	8	-	-	Key date of the last interest calculation
27	ZINRT	-	Int.cal.fr	NUMC	2	-	-	Interest calculation frequency in months
28	EIKTO	-	Acct at ct	CHAR	12	-	-	Our account number at customer
29	ZSABE	-	Cust.user	CHAR	15	-	-	User at customer
30	KVERM	-	Memo	CHAR	30	-	-	Memo
31	FDGRV	-	Plan.group	CHAR	10	-	-	Planning group
32	VRBKZ	-	Institut.	CHAR	2	-	-	Export credit insurance institution number
33	VLIBB	-	Amnt.Insd	CURR	13	2	-	Amount Insured
34	VRSZL	-	Lead mnths	DEC	3	-	-	Insurance lead months
35	VRSPR	-	Deductible	DEC	3	-	-	Deductible percentage rate
36	VRSNR	-	Contract	CHAR	10	-	-	Insurance number
37	VERDT	-	Valid To	DATS	8	-	-	Insurance validity date
38	PERKZ	-	Cl.inv.var	CHAR	1	-	-	Collective invoice variant
39	XDEZV	-	Loc.proc.	CHAR	1	-	-	Indicator: Local processing?
40	XAUSZ	-	Acct stmnt	CHAR	1	-	-	Indicator for periodic account statements
41	WEBTR	-	B/e limit	CURR	13	2	-	Bill of exchange limit (in local currency)
42	REMIT	-	Next payee	CHAR	10	-	-	Next payee
43	DATLZ	-	Lst int.rn	DATS	8	-	-	Date of the last interest calculation run
44	XZVER	-	Pmnt hist.	CHAR	1	-	-	Indicator: Record Payment History ?
45	TOGRU	-	Tol.group	CHAR	4	-	-	Tolerance group for the business partner/G/L account
46	KULTG	-	Grace per.	DEC	3	-	-	Probable time until check is paid
47	HBKID	-	House Bank	CHAR	5	-	-	Short Key for a House Bank
48	XPORE	-	Indiv.pmnt	CHAR	1	-	-	Indicator: Pay all items separately ?
49	BLNKZ	-	Subs.ind.	CHAR	2	-	-	Subsidy indicator for determining the reduction rates
50	ALTKN	-	Pre.ac.no.	CHAR	10	-	-	Previous Master Record Number
51	ZGRUP	-	Grpng key	CHAR	2	-	-	Key for Payment Grouping
52	URLID	-	Leave	CHAR	4	-	-	Short Key for Known/Negotiated Leave
53	MGRUP	-	Grpng key	CHAR	2	-	-	Key for dunning notice grouping
54	LOCKB	-	Lockbox	CHAR	7	-	-	Key of the Lockbox to Which the Customer Is To Pay
55	UZAWE	-	PmtMthSupl	CHAR	2	-	-	Payment Method Supplement
56	EKVBD	-	Buying Grp	CHAR	10	-	-	Account Number of Buying Group
57	SREGL	-	Sel.rule	CHAR	3	-	-	Selection Rule for Payment Advices
58	XEDIP	-	EDI	CHAR	1	-	-	Indicator: Send Payment Advices by EDI
59	FRGRP	-	Appr.group	CHAR	4	-	-	Release Approval Group
60	VRSDG	-	Version	CHAR	3	-	-	Reason Code Conversion Version
61	TLFXS	-	Fax	CHAR	31	-	-	Accounting clerk's fax number at the customer/vendor
62	INTAD	-	Internet	CHAR	130	-	-	Internet address of partner company clerk
63	XKNZB	-	AltPayerAc	CHAR	1	-	-	Indicator: Alternative payer using account number
64	GUZTE	-	CrMemTerms	CHAR	4	-	-	Payment Terms Key for Credit Memos
65	GRICD	-	Activity	CHAR	2	-	-	Activity Code for Gross Income Tax
66	GRIDT	-	Distribut.	CHAR	2	-	-	Distribution Type for Employment Tax
67	WBRSL	-	V.A key	CHAR	2	-	-	Value Adjustment Key
68	CONFS	-	CCdeCfStat	CHAR	1	-	-	Status of Change Authorization (Company Code Level)
69	UPDAT	-	Conf.date	DATS	8	-	-	Date on Which the Changes Were Confirmed
70	UPTIM	-	Conf.time	TIMS	6	-	-	Time of Last Change Confirmation
71	NODEL	-	Del.block	CHAR	1	-	-	Deletion bock for master record (company code level)
72	TLFNS	-	Telephone	CHAR	30	-	-	Accounting clerk's telephone number at business partner
73	CESSION_KZ	-	AR pledg.	CHAR	2	-	-	Accounts Receivable Pledging Indicator
74	GMVKZD	-	Execution	CHAR	1	-	-	Customer is in execution

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk KNB1.

Interactive ERD Diagrams

SAP SD - Links to FI Tables →

Standard T-Codes

FD03 XD03 FBL5N FD10N

Related Tables

KNA1 T001 KNVP KNVV KNVD KNB5

ANSI SQL Query

SELECT a.KUNNR,
       a.BUKRS,
       a.PERNR,
       a.ERDAT,
       a.ERNAM,
       a.SPERR,
       a.LOEVM
FROM KNB1 AS a
WHERE a.KUNNR = '0000100025'
  AND a.BUKRS = '1000';

ABAP OpenSQL (7.40+)

SELECT a~kunnr,
       a~bukrs,
       a~pernr,
       a~erdat,
       a~ernam,
       a~sperr,
       a~loevm
  FROM knb1 AS a
  WHERE a~kunnr = '0000100025'
  and a~bukrs = '1000'
  INTO TABLE @DATA(lt_knb1)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 KNB1

KNB1

Dictionary Fields Fields

Related References & SQL