SAP table KONR (Resource Prices: Help Table for Variable Fields)

SAP table KONR has 9 primary key fields being MANDT,KOKRS,VERSN,GJAHR,RESRC,PGUAB,KSCHL,VARFLD001,VARFLD002.

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 T000 MANDT
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
VERSN Version CHAR 3 0 TKA07 VERSN
GJAHR Fiscal Year NUMC 4 0 GJAHR
RESRC Resource CHAR 10 0 CO_RESSOURCE
PGUAB Valid from period NUMC 3 0 PGUAB
KSCHL Condition Type CHAR 4 0 T685 KSCHL
VARFLD001 30 Characters CHAR 30 0 CHAR30
VARFLD002 30 Characters CHAR 30 0 CHAR30
VARFLD003 30 Characters CHAR 30 0 CHAR30
VARFLD004 30 Characters CHAR 30 0 CHAR30
VARFLD005 30 Characters CHAR 30 0 CHAR30
VARFLD006 30 Characters CHAR 30 0 CHAR30
VARFLD007 30 Characters CHAR 30 0 CHAR30
VARFLD008 30 Characters CHAR 30 0 CHAR30
VARFLD009 30 Characters CHAR 30 0 CHAR30
VARFLD010 30 Characters CHAR 30 0 CHAR30
KNUMH Number of the Condition Record CHAR 10 0 KNUMH
KAPPL Application CHAR 2 0 KAPPL
KVEWE Usage of the condition table CHAR 1 0 KVEWE
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)
KOZGF Access Sequence CHAR 4 0 KOZGF
KOLNR Access sequence - Access number NUMC 3 0 KOLNR
KOTABNR Number of the Condition Table CHAR 3 0 KOTABNR
KOTAB Condition table CHAR 30 0 KOTAB
KBETR Condition amount or percentage where no scale exists CURR 11 2 KBETR_KOND
KONWA Condition Unit (Currency or Percentage) CUKY 5 0 TCURC KONWA
KPEIN Condition Pricing Unit DEC 5 0 KPEIN
KMEIN Condition Unit UNIT 3 0 T006 KMEIN
KTEXT General Name CHAR 20 0 KTEXT

KONR foreign key relationships

Table Field Check Table Check Field
0 KONR KMEIN T006 Units of Measurement MANDT
1 KONR KOKRS TKA01 Controlling Areas MANDT
0 KONR KONWA TCURC Currency Codes MANDT
0 KONR KONWA TCURC Currency Codes WAERS
1 KONR KSCHL T685 Conditions: Types KAPPL
1 KONR KSCHL T685 Conditions: Types KSCHL
0 KONR MANDT T000 Clients MANDT
1 KONR VERSN TKA07 Fiscal-Year Dependent Version Parameters MANDT
1 KONR VERSN TKA07 Fiscal-Year Dependent Version Parameters KOKRS
1 KONR VERSN TKA07 Fiscal-Year Dependent Version Parameters VERSN
1 KONR VERSN TKA07 Fiscal-Year Dependent Version Parameters GJAHR