1. Home
  2. Resources
  3. SAP Tables
  4. MC11VA0KON - Extraction SD Sales BW: Document Condition

SAP Table MC11VA0KON

Extraction SD Sales BW: Document Condition

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

Source: MC11VA0KON (Extraction SD Sales BW: Document Condition)

MC11VA0KON table fields

Field Data element Checktable Datatype Length Decimals
ROCANCEL Indicator: Cancel Data Record ROCANCEL CHAR 1 0
X TRUE
NULL FALSE
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
ABSTA Rejection status for SD item ABSTA_VB CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
POSNR Item number of the SD document POSNR NUMC 6 0
RFGSA Overall status of reference RFGSA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
RFSTA Reference status RFSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPRS Pricing for item is incomplete UVPRS_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
AUART Sales Document Type AUART CHAR 4 0
AUGRU Order reason (reason for the business transaction) AUGRU CHAR 3 0
BUKRS Company Code BUKRS CHAR 4 0
FAKSK Billing block in SD document FAKSK CHAR 2 0
HWAER Local Currency HWAER CUKY 5 0
KUNNR Sold-to party KUNAG CHAR 10 0
KURST Exchange Rate Type KURST CHAR 4 0
KVGR1 Customer group 1 KVGR1 CHAR 3 0
KVGR2 Customer group 2 KVGR2 CHAR 3 0
KVGR3 Customer group 3 KVGR3 CHAR 3 0
KVGR4 Customer group 4 KVGR4 CHAR 3 0
KVGR5 Customer group 5 KVGR5 CHAR 3 0
STWAE Statistics currency STWAE CUKY 5 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
VKBUR Sales Office VKBUR CHAR 4 0
VKGRP Sales Group VKGRP CHAR 3 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
ABGRU Reason for rejection of quotations and sales orders ABGRU_VA CHAR 2 0
AEDAT Changed On AEDAT DATS 8 0
BWAPPLNM Application Component RSAPPLNM CHAR 30 0
BWVORG SAP BW transaction key MCW_BWVORG NUMC 3 0
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
KWMENG Cumulative Order Quantity in Sales Units KWMENG QUAN 15 3
MATKL Material Group MATKL CHAR 9 0
MATNR Material Number MATNR CHAR 18 0
MATWA Material entered MATWA CHAR 18 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
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
PSTYV Sales document item category PSTYV CHAR 4 0
PVRTNR Sales employee VRTNR NUMC 8 0
PZPERS Person responsible DZPERS NUMC 8 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
VRKME Sales unit VRKME UNIT 3 0
WAERK SD Document Currency WAERK CUKY 5 0
ZIEME Target quantity UoM DZIEME UNIT 3 0
ZMENG Target quantity in sales units DZMENG QUAN 13 3
BZIRK Sales district BZIRK CHAR 6 0
FBUDA Date on which services rendered FBUDA DATS 8 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
KDGRP Customer group KDGRP CHAR 2 0
KTGRD Account assignment group for this customer KTGRD CHAR 2 0
KURSK Exchange Rate for Price Determination KURSK DEC 9 5
KURSK_DAT Translation Date WWERT_D DATS 8 0
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
WAKTION Promotion WAKTION CHAR 10 0
KAPPL Application KAPPL CHAR 2 0
KHERK Origin of the condition KHERK CHAR 1 0
A Automatic pricing
B Duplicated from main item
C Manually entered
D Header condition
E Item total
F Condition supplement
G Original header condition
H Correction Rebate
I Cost Correction
KINAK Condition is inactive KINAK CHAR 1 0
A Condition exclusion item
K Inactive due to calculation basis/shipping material type
L Condition exclusion header or inactive at header level
M Inactive due to manual entry
T Inactive at header level
W The document item is statistical
X Inactive via formulae of incorrect
Y Inactive because of subsequent price
KNTYP Condition category (examples: tax, freight, price, cost) KNTYP CHAR 1 0
$ TaxJurCode trigger (without license check KNVL)
+ Tax exemption license via conditions
- Total charges (only IS-OIL)
0 Charges - condition records (only IS-OIL)
1 Tax JurDic level 1 (with license check KNVL)
2 Tax JurDic level 2
3 Tax JurDic level 3
4 Tax JurDic level 4
5 Customer reserve 5
6 Customer reserve 6
7 Customer reserve 7
8 Customer reserve 8
9 Customer reserve 9
A Packaging
B Delivery costs
C Insurance
D Tax
E Cash discount
F Freight
G Internal price
H Basic price
I Price for intercompany billing
J Customer expected price / customer value (excl.tax)
K Base amount excluding tax
L Generally new when copying
M Sales tax w/license-checking (VAT)
N Input Tax not Deductible
O Variants
P Base amount including tax
Q Costing
R Invoice list condition
S Standard cost
T Moving cost
U Discount/surcharge for precious metals
V Price component
W Expected sales price (including tax)
X Customer reserve X
Y Customer reserve Y
Z Customer reserve Z
a Reserved (fixed extra pay)
b Transfer Price for Group Valuation
c Transfer price for profit centers
d Confirmed purchase net price/value
e Down payment request/down payment clearing
f Free goods - inclusive
g Payment
h Profit Center Cost
i Ship & Debit 1 (IBU HiTec)
j Ship & Debit 2 (IBU HiTec)
l TP-ILV: Base Tarif That Covers Costs
m SSR Discount (only IS-Oil)
n Profit Center Internal Price (Route)
o AFS Season Determination
p SSR Partner Commission (only IS-OIL)
& AFS Value-Added Services
KOAID Condition class KOAID CHAR 1 0
A Discount or surcharge
B Prices
C Expense reimbursement
D Taxes
E Extra pay
F Fees or differential (only IS-OIL)
G Tax Classification
H Determining sales deal
Q Totals record for fees (only IS-OIL)
W Wage Withholding Tax
KSCHL Condition type KSCHA CHAR 4 0
KSTAT Condition is used for statistics KSTAT CHAR 1 0
X Yes
NULL No
KVARC Condition for configuration KVARC CHAR 1 0
X Yes
NULL No
STUNR Step number STUNR NUMC 3 0
VARCOND Variant condition VARCOND CHAR 26 0
KWERT Condition value KWERT CURR 13 2
ZAEHK Condition counter DZAEHK NUMC 2 0
WAERK_VBAK SD Document Currency WAERK CUKY 5 0
SPARA Division for order header SPART_AK CHAR 2 0
VGTYP_AK Sales Document Category of Reference Doc. in Order Header MC_VBTYPAK 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
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
PERIV Fiscal Year Variant PERIV CHAR 2 0