SAP table FKK_KONV_SHORT (Price Conditions for SD Billing Document - Extracts)

SAP table FKK_KONV_SHORT has 9 primary key fields being MANDT,BUKRS,GJAHR,OPBEL,VBELN,KNUMV,KPOSN,STUNR,ZAEHK.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BUKRS Company Code CHAR 4 0 BUKRS
GJAHR Posting year NUMC 4 0 GJAHR_KK
OPBEL Number of Contract Accts Rec. & Payable Doc. CHAR 12 0 SH_OPBEL_KK
VBELN Sales and Distribution Document Number CHAR 10 0 FKK_VBRK_SHORT VBELN
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
KPOSN Condition item number NUMC 6 0 KPOSN
STUNR Step Number NUMC 3 0 STUNR
ZAEHK Condition Counter NUMC 3 0 DZAEHK
KAPPL Application CHAR 2 0 KAPPL
KSCHL Condition Type CHAR 4 0 KSCHA
KDATU Condition Pricing Date DATS 8 0 KDATU
KRECH Calculation Type for Condition CHAR 1 0 KRECH
A Percentage
B Fixed Amount
C Quantity
D Gross Weight
E Net Weight
F Volume
G Formula
H Percentage (in Hundreds)
I Percentage (Travel Costs)
J Per Mille
K Per Mille (in Thousands)
L Points
M Quantity - Monthly Price
N Quantity - Year Price
O Quantity - Daily Price
P Quantity - Weekly Price
Q Commodity Price
R Distance-Dependent
S Number of Shipping Units
T Multi-Dimensional
U Percentage FIN (CRM Only)
V Quantity Adjustment
W Percentage (with 6 Decimal Places)
KAWRT Condition Basis CURR 15 2 KAWRT
KBETR Condition Amount or Percentage CURR 11 2 KBETR
WAERS Currency Key CUKY 5 0 WAERS
KKURS Condition exchange rate for conversion to local currency DEC 9 5 KKURS
KPEIN Condition Pricing Unit DEC 5 0 KPEIN
KMEIN Condition Unit UNIT 3 0 KMEIN
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
KSTAT Condition is used for statistics CHAR 1 0 KSTAT
KNUMH Number of the Condition Record CHAR 10 0 KNUMH
KOPOS Sequential number of the condition NUMC 2 0 KOPOS
SAKN1 G/L Account Number CHAR 10 0 SAKNR
MWSK1 Tax on sales/purchases code CHAR 2 0 MWSKZ
SAKN2 G/L Account Number CHAR 10 0 SAKNR
MWSK2 Withholding Tax Code CHAR 2 0 WT_WITHCD
KWERT Condition Value CURR 13 2 KWERT
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
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

FKK_KONV_SHORT foreign key relationships

Table Field Check Table Check Field
0 FKK_KONV_SHORT VBELN FKK_VBRK_SHORT Header Data for SD Billing Document - Extracts BUKRS
0 FKK_KONV_SHORT VBELN FKK_VBRK_SHORT Header Data for SD Billing Document - Extracts GJAHR
0 FKK_KONV_SHORT VBELN FKK_VBRK_SHORT Header Data for SD Billing Document - Extracts OPBEL
0 FKK_KONV_SHORT VBELN FKK_VBRK_SHORT Header Data for SD Billing Document - Extracts VBELN