SAP ABAP Table ENT6096 (Generated Table for View)

Basic Data

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

Foreign Keys

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

History

Last changed by/on	SAP	20131127
SAP Release Created in