SAP ABAP View VIVEDA (Sales Document Item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ ICSV (Package) R/3 Customer Service

Basic Data

View Type	D	Database View
Database View	VIVEDA
Short Description	Sales Document Item
Root table	VBAK	Sales Document: Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VBAK	VBAK
2	VBAP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VBAP	MANDT	JL	EQ				0	0
2	VBAK	MANDT	JR	EQ			AND	0	0
3	VBAP	VBELN	JL	EQ				0	0
4	VBAK	VBELN	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VBAP	MANDT		☐	MANDT	☐	Client
2	VBELN	VBAP	VBELN		☐	VBELN_VA	☐	Sales Document
3	POSNR	VBAP	POSNR		☐	POSNR_VA	☐	Sales Document Item
4	AUART	VBAK	AUART		☐	AUART	☐	Sales Document Type
5	VBTYP	VBAK	VBTYP		☐	VBTYP	☐	SD document category
6	AUGRU	VBAK	AUGRU		☐	AUGRU	☐	Order reason (reason for the business transaction)
7	ERNAM	VBAK	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
8	SUBMI	VBAK	SUBMI		☐	SUBMI_SD	☐	Collective number (SD)
9	FAKSK	VBAK	FAKSK		☐	FAKSK	☐	Billing block in SD document
10	NETWR	VBAK	NETWR		☐	NETWR_AK	☐	Net Value of the Sales Order in Document Currency
11	WAERK	VBAK	WAERK		☐	WAERK	☐	SD document currency
12	VKORG	VBAK	VKORG		☐	VKORG	☐	Sales Organization
13	VTWEG	VBAK	VTWEG		☐	VTWEG	☐	Distribution Channel
14	VKGRP	VBAK	VKGRP		☐	VKGRP	☐	Sales group
15	VKBUR	VBAK	VKBUR		☐	VKBUR	☐	Sales office
16	BSTZD	VBAK	BSTZD		☐	BSTZD	☐	Customer purchase order number supplement
17	BNAME	VBAK	BNAME		☐	BNAME_V	☐	Name of orderer
18	TELF1	VBAK	TELF1		☐	TELF1_VP	☐	Telephone Number
19	KUNNR	VBAK	KUNNR		☐	KUNAG	☐	Sold-to party
20	KVGR1	VBAK	KVGR1		☐	KVGR1	☐	Customer group 1
21	KVGR2	VBAK	KVGR2		☐	KVGR2	☐	Customer group 2
22	KVGR3	VBAK	KVGR3		☐	KVGR3	☐	Customer group 3
23	KVGR4	VBAK	KVGR4		☐	KVGR4	☐	Customer group 4
24	KVGR5	VBAK	KVGR5		☐	KVGR5	☐	Customer group 5
25	MATNRX	VBAP	MATNR		☐	MATNR	☐	Material Number
26	MATWA	VBAP	MATWA		☐	MATWA	☐	Material entered
27	CHARG	VBAP	CHARG		☐	CHARG_D	☐	Batch Number
28	MATKL	VBAP	MATKL		☐	MATKL	☐	Material Group
29	ARKTX	VBAP	ARKTX		☐	ARKTX	☐	Short text for sales order item
30	PSTYV	VBAP	PSTYV		☐	PSTYV	☐	Sales document item category
31	UEPOS	VBAP	UEPOS		☐	UEPOS	☐	Higher-level item in bill of material structures
32	ABGRU	VBAP	ABGRU		☐	ABGRU_VA	☐	Reason for rejection of quotations and sales orders
33	PRODH	VBAP	PRODH		☐	PRODH_D	☐	Product Hierarchy
34	ZMENG	VBAP	ZMENG		☐	DZMENG	☐	Target quantity in sales units
35	ZIEME	VBAP	ZIEME		☐	DZIEME	☐	Target quantity UoM
36	UMZIZ	VBAP	UMZIZ		☐	UMZIZ	☐	Factor for converting sales units to base units (target qty)
37	UMZIN	VBAP	UMZIN		☐	UMZIN	☐	Factor for converting sales units to base units (target qty)
38	MEINS	VBAP	MEINS		☐	MEINS	☐	Base Unit of Measure
39	KDMAT	VBAP	KDMAT		☐	MATNR_KU	☐	Customer Material Number
40	POSEX	VBAP	POSEX		☐	POSEX	☐	Item Number of the Underlying Purchase Order
41	FAKSP	VBAP	FAKSP		☐	FAKSP_AP	☐	Billing block for item
42	SPART	VBAP	SPART		☐	SPART	☐	Division
43	NETWRX	VBAP	NETWR		☐	NETWR_AP	☐	Net value of the order item in document currency
44	VGBEL	VBAP	VGBEL		☐	VGBEL	☐	Document number of the reference document
45	VGPOS	VBAP	VGPOS		☐	VGPOS	☐	Item number of the reference item
46	WERKS	VBAP	WERKS		☐	WERKS_EXT	☐	Plant (Own or External)
47	NETPR	VBAP	NETPR		☐	NETPR	☐	Net price
48	EAN11	VBAP	EAN11		☐	EAN11	☐	International Article Number (EAN/UPC)
49	MVGR1	VBAP	MVGR1		☐	MVGR1	☐	Material group 1
50	MVGR2	VBAP	MVGR2		☐	MVGR2	☐	Material group 2
51	MVGR3	VBAP	MVGR3		☐	MVGR3	☐	Material group 3
52	MVGR4	VBAP	MVGR4		☐	MVGR4	☐	Material group 4
53	MVGR5	VBAP	MVGR5		☐	MVGR5	☐	Material group 5
54	PRCTR	VBAP	PRCTR		☐	PRCTR	☐	Profit Center
55	CUOBJ	VBAP	CUOBJ		☐	CUOBJ_VA	☐	Configuration
56	WAERKX	VBAP	WAERK		☐	WAERK	☐	SD document currency
57	KTEXT	VBAK	KTEXT		☐	KTEXT_V	☐	Search term for product proposal

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	20140121
SAP Release Created in