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_BOE_VIEWSTACK_INFO_UNION | view | union | Union of dd26s and ddcds_fromclause data | |
| 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 | |
| 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