SAP ABAP Table SVBMTV_TRVOG (View: Order Items for Material + Transaction Operation)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VREP (Package) Application development RV reporting

Basic Data

Table Category	INTTAB	Structure
Structure	SVBMTV_TRVOG	Table Relationship Diagram
Short Description	View: Order Items for Material + Transaction Operation

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	.INCLUDE	☐				0	0	View: Order Items for Material
2	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
3	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
4	ETENR	☐	ETENR	ETENR	NUMC	4	0	Schedule line	VBEP
5	SELKZ	☐	SELKZ_LIST	SELKZ	CHAR	1	0	Selection indicator for list screens
6	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
7	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
8	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
9	BMENG	☐	BMENG	MENG13	QUAN	13	3	Confirmed quantity
10	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
11	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
12	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
13	DATAB	☐	DATAB_VI	DATUM	DATS	8	0	Quotation or contract valid from
14	DATBI	☐	DATBI_VI	DATUM	DATS	8	0	Quotation or contract valid to
15	EDATU	☐	EDATU	DATUM	DATS	8	0	Schedule line date
16	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
17	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	TVFS
18	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
19	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
20	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
21	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
22	LFIMG	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
23	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	TVLS
24	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
25	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
26	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
27	CBETR	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
28	CSEPR	☐	CSEPR	WERTV6	CURR	11	2	Customer expected price
29	CSEIN	☐	CSEIN	KPEIN	DEC	5	0	Price unit of customer expected price
30	CMEIN	☐	CMEIN	MEINS	UNIT	3	0	Unit of measure of customer expected price	*
31	CNETW	☐	CNETW	WERTV8	CURR	15	2	Customer expected value
32	CWAER	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
33	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
34	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
35	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
36	NETWR_AK	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
37	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
38	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
39	STATUS	☐	STATUS_VB	STATV	CHAR	1	0	Status of the document
40	STATU	☐	STATS	TEXT20	CHAR	20	0	Document status
41	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
42	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
43	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
44	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
45	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
46	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
47	WADAT	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
48	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
49	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
50	WMENG	☐	WMENG	MENG13	QUAN	13	3	Order quantity in sales units
51	WLDAT	☐	WLDAT	DATUM	DATS	8	0	Requested delivery date
52	KTEXT	☐	KTEXT_V	TEXT40	CHAR	40	0	Search term for product proposal
53	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
54	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	TVAG
55	AWAHR	☐	AWAHR_AK	AWAHR	NUMC	3	0	Sales Probability
56	ADRNR	☐	ADRNR_AG	ADRNR	CHAR	10	0	Address number of the sold-to party	*
57	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
58	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
59	ACTIV	☐	ACTIV	NUM02	NUMC	2	0	List Level in which the Line Item is Active
60	AUARA	☐	AUARA	AUART	CHAR	4	0	Proposal for order type for the subsequent function	*
61	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
62	KURSK_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
63	KURRF_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
64	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
65	.INCLUDE	☐				0	0	Contract Items
66	VLAUFZ	☐	VLAUF_VEDA	NUM3	NUMC	3	0	Contract Term
67	VLAUEZ	☐	VLAUE_VEDA	KDZEH	CHAR	1	0	Unit of validity period of contract
68	VLAUFK	☐	VLAUK_VEDA	VLAUK_VEDA	CHAR	2	0	Validity period category of contract	*
69	VINSDAT	☐	VIDAT_VEDA	DATUM	DATS	8	0	Installation date
70	VABNDAT	☐	VADAT_VEDA	DATUM	DATS	8	0	Agreement acceptance date
71	VUNTDAT	☐	VUDAT_VEDA	DATUM	DATS	8	0	Date on which contract is signed
72	VKUESCH	☐	VKUES_VEDA	VKUES_VEDA	CHAR	4	0	Assignment cancellation procedure/cancellation rule	*
73	VAKTSCH	☐	VASCH_VEDA	AKTVT	CHAR	4	0	Activity at end of contract	*
74	VEINDAT	☐	VEDAT_VEDA	DATUM	DATS	8	0	Date on which cancellation request was received
75	VWUNDAT	☐	VWDAT_VEDA	DATUM	DATS	8	0	Requested cancellation date
76	VKUEPAR	☐	VKPAR_VEDA	VKPAR_VEDA	CHAR	1	0	Cancelling Party
77	VKUEGRU	☐	VKGRU_VEDA	KUEGRU	CHAR	2	0	Reason for cancellation of contract	*
78	VBELKUE	☐	VBELK_VEDA	CHAR20	CHAR	20	0	Cancellation document number of contract partner
79	VBEDKUE	☐	VBEDK_VEDA	DATUM	DATS	8	0	Date of cancellation document from contract partner
80	VDEMDAT	☐	VDDAT_VEDA	DATUM	DATS	8	0	Dismantling date
81	VASDA	☐	VASDA	DATUM	DATS	8	0	Date of Activity
82	AKTVT	☐	AKTVT	AKTVT	CHAR	4	0	Activities	*
83	BEZEI	☐	BEZEI40	TEXT40	CHAR	40	0	Description
84	.INCLUDE	☐				0	0	Customer enhancements for orders items for material
85	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
86	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
87	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
88	TRVOG	☐	TRVOG	TRVOG	CHAR	1	0	Transaction group
89	TRVOGT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
90	ZPAVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
91	ZPERS	☐	DZPERS	PERNR	NUMC	8	0	Person responsible
92	AUARTT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
93	PARVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
94	KUNDE	☐	KUNDE_D	KUNDE	CHAR	10	0	Partner number (KUNNR, LIFNR, or PERNR)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SVBMTV_TRVOG	ABGRU	TVAG	ABGRU
2	SVBMTV_TRVOG	AUART	TVAK	AUART
3	SVBMTV_TRVOG	AUGRU	TVAU	AUGRU
4	SVBMTV_TRVOG	CHARG	MCHA	CHARG
5	SVBMTV_TRVOG	ETENR	VBEP	ETENR
6	SVBMTV_TRVOG	FAKSK	TVFS	FAKSP
7	SVBMTV_TRVOG	KUNNR	KNA1	KUNNR
8	SVBMTV_TRVOG	LGORT	T001L	LGORT
9	SVBMTV_TRVOG	LIFSK	TVLS	LIFSP
10	SVBMTV_TRVOG	MATNR	MARA	MATNR
11	SVBMTV_TRVOG	MEINS	T006	MSEHI
12	SVBMTV_TRVOG	POSNR	VBUP	POSNR
13	SVBMTV_TRVOG	SPART	TSPA	SPART
14	SVBMTV_TRVOG	VBELN	VBUK	VBELN
15	SVBMTV_TRVOG	VKBUR	TVBUR	VKBUR
16	SVBMTV_TRVOG	VKGRP	TVKGR	VKGRP
17	SVBMTV_TRVOG	VKORG	TVKO	VKORG
18	SVBMTV_TRVOG	VRKME	T006	MSEHI
19	SVBMTV_TRVOG	VSTEL	TVST	VSTEL
20	SVBMTV_TRVOG	VTWEG	TVTW	VTWEG
21	SVBMTV_TRVOG	WAERK	TCURC	WAERS
22	SVBMTV_TRVOG	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in	500