SAP Table MC11VA4ITM

Extraction SD Sales BW: Document Item MCVBAP

MC11VA4ITM (Extraction SD Sales BW: Document Item MCVBAP) 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 MC11VA4ITM to other SAP tables.

MC11VA4ITM table fields

Field Data element Checktable Datatype Length Decimals
ABGRU Reason for rejection of quotations and sales orders ABGRU_VA CHAR 2 0
AEDAT Changed On AEDAT DATS 8 0
AWAHR Order probability of the item AWAHR NUMC 3 0
000 Sales order probability
BRGEW Gross Weight of the Item BRGEW_AP QUAN 15 3
BWAPPLNM Application Component RSAPPLNM CHAR 30 0
BWVORG SAP BW transaction key MCW_BWVORG NUMC 3 0
CHARG Batch Number CHARG_D CHAR 10 0
CMKUA Credit data exchange rate for requested delivery date CMKUA DEC 9 5
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERZET Entry time ERZET TIMS 6 0
FAKSP Billing block for item FAKSP_AP CHAR 2 0
GEWEI Weight Unit GEWEI UNIT 3 0
KBMENG Cumulative confirmed quantity in sales unit KBMENG QUAN 15 3
KLMENG Cumulative confirmed quantity in base unit KLMENG QUAN 15 3
KMEIN Condition unit KMEIN UNIT 3 0
KNUMA_AG Sales deal KNUMA_AG CHAR 10 0
KPEIN Condition pricing unit KPEIN DEC 5 0
KWMENG Cumulative Order Quantity in Sales Units KWMENG QUAN 15 3
KZWI1 Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
KZWI2 Subtotal 2 from pricing procedure for condition KZWI2 CURR 13 2
KZWI3 Subtotal 3 from pricing procedure for condition KZWI3 CURR 13 2
KZWI4 Subtotal 4 from pricing procedure for condition KZWI4 CURR 13 2
KZWI5 Subtotal 5 from pricing procedure for condition KZWI5 CURR 13 2
KZWI6 Subtotal 6 from pricing procedure for condition KZWI6 CURR 13 2
LFMNG Minimum delivery quantity in delivery note processing MINLF QUAN 13 3
LGORT Storage Location LGORT_D CHAR 4 0
LSMENG Cumulative required delivery qty (all dlv-relev.sched.lines) LSMENG QUAN 15 3
MATKL Material Group MATKL CHAR 9 0
MATNR Material Number MATNR CHAR 18 0
MATWA Material entered MATWA CHAR 18 0
MEINS Base Unit of Measure MEINS UNIT 3 0
MVGR1 Material group 1 MVGR1 CHAR 3 0
MVGR2 Material group 2 MVGR2 CHAR 3 0
MVGR3 Material group 3 MVGR3 CHAR 3 0
MVGR4 Material group 4 MVGR4 CHAR 3 0
MVGR5 Material group 5 MVGR5 CHAR 3 0
MWSBP Tax amount in document currency MWSBP CURR 13 2
NETPR Net price NETPR CURR 11 2
NETWR Net value of the order item in document currency NETWR_AP CURR 15 2
NTGEW Net Weight of the Item NTGEW_AP QUAN 15 3
PABLA Unloading point of the ship-to party PABLA CHAR 25 0
PKUNRE Bill-to party KUNRE CHAR 10 0
PKUNRG Payer KUNRG CHAR 10 0
PKUNWE Ship-to party KUNWE CHAR 10 0
PRODH Product hierarchy PRODH_D CHAR 18 0
PSPDNR Forwarding agent SPDNR CHAR 10 0
PSTYV Sales document item category PSTYV CHAR 4 0
PVRTNR Sales employee VRTNR NUMC 8 0
PZPERS Person responsible DZPERS NUMC 8 0
ROOT_DATE Date of the Root Item TDD_ROOT_DATE DATS 8 0
ROOT_HEAD Document Number of the Root Header TDD_ROOT_HEAD CHAR 10 0
ROOT_ITEM Item Number of the Root Item TDD_ROOT_ITEM NUMC 6 0
ROUTE Route ROUTE CHAR 6 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
SPART Division SPART CHAR 2 0
STADAT Statistics date STADAT DATS 8 0
STCUR Exchange rate for statistics (Exch.rate at time of creation) STCUR_AP DEC 9 5
SUGRD Reason for material substitution SUGRD CHAR 4 0
UEBTK Unlimited overdelivery allowed UEBTK_V CHAR 1 0
X Yes
NULL No
UEBTO Overdelivery Tolerance Limit UEBTO DEC 3 1
UMVKN Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
UMZIN Factor for converting sales units to base units (target qty) UMZIN DEC 5 0
UMZIZ Factor for converting sales units to base units (target qty) UMZIZ DEC 5 0
UNTTO Underdelivery Tolerance Limit UNTTO DEC 3 1
VDATU Date of update for statistics updating MC_VDATUM DATS 8 0
VGBEL Document number of the reference document VGBEL CHAR 10 0
VGPOS Item number of the reference item VGPOS NUMC 6 0
VGTYP Document category of preceding SD document VBTYP_V 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
VOLEH Volume unit VOLEH UNIT 3 0
VOLUM Volume of the item VOLUM_AP QUAN 15 3
VRKME Sales unit VRKME UNIT 3 0
VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
WAERK SD Document Currency WAERK CUKY 5 0
WAVWR Cost in document currency WAVWR CURR 13 2
WERKS Plant (Own or External) WERKS_EXT CHAR 4 0
ZIEME Target quantity UoM DZIEME UNIT 3 0
ZMENG Target quantity in sales units DZMENG QUAN 13 3
ZWERT Target Value for Outline Agreement in Document Currency DZWERT CURR 13 2