SAP table KONP (Conditions (Item))

SAP table KONP has 3 primary key fields being MANDT,KNUMH,KOPOS.

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
KNUMH Number of the Condition Record CHAR 10 0 KNUMH
KOPOS Sequential number of the condition NUMC 2 0 KOPOS
KAPPL Application CHAR 2 0 T681A KAPPL
KSCHL Condition Type CHAR 4 0 T685 KSCHA
KNUMT Number of texts CHAR 10 0 KNUMT
STFKZ Scale Type CHAR 1 0 STFKZ
can be maintained in condition record
A Base scale
B To-scale
C not used
D Graduated-to interval scale
KZBZG Scale Base Type CHAR 1 0 KZBZG
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 QUAN 15 3 KSTBM
KONMS Condition Scale Unit of Measure UNIT 3 0 T006 KONMS
KSTBW Scale Value CURR 15 2 KSTBW
KONWS Scale Currency CUKY 5 0 TCURC KONWS
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)
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
PRSCH Scale Group CHAR 4 0 SCLGR
KUMZA Numerator for converting condition units to base units DEC 5 0 KUMZA
KUMNE Denominator for converting condition units to base units DEC 5 0 KUMNE
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
MXWRT Lower limit of the condition rate/amount CURR 11 2 MXWRT
GKWRT Upper limit for the condition rate CURR 11 2 GKWRT
PKWRT Planned condition value CURR 15 2 PKWRT
FKWRT Cumulative guaranteed discount (not used) CURR 15 2 FKWRT
RSWRT Accumulated accruals values (not used) CURR 15 2 RSWRT
KWAEH Condition Currency (for Cumulation Fields) CUKY 5 0 TCURC KWAEH
UKBAS Planned condition basis CURR 15 2 UKBAS
KZNEP Condition exclusion indicator CHAR 1 0 T686A KZNEP
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
MWSK1 Tax on sales/purchases code CHAR 2 0 MWSKZ
LOEVM_KO Deletion Indicator for Condition Record CHAR 1 0 LOEVM_KO
ZAEHK_IND Condition item index NUMC 3 0 DZAEHK_IND
BOMAT Material for rebate settlement CHAR 40 0 MARA BOMAT
KBRUE Accrual Amount CURR 11 2 KBRUE
KSPAE Rebate was set up retroactively CHAR 1 0 KSPAE
BOSTA Condition Record Status (Rebate) CHAR 1 0 BOSTA_CR
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 Sales Promotion CHAR 10 0 KONA KNUMA_PI
KNUMA_AG Sales Deal CHAR 10 0 KONA KNUMA_AG
KNUMA_SQ Sales quote CHAR 10 0 KONA KNUMA_SQ
VALTG Additional Value Days NUMC 2 0 VALTG
VALDT Fixed Value Date DATS 8 0 VALDT
ZTERM Terms of payment key CHAR 4 0 DZTERM
ANZAUF Maximum number of sales orders per condition record NUMC 2 0 ANZAUF
01
MIKBAS Minimum condition base value QUAN 15 3 MIKBAS
MXKBAS Maximum condition base value QUAN 15 3 MXKBAS
KOMXWRT Maximum condition value CURR 13 2 KOMXWRT
KLF_STG Number of incremental scale NUMC 4 0 KLF_STG
KLF_KAL Scale number for pricing NUMC 4 0 KLF_KAL
VKKAL Sales Price Calculation: Relevant to Pricing CHAR 1 0 VKKAL
AKTNR Promotion CHAR 10 0 WAKTION
KNUMA_BO Agreement (subsequent settlement) CHAR 10 0 KONA KNUMA_BO
MWSK2 Withholding Tax Code CHAR 2 0 WT_WITHCD
VERTT Contract Type CHAR 1 0 RANTYP
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
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
VERTN Contract Number CHAR 13 0 RANL
VBEWA Flow Type CHAR 4 0 TZB0A SBEWART
MDFLG Indicator: Matrix Maintenance CHAR 1 0 MDFLG
Standard maintenance
1 Matrix maintenance: 1-dimensional
2 Matrix maintenance: 2-dimensional
3 Matrix maintenance: 3-dimensional
KFRST Release Status CHAR 1 0 KFRST
Released
A Blocked
B Released for pricing simulation
C Released for planning and pricing simulation
D In Review
E Rejected
UASTA Status of business volume comparison for a condition CHAR 1 0 UASTA
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
CNDN_CHGREASON Reason for Changing Condition Record CHAR 3 0 CNDN_CHG_REASON CNDN_CHGREASON

KONP foreign key relationships

Table Field Check Table Check Field
0 KONP BOMAT MARA General Material Data MANDT
0 KONP BOMAT MARA General Material Data MATNR
1 KONP CNDN_CHGREASON CNDN_CHG_REASON Reason for Changing Condition Record KAPPL
0 KONP KAPPL T681A Conditions: Applications KAPPL
1 KONP KMEIN T006 Units of Measurement MANDT
0 KONP KNUMA_AG KONA Agreements MANDT
0 KONP KNUMA_AG KONA Agreements KNUMA
1 KONP KNUMA_BO KONA Agreements MANDT
1 KONP KNUMA_BO KONA Agreements KNUMA
0 KONP KNUMA_PI KONA Agreements MANDT
0 KONP KNUMA_PI KONA Agreements KNUMA
1 KONP KNUMA_SQ KONA Agreements MANDT
1 KONP KNUMA_SQ KONA Agreements KNUMA
0 KONP KONMS T006 Units of Measurement MANDT
1 KONP KONWA TCURC Currency Codes MANDT
1 KONP KONWA TCURC Currency Codes WAERS
0 KONP KONWS TCURC Currency Codes MANDT
0 KONP KONWS TCURC Currency Codes WAERS
1 KONP KSCHL T685 Conditions: Types KAPPL
1 KONP KSCHL T685 Conditions: Types KSCHL
0 KONP KUNNR KNA1 General Data in Customer Master MANDT
0 KONP KUNNR KNA1 General Data in Customer Master KUNNR
1 KONP KWAEH TCURC Currency Codes MANDT
1 KONP KWAEH TCURC Currency Codes WAERS
0 KONP KZNEP T686A Conditions: Exclusion Indicator MANDT
0 KONP KZNEP T686A Conditions: Exclusion Indicator KAPPL
0 KONP KZNEP T686A Conditions: Exclusion Indicator KZNEP
1 KONP LIFNR LFA1 Supplier Master (General Section) MANDT
1 KONP LIFNR LFA1 Supplier Master (General Section) LIFNR
0 KONP MANDT T000 Clients MANDT
1 KONP MEINS T006 Units of Measurement MANDT
1 KONP MEINS T006 Units of Measurement MSEHI
0 KONP VBEWA TZB0A Definition of flow types MANDT
0 KONP VBEWA TZB0A Definition of flow types SBEWART