KONP

Transparent Table Application Table
62 Fields 31 CDS Views

Conditions (Item)

KONP is an SAP database table in S/4HANA. Conditions (Item). It contains 62 fields. 31 CDS views read from this table.

CDS Views using this table (31)

ViewTypeJoinVDMDescription
/dmbe/i_MM_Contract_Conditions view inner
CIC_CONDITIONS_PRICES view_entity from Proj.on Prices(Industry Cloud Solutions)
FAC_DART_Z3_TAX_LINEITEM_BKPF view left_outer Tax Line Item with BSTAT <> D/M
fcov_cost_rate_mig view inner Activity prices in ACCOSTRATE format
I_CmmdtyPrcgTmeDepdntLinkage view_entity inner BASIC CPE Time dependent condition linkage
I_CntrlPurContrItemCondition view inner BASIC Central Purchase Contract Condition Basic view
I_PricingConditionLinkage view_entity inner COMPOSITE CPE Pricing Condition Linkage
I_PurCtrCnd view inner BASIC Contract Conditions Header View
I_PurCtrCndItem view inner BASIC Contract Conditions Item View
I_PurCtrCond view inner BASIC Purchase Contract header Conditions
I_PurCtrCondItem view inner BASIC Purchase Contract Item Conditions
I_PurInfCndPeriod view inner BASIC CONDITONS VALIDITY
I_Schedgagrmthdrcnd view inner BASIC Scheduling Agreement Header Conditions
I_Schedgagrmtitmcnd view inner BASIC Scheduling Agreement Item Conditions
P_CndnContrConditionItem view from BASIC
P_CntrlPurContrHdrCndnValdty view inner BASIC
P_CntrlPurContrItmCndnVal view inner BASIC
P_CntrlPurContrItmCndValPlnt view inner BASIC
P_ConditionsItem view from BASIC
P_KSCHL_SETTLEMENT_VALUEHELP view inner BASIC
P_MaterialInfo view left_outer BASIC
P_PrcgCndnRecordItem view from BASIC
P_PurContrCndnItm view inner BASIC
P_PurContrHdrCndnValdty view inner BASIC
P_PurContrItmCndnValPlnt view inner BASIC
P_SchedgAgrmtCndnItm view inner BASIC
P_SPQItmConditionAmountDEX view_entity from BASIC Private Data Extraction For Amount of SPQ Item
P_SrcgProjQtnItemCondition view inner BASIC
P_SrcgProjQtnItmCndnValidity view_entity inner BASIC
P_SrcgProjQtnItmCndnVldtyPlnt view_entity inner BASIC
P_TH_TaxCodeRate view left_outer COMPOSITE

