SAP ABAP View V_KNA1WRF1 (Combined read operation of KNA1 and WRF1 (field selection))

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	V_KNA1WRF1
Short Description	Combined read operation of KNA1 and WRF1 (field selection)
Root table	KNA1	General Data in Customer Master

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KNA1	MANDT	JL	EQ				0	0
2	WRF1	MANDT	JR	EQ			AND	0	0
3	KNA1	KUNNR	JL	EQ				0	0
4	WRF1	LOCNR	JR	EQ				0	0

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	NAME1	KNA1	NAME1		☐	NAME1_GP	☐	Name 1
4	WERKS	KNA1	WERKS		☐	WERKS_D	☐	Plant
5	KATR1	KNA1	KATR1		☐	KATR1	☐	Attribute 1
6	KATR2	KNA1	KATR2		☐	KATR2	☐	Attribute 2
7	KATR3	KNA1	KATR3		☐	KATR3	☐	Attribute 3
8	KATR4	KNA1	KATR4		☐	KATR4	☐	Attribute 4
9	KATR5	KNA1	KATR5		☐	KATR5	☐	Attribute 5
10	KATR6	KNA1	KATR6		☐	KATR6	☐	Attribute 6
11	KATR7	KNA1	KATR7		☐	KATR7	☐	Attribute 7
12	KATR8	KNA1	KATR8		☐	KATR8	☐	Attribute 8
13	KATR9	KNA1	KATR9		☐	KATR9	☐	Attribute 9
14	KATR10	KNA1	KATR10		☐	KATR10	☐	Attribute 10
15	LIFNR	KNA1	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
16	KNAZK	KNA1	KNAZK		☐	KNAZK	☐	Working Time Calendar
17	BEGRU	KNA1	BEGRU		☐	BRGRU	☐	Authorization Group
18	BRSCH	KNA1	BRSCH		☐	BRSCH	☐	Industry key
19	EXABL	KNA1	EXABL		☐	EXABL	☐	Indicator: Unloading points exist
20	KUKLA	KNA1	KUKLA		☐	KUKLA	☐	Customer classification
21	LAND1	KNA1	LAND1		☐	LAND1_GP	☐	Country Key
22	LIFSD	KNA1	LIFSD		☐	LIFSD_X	☐	Central delivery block for the customer
23	LOEVM	KNA1	LOEVM		☐	LOEVM_X	☐	Central Deletion Flag for Master Record
24	NIELS	KNA1	NIELS		☐	NIELS	☐	Nielsen ID
25	SPRAS	KNA1	SPRAS		☐	SPRAS	☐	Language Key
26	STKZA	KNA1	STKZA		☐	STKZA	☐	Indicator: Business Partner Subject to Equalization Tax?
27	STKZU	KNA1	STKZU		☐	STKZU	☐	Liable for VAT
28	LZONE	KNA1	LZONE		☐	LZONE	☐	Transportation zone to or from which the goods are delivered
29	XCPDK	KNA1	XCPDK		☐	XCPDK	☐	Indicator: Is the account a one-time account?
30	TXJCD	KNA1	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
31	HZUOR	KNA1	HZUOR		☐	HZUOR	☐	Assignment to Hierarchy
32	SPERZ	KNA1	SPERZ		☐	SPERZ	☐	Payment Block
33	ETIKG	KNA1	ETIKG		☐	ETIKG	☐	IS-R Labeling: customer/plant group
34	EROED	WRF1	EROED		☐	EROED	☐	Opening date
35	SCHLD	WRF1	SCHLD		☐	SCHLD	☐	Closing date
36	SPDAB	WRF1	SPDAB		☐	SPDAB	☐	Block from
37	SPDBI	WRF1	SPDBI		☐	SPDBI	☐	Block to
38	KOPRO	WRF1	KOPRO		☐	POSKOPRO	☐	POS outbound profile
39	AUTOB	WRF1	AUTOB		☐	AUTOB	☐	Automatic purchase order
40	LAYVR	WRF1	LAYVR		☐	LAYVAR	☐	Layout
41	FLVAR	WRF1	FLVAR		☐	FLVAR	☐	Area schema
42	STFAK	WRF1	STFAK		☐	STKAL	☐	Calendar
43	VERFL	WRF1	VERFL		☐	VERFL_WWS	☐	Sales area (floor space)
44	VERFE	WRF1	VERFE		☐	VERFE_WWS	☐	Sales area (floor space) unit
45	SPGR1	WRF1	SPGR1		☐	SPGR1	☐	Blocking reason
46	INPRO	WRF1	INPRO		☐	POSINTPROF	☐	POS inbound profile
47	EKOAR	WRF1	EKOAR		☐	POSEKOAR	☐	POS outbound: condition type group
48	KZLIK	WRF1	KZLIK		☐	KZLIK	☐	Listing conditions should be created per assortment
49	BETRP	WRF1	BETRP		☐	BETRP	☐	Plant profile
50	NLMATFB	WRF1	NLMATFB		☐	NLMATFB	☐	ID: Carry out subsequent listing
51	BWWRK	WRF1	BWWRK		☐	BWWRK	☐	Plant for retail price determination
52	BWVKO	WRF1	BWVKO		☐	BWVKO	☐	Sales organization for retail price determination
53	BWVTW	WRF1	BWVTW		☐	BWVTW	☐	Distribution channel for retail price determination
54	BBPRO	WRF1	BBPRO		☐	BBPRO	☐	Assortment list profile
55	VKBUR_WRK	WRF1	VKBUR_WRK		☐	VKBUR_WRK	☐	Sales office
56	VLFKZ	WRF1	VLFKZ		☐	VLFKZ	☐	Plant category
57	LSTFL	WRF1	LSTFL		☐	LSTFL	☐	Listing procedure for store or other assortment categories

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