SAP ABAP View V_SONU (Assortment user data)

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_SONU
Short Description	Assortment user data
Root table	WRF1	Plant data

Table

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

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	WRF1	MANDT		☐	MANDT	☐	Client
2	LOCNR	WRF1	LOCNR		☐	KUNNR	☐	Customer Number
3	EROED	WRF1	EROED		☐	EROED	☐	Opening date
4	SCHLD	WRF1	SCHLD		☐	SCHLD	☐	Closing date
5	SPDAB	WRF1	SPDAB		☐	SPDAB	☐	Block from
6	SPDBI	WRF1	SPDBI		☐	SPDBI	☐	Block to
7	AUTOB	WRF1	AUTOB		☐	AUTOB	☐	Automatic purchase order
8	KOPRO	WRF1	KOPRO		☐	POSKOPRO	☐	POS outbound profile
9	LAYVR	WRF1	LAYVR		☐	LAYVAR	☐	Layout
10	FLVAR	WRF1	FLVAR		☐	FLVAR	☐	Area schema
11	STFAK	WRF1	STFAK		☐	STKAL	☐	Calendar
12	VERFL	WRF1	VERFL		☐	VERFL_WWS	☐	Sales area (floor space)
13	VERFE	WRF1	VERFE		☐	VERFE_WWS	☐	Sales area (floor space) unit
14	SPGR1	WRF1	SPGR1		☐	SPGR1	☐	Blocking reason
15	INPRO	WRF1	INPRO		☐	POSINTPROF	☐	POS inbound profile
16	EKOAR	WRF1	EKOAR		☐	POSEKOAR	☐	POS outbound: condition type group
17	BETRP	WRF1	BETRP		☐	BETRP	☐	Plant profile
18	BWWRK	WRF1	BWWRK		☐	BWWRK	☐	Plant for retail price determination
19	BWVKO	WRF1	BWVKO		☐	BWVKO	☐	Sales organization for retail price determination
20	BWVTW	WRF1	BWVTW		☐	BWVTW	☐	Distribution channel for retail price determination
21	BBPRO	WRF1	BBPRO		☐	BBPRO	☐	Assortment list profile
22	VKBUR_WRK	WRF1	VKBUR_WRK		☐	VKBUR_WRK	☐	Sales office
23	VLFKZ	WRF1	VLFKZ		☐	VLFKZ	☐	Plant category
24	LIGRD	WRF1	LIGRD		☐	WLIGRD	☐	Basic listing rule for assortments
25	VKORG	WRF1	VKORG		☐	VKOIV	☐	Sales organization for intercompany billing
26	VTWEG	WRF1	VTWEG		☐	VTWIV	☐	Distribution channel for intercompany billing
27	KNAZK	KNA1	KNAZK		☐	KNAZK	☐	Working Time Calendar
28	KTOKD	KNA1	KTOKD		☐	KTOKD	☐	Customer Account Group
29	KUKLA	KNA1	KUKLA		☐	KUKLA	☐	Customer classification
30	LIFNR	KNA1	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
31	NAME1	KNA1	NAME1		☐	NAME1_GP	☐	Name 1
32	REGIO	KNA1	REGIO		☐	REGIO	☐	Region (State, Province, County)
33	KATR1	KNA1	KATR1		☐	KATR1	☐	Attribute 1
34	KATR2	KNA1	KATR2		☐	KATR2	☐	Attribute 2
35	KATR3	KNA1	KATR3		☐	KATR3	☐	Attribute 3
36	KATR4	KNA1	KATR4		☐	KATR4	☐	Attribute 4
37	KATR5	KNA1	KATR5		☐	KATR5	☐	Attribute 5
38	KATR6	KNA1	KATR6		☐	KATR6	☐	Attribute 6
39	KATR7	KNA1	KATR7		☐	KATR7	☐	Attribute 7
40	KATR8	KNA1	KATR8		☐	KATR8	☐	Attribute 8
41	KATR9	KNA1	KATR9		☐	KATR9	☐	Attribute 9
42	KATR10	KNA1	KATR10		☐	KATR10	☐	Attribute 10
43	TXJCD	KNA1	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
44	WERKS	KNA1	WERKS		☐	WERKS_D	☐	Plant
45	HZUOR	KNA1	HZUOR		☐	HZUOR	☐	Assignment to Hierarchy
46	ETIKG	KNA1	ETIKG		☐	ETIKG	☐	IS-R Labeling: customer/plant group

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