Fields (62)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY knumh KNUMH Cond.Record No.
KEY kopos KOPOS Sequent. No. of Cond
kappl KAPPL Application
kschl KSCHA Condition Type
knumt KNUMT Text number
stfkz STFKZ Scale Type
kzbzg KZBZG Scale Base Type
kstbm KSTBM Scale Quantity
konms KONMS Scale UoM
kstbw KSTBW Scale Value
konws KONWS Scale Currency
krech KRECH Calculat.Type
kbetr KBETR_KOND Amount
konwa KONWA Cond. Currency
kpein KPEIN Pricing Unit
kmein KMEIN Unit of Measure
prsch SCLGR Scale Group
kumza KUMZA Numer.for Conv.
kumne KUMNE Den. for Conv.
meins MEINS Base Unit
mxwrt MXWRT Lower limit
gkwrt GKWRT Upper limit
pkwrt PKWRT PlannedCondVal.
fkwrt FKWRT Cumulative value
rswrt RSWRT Cumulative accr
kwaeh KWAEH Cndn Currency
ukbas UKBAS Planned basis
kznep KZNEP Exclusion
kunnr KUNNR Customer
lifnr LIFNR Supplier
mwsk1 MWSKZ Tax Code
loevm_ko LOEVM_KO Deletion Indic.
zaehk_ind DZAEHK_IND Cond.Item Index
bomat BOMAT Matl f. settl.
kbrue KBRUE Accruals
kspae KSPAE Retroactive
bosta BOSTA_CR Cond.Rec Status
knuma_pi KNUMA_PI Promotion
knuma_ag KNUMA_AG Sales Deal
knuma_sq KNUMA_SQ Sales quote
valtg VALTG Add. Value Days
valdt VALDT Fixed Val. Date
zterm DZTERM Pyt Terms
anzauf ANZAUF NumberOfOrders
mikbas MIKBAS MinCondBaseVal.
mxkbas MXKBAS MaxCondBaseVal.
komxwrt KOMXWRT MaxConditValue
klf_stg KLF_STG Increment scale
klf_kal KLF_KAL Pricing scale
vkkal VKKAL Rel. to Pricing
aktnr WAKTION Promotion
knuma_bo KNUMA_BO Agreement
mwsk2 WT_WITHCD W/Tax Code
vertt RANTYP Contract Type
vertn RANL Contract Number
vbewa SBEWART Flow Type
mdflg MDFLG Matrix Maint.
kfrst KFRST Release Status
uasta UASTA Status BV c/a
cndn_chgreason CNDN_CHGREASON Cndn Change Reason
cmmdtyprcgcndnfmlauuid CPET_DOCITEMCOND_GUID Doc. Cond. Item GUID

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Conditions (Item)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KONP (
    MANDT,                   -- Client [MANDT]
    KNUMH,                   -- Cond.Record No. [KNUMH]
    KOPOS,                   -- Sequent. No. of Cond [KOPOS]
    KAPPL,                   -- Application [KAPPL]
    KSCHL,                   -- Condition Type [KSCHA]
    KNUMT,                   -- Text number [KNUMT]
    STFKZ,                   -- Scale Type [STFKZ]
    KZBZG,                   -- Scale Base Type [KZBZG]
    KSTBM,                   -- Scale Quantity [KSTBM]
    KONMS,                   -- Scale UoM [KONMS]
    KSTBW,                   -- Scale Value [KSTBW]
    KONWS,                   -- Scale Currency [KONWS]
    KRECH,                   -- Calculat.Type [KRECH]
    KBETR,                   -- Amount [KBETR_KOND]
    KONWA,                   -- Cond. Currency [KONWA]
    KPEIN,                   -- Pricing Unit [KPEIN]
    KMEIN,                   -- Unit of Measure [KMEIN]
    PRSCH,                   -- Scale Group [SCLGR]
    KUMZA,                   -- Numer.for Conv. [KUMZA]
    KUMNE,                   -- Den. for Conv. [KUMNE]
    MEINS,                   -- Base Unit [MEINS]
    MXWRT,                   -- Lower limit [MXWRT]
    GKWRT,                   -- Upper limit [GKWRT]
    PKWRT,                   -- PlannedCondVal. [PKWRT]
    FKWRT,                   -- Cumulative value [FKWRT]
    RSWRT,                   -- Cumulative accr [RSWRT]
    KWAEH,                   -- Cndn Currency [KWAEH]
    UKBAS,                   -- Planned basis [UKBAS]
    KZNEP,                   -- Exclusion [KZNEP]
    KUNNR,                   -- Customer [KUNNR]
    LIFNR,                   -- Supplier [LIFNR]
    MWSK1,                   -- Tax Code [MWSKZ]
    LOEVM_KO,                -- Deletion Indic. [LOEVM_KO]
    ZAEHK_IND,               -- Cond.Item Index [DZAEHK_IND]
    BOMAT,                   -- Matl f. settl. [BOMAT]
    KBRUE,                   -- Accruals [KBRUE]
    KSPAE,                   -- Retroactive [KSPAE]
    BOSTA,                   -- Cond.Rec Status [BOSTA_CR]
    KNUMA_PI,                -- Promotion [KNUMA_PI]
    KNUMA_AG,                -- Sales Deal [KNUMA_AG]
    KNUMA_SQ,                -- Sales quote [KNUMA_SQ]
    VALTG,                   -- Add. Value Days [VALTG]
    VALDT,                   -- Fixed Val. Date [VALDT]
    ZTERM,                   -- Pyt Terms [DZTERM]
    ANZAUF,                  -- NumberOfOrders [ANZAUF]
    MIKBAS,                  -- MinCondBaseVal. [MIKBAS]
    MXKBAS,                  -- MaxCondBaseVal. [MXKBAS]
    KOMXWRT,                 -- MaxConditValue [KOMXWRT]
    KLF_STG,                 -- Increment scale [KLF_STG]
    KLF_KAL,                 -- Pricing scale [KLF_KAL]
    VKKAL,                   -- Rel. to Pricing [VKKAL]
    AKTNR,                   -- Promotion [WAKTION]
    KNUMA_BO,                -- Agreement [KNUMA_BO]
    MWSK2,                   -- W/Tax Code [WT_WITHCD]
    VERTT,                   -- Contract Type [RANTYP]
    VERTN,                   -- Contract Number [RANL]
    VBEWA,                   -- Flow Type [SBEWART]
    MDFLG,                   -- Matrix Maint. [MDFLG]
    KFRST,                   -- Release Status [KFRST]
    UASTA,                   -- Status BV c/a [UASTA]
    CNDN_CHGREASON,          -- Cndn Change Reason [CNDN_CHGREASON]
    CMMDTYPRCGCNDNFMLAUUID,  -- Doc. Cond. Item GUID [CPET_DOCITEMCOND_GUID]
    PRIMARY KEY (MANDT, KNUMH, KOPOS)
);

Learn More