1. Home
  2. Resources
  3. SAP Tables
  4. VBMTV - View: Order Items for Material

SAP Table VBMTV

View: Order Items for Material

VBMTV (View: Order Items for Material) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VBMTV to other SAP tables.

VBMTV table fields

Field Data element Checktable Datatype Length Decimals
VBELN Sales and Distribution Document Number VBELN VBUK CHAR 10 0
POSNR Item number of the SD document POSNR VBUP NUMC 6 0
ETENR Delivery Schedule Line Number ETENR VBEP NUMC 4 0
SELKZ Selection indicator for list screens SELKZ_LIST CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
ARKTX Short text for sales order item ARKTX CHAR 40 0
AUART Sales Document Type AUART TVAK CHAR 4 0
AUDAT Document Date (Date Received/Sent) AUDAT DATS 8 0
BMENG Confirmed Quantity BMENG QUAN 13 3
BSTNK Customer purchase order number BSTNK CHAR 20 0
BSTKD Customer purchase order number BSTKD CHAR 35 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
DATAB Quotation or contract valid from DATAB_VI DATS 8 0
DATBI Quotation or contract valid to DATBI_VI DATS 8 0
EDATU Schedule line date EDATU DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
FAKSK Billing block in SD document FAKSK TVFS CHAR 2 0
KUNNR Sold-to party KUNAG KNA1 CHAR 10 0
KURSK Exchange Rate for Price Determination KURSK DEC 9 5
KWMENG Cumulative Order Quantity in Sales Units KWMENG QUAN 15 3
LGORT Storage Location LGORT_D T001L CHAR 4 0
LFIMG Actual quantity delivered (in sales units) LFIMG QUAN 13 3
LIFSK Delivery block (document header) LIFSK TVLS CHAR 2 0
MATNR Material Number MATNR MARA CHAR 18 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
NAME1 Name 1 NAME1_GP CHAR 35 0
CBETR Rate (condition amount or percentage) KBETR CURR 11 2
CSEPR Customer expected price CSEPR CURR 11 2
CSEIN Price unit of customer expected price CSEIN DEC 5 0
CMEIN Unit of measure of customer expected price CMEIN UNIT 3 0
CNETW Customer expected value CNETW CURR 15 2
CWAER Condition currency (for cumulation fields) KWAEH CUKY 5 0
NETPR Net price NETPR CURR 11 2
KPEIN Condition pricing unit KPEIN DEC 5 0
KMEIN Condition unit KMEIN UNIT 3 0
NETWR_AK Net Value of the Sales Order in Document Currency NETWR_AK CURR 15 2
NETWR Net Value in Document Currency NETWR CURR 15 2
SPART Division SPART TSPA CHAR 2 0
STATUS Status of the document STATUS_VB CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
STATU Document status STATS CHAR 20 0
VKBUR Sales Office VKBUR TVBUR CHAR 4 0
VKGRP Sales Group VKGRP TVKGR CHAR 3 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VRKME Sales unit VRKME T006 UNIT 3 0
VSTEL Shipping Point/Receiving Point VSTEL TVST CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
WADAT Goods Issue Date WADAT DATS 8 0
WAERK SD Document Currency WAERK TCURC CUKY 5 0
WERKS Plant WERKS_D T001W CHAR 4 0
WMENG Order quantity in sales units WMENG QUAN 13 3
WLDAT Requested delivery date WLDAT DATS 8 0
KTEXT Search term for product proposal KTEXT_V CHAR 40 0
AUGRU Order reason (reason for the business transaction) AUGRU TVAU CHAR 3 0
ABGRU Reason for rejection of quotations and sales orders ABGRU_VA TVAG CHAR 2 0
AWAHR Sales probability AWAHR_AK NUMC 3 0
000 Sales order probability
ADRNR Address number of the sold-to party ADRNR_AG CHAR 10 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
ACTIV List Level in which the Line Item is Active ACTIV NUMC 2 0
AUARA Proposal for order type for the subsequent function AUARA CHAR 4 0
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
KURSK_DAT Translation Date WWERT_D DATS 8 0
KURRF_DAT Translation Date WWERT_D DATS 8 0
KURST Exchange Rate Type KURST CHAR 4 0
VLAUFZ Validity period of contract VLAUF_VEDA NUMC 3 0
VLAUEZ Unit of validity period of contract VLAUE_VEDA CHAR 1 0
1 Day
2 Week
3 Month
4 Year
VLAUFK Validity period category of contract VLAUK_VEDA CHAR 2 0
VINSDAT Installation date VIDAT_VEDA DATS 8 0
VABNDAT Agreement acceptance date VADAT_VEDA DATS 8 0
VUNTDAT Date on which contract is signed VUDAT_VEDA DATS 8 0
VKUESCH Assignment cancellation procedure/cancellation rule VKUES_VEDA CHAR 4 0
VAKTSCH Action at end of contract VASCH_VEDA CHAR 4 0
VEINDAT Date on which cancellation request was received VEDAT_VEDA DATS 8 0
VWUNDAT Requested cancellation date VWDAT_VEDA DATS 8 0
VKUEPAR Cancellation party VKPAR_VEDA CHAR 1 0
A Oneself
B Contract partner
VKUEGRU Reason for Cancellation of Contract VKGRU_VEDA CHAR 2 0
VBELKUE Cancellation document number of contract partner VBELK_VEDA CHAR 20 0
VBEDKUE Date of cancellation document from contract partner VBEDK_VEDA DATS 8 0
VDEMDAT Dismantling date VDDAT_VEDA DATS 8 0
VASDA Date for action VASDA DATS 8 0
AKTVT Action AKTVT CHAR 4 0
BEZEI Description BEZEI40 CHAR 40 0
PBLNR Business location identifier (IS-Oil MRN) OIF_PBLNR CHAR 10 0
DUMMY Dummy function in length 1 DUMMY CHAR 1 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0

