SAP ABAP Table ENT6400 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ENT6400	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	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
6	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
7	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
8	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
9	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
10	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
11	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	TKUKL
12	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
13	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
14	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
15	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
16	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
17	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
18	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
19	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
20	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
21	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
22	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
23	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
24	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
25	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
26	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
27	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
28	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
29	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
30	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
31	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
32	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
33	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
34	DEAR1	☐	DEAR1	XFELD	CHAR	1	0	Indicator: Competitor
35	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	TVGF
36	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
37	UMSAT	☐	UMSAT	UMSAT	CURR	8	2	Annual sales
38	UMJAH	☐	UMJAH	JAHR	NUMC	4	0	Year For Which Sales are Given
39	UWAER	☐	UWAER	WAERS	CUKY	5	0	Currency of Sales Volume	TCURC
40	JMZAH	☐	JMZAH	JMZAH	NUMC	6	0	Yearly number of employees
41	JMJAH	☐	JMJAH	JAHR	NUMC	4	0	Year for which the number of employees is given
42	UMSA1	☐	UMSA1	UMSA1	CURR	15	2	Annual sales

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT6400	BRAN1	TBRC	BRACO	KEY	1	CN
2	ENT6400	BRSCH	T016	BRSCH	REF	C	CN
3	ENT6400	GFORM	TVGF	GFORM	KEY	1	CN
4	ENT6400	KTOKD	T077D	KTOKD	REF	1	CN
5	ENT6400	KUKLA	TKUKL	KUKLA	REF	C	CN
6	ENT6400	LAND1	T005	LAND1	REF	C	CN
7	ENT6400	MANDT	T000	MANDT	KEY	1	CN
8	ENT6400	NIELS	TNLS	NIELS	REF	C	CN
9	ENT6400	REGIO	T005S	BLAND	REF	C	CN
10	ENT6400	SPRAS	T002	SPRAS	REF	1	CN
11	ENT6400	UWAER	TCURC	WAERS	REF	1	C

History

Last changed by/on	SAP	20131127
SAP Release Created in