SAP ABAP Table V_SONU (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_SONU	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LOCNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
3	EROED	☐	EROED	DATUM	DATS	8	0	Opening date
4	SCHLD	☐	SCHLD	DATUM	DATS	8	0	Closing date
5	SPDAB	☐	SPDAB	DATUM	DATS	8	0	Block from
6	SPDBI	☐	SPDBI	DATUM	DATS	8	0	Block to
7	AUTOB	☐	AUTOB	CHAR001	CHAR	1	0	Automatic purchase order
8	KOPRO	☐	POSKOPRO	POSKOPRO	CHAR	4	0	POS outbound profile	TWPFI
9	LAYVR	☐	LAYVAR	LAYVAR	CHAR	10	0	Layout	TWGV
10	FLVAR	☐	FLVAR	FLVAR	CHAR	4	0	Area schema	TWGF
11	STFAK	☐	STKAL	WFCID	CHAR	2	0	Calendar	TFACD
12	VERFL	☐	VERFL_WWS	VERFL_WWS	QUAN	6	0	Sales area (floor space)
13	VERFE	☐	VERFE_WWS	MEINS	UNIT	3	0	Sales area (floor space) unit	T006
14	SPGR1	☐	SPGR1	SPGR1	CHAR	2	0	Blocking reason	TWRF11
15	INPRO	☐	POSINTPROF	POSINTPROF	CHAR	4	0	POS inbound profile	TWPIS
16	EKOAR	☐	POSEKOAR	POSEKOAR	CHAR	4	0	POS outbound: condition type group	TWPPK
17	BETRP	☐	BETRP	BETRP	CHAR	4	0	Plant profile	TWRF2
18	BWWRK	☐	BWWRK	WERKS	CHAR	4	0	Plant for retail price determination	T001W
19	BWVKO	☐	BWVKO	VKORG	CHAR	4	0	Sales organization for retail price determination	TVKO
20	BWVTW	☐	BWVTW	VTWEG	CHAR	2	0	Distribution channel for retail price determination	TVTW
21	BBPRO	☐	BBPRO	BBPRO	CHAR	4	0	Assortment list profile	TWBP
22	VKBUR_WRK	☐	VKBUR_WRK	VKBUR	CHAR	4	0	Sales office
23	VLFKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
24	LIGRD	☐	WLIGRD	WLIGRD	CHAR	1	0	Basic listing rule for assortments
25	VKORG	☐	VKOIV	VKORG	CHAR	4	0	Sales organization for intercompany billing	TVKO
26	VTWEG	☐	VTWIV	VTWEG	CHAR	2	0	Distribution channel for intercompany billing	TVTW
27	KNAZK	☐	KNAZK	WFCID	CHAR	2	0	Working Time Calendar	TFACD
28	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
29	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	TKUKL
30	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
31	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
32	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
33	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	TVK1
34	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	TVK2
35	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	TVK3
36	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	TVK4
37	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	TVK5
38	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	TVK6
39	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	TVK7
40	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	TVK8
41	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	TVK9
42	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	TVK0
43	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
44	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
45	HZUOR	☐	HZUOR	HZUOR	NUMC	2	0	Assignment to Hierarchy
46	ETIKG	☐	ETIKG	ETIKG	CHAR	10	0	IS-R Labeling: customer/plant group	TWEK

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_SONU	BBPRO	TWBP	BBPRO
2	V_SONU	BETRP	TWRF2	BETRP
3	V_SONU	BWVKO	TVKO	VKORG	KEY	1	CN
4	V_SONU	BWVTW	TVTW	VTWEG	KEY	1	CN
5	V_SONU	BWWRK	T001W	WERKS	KEY	1	CN
6	V_SONU	EKOAR	TWPPK	EKOAR	KEY	1	CN
7	V_SONU	ETIKG	TWEK	KUNGR	REF	1	CN
8	V_SONU	FLVAR	TWGF	FLVAR	REF	C	CN
9	V_SONU	INPRO	TWPIS	INPRO	KEY	1	CN
10	V_SONU	KATR1	TVK1	KATR1	KEY	1	CN
11	V_SONU	KATR10	TVK0	KATR10	KEY	1	CN
12	V_SONU	KATR2	TVK2	KATR2	KEY	1	CN
13	V_SONU	KATR3	TVK3	KATR3	KEY	1	CN
14	V_SONU	KATR4	TVK4	KATR4	KEY	1	CN
15	V_SONU	KATR5	TVK5	KATR5	KEY	1	CN
16	V_SONU	KATR6	TVK6	KATR6	KEY	1	CN
17	V_SONU	KATR7	TVK7	KATR7	KEY	1	CN
18	V_SONU	KATR8	TVK8	KATR8	KEY	1	CN
19	V_SONU	KATR9	TVK9	KATR9	KEY	1	CN
20	V_SONU	KNAZK	TFACD	IDENT	REF	C	CN
21	V_SONU	KOPRO	TWPFI	KOPRO	KEY	1	CN
22	V_SONU	KTOKD	T077D	KTOKD	REF	1	CN
23	V_SONU	KUKLA	TKUKL	KUKLA	REF	C	CN
24	V_SONU	LAYVR	TWGV	LAYVR	KEY	1	CN
25	V_SONU	LIFNR	LFA1	LIFNR	REF	C	CN
26	V_SONU	LOCNR	KNA1	KUNNR	KEY	1	CN
27	V_SONU	MANDT	T000	MANDT	KEY	1	CN
28	V_SONU	SPGR1	TWRF11	SPGR1	KEY	1	CN
29	V_SONU	STFAK	TFACD	IDENT	KEY	1	CN
30	V_SONU	TXJCD	TTXJ	TXJCD	REF	C	CN
31	V_SONU	VERFE	T006	MSEHI	KEY	1	CN
32	V_SONU	VKORG	TVKO	VKORG	REF	1	CN
33	V_SONU	VTWEG	TVTW	VTWEG	REF	C	CN
34	V_SONU	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in