/SCMTMS/D_CONDDE

Transparent Table Customizing Table
18 Fields 1 CDS Views

BO Conditions: Root Node(Condition Header)

/SCMTMS/D_CONDDE is an SAP database table in S/4HANA. BO Conditions: Root Node(Condition Header). It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TransportationCondition view from BASIC Transportation Condition

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY condition_id /SCMTMS/CONDITION_ID Condition
KEY db_key /BOBF/CONF_KEY NodeID
cond_descr /SCMTMS/CONDITION_DESCRIPTION Description
condition_type /SCMTMS/CONDITION_TYPE Condition Type
condition_origin /SCMTMS/CONDITION_ORIGIN Origin of Condition
fdt_multiresult /SCMTMS/FDT_MULTIRESULT Result Is Structure
fdt_expr_guid /SCMTMS/FDT_EXPR_ID Universal Unique ID
fdt_appl_guid /SCMTMS/FDT_APPL_ID BRFplus Appl. GUID
fdt_func_guid /SCMTMS/FDT_FUNC_ID BRFplus Func. GUID
fdt_last_update /SCMTMS/DATETIME_CH Changed On/At
cond_inactive /SCMTMS/COND_INACTIVE Condition Inactive
entry_bo_key /SCMTMS/BO_KEY_WITH_NAME Business Object
entry_bo_node /SCMTMS/BO_NODE_KEY_WITH_NAME Business Object Node
created_by /BOFU/USER_ID_CREATED_BY Created By
created_on /BOFU/TSTMP_CREATION_TIME Created On
changed_by /BOFU/USER_ID_CHANGED_BY Changed By
changed_on /BOFU/TSTMP_CHANGED_TIME Changed On

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.

-- BO Conditions: Root Node(Condition Header)
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SCMTMS/D_CONDDE (
    MANDT,             -- Client [MANDT]
    CONDITION_ID,      -- Condition [/SCMTMS/CONDITION_ID]
    DB_KEY,            -- NodeID [/BOBF/CONF_KEY]
    COND_DESCR,        -- Description [/SCMTMS/CONDITION_DESCRIPTION]
    CONDITION_TYPE,    -- Condition Type [/SCMTMS/CONDITION_TYPE]
    CONDITION_ORIGIN,  -- Origin of Condition [/SCMTMS/CONDITION_ORIGIN]
    FDT_MULTIRESULT,   -- Result Is Structure [/SCMTMS/FDT_MULTIRESULT]
    FDT_EXPR_GUID,     -- Universal Unique ID [/SCMTMS/FDT_EXPR_ID]
    FDT_APPL_GUID,     -- BRFplus Appl. GUID [/SCMTMS/FDT_APPL_ID]
    FDT_FUNC_GUID,     -- BRFplus Func. GUID [/SCMTMS/FDT_FUNC_ID]
    FDT_LAST_UPDATE,   -- Changed On/At [/SCMTMS/DATETIME_CH]
    COND_INACTIVE,     -- Condition Inactive [/SCMTMS/COND_INACTIVE]
    ENTRY_BO_KEY,      -- Business Object [/SCMTMS/BO_KEY_WITH_NAME]
    ENTRY_BO_NODE,     -- Business Object Node [/SCMTMS/BO_NODE_KEY_WITH_NAME]
    CREATED_BY,        -- Created By [/BOFU/USER_ID_CREATED_BY]
    CREATED_ON,        -- Created On [/BOFU/TSTMP_CREATION_TIME]
    CHANGED_BY,        -- Changed By [/BOFU/USER_ID_CHANGED_BY]
    CHANGED_ON,        -- Changed On [/BOFU/TSTMP_CHANGED_TIME]
    PRIMARY KEY (MANDT, CONDITION_ID, DB_KEY)
);

Learn More