SAP ABAP Table W_KNA1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	W_KNA1	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number
3	AUFSD	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	TVAST
4	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
5	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
6	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
7	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
8	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
9	EXABL	☐	EXABL	XFELD	CHAR	1	0	Indicator: Unloading points exist
10	FAKSD	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	TVFS
11	KNAZK	☐	KNAZK	WFCID	CHAR	2	0	Working Time Calendar	TFACD
12	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer	KNA1
13	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	TKUKL
14	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
15	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
16	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
17	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
18	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
19	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
20	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
21	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
22	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
23	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
24	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
25	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
26	XZEMP	☐	XREGU	XFELD	CHAR	1	0	Indicator: Is an alternative payer allowed in document?
27	DEAR1	☐	DEAR1	XFELD	CHAR	1	0	Indicator: Competitor
28	DEAR2	☐	DEAR2	XFELD	CHAR	1	0	Indicator: Sales partner
29	DEAR3	☐	DEAR3	DEAR3	CHAR	1	0	Indicator: Sales prospect
30	DEAR4	☐	DEAR4	XFELD	CHAR	1	0	Indicator for customer type 4
31	DEAR5	☐	DEAR5	XFELD	CHAR	1	0	ID for default sold-to party
32	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	TVGF
33	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
34	INSPBYDEBI	☐	QINSPBYDEB	QKZ	CHAR	1	0	Inspection Carried Out By Customer (No Inspection Lot)
35	INSPATDEBI	☐	QINSPATDEB	QKZ	CHAR	1	0	Inspection for a Delivery Note After Outbound Delivery
36	KTOCD	☐	KTOCD	KTOKD	CHAR	4	0	Reference Account Group for One-Time Account (Customer)	T077D
37	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
38	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
39	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange
40	DUEFL	☐	DUEFL_BKPF	DUEFL_BKPF	CHAR	1	0	Status of Data Transfer into Subsequent Release
41	HZUOR	☐	HZUOR	HZUOR	NUMC	2	0	Assignment to Hierarchy

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	W_KNA1	AUFSD	TVAST	AUFSP	REF	C	CN
2	W_KNA1	BRSCH	T016	BRSCH	REF	C	CN
3	W_KNA1	FAKSD	TVFS	FAKSP	REF	C	CN
4	W_KNA1	GFORM	TVGF	GFORM	KEY	1	CN
5	W_KNA1	KNAZK	TFACD	IDENT	REF	C	CN
6	W_KNA1	KNRZA	KNA1	KUNNR	REF	C	CN
7	W_KNA1	KTOCD	T077D	KTOKD	REF	C	CN
8	W_KNA1	KUKLA	TKUKL	KUKLA	REF	C	CN
9	W_KNA1	LAND1	T005	LAND1	REF	C	CN
10	W_KNA1	LIFNR	LFA1	LIFNR	REF	C	CN
11	W_KNA1	LIFSD	TVLS	LIFSP	REF	C	CN
12	W_KNA1	MANDT	T000	MANDT	KEY	1	CN
13	W_KNA1	NIELS	TNLS	NIELS	REF	C	CN
14	W_KNA1	SPRAS	T002	SPRAS	REF	1	CN
15	W_KNA1	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in