SAP ABAP View ENT6001 (Customer)

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	ENT6001
Short Description	Customer
Root table	KNA1	General Data in Customer Master

Entity Type	DM02L
Short text	Customer

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

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