/SCMTMS/D_CONDDE
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 14 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_TransportationCondition | view_entity | from | BASIC | Transportation Condition |
Fields (14)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 |
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]
PRIMARY KEY (MANDT, CONDITION_ID, DB_KEY)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA