SAP ABAP Table VBMTV (View: Order Items for Material)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS-GF (Application Component) Basic Functions
     ⤷ VAR (Package) Application development R/3 reporting sales

Basic Data

Table Category	INTTAB	Structure
Structure	VBMTV	Table Relationship Diagram
Short Description	View: Order Items for Material

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in