KONP

Transparent Table Application Table
61 Fields 26 CDS Views

Conditions (Item)

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

CDS Views using this table (26)

ViewTypeJoinVDMDescription
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_CntrlPurContrItemCondition view inner BASIC Central Purchase Contract Condition Basic view
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 Condition Item
P_CntrlPurContrHdrCndnValdty view inner BASIC Header Condition Validity
P_CntrlPurContrItmCndnVal view inner BASIC Central Contract Item Condition Validity
P_CntrlPurContrItmCndValPlnt view inner BASIC Central Contract Item plant dependent Condition Validity
P_ConditionsItem view from BASIC Private view to retrieve Conditions Item
P_KSCHL_SETTLEMENT_VALUEHELP view inner BASIC Value Help for Settlement Condition Type
P_MaterialInfo view left_outer BASIC Material Info Stock Champion
P_PrcgCndnRecordItem view from BASIC Condition Record Item for Pricing
P_PurContrCndnItm view inner BASIC Basic view for Contract Conditon Item
P_PurContrHdrCndnValdty view inner BASIC Purchase Contract Header Condition Validity
P_PurContrItmCndnValPlnt view inner BASIC Plant dependent condition view
P_SchedgAgrmtCndnItm view inner BASIC Condition Record Item
P_SrcgProjQtnItemCondition view inner BASIC Sourcing Project Item Condition
P_SrcgProjQtnItmCndnValidity view_entity inner BASIC Src Proj Qtn Item Condition Validity
P_SrcgProjQtnItmCndnVldtyPlnt view_entity inner BASIC SPQTN Item Condition Validity Plant
P_TH_TaxCodeRate view left_outer COMPOSITE Get all tax code configured in Thailand

Fields (61)

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

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]
    PRIMARY KEY (MANDT, KNUMH, KOPOS)
);

Learn More