VBMTV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBMTV ABGRU SYST MANDT TVAG Sales Documents: Rejection Reasons MANDT
VBMTV ABGRU VBMTV ABGRU TVAG Sales Documents: Rejection Reasons ABGRU
VBMTV AUART SYST MANDT TVAK Sales Document Types MANDT
VBMTV AUART VBMTV AUART TVAK Sales Document Types AUART
VBMTV AUGRU VBMTV AUGRU TVAU Sales Documents: Order Reasons AUGRU
VBMTV AUGRU SYST MANDT TVAU Sales Documents: Order Reasons MANDT
VBMTV CHARG SYST MANDT MCHA Batches MANDT
VBMTV CHARG VBMTV MATNR MCHA Batches MATNR
VBMTV CHARG VBMTV WERKS MCHA Batches WERKS
VBMTV CHARG VBMTV CHARG MCHA Batches CHARG
VBMTV ETENR VBMTV VBELN VBEP Sales Document: Schedule Line Data VBELN
VBMTV ETENR VBMTV POSNR VBEP Sales Document: Schedule Line Data POSNR
VBMTV ETENR VBMTV ETENR VBEP Sales Document: Schedule Line Data ETENR
VBMTV ETENR SYST MANDT VBEP Sales Document: Schedule Line Data MANDT
VBMTV FAKSK SYST MANDT TVFS Billing: Reasons for Blocking MANDT
VBMTV FAKSK VBMTV FAKSK TVFS Billing: Reasons for Blocking FAKSP
VBMTV KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
VBMTV KUNNR VBMTV KUNNR KNA1 General Data in Customer Master KUNNR
VBMTV LGORT VBMTV LGORT T001L Storage Locations LGORT
VBMTV LGORT SYST MANDT T001L Storage Locations MANDT
VBMTV LGORT VBMTV WERKS T001L Storage Locations WERKS
VBMTV LIFSK VBMTV LIFSK TVLS Deliveries: Blocking Reasons/Criteria LIFSP
VBMTV LIFSK SYST MANDT TVLS Deliveries: Blocking Reasons/Criteria MANDT
VBMTV MATNR SYST MANDT MARA General Material Data MANDT
VBMTV MATNR VBMTV MATNR MARA General Material Data MATNR
VBMTV MEINS SYST MANDT T006 Units of Measurement MANDT
VBMTV MEINS VBMTV MEINS T006 Units of Measurement MSEHI
VBMTV POSNR SYST MANDT VBUP Sales Document: Item Status MANDT
VBMTV POSNR VBMTV VBELN VBUP Sales Document: Item Status VBELN
VBMTV POSNR VBMTV POSNR VBUP Sales Document: Item Status POSNR
VBMTV SPART VBMTV SPART TSPA Organizational Unit: Sales Divisions SPART
VBMTV SPART SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
VBMTV VBELN SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBMTV VBELN VBMTV VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
VBMTV VKBUR SYST MANDT TVBUR Organizational Unit: Sales Offices MANDT
VBMTV VKBUR VBMTV VKBUR TVBUR Organizational Unit: Sales Offices VKBUR
VBMTV VKGRP SYST MANDT TVKGR Organizational Unit: Sales Groups MANDT
VBMTV VKGRP VBMTV VKGRP TVKGR Organizational Unit: Sales Groups VKGRP
VBMTV VKORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
VBMTV VKORG VBMTV VKORG TVKO Organizational Unit: Sales Organizations VKORG
VBMTV VRKME SYST MANDT T006 Units of Measurement MANDT
VBMTV VRKME VBMTV VRKME T006 Units of Measurement MSEHI
VBMTV VSTEL SYST MANDT TVST Organizational Unit: Shipping Points MANDT
VBMTV VSTEL VBMTV VSTEL TVST Organizational Unit: Shipping Points VSTEL
VBMTV VTWEG SYST MANDT TVTW Organizational Unit: Distribution Channels MANDT
VBMTV VTWEG VBMTV VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
VBMTV WAERK SYST MANDT TCURC Currency Codes MANDT
VBMTV WAERK VBMTV WAERK TCURC Currency Codes WAERS
VBMTV WERKS SYST MANDT T001W Plants/Branches MANDT
VBMTV WERKS VBMTV WERKS T001W Plants/Branches WERKS