SAP Table

KONP Conditions (Item)

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

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

/ Fields

KONP columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyKNUMH Number of the Condition Record CHAR 10 0 KNUMH
KeyKOPOS 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
KZBZG Scale Base Type CHAR 1 0 KZBZG
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
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
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
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
VERTN Contract Number CHAR 13 0 RANL
VBEWA Flow Type CHAR 4 0 TZB0A SBEWART
MDFLG Indicator: Matrix Maintenance CHAR 1 0 MDFLG
KFRST Release Status CHAR 1 0 KFRST
UASTA Status of business volume comparison for a condition CHAR 1 0 UASTA
CNDN_CHGREASON Reason for Changing Condition Record CHAR 3 0 CNDN_CHG_REASON CNDN_CHGREASON
/ Relationships

KONP foreign keys.

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