SAP ABAP Table CRMS_ERP_VBMTV (ERP Order Items for Material)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ERP (Application Component) BSP for ERP Sales Order
     ⤷ CRM_ERP_IL (Package) ERP Sales Order: GENIL Implementation

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_ERP_VBMTV	Table Relationship Diagram
Short Description	ERP 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
2	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document
3	ETENR	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
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	*
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
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	*
17	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
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
21	LFIMG	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
22	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	*
23	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
24	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
25	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
26	CBETR	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
27	CSEPR	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
28	CSEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
29	CMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
30	CNETW	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
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_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
37	SPART	☐	SPART	SPART	CHAR	2	0	Division
38	STATUS	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
39	STATU	☐	STATS	TEXT20	CHAR	20	0	Document status
40	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
41	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
42	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
43	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
44	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point
45	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
46	WADAT	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
47	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
48	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
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)	*
53	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
54	AWAHR	☐	AWAHR_AK	AWAHR	NUMC	3	0	Sales Probability
55	ADRNR	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
56	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
57	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
58	ACTIV	☐	CRMT_ACTIV_ERPIL	NUM02	NUMC	2	0	ERP: 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	ERP 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	ERP 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

History

Last changed by/on	SAP	20130604
SAP Release Created in	700