SAP Table KONP

Conditions (Item)

KONP (Conditions (Item)) 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 KONP to other SAP tables.

KONP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KNUMH Condition record number KNUMH CHAR 10 0
KOPOS Sequential number of the condition KOPOS NUMC 2 0
KAPPL Application KAPPL T681A CHAR 2 0
KSCHL Condition type KSCHA T685 CHAR 4 0
KNUMT Number of texts KNUMT CHAR 10 0
STFKZ Scale Type STFKZ CHAR 1 0
NULL can be maintained in condition record
A Base-scale
B To-scale
C not used
D Graduated-to interval scale
KZBZG Scale basis indicator KZBZG CHAR 1 0
B Value scale
C Quantity scale
D Gross weight scale
E Net weight scale
F Volume scale
G Scale based on a formula
L Point scale
M Time period scale - Month
N Time period scale - Years
O Time period scale - Days
P Time period scale - Week
R Distance
S Number of shipping units
T reserved (IS-OIL, time prices)
X reserved (IS-OIL, day prices)
KSTBM Condition scale quantity KSTBM QUAN 15 3
KONMS Condition scale unit of measure KONMS T006 UNIT 3 0
KSTBW Scale value KSTBW CURR 15 2
KONWS Scale currency KONWS TCURC CUKY 5 0
KRECH Calculation type for condition KRECH CHAR 1 0
A Percentage
B Fixed amount
C Quantity
D Gross weight
E Net weight
F Volume
G Formula
H Percentage included
I Percentage (travel expenses)
K Per mille
J Per mille
L Points
M Quantity - monthy price
N Quantity - yearly 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)
KBETR Rate (condition amount or percentage) where no scale exists KBETR_KOND CURR 11 2
KONWA Rate unit (currency or percentage) KONWA TCURC CUKY 5 0
KPEIN Condition pricing unit KPEIN DEC 5 0
KMEIN Condition unit KMEIN T006 UNIT 3 0
PRSCH Scale Group SCLGR CHAR 4 0
KUMZA Numerator for converting condition units to base units KUMZA DEC 5 0
KUMNE Denominator for converting condition units to base units KUMNE DEC 5 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
MXWRT Lower limit of the condition rate/amount MXWRT CURR 11 2
GKWRT Upper limit for the condition rate GKWRT CURR 11 2
PKWRT Planned condition value PKWRT CURR 15 2
FKWRT Cumulative guaranteed discount (not used) FKWRT CURR 15 2
RSWRT Accumulated accruals values (not used) RSWRT CURR 15 2
KWAEH Condition currency (for cumulation fields) KWAEH TCURC CUKY 5 0
UKBAS Planned condition basis UKBAS CURR 15 2
KZNEP Condition exclusion indicator KZNEP T686A CHAR 1 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
MWSK1 Tax on sales/purchases code MWSKZ CHAR 2 0
LOEVM_KO Deletion Indicator for Condition Item LOEVM_KO CHAR 1 0
X Yes
NULL No
ZAEHK_IND Condition item index DZAEHK_IND NUMC 2 0
BOMAT Material for rebate settlement BOMAT MARA CHAR 18 0
KBRUE Accrual Amount KBRUE CURR 11 2
KSPAE Rebate was set up retroactively KSPAE CHAR 1 0
X Yes
NULL No
BOSTA Condition Record Status (Rebate) BOSTA_CR CHAR 1 0
NULL Open
A Settlement Is Being Checked for Release
B Agreement Released for Settlement
C Settlement Has Been Created
D Condition Record Is Settled
P Condition Record Settled, Other Periods Open
KNUMA_PI Promotion KNUMA_PI KONA CHAR 10 0
KNUMA_AG Sales deal KNUMA_AG KONA CHAR 10 0
KNUMA_SQ Sales quote KNUMA_SQ KONA CHAR 10 0
VALTG Additional value days VALTG NUMC 2 0
VALDT Fixed value date VALDT DATS 8 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ANZAUF Maximum number of sales orders per condition record ANZAUF NUMC 2 0
01
MIKBAS Minimum condition base value MIKBAS QUAN 15 3
MXKBAS Maximum condition base value MXKBAS QUAN 15 3
KOMXWRT Maximum condition value KOMXWRT CURR 13 2
KLF_STG Number of incremental scale KLF_STG NUMC 4 0
KLF_KAL Scale number for pricing KLF_KAL NUMC 4 0
VKKAL Sales Price Calculation: Relevant to pricing VKKAL CHAR 1 0
X Yes
NULL No
AKTNR Promotion WAKTION CHAR 10 0
KNUMA_BO Agreement (subsequent settlement) KNUMA_BO KONA CHAR 10 0
MWSK2 Withholding tax code WT_WITHCD CHAR 2 0
VERTT Contract Type RANTYP CHAR 1 0
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
VERTN Contract Number RANL CHAR 13 0
VBEWA Flow Type SBEWART TZB0A CHAR 4 0
MDFLG Indicator: Matrix maintenance MDFLG CHAR 1 0
NULL Standard maintenance
1 Matrix maintenance: 1-dimensional
2 Matrix maintenance: 2-dimensional
3 Matrix maintenance: 3-dimensional
KFRST Release status KFRST CHAR 1 0
NULL Released
A Blocked
B Released for pricing simulation
C Released for planning and pricing simulation
UASTA Status of business volume comparison for a condition UASTA CHAR 1 0
NULL Business volume comparison/agreement is not defined
A Bus. vol. compar./agreement optional and was not carried out
B Bus. vol. compar./agreement optional and already carried out
C Bus.vol. compar./agree. required and not yet carried out
D Bus.vol. compar./agree. required and already carried out
/BEV1/ECRTT Contract Type RANTYP CHAR 1 0
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
/BEV1/ECRTN Contract Number RANL CHAR 13 0
/BEV1/ECEWA Flow Type SBEWART CHAR 4 0
OICHDOCNUM SSR price change document number OIRC_CHDOCNUM CHAR 10 0
OIU_EP Exploration and Production condition (PRA) OIU_EP CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
OIU_DMGRV Deemed gravity to override observed gravity in gravity eval. OIU_DMGRV FLTP 16 16
OIU_DNTY Density type OIU_DENSTYP CHAR 1 0
1 API Gravity, Liquids
2 Relative Density (relative to water at standard conditions)
3 Density (absolute)
4 Relative Density (relative to air at standard conditions)
OIU_CLGRV Ceiling gravity to override gravity from transaction OIU_CLGRV FLTP 16 16
OIU_FLGRV Floor gravity to override gravity from transaction OIU_FLGRV FLTP 16 16
OIU_FLOOR Floor rate for formula pricing OIU_FLOOR CURR 11 2
OIU_PERF Condition pricing unit KPEIN DEC 5 0
OIU_CURF Currency for floor and ceiling rate OIU_CURR CUKY 5 0
OIU_UOMF Pricing UOM for floor rate OIU_UOMF UNIT 3 0
OIU_CEIL Ceiling rate for formula pricing OIU_CEIL CURR 11 2
OIU_PERC Condition pricing unit KPEIN DEC 5 0
OIU_CURC Currency for floor and ceiling rate OIU_CURR CUKY 5 0
OIU_UOMC Pricing UOM for ceiling rate OIU_UOMC UNIT 3 0

