DDCDS_FROMCLAUSE
DD: From clause of CDS Entity
DDCDS_FROMCLAUSE is an SAP database table in S/4HANA. DD: From clause of CDS Entity. It contains 11 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| DDCDS_BASE_OBJECTS | view_entity | union | Hierarchy of CDS VIEWS | |
| DDCDS_DIRECT_BASE_OBJECTS_V2 | view_entity | from | Get direct base objects for V2 Entity | |
| DDCDS_LIST_DIRECT_BASE_ENTITY | view_entity | from | List direct base entities | |
| DDCDS_RAP_TRANSACT_INTERFACES | view_entity | inner | ABAP Dictionary: Transactional Interface | |
| ddddls_viewstack_union | view_entity | union | Viewstack Union | |
| I_DIRECTBASEOBJECTS_V2CDS | view_entity | left_outer | CDS View Browser Direct Base Objects | |
| RSRTS_QF4_DirectBaseCDSViews | view | from | List direct base objects |
Fields (11)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | entity_name | dd_cds_entity_name | Entity Name | |||
| KEY | union_number | dd_union_number | Union Select Number | |||
| KEY | base_obj_alias | dd_cds_object_name | Object Name | |||
| KEY | base_obj_pos | ddfdpos | DD: Marked Position in a Repeat Group | |||
| KEY | parameter_name | dd_ddl_parameter | CDS Feature | |||
| KEY | parameter_component | dd_ddl_parameter_component | Feature Component | |||
| KEY | as4local | as4local | Activation State | |||
| parameter_value | dd_ddl_parameter_value | Feature Value | ||||
| base_obj_name | dd_cds_object_name | Object Name | ||||
| base_obj_type | dd_cds_object_type | Object Type | ||||
| parameter_component_name | dd_ddl_parameter | CDS Feature |
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.
-- DD: From clause of CDS Entity
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DDCDS_FROMCLAUSE (
ENTITY_NAME, -- Entity Name [dd_cds_entity_name]
UNION_NUMBER, -- Union Select Number [dd_union_number]
BASE_OBJ_ALIAS, -- Object Name [dd_cds_object_name]
BASE_OBJ_POS, -- DD: Marked Position in a Repeat Group [ddfdpos]
PARAMETER_NAME, -- CDS Feature [dd_ddl_parameter]
PARAMETER_COMPONENT, -- Feature Component [dd_ddl_parameter_component]
AS4LOCAL, -- Activation State [as4local]
PARAMETER_VALUE, -- Feature Value [dd_ddl_parameter_value]
BASE_OBJ_NAME, -- Object Name [dd_cds_object_name]
BASE_OBJ_TYPE, -- Object Type [dd_cds_object_type]
PARAMETER_COMPONENT_NAME, -- CDS Feature [dd_ddl_parameter]
PRIMARY KEY (ENTITY_NAME, UNION_NUMBER, BASE_OBJ_ALIAS, BASE_OBJ_POS, PARAMETER_NAME, PARAMETER_COMPONENT, AS4LOCAL)
);
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