KONDD

Transparent Table Application Table

Material Substitution - Data Division

KONDD is an SAP database table in S/4HANA. Material Substitution - Data Division. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SlsMatlDeterminationRecord view_entity from BASIC Material Determination Condition Record

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY knumh knumh Cond.Record No.
smatn smatn Material
meins subme Unit of measure
sugrd sugrd_ms Reason
psdsp psdsp MRP indicator
kappl kappl Application
kschl kschd Mat.Determ.Type
datbi kodatbi Valid To
datab kodatab Valid From
conditiontable kotabnr_char Condition Table
upd_tmstmp timestampl Time Stamp
sdm_version sd_sdm_version_kondd

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.

-- Material Substitution - Data Division
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KONDD (
    MANDT,           -- Client [mandt]
    KNUMH,           -- Cond.Record No. [knumh]
    SMATN,           -- Material [smatn]
    MEINS,           -- Unit of measure [subme]
    SUGRD,           -- Reason [sugrd_ms]
    PSDSP,           -- MRP indicator [psdsp]
    KAPPL,           -- Application [kappl]
    KSCHL,           -- Mat.Determ.Type [kschd]
    DATBI,           -- Valid To [kodatbi]
    DATAB,           -- Valid From [kodatab]
    CONDITIONTABLE,  -- Condition Table [kotabnr_char]
    UPD_TMSTMP,      -- Time Stamp [timestampl]
    SDM_VERSION,     -- sd_sdm_version_kondd
    PRIMARY KEY (MANDT, KNUMH)
);