1. Home
  2. Resources
  3. SAP Tables
  4. MCVBAPF - Order Item Flow

SAP Table MCVBAPF

Order Item Flow

MCVBAPF (Order Item Flow) 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 MCVBAPF to other SAP tables.

Source: MCVBAPF (Order Item Flow)

MCVBAPF 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
DUMMY Single-Character Indicator CHAR1 CHAR 1 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
REFKZ Item was referenced REFKZ CHAR 1 0
X Yes
NULL No
ERLMENGE Quantity for completion (sales) in basic unit of measure ERLMENGF FLTP 16 16
ERLWERT Value for completion ERLWERT CURR 15 2
ERLWERT_WA Value for completion ERLWERT CURR 15 2
ERLMENGE_L Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
ERLMENGE_P Quantity for completion (sales) in basic unit of measure ERLMENGE QUAN 13 3
ERLMENGE_F Invoiced quantity in basic unit of measure ERLMENGE_F QUAN 13 3
FAKLMENG Invoiced delivery quantity in base unit of measure FAKLMENG QUAN 13 3
AMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
BMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
CMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
DMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
EMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
FMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
GMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
HMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
IMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
JMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
KMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
LMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
MMENGE Completed quantity base UoM; 1st letter = sales doc. type XMENGE QUAN 13 3
NMENGE Completed quantity base UoM; 1st letter = sales doc. type XMENGE QUAN 13 3
OMENGE Completed quantity base UoM; 1st letter = sales doc. type XMENGE QUAN 13 3
PMENGE Completed quantity base UoM; 1st letter = sales doc. type XMENGE QUAN 13 3
QMENGE Completed quantity base UoM; 1st letter = sales doc. type XMENGE QUAN 13 3
RMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
RMENGE_P Completed quantity base UoM; 1st letter = sales doc. type XMENGE QUAN 13 3
RMENGE_NV_P Completed quantity base UoM; 1st letter = sales doc. type XMENGE QUAN 13 3
SMENGE Completed quantity base UoM; 1st letter = sales doc. type XMENGE QUAN 13 3
TMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
UMENGE Completed quantity base UoM; 1st letter = sales doc. type XMENGE QUAN 13 3
VMENGE Completed quantity base UoM; 1st letter = sales doc. type XMENGE QUAN 13 3
WMENGE Completed quantity base UoM; 1st letter = sales doc. type XMENGE QUAN 13 3
XMENGE Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
YMENGE Completed quantity base UoM; 1st letter = sales doc. type XMENGE QUAN 13 3
ANZTAP Number of transfer order items ANZTAP DEC 5 0
ANZQTAP Number of confirmed transfer order items ANZQTAP DEC 5 0
ANZLFP Number of delivery items ANZLFP DEC 5 0
ANZFKP Number of billing items ANZFKP DEC 5 0
ANZFKP_IV Number of billing items (inter-company billing) ANZFKP_IV DEC 5 0
ANZWAP Number of goods issue items ANZWAP DEC 5 0
WEMNG Quantity of goods received in base unit of measure WEMENGE QUAN 13 3
REMNG Invoice receipt quantity in base unit of measure REMENGE QUAN 13 3
ANZLRP No.of invoice lists ANZLRP DEC 5 0
ANZLGP No.of credit memo lists ANZLGP DEC 5 0
REWRT Invoice value in local currency REWRT CURR 13 2
WEWRT Value of goods received in local currency WEWRT CURR 13 2
BEWRT Net value of purchasing document item in local currency NEHWR CURR 15 2
ERLMENGEV Completion quantity for sales (category F) in sales unit ERLMENGFV FLTP 16 16
ERLMENGELV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
ERLMENGEPV Completed quantity for sales (category P) in sales unit ERLMENGEV QUAN 13 3
ERLMENGEFV Invoiced quantity (P category) in sales unit ERLMENGEFV QUAN 13 3
FAKLMENGV Billed delivery quantity (P category) in sales unit FAKLMENGV QUAN 13 3
AMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
BMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
CMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
DMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
EMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
FMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
GMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
HMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
IMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
JMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
KMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
LMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
MMENGEV Compltd qty (category P) in sales unit; 1st place=VBAK-VBTYP XMENGEV QUAN 13 3
NMENGEV Compltd qty (category P) in sales unit; 1st place=VBAK-VBTYP XMENGEV QUAN 13 3
OMENGEV Compltd qty (category P) in sales unit; 1st place=VBAK-VBTYP XMENGEV QUAN 13 3
PMENGEV Compltd qty (category P) in sales unit; 1st place=VBAK-VBTYP XMENGEV QUAN 13 3
QMENGEV Compltd qty (category P) in sales unit; 1st place=VBAK-VBTYP XMENGEV QUAN 13 3
RMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
RMENGE_PV Compltd qty (category P) in sales unit; 1st place=VBAK-VBTYP XMENGEV QUAN 13 3
RMENGE_NV_PV Compltd qty (category P) in sales unit; 1st place=VBAK-VBTYP XMENGEV QUAN 13 3
SMENGEV Compltd qty (category P) in sales unit; 1st place=VBAK-VBTYP XMENGEV QUAN 13 3
TMENGEV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
UMENGEV Compltd qty (category P) in sales unit; 1st place=VBAK-VBTYP XMENGEV QUAN 13 3
VMENGEV Compltd qty (category P) in sales unit; 1st place=VBAK-VBTYP XMENGEV QUAN 13 3
WMENGEV Compltd qty (category P) in sales unit; 1st place=VBAK-VBTYP XMENGEV QUAN 13 3
XMENGEV Dummy RFMNG_FLO FLTP 16 16
YMENGEV Compltd qty (category P) in sales unit; 1st place=VBAK-VBTYP XMENGEV QUAN 13 3
WEMNGV Quantity of goods received (category P) in sales unit WEMENGEV QUAN 13 3
REMNGV Invoiced receipt quantity (category P) in sales unit REMENGEV QUAN 13 3
PZMNG_SAV Completd qty (category F) in sales unit;1st place=VBAK-VBTYP XMENGE_FLTV FLTP 16 16
ERLMENGEFV_IV Invoiced quantity (P category) in sales unit ERLMENGEFV QUAN 13 3
NOQUANTITY No quantity logic (document item without quantity) NOQUANTITY CHAR 1 0
X Yes
NULL No
ANZWAP_EX Number of external goods issue items ANZWAP_EX DEC 5 0
ANZWAP_EX_QGT0 Number of ext. goods issue items with quantity > 0 ANZWAP_EX_QGT0 DEC 5 0
ANZWAP_EX_MAIN Number of ext. goods issue items with item number < 900000 ANZWAP_EX_MAIN DEC 5 0
QMENGE_F Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
PZMNG_SA Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
ERLMENGE_F_IV Invoiced quantity in basic unit of measure ERLMENGE_F QUAN 13 3
ANZFKP_NE Number of Billing Items in Prov. or Diff. Billing Document ANZFKP_NE DEC 5 0
ANZFKP_IV_NE Number of ICB Items in Provisional or Differential Invoice ANZFKP_IV_NE DEC 5 0
/CWM/REMNG_BPRME Order Price Unit (Purchasing) BPRME UNIT 3 0
/CWM/BPREM Invoice receipt quantity in order price unit BPREM QUAN 13 3
/CWM/BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
ERLMENGE_S Invoiced quantity in basic unit of measure ERLMENGE_F QUAN 13 3

MCVBAPF foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MCVBAPF POSNR SYST MANDT VBUP Sales Document: Item Status MANDT
MCVBAPF POSNR MCVBAPF VBELN VBUP Sales Document: Item Status VBELN
MCVBAPF POSNR MCVBAPF POSNR VBUP Sales Document: Item Status POSNR
MCVBAPF VBELN SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
MCVBAPF VBELN MCVBAPF VBELN VBUK Sales Document: Header Status and Administrative Data VBELN