KONH

Transparent Table Application Table
27 Fields 7 CDS Views

Conditions (Header)

KONH is an SAP database table in S/4HANA. Conditions (Header). It contains 27 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
fcov_cost_rate_mig view inner Activity prices in ACCOSTRATE format
P_CndnContrCndnRecdQtyScale view inner BASIC
P_CndnContrCndnRecdValueScale view inner BASIC
P_CndnContrConditionHeader view from BASIC
P_CndnContrConditionItem view inner BASIC
P_PrcgCndnRecordHeader view from BASIC
V_WB2_VBRK_VBRP_3 view inner Business Volume from Billing Document for Chargeback

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY knumh KNUMH Cond.Record No.
ernam ERNAM Created By
erdat ERDAT Created On
kvewe KVEWE Usage
kotabnr KOTABNR Table Number
kappl KAPPL Application
kschl KSCHA Condition Type
datab DATAB Valid From
datbi DATBI Valid To
kosrt KOSRT Search term
kzust KZUST Responsibility
knuma_pi KNUMA_PI Promotion
knuma_ag KNUMA_AG Sales Deal
knuma_sq KNUMA_SQ Sales quote
knuma_sd KNUMA_SD Std agrmnt
aktnr WAKTION Promotion
knuma_bo KNUMA_BO Agreement
licno LICNO License Number
licdt LICDT License Date
tkonn TKONN Trading Contract
ccnum WCB_COCO_NUM Condition Contract
external_guid EXT_COND_GUID External GUID
reference COND_REFERENCE Reference
priceapprovalrequest PRICEAPPROVALREQUEST Approval Request
knumh_prev_aprvd KNUMH_PREV_APRVD Cond.Record No.
upd_tmstmp TIMESTAMPL Time Stamp

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 (Header)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KONH (
    MANDT,                 -- Client [MANDT]
    KNUMH,                 -- Cond.Record No. [KNUMH]
    ERNAM,                 -- Created By [ERNAM]
    ERDAT,                 -- Created On [ERDAT]
    KVEWE,                 -- Usage [KVEWE]
    KOTABNR,               -- Table Number [KOTABNR]
    KAPPL,                 -- Application [KAPPL]
    KSCHL,                 -- Condition Type [KSCHA]
    DATAB,                 -- Valid From [DATAB]
    DATBI,                 -- Valid To [DATBI]
    KOSRT,                 -- Search term [KOSRT]
    KZUST,                 -- Responsibility [KZUST]
    KNUMA_PI,              -- Promotion [KNUMA_PI]
    KNUMA_AG,              -- Sales Deal [KNUMA_AG]
    KNUMA_SQ,              -- Sales quote [KNUMA_SQ]
    KNUMA_SD,              -- Std agrmnt [KNUMA_SD]
    AKTNR,                 -- Promotion [WAKTION]
    KNUMA_BO,              -- Agreement [KNUMA_BO]
    LICNO,                 -- License Number [LICNO]
    LICDT,                 -- License Date [LICDT]
    TKONN,                 -- Trading Contract [TKONN]
    CCNUM,                 -- Condition Contract [WCB_COCO_NUM]
    EXTERNAL_GUID,         -- External GUID [EXT_COND_GUID]
    REFERENCE,             -- Reference [COND_REFERENCE]
    PRICEAPPROVALREQUEST,  -- Approval Request [PRICEAPPROVALREQUEST]
    KNUMH_PREV_APRVD,      -- Cond.Record No. [KNUMH_PREV_APRVD]
    UPD_TMSTMP,            -- Time Stamp [TIMESTAMPL]
    PRIMARY KEY (MANDT, KNUMH)
);

Learn More