SAP ABAP Table ENT6001 (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	KNA1
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address
4	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
5	BAHNE	☐	BAHNE	BAHNH	CHAR	25	0	Express train station
6	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
7	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
8	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
9	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
10	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
11	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
12	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
13	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
14	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
15	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
16	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
17	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
18	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
19	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
20	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
21	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
22	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
23	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
24	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
25	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
26	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
27	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
28	KNAZK	☐	KNAZK	WFCID	CHAR	2	0	Working Time Calendar	TFACD
29	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
30	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
31	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
32	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
33	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
34	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
35	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
36	AUFSD	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	TVAST
37	FAKSD	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	TVFS
38	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	TKUKL
39	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
40	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
41	XZEMP	☐	XREGU	XFELD	CHAR	1	0	Indicator: Is an alternative payer allowed in document?
42	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
43	EXABL	☐	EXABL	XFELD	CHAR	1	0	Indicator: Unloading points exist
44	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
45	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
46	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
47	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
48	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
49	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
50	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
51	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
52	DEAR1	☐	DEAR1	XFELD	CHAR	1	0	Indicator: Competitor
53	DEAR2	☐	DEAR2	XFELD	CHAR	1	0	Indicator: Sales partner
54	DEAR3	☐	DEAR3	DEAR3	CHAR	1	0	Indicator: Sales prospect
55	DEAR4	☐	DEAR4	XFELD	CHAR	1	0	Indicator for customer type 4
56	DEAR5	☐	DEAR5	XFELD	CHAR	1	0	ID for default sold-to party
57	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	TVGF
58	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
59	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	TBRC
60	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	TBRC
61	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	TBRC
62	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	TBRC
63	EKONT	☐	EKONT	VBELN	CHAR	10	0	Initial contact	VBUK
64	UMSAT	☐	UMSAT	UMSAT	CURR	8	2	Annual sales
65	UMJAH	☐	UMJAH	JAHR	NUMC	4	0	Year For Which Sales are Given
66	UWAER	☐	UWAER	WAERS	CUKY	5	0	Currency of Sales Volume	TCURC
67	JMZAH	☐	JMZAH	JMZAH	NUMC	6	0	Yearly number of employees
68	JMJAH	☐	JMJAH	JAHR	NUMC	4	0	Year for which the number of employees is given
69	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	TVK1
70	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	TVK2
71	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	TVK3
72	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	TVK4
73	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	TVK5
74	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	TVK6
75	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	TVK7
76	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	TVK8
77	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	TVK9
78	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	TVK0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT6001	AUFSD	TVAST	AUFSP	REF	C	CN
2	ENT6001	BRAN1	TBRC	BRACO	KEY	1	CN
3	ENT6001	BRAN2	TBRC	BRACO	KEY	1	CN
4	ENT6001	BRAN3	TBRC	BRACO	KEY	1	CN
5	ENT6001	BRAN4	TBRC	BRACO	KEY	1	CN
6	ENT6001	BRAN5	TBRC	BRACO	KEY	1	CN
7	ENT6001	BRSCH	T016	BRSCH	REF	C	CN
8	ENT6001	CITYC	T005G	CITYC	REF	C	CN
9	ENT6001	COUNC	T005E	COUNC	REF	C	CN
10	ENT6001	EKONT	VBUK	VBELN	REF	1	C
11	ENT6001	FAKSD	TVFS	FAKSP	REF	C	CN
12	ENT6001	GFORM	TVGF	GFORM	KEY	1	CN
13	ENT6001	KATR1	TVK1	KATR1	KEY	1	CN
14	ENT6001	KATR10	TVK0	KATR10	KEY	1	CN
15	ENT6001	KATR2	TVK2	KATR2	KEY	1	CN
16	ENT6001	KATR3	TVK3	KATR3	KEY	1	CN
17	ENT6001	KATR4	TVK4	KATR4	KEY	1	CN
18	ENT6001	KATR5	TVK5	KATR5	KEY	1	CN
19	ENT6001	KATR6	TVK6	KATR6	KEY	1	CN
20	ENT6001	KATR7	TVK7	KATR7	KEY	1	CN
21	ENT6001	KATR8	TVK8	KATR8	KEY	1	CN
22	ENT6001	KATR9	TVK9	KATR9	KEY	1	CN
23	ENT6001	KNAZK	TFACD	IDENT	REF	C	CN
24	ENT6001	KTOKD	T077D	KTOKD	REF	1	CN
25	ENT6001	KUKLA	TKUKL	KUKLA	REF	C	CN
26	ENT6001	LAND1	T005	LAND1	REF	C	CN
27	ENT6001	LIFNR	LFA1	LIFNR	REF	C	CN
28	ENT6001	LIFSD	TVLS	LIFSP	REF	C	CN
29	ENT6001	LZONE	TZONE	ZONE1	REF	C	CN
30	ENT6001	MANDT	T000	MANDT	KEY	1	CN
31	ENT6001	NIELS	TNLS	NIELS	REF	C	CN
32	ENT6001	REGIO	T005S	BLAND	REF	C	CN
33	ENT6001	SPRAS	T002	SPRAS	REF	1	CN
34	ENT6001	UWAER	TCURC	WAERS	REF	1	C

History

Last changed by/on	SAP	20131127
SAP Release Created in