KONP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KONP BOMAT KONP MANDT MARA General Material Data MANDT
KONP BOMAT KONP BOMAT MARA General Material Data MATNR
KONP KAPPL KONP KAPPL T681A Conditions: Applications KAPPL
KONP KMEIN KONP MANDT T006 Units of Measurement MANDT
KONP KMEIN KONP KMEIN T006 Units of Measurement MSEHI
KONP KNUMA_AG KONP KNUMA_AG KONA Agreements KNUMA
KONP KNUMA_AG KONP MANDT KONA Agreements MANDT
KONP KNUMA_BO KONP MANDT KONA Agreements MANDT
KONP KNUMA_BO KONP KNUMA_BO KONA Agreements KNUMA
KONP KNUMA_PI KONP MANDT KONA Agreements MANDT
KONP KNUMA_PI KONP KNUMA_PI KONA Agreements KNUMA
KONP KNUMA_SQ KONP MANDT KONA Agreements MANDT
KONP KNUMA_SQ KONP KNUMA_SQ KONA Agreements KNUMA
KONP KONMS KONP MANDT T006 Units of Measurement MANDT
KONP KONMS KONP KONMS T006 Units of Measurement MSEHI
KONP KONWA KONP KONWA TCURC Currency Codes WAERS
KONP KONWA KONP MANDT TCURC Currency Codes MANDT
KONP KONWS KONP MANDT TCURC Currency Codes MANDT
KONP KONWS KONP KONWS TCURC Currency Codes WAERS
KONP KSCHL KONP KAPPL T685 Conditions: Types KAPPL
KONP KSCHL KONP KSCHL T685 Conditions: Types KSCHL
KONP KSCHL KONP MANDT T685 Conditions: Types MANDT
KONP KSCHL 'A' T685 Conditions: Types KVEWE
KONP KUNNR KONP MANDT KNA1 General Data in Customer Master MANDT
KONP KUNNR KONP KUNNR KNA1 General Data in Customer Master KUNNR
KONP KWAEH KONP MANDT TCURC Currency Codes MANDT
KONP KWAEH KONP KWAEH TCURC Currency Codes WAERS
KONP KZNEP KONP MANDT T686A Conditions: Exclusion Indicator MANDT
KONP KZNEP KONP KAPPL T686A Conditions: Exclusion Indicator KAPPL
KONP KZNEP KONP KZNEP T686A Conditions: Exclusion Indicator KZNEP
KONP LIFNR KONP MANDT LFA1 Vendor Master (General Section) MANDT
KONP LIFNR KONP LIFNR LFA1 Vendor Master (General Section) LIFNR
KONP MANDT KONP MANDT T000 Clients MANDT
KONP MEINS KONP MANDT T006 Units of Measurement MANDT
KONP MEINS KONP MEINS T006 Units of Measurement MSEHI
KONP VBEWA KONP MANDT TZB0A Definition of flow types MANDT
KONP VBEWA KONP VERTT TZB0A Definition of flow types RANTYP
KONP VBEWA KONP VBEWA TZB0A Definition of flow types SBEWART