SAP table MC11VA0KON (Extraction SD Sales BW: Document Condition)

Field Description Data Type Length Decimals Checktable Data Element
ROCANCEL Indicator: Cancel Data Record CHAR 1 0 ROCANCEL
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
ABSTA Rejection Status (Item) CHAR 1 0 ABSTA_VB
POSNR Item number of the SD document NUMC 6 0 POSNR
UVPRS Pricing Incompletion Status (Item) CHAR 1 0 UVPRS_UP
AUART Sales Document Type CHAR 4 0 * AUART
AUGRU Order Reason (Reason for the Business Transaction) CHAR 3 0 * AUGRU
BUKRS Company Code CHAR 4 0 BUKRS
FAKSK Billing Block in SD Document CHAR 2 0 * FAKSK
HWAER Local Currency CUKY 5 0 * HWAER
KUNNR Sold-to Party CHAR 10 0 * KUNAG
KURST Exchange Rate Type CHAR 4 0 * KURST
KVGR1 Customer Group 1 CHAR 3 0 * KVGR1
KVGR2 Customer Group 2 CHAR 3 0 * KVGR2
KVGR3 Customer Group 3 CHAR 3 0 * KVGR3
KVGR4 Customer Group 4 CHAR 3 0 * KVGR4
KVGR5 Customer Group 5 CHAR 3 0 * KVGR5
STWAE Statistics Currency CUKY 5 0 * STWAE
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
VKBUR Sales office CHAR 4 0 * VKBUR
VKGRP Sales group CHAR 3 0 * VKGRP
VKORG Sales Organization CHAR 4 0 VKORG
VTWEG Distribution Channel CHAR 2 0 VTWEG
ABGRU Reason for Rejection of Sales Documents CHAR 2 0 * ABGRU_VA
AEDAT Last Changed On DATS 8 0 AEDAT
BWAPPLNM Application Component CHAR 30 0 RSAPPLNM
BWVORG SAP BW transaction key NUMC 3 0 MCW_BWVORG
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERZET Entry time TIMS 6 0 ERZET
FAKSP Billing Block for Item CHAR 2 0 * FAKSP_AP
KWMENG Cumulative order quantity in sales units QUAN 15 3 KWMENG
MATKL Material Group CHAR 9 0 MATKL
MATNR Material Number CHAR 40 0 MATNR
MATWA Material Entered CHAR 40 0 * MATWA
MVGR1 Material Group 1 CHAR 3 0 * MVGR1
MVGR2 Material Group 2 CHAR 3 0 * MVGR2
MVGR3 Material Group 3 CHAR 3 0 * MVGR3
MVGR4 Material Group 4 CHAR 3 0 * MVGR4
MVGR5 Material Group 5 CHAR 3 0 * MVGR5
PKUNRE Bill-to Party CHAR 10 0 * KUNRE
PKUNRG Payer CHAR 10 0 * KUNRG
PKUNWE Ship-to Party CHAR 10 0 * KUNWE
PRODH Product hierarchy CHAR 18 0 * PRODH_D
PSTYV Sales document item category CHAR 4 0 * PSTYV
PVRTNR Sales employee NUMC 8 0 VRTNR
SPART Division CHAR 2 0 SPART
STADAT Statistics date DATS 8 0 STADAT
STCUR Exchange rate for statistics (Exch.rate at time of creation) DEC 9 5 STCUR_AP
VRKME Sales unit UNIT 3 0 * VRKME
WAERK SD Document Currency CUKY 5 0 * WAERK
ZIEME Target Quantity UoM UNIT 3 0 * DZIEME
ZMENG Target Quantity in Sales Units QUAN 13 3 DZMENG
BZIRK Sales District CHAR 6 0 * BZIRK
FBUDA Date on which services are rendered DATS 8 0 FBUDA
FKDAT Billing Date DATS 8 0 FKDAT
INCO1 Incoterms (Part 1) CHAR 3 0 * INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
KDGRP Customer Group CHAR 2 0 * KDGRP
KTGRD Account Assignment Group for this Customer CHAR 2 0 * KTGRD
KURSK Exchange Rate for Price Determination DEC 9 5 KURSK
KURSK_DAT Translation date DATS 8 0 WWERT_D
PRSDT Date for Pricing and Exchange Rate DATS 8 0 PRSDT
WAKTION Promotion CHAR 10 0 * WAKTION
KAPPL Application CHAR 2 0 * KAPPL
KHERK Origin of the Condition CHAR 1 0 KHERK
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 CHAR 1 0 KINAK
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 formulas or incorrect
Y Inactive because of subsequent price
KNTYP Condition Category (Examples: Tax, Freight, Price, Cost) CHAR 1 0 KNTYP
$ TaxJurCode trigger (without license check KNVL)
& AFS Value-Added Services
+ 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
a Reserved (fixed extra pay)
B Delivery costs
b Transfer Price for Group Valuation
C Insurance
c Transfer price for profit centers
d Confirmed purchase net price/value
D Tax
E Cash discount
e Down payment request/down payment clearing
f Free goods - inclusive
F Freight
G Internal price
g Payment
H Basic price
h Profit Center Cost
I Price for intercompany billing
i Ship & Debit 1 (IBU HiTec)
J Customer expected price / customer value (excl.tax)
j Ship & Debit 2 (IBU HiTec)
K Base amount excluding tax
L Generally new when copying
l TP-ILV: Base Tarif That Covers Costs
M Sales tax w/license-checking (VAT)
m SSR Discount (only IS-Oil)
N Input Tax not Deductible
n Profit Center Internal Price (Route)
o AFS Season Determination
O Variants
P Base amount including tax
p SSR Partner Commission (only IS-OIL)
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
KOAID Condition Class CHAR 1 0 KOAID
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
P Compare Price Protection
Q Totals record for fees (only IS-OIL)
W Wage Withholding Tax
KSCHL Condition Type CHAR 4 0 * KSCHA
KSTAT Condition is used for statistics CHAR 1 0 KSTAT
KVARC Condition Used for Variant Configuration CHAR 1 0 KVARC
STUNR Step Number NUMC 3 0 * STUNR
VARCOND Variant Condition Key CHAR 26 0 * VARCOND
KWERT Condition Value CURR 13 2 KWERT
ZAEHK Condition Counter NUMC 3 0 DZAEHK
WAERK_VBAK SD Document Currency CUKY 5 0 WAERK
SPARA Division for order header CHAR 2 0 SPART_AK
VGTYP_AK Sales Document Category of Reference Doc. in Order Header CHAR 4 0 MC_VBTYPAK
PS_POSID Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
PERIV Fiscal Year Variant CHAR 2 0 PERIV