SAP ABAP Table WINT_KNA1 (Excerpt KNA1 (Assortments))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WSOR (Package) IS-R: Assortments

Basic Data

Table Category	INTTAB	Structure
Structure	WINT_KNA1	Table Relationship Diagram
Short Description	Excerpt KNA1 (Assortments)

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	KNA1
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	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
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	WINT_KNA1	AUFSD	TVAST	AUFSP		1	CN
2	WINT_KNA1	BRSCH	T016	BRSCH		1	CN
3	WINT_KNA1	FAKSD	TVFS	FAKSP		1	CN
4	WINT_KNA1	GFORM	TVGF	GFORM		1	CN
5	WINT_KNA1	KNAZK	TFACD	IDENT		1	CN
6	WINT_KNA1	KNRZA	KNA1	KUNNR		1	CN
7	WINT_KNA1	KTOCD	T077D	KTOKD		1	CN
8	WINT_KNA1	KUKLA	TKUKL	KUKLA		1	CN
9	WINT_KNA1	KUNNR	KNA1	KUNNR		1	CN
10	WINT_KNA1	LAND1	T005	LAND1		1	CN
11	WINT_KNA1	LIFNR	LFA1	LIFNR		1	CN
12	WINT_KNA1	LIFSD	TVLS	LIFSP		1	CN
13	WINT_KNA1	MANDT	T000	MANDT		1	CN
14	WINT_KNA1	NIELS	TNLS	NIELS		1	CN
15	WINT_KNA1	SPRAS	T002	SPRAS		1	CN
16	WINT_KNA1	WERKS	T001W	WERKS		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in