SAP ABAP View W_KNA1 (Field string KNA1 for assortment functions)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WSOR (Package) IS-R: Assortments

Basic Data

View Type	D	Database View
Database View	W_KNA1
Short Description	Field string KNA1 for assortment functions
Root table	KNA1	General Data in Customer Master

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	AUFSD	KNA1	AUFSD		☐	AUFSD_X	☐	Central order block for customer
4	BBBNR	KNA1	BBBNR		☐	BBBNR	☐	International location number (part 1)
5	BBSNR	KNA1	BBSNR		☐	BBSNR	☐	International location number (Part 2)
6	BEGRU	KNA1	BEGRU		☐	BRGRU	☐	Authorization Group
7	BRSCH	KNA1	BRSCH		☐	BRSCH	☐	Industry key
8	BUBKZ	KNA1	BUBKZ		☐	BUBKZ	☐	Check digit for the international location number
9	EXABL	KNA1	EXABL		☐	EXABL	☐	Indicator: Unloading points exist
10	FAKSD	KNA1	FAKSD		☐	FAKSD_X	☐	Central billing block for customer
11	KNAZK	KNA1	KNAZK		☐	KNAZK	☐	Working Time Calendar
12	KNRZA	KNA1	KNRZA		☐	KNRZA	☐	Account number of an alternative payer
13	KUKLA	KNA1	KUKLA		☐	KUKLA	☐	Customer classification
14	LAND1	KNA1	LAND1		☐	LAND1_GP	☐	Country Key
15	LIFNR	KNA1	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
16	LIFSD	KNA1	LIFSD		☐	LIFSD_X	☐	Central delivery block for the customer
17	LOEVM	KNA1	LOEVM		☐	LOEVM_X	☐	Central Deletion Flag for Master Record
18	NAME1	KNA1	NAME1		☐	NAME1_GP	☐	Name 1
19	NIELS	KNA1	NIELS		☐	NIELS	☐	Nielsen ID
20	RPMKR	KNA1	RPMKR		☐	RPMKR	☐	Regional market
21	SPERR	KNA1	SPERR		☐	SPERB_X	☐	Central posting block
22	SPRAS	KNA1	SPRAS		☐	SPRAS	☐	Language Key
23	STKZA	KNA1	STKZA		☐	STKZA	☐	Indicator: Business Partner Subject to Equalization Tax?
24	STKZU	KNA1	STKZU		☐	STKZU	☐	Liable for VAT
25	XCPDK	KNA1	XCPDK		☐	XCPDK	☐	Indicator: Is the account a one-time account?
26	XZEMP	KNA1	XZEMP		☐	XREGU	☐	Indicator: Is an alternative payer allowed in document?
27	DEAR1	KNA1	DEAR1		☐	DEAR1	☐	Indicator: Competitor
28	DEAR2	KNA1	DEAR2		☐	DEAR2	☐	Indicator: Sales partner
29	DEAR3	KNA1	DEAR3		☐	DEAR3	☐	Indicator: Sales prospect
30	DEAR4	KNA1	DEAR4		☐	DEAR4	☐	Indicator for customer type 4
31	DEAR5	KNA1	DEAR5		☐	DEAR5	☐	ID for default sold-to party
32	GFORM	KNA1	GFORM		☐	GFORM	☐	Legal status
33	STKZN	KNA1	STKZN		☐	STKZN	☐	Natural Person
34	INSPBYDEBI	KNA1	INSPBYDEBI		☐	QINSPBYDEB	☐	Inspection Carried Out By Customer (No Inspection Lot)
35	INSPATDEBI	KNA1	INSPATDEBI		☐	QINSPATDEB	☐	Inspection for a Delivery Note After Outbound Delivery
36	KTOCD	KNA1	KTOCD		☐	KTOCD	☐	Reference Account Group for One-Time Account (Customer)
37	WERKS	KNA1	WERKS		☐	WERKS_D	☐	Plant
38	DTAMS	KNA1	DTAMS		☐	DTAMS	☐	Report key for data medium exchange
39	DTAWS	KNA1	DTAWS		☐	DTAWS	☐	Instruction key for data medium exchange
40	DUEFL	KNA1	DUEFL		☐	DUEFL_BKPF	☐	Status of Data Transfer into Subsequent Release
41	HZUOR	KNA1	HZUOR		☐	HZUOR	☐	Assignment to Hierarchy

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	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20131127
SAP Release Created in