SAP ABAP View ENT6400 (Competitor)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ UUDM (Package) EDM: Data Modeler (General)

Basic Data

View Type	D	Database View
Database View	ENT6400
Short Description	Competitor
Root table	KNA1	General Data in Customer Master

Entity Type	DM02L
Short text	Competitor

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KNA1	KNA1

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	KNA1	MANDT		☐	MANDT	☐	Client
2	KUNNR	KNA1	KUNNR		☐	KUNNR	☐	Customer Number
3	ADRNR	KNA1	ADRNR		☐	ADRNR	☐	Address
4	ANRED	KNA1	ANRED		☐	ANRED	☐	Title
5	BRSCH	KNA1	BRSCH		☐	BRSCH	☐	Industry key
6	BEGRU	KNA1	BEGRU		☐	BRGRU	☐	Authorization Group
7	ERDAT	KNA1	ERDAT		☐	ERDAT_RF	☐	Date on which the Record Was Created
8	ERNAM	KNA1	ERNAM		☐	ERNAM_RF	☐	Name of Person who Created the Object
9	KONZS	KNA1	KONZS		☐	KONZS	☐	Group key
10	KTOKD	KNA1	KTOKD		☐	KTOKD	☐	Customer Account Group
11	KUKLA	KNA1	KUKLA		☐	KUKLA	☐	Customer classification
12	LAND1	KNA1	LAND1		☐	LAND1_GP	☐	Country Key
13	LOEVM	KNA1	LOEVM		☐	LOEVM_X	☐	Central Deletion Flag for Master Record
14	NAME1	KNA1	NAME1		☐	NAME1_GP	☐	Name 1
15	NAME2	KNA1	NAME2		☐	NAME2_GP	☐	Name 2
16	NAME3	KNA1	NAME3		☐	NAME3_GP	☐	Name 3
17	NAME4	KNA1	NAME4		☐	NAME4_GP	☐	Name 4
18	NIELS	KNA1	NIELS		☐	NIELS	☐	Nielsen ID
19	ORT01	KNA1	ORT01		☐	ORT01_GP	☐	City
20	ORT02	KNA1	ORT02		☐	ORT02_GP	☐	District
21	PFACH	KNA1	PFACH		☐	PFACH	☐	PO Box
22	PSTL2	KNA1	PSTL2		☐	PSTL2	☐	P.O. Box Postal Code
23	PSTLZ	KNA1	PSTLZ		☐	PSTLZ	☐	Postal Code
24	REGIO	KNA1	REGIO		☐	REGIO	☐	Region (State, Province, County)
25	SORTL	KNA1	SORTL		☐	SORTL	☐	Sort field
26	SPRAS	KNA1	SPRAS		☐	SPRAS	☐	Language Key
27	STRAS	KNA1	STRAS		☐	STRAS_GP	☐	House number and street
28	TELBX	KNA1	TELBX		☐	TELBX	☐	Telebox number
29	TELF1	KNA1	TELF1		☐	TELF1	☐	First telephone number
30	TELF2	KNA1	TELF2		☐	TELF2	☐	Second telephone number
31	TELFX	KNA1	TELFX		☐	TELFX	☐	Fax Number
32	TELTX	KNA1	TELTX		☐	TELTX	☐	Teletex number
33	TELX1	KNA1	TELX1		☐	TELX1	☐	Telex number
34	DEAR1	KNA1	DEAR1		☐	DEAR1	☐	Indicator: Competitor
35	GFORM	KNA1	GFORM		☐	GFORM	☐	Legal status
36	BRAN1	KNA1	BRAN1		☐	BRAN1_D	☐	Industry code 1
37	UMSAT	KNA1	UMSAT		☐	UMSAT	☐	Annual sales
38	UMJAH	KNA1	UMJAH		☐	UMJAH	☐	Year For Which Sales are Given
39	UWAER	KNA1	UWAER		☐	UWAER	☐	Currency of Sales Volume
40	JMZAH	KNA1	JMZAH		☐	JMZAH	☐	Yearly number of employees
41	JMJAH	KNA1	JMJAH		☐	JMJAH	☐	Year for which the number of employees is given
42	UMSA1	KNA1	UMSA1		☐	UMSA1	☐	Annual sales

Maintenance Status

Access

☐   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☑   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

History

Last changed by/on	SAP	20131127
SAP Release Created in