SAP ABAP Table VIVEDA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VIVEDA	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	VBELN	☑	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
3	POSNR	☑	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
4	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
5	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
6	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
7	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	SUBMI	☐	SUBMI_SD	CHAR10	CHAR	10	0	Collective number (SD)
9	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	TVFS
10	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
11	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
12	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
13	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
14	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
15	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office
16	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
17	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
18	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
19	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
20	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
21	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
22	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
23	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
24	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
25	MATNRX	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
26	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
27	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
28	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
29	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
30	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	TVPT
31	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures
32	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	TVAG
33	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
34	ZMENG	☐	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
35	ZIEME	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	T006
36	UMZIZ	☐	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
37	UMZIN	☐	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
38	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
39	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
40	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
41	FAKSP	☐	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	TVFS
42	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
43	NETWRX	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
44	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
45	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
46	WERKS	☐	WERKS_EXT	WERKS	CHAR	4	0	Plant (Own or External)
47	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
48	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
49	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	TVM1
50	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
51	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	TVM3
52	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	TVM4
53	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	TVM5
54	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
55	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
56	WAERKX	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
57	KTEXT	☐	KTEXT_V	TEXT40	CHAR	40	0	Search term for product proposal

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIVEDA	ABGRU	TVAG	ABGRU	REF	C	CN
2	VIVEDA	AUART	TVAK	AUART	REF	1	CN
3	VIVEDA	AUGRU	TVAU	AUGRU	REF	C	CN
4	VIVEDA	CHARG	MCHA	CHARG	REF	C	CN
5	VIVEDA	FAKSK	TVFS	FAKSP	REF	C	CN
6	VIVEDA	FAKSP	TVFS	FAKSP	REF	C	CN
7	VIVEDA	KUNNR	KNA1	KUNNR	REF	C	CN
8	VIVEDA	KVGR1	TVV1	KVGR1	REF	C	CN
9	VIVEDA	KVGR2	TVV2	KVGR2	REF	C	CN
10	VIVEDA	KVGR3	TVV3	KVGR3	REF	C	CN
11	VIVEDA	KVGR4	TVV4	KVGR4	REF	C	CN
12	VIVEDA	KVGR5	TVV5	KVGR5	REF	C	CN
13	VIVEDA	MANDT	T000	MANDT	KEY	1	CN
14	VIVEDA	MATKL	T023	MATKL	REF	C	CN
15	VIVEDA	MATNRX	MARA	MATNR	REF	C	CN
16	VIVEDA	MATWA	MARA	MATNR	REF	C	CN
17	VIVEDA	MEINS	T006	MSEHI	REF	C	CN
18	VIVEDA	MVGR1	TVM1	MVGR1	REF	C	CN
19	VIVEDA	MVGR2	TVM2	MVGR2	REF	C	CN
20	VIVEDA	MVGR3	TVM3	MVGR3	REF	C	CN
21	VIVEDA	MVGR4	TVM4	MVGR4	REF	C	CN
22	VIVEDA	MVGR5	TVM5	MVGR5	REF	C	CN
23	VIVEDA	POSNR	VBUP	POSNR	KEY	1	CN
24	VIVEDA	PRODH	T179	PRODH	REF	C	CN
25	VIVEDA	PSTYV	TVPT	PSTYV	REF	1	CN
26	VIVEDA	SPART	TSPA	SPART	REF	C	CN
27	VIVEDA	VBELN	VBUK	VBELN	KEY	1	CN
28	VIVEDA	VGBEL	VBUK	VBELN	REF	C	CN
29	VIVEDA	VGPOS	VBUP	POSNR	REF	C	CN
30	VIVEDA	VKGRP	TVBVK	VKGRP	REF	C	CN
31	VIVEDA	VKORG	TVKO	VKORG	REF	1	CN
32	VIVEDA	VTWEG	TVKOV	VTWEG	REF	1	CN
33	VIVEDA	WAERK	TCURC	WAERS	REF	C	CN
34	VIVEDA	WAERKX	TCURC	WAERS	REF	C	CN
35	VIVEDA	ZIEME	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in