SE11 ABAP Dictionary SE11 KNA1

Popular:

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

KNA1

General Data in Customer Master

SAP SD Transparent Table 168 Fields

Primary Key:

MANDT KUNNR

#	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	LAND1	-	Country	CHAR	3	-	T005	Country Key
4	NAME1	-	Name	CHAR	35	-	-	Name 1
5	NAME2	-	Name 2	CHAR	35	-	-	Name 2
6	ORT01	-	City	CHAR	35	-	-	City
7	PSTLZ	-	Post.Code	CHAR	10	-	-	Postal Code
8	REGIO	-	Region	CHAR	3	-	-	Region (State, Province, County)
9	SORTL	-	SearchTerm	CHAR	10	-	-	Sort field
10	STRAS	-	Street	CHAR	35	-	-	House number and street
11	TELF1	-	Telephone1	CHAR	16	-	-	First telephone number
12	TELFX	-	Fax Number	CHAR	31	-	-	Fax Number
13	XCPDK	-	One-time	CHAR	1	-	-	Indicator: Is the account a one-time account?
14	ADRNR	-	Address	CHAR	10	-	-	Address
15	MCOD1	-	Name	CHAR	25	-	-	Search term for matchcode search
16	MCOD2	-	Name 2	CHAR	25	-	-	Search Term for Matchcode Search
17	MCOD3	-	City	CHAR	25	-	-	Search term for matchcode search
18	ANRED	-	Title	CHAR	15	-	-	Title
19	AUFSD	-	Central	CHAR	2	-	-	Central order block for customer
20	BAHNE	-	Expr.stat.	CHAR	25	-	-	Express train station
21	BAHNS	-	Train stat	CHAR	25	-	-	Train station
22	BBBNR	-	Loc.no. 1	NUMC	7	-	-	International location number (part 1)
23	BBSNR	-	Loc.no. 2	NUMC	5	-	-	International location number (Part 2)
24	BEGRU	-	Authoriz.	CHAR	4	-	-	Authorization Group
25	BRSCH	-	Industry	CHAR	4	-	-	Industry key
26	BUBKZ	-	Chk.digit	NUMC	1	-	-	Check digit for the international location number
27	DATLT	-	Data line	CHAR	14	-	-	Data communication line no.
28	ERDAT	-	Creat.date	DATS	8	-	-	Date on which the Record Was Created
29	ERNAM	-	Created by	CHAR	12	-	-	Name of Person who Created the Object
30	EXABL	-	Unload.pt	CHAR	1	-	-	Indicator: Unloading points exist
31	FAKSD	-	Central	CHAR	2	-	-	Central billing block for customer
32	FISKN	-	Fisc.addr.	CHAR	10	-	-	Account number of the master record with the fiscal address
33	KNAZK	-	Work time	CHAR	2	-	-	Working Time Calendar
34	KNRZA	-	Alt.payer	CHAR	10	-	-	Account number of an alternative payer
35	KONZS	-	Group	CHAR	10	-	-	Group key
36	KTOKD	-	Acct Group	CHAR	4	-	-	Customer Account Group
37	KUKLA	-	Classific.	CHAR	2	-	-	Customer classification
38	LIFNR	-	Vendor	CHAR	10	-	LFA1	Account Number of Vendor or Creditor
39	LIFSD	-	Central	CHAR	2	-	-	Central delivery block for the customer
40	LOCCO	-	Loc.code	CHAR	10	-	-	City Coordinates
41	LOEVM	-	Del.flag	CHAR	1	-	-	Central Deletion Flag for Master Record
42	NAME3	-	Name 3	CHAR	35	-	-	Name 3
43	NAME4	-	Name 4	CHAR	35	-	-	Name 4
44	NIELS	-	Nielsen ID	CHAR	2	-	-	Nielsen ID
45	ORT02	-	District	CHAR	35	-	-	District
46	PFACH	-	PO Box	CHAR	10	-	-	PO Box
47	PSTL2	-	PO Box pcd	CHAR	10	-	-	P.O. Box Postal Code
48	COUNC	-	County cde	CHAR	3	-	-	County Code
49	CITYC	-	City code	CHAR	4	-	-	City Code
50	RPMKR	-	Reg.Market	CHAR	5	-	-	Regional Market
51	SPERR	-	PstBlock	CHAR	1	-	-	Central posting block
52	SPRAS	-	Language	LANG	1	-	T002	Language Key
53	STCD1	-	Tax No. 1	CHAR	16	-	-	Tax Number 1
54	STCD2	-	Tax No. 2	CHAR	11	-	-	Tax Number 2
55	STKZA	-	Equal.tax	CHAR	1	-	-	Indicator: Business Partner Subject to Equalization Tax?
56	STKZU	-	VAT	CHAR	1	-	-	Liable for VAT
57	TELBX	-	Telebox	CHAR	15	-	-	Telebox number
58	TELF2	-	Telephone2	CHAR	16	-	-	Second telephone number
59	TELTX	-	Teletex	CHAR	30	-	-	Teletex number
60	TELX1	-	Telex	CHAR	30	-	-	Telex number
61	LZONE	-	Zone	CHAR	10	-	-	Transportation zone to or from which the goods are delivered
62	XZEMP	-	Payer/doc.	CHAR	1	-	-	Indicator: Is an alternative payer allowed in document?
63	VBUND	-	Tradg Part	CHAR	6	-	-	Company ID of trading partner
64	STCEG	-	VAT Reg.No	CHAR	20	-	-	VAT Registration Number
65	DEAR1	-	Competitor	CHAR	1	-	-	Indicator: Competitor
66	DEAR2	-	SlsPartner	CHAR	1	-	-	Indicator: Sales partner
67	DEAR3	-	Prospect	CHAR	1	-	-	Indicator: Sales prospect
68	DEAR4	-	CustType 4	CHAR	1	-	-	Indicator for customer type 4
69	DEAR5	-	Dflt SP	CHAR	1	-	-	ID for default sold-to party
70	GFORM	-	LegalStat.	CHAR	2	-	-	Legal status
71	BRAN1	-	Ind.Code 1	CHAR	10	-	-	Industry Code 1
72	BRAN2	-	Ind.code 2	CHAR	10	-	-	Industry code 2
73	BRAN3	-	Ind.code 3	CHAR	10	-	-	Industry code 3
74	BRAN4	-	Ind.code 4	CHAR	10	-	-	Industry code 4
75	BRAN5	-	Ind.code 5	CHAR	10	-	-	Industry code 5
76	EKONT	-	InitContct	CHAR	10	-	-	Initial contact
77	UMSAT	-	Ann.sales	CURR	8	2	-	Annual sales
78	UMJAH	-	Year	NUMC	4	-	-	Year For Which Sales are Given
79	UWAER	-	Currency	CUKY	5	-	-	Currency of sales figure
80	JMZAH	-	Employees	NUMC	6	-	-	Yearly number of employees
81	JMJAH	-	Year	NUMC	4	-	-	Year for which the number of employees is given
82	KATR1	-	Attribute	CHAR	2	-	-	Attribute 1
83	KATR2	-	Attrib. 2	CHAR	2	-	-	Attribute 2
84	KATR3	-	Attrib. 3	CHAR	2	-	-	Attribute 3
85	KATR4	-	Attrib. 4	CHAR	2	-	-	Attribute 4
86	KATR5	-	Attrib. 5	CHAR	2	-	-	Attribute 5
87	KATR6	-	Attrib. 6	CHAR	3	-	-	Attribute 6
88	KATR7	-	Attrib. 7	CHAR	3	-	-	Attribute 7
89	KATR8	-	Attrib. 8	CHAR	3	-	-	Attribute 8
90	KATR9	-	Attrib. 9	CHAR	3	-	-	Attribute 9
91	KATR10	-	Attrib.10	CHAR	3	-	-	Attribute 10
92	STKZN	-	Nat.Person	CHAR	1	-	-	Natural Person
93	UMSA1	-	Ann.sales	CURR	15	2	-	Annual sales
94	TXJCD	-	Tax Jur.	CHAR	15	-	-	Tax Jurisdiction
95	PERIV	-	FY Variant	CHAR	2	-	-	Fiscal Year Variant
96	ABRVW	-	Usage	CHAR	3	-	-	Usage Indicator
97	INSPBYDEBI	-	ByCustomer	CHAR	1	-	-	Inspection Carried Out By Customer (No Inspection Lot)
98	INSPATDEBI	-	AfterDeliv	CHAR	1	-	-	Inspection for a Delivery Note After Outbound Delivery
99	KTOCD	-	Ref.ActGr.	CHAR	4	-	-	Reference Account Group for One-Time Account (Customer)
100	PFORT	-	P.O.Bx cty	CHAR	35	-	-	PO Box city
101	WERKS	-	Plant	CHAR	4	-	T001W	Plant
102	DTAMS	-	DME Ind.	CHAR	1	-	-	Indicator for Data Medium Exchange
103	DTAWS	-	Instr.key	CHAR	2	-	-	Instruction key for data medium exchange
104	DUEFL	-	Status	CHAR	1	-	-	Status of Data Transfer into Subsequent Release
105	HZUOR	-	HierAssign	NUMC	2	-	-	Assignment to Hierarchy
106	SPERZ	-	Pmnt block	CHAR	1	-	-	Payment Block
107	ETIKG	-	LabCustGrp	CHAR	10	-	-	IS-R Labeling: customer/plant group
108	CIVVE	-	Non-milit.	CHAR	1	-	-	ID for mainly non-military use
109	MILVE	-	Milit. use	CHAR	1	-	-	ID for mainly military use
110	KDKG1	-	CondGrp 1	CHAR	2	-	-	Customer condition group 1
111	KDKG2	-	CondGrp 2	CHAR	2	-	-	Customer condition group 2
112	KDKG3	-	CondGrp 3	CHAR	2	-	-	Customer condition group 3
113	KDKG4	-	CondGrp 4	CHAR	2	-	-	Customer condition group 4
114	KDKG5	-	CondGrp 5	CHAR	2	-	-	Customer condition group 5
115	XKNZA	-	AltPayerAc	CHAR	1	-	-	Indicator: Alternative payer using account number
116	FITYP	-	Tax type	CHAR	2	-	-	Tax type
117	STCDT	-	Tax no.ty.	CHAR	2	-	-	Tax Number Type
118	STCD3	-	Tax No. 3	CHAR	18	-	-	Tax Number 3
119	STCD4	-	Tax No. 4	CHAR	18	-	-	Tax Number 4
120	XICMS	-	No ICMS	CHAR	1	-	-	Customer is ICMS-exempt
121	XXIPI	-	No IPI	CHAR	1	-	-	Customer is IPI-exempt
122	XSUBT	-	SubT grp.	CHAR	3	-	-	Customer group for Substituiçao Tributária calculation
123	CFOPC	-	CFOP cat.	CHAR	2	-	-	Customer's CFOP category
124	TXLW1	-	ICMS text	CHAR	3	-	-	Tax law: ICMS
125	TXLW2	-	IPI text	CHAR	3	-	-	Tax law: IPI
126	CCC01	-	BCW	CHAR	1	-	-	Indicator for biochemical warfare for legal control
127	CCC02	-	Nucl.nonp.	CHAR	1	-	-	Indicator for nuclear nonproliferation for legal control
128	CCC03	-	Natl sec.	CHAR	1	-	-	Indicator for national security for legal control
129	CCC04	-	Miss.tech.	CHAR	1	-	-	Indicator for missile technology for legal control
130	CASSD	-	Central	CHAR	2	-	-	Central sales block for customer
131	KNURL	-	URL	CHAR	132	-	-	Uniform Resource Locator
132	J_1KFREPRE	-	Rep's Name	CHAR	10	-	-	Name of Representative
133	J_1KFTBUS	-	TOB	CHAR	30	-	-	Type of Business
134	J_1KFTIND	-	TOI	CHAR	30	-	-	Type of Industry
135	CONFS	-	Conf.St.	CHAR	1	-	-	Status of Change Authorization (Central)
136	UPDAT	-	Conf.date	DATS	8	-	-	Date on Which the Changes Were Confirmed
137	UPTIM	-	Conf.time	TIMS	6	-	-	Time of Last Change Confirmation
138	NODEL	-	Del.block	CHAR	1	-	-	Central deletion block for master record
139	DEAR6	-	Consumer	CHAR	1	-	-	Indicator: Consumer
140	/VSO/R_PALHGT	-	Max.StackH	QUAN	13	3	-	Maximum Stacking Height of the Packaging Material (VSO)
141	/VSO/R_PAL_UL	-	LengthUnit	UNIT	3	-	-	Unit of Length for Packaging Material (VSO)
142	/VSO/R_PK_MAT	-	CustRelate	CHAR	1	-	-	Customer-Related Packing for Each Packaging Material (VSO)
143	/VSO/R_MATPAL	-	PKM Cust.	CHAR	18	-	-	Packaging Material of the Customer in VSO
144	/VSO/R_I_NO_LYR	-	No.IntPal	NUMC	2	-	-	Number Layers Under an Inter-Pallet (VSO)
145	/VSO/R_ONE_MAT	-	Mat.-Spec.	CHAR	1	-	-	Packing Material-Specific for Each Packaging Material
146	/VSO/R_ONE_SORT	-	Pack Pck	CHAR	1	-	-	Pack Only One Package Type for Each PKM (VSO)
147	/VSO/R_ULD_SIDE	-	Side Pref.	NUMC	1	-	-	Side Preference of Loading/Unloading (VSO)
148	/VSO/R_LOAD_PREF	-	F/B Pref.	NUMC	1	-	-	Front/Back Preference of Loading/Unloading (VSO)
149	/VSO/R_DPOINT	-	CollUnlPnt	CHAR	10	-	-	Collective Unloading Point for VSO
150	ALC	-	ALC	CHAR	8	-	-	Agency Location Code
151	PMT_OFFICE	-	Pmt Off	CHAR	5	-	-	Payment Office
152	FEE_SCHEDULE	-	Schedule	CHAR	4	-	-	Fee schedule
153	DUNS	-	DUNS No.	CHAR	9	-	-	DUNS Number
154	DUNS4	-	DUNS+4	CHAR	4	-	-	DUNS+4
155	PSOFG	-	Process.gp	CHAR	10	-	-	Processor group
156	PSOIS	-	SLA PreprP	CHAR	20	-	-	Subledger acct preprocessing procedure
157	PSON1	-	Name	CHAR	35	-	-	Name 1
158	PSON2	-	Name 2	CHAR	35	-	-	Name 2
159	PSON3	-	Name 3	CHAR	35	-	-	Name 3
160	PSOVN	-	First Name	CHAR	35	-	-	First Name
161	PSOTL	-	Title	CHAR	20	-	-	Title
162	PSOHS	-	House no.	CHAR	6	-	-	House number: is no longer used from Release 4.6B
163	PSOST	-	Street	CHAR	28	-	-	Street: No longer used from Release 4.6B
164	PSOO1	-	Descr.	CHAR	50	-	-	Description
165	PSOO2	-	Descr.	CHAR	50	-	-	Description
166	PSOO3	-	Descr.	CHAR	50	-	-	Description
167	PSOO4	-	Descr.	CHAR	50	-	-	Description
168	PSOO5	-	Descr.	CHAR	50	-	-	Description

Related References & SQL

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

Interactive ERD Diagrams

SAP PM & SD - Plant Maintenance Main Tables Relation → SAP SD - Links to FI Tables →

Standard T-Codes

XD03 XD01 XD02 VD03 FD03 FBL5N

Related Tables

T005 LFA1 T002 T001W EQUI EQKT EQUZ EQST

ANSI SQL Query

SELECT a.KUNNR,
       a.LAND1,
       a.NAME1,
       a.NAME2,
       a.ORT01,
       a.PSTLZ
FROM KNA1 AS a
WHERE a.KUNNR = '0000100025';

ABAP OpenSQL (7.40+)

SELECT a~kunnr,
       a~land1,
       a~name1,
       a~name2,
       a~ort01,
       a~pstlz
  FROM kna1 AS a
  WHERE a~kunnr = '0000100025'
  INTO TABLE @DATA(lt_kna1)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 KNA1

KNA1

Dictionary Fields Fields

Related References & SQL