DDDDLSRC
DDL Sources
DDDDLSRC is an SAP database table in S/4HANA. DDL Sources. It contains 12 fields. 101 CDS views read from this table.
CDS Views using this table (101)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /SSB/ALL_CDS_VIEWS | view | union_all | All views including CDS 2.0 views | |
| /SSB/ALL_VIEW_NAMES | view | union_all | All views for SSB | |
| /SSB/ANALYTICS_CDS1_LIST | view | from | Fetches CDS 1.0 Analytical Queries | |
| /SSB/ANALYTICS_CDS2_LIST | view | from | Fetches CDS 2.0 Analytical Queries | |
| /SSB/ANALYTICS_CDS3_LIST | view | from | Fetches CDS 3.0 Analytical Queries | |
| /SSB/CDS_2_VIEWS_INFO | view | from | CDS 2.0 views information | |
| /ssb/cds_Views | view | from | SSB: List of all CDS Views | |
| ACM_DDLSSTOBVIEW_1ROW_CDSV | view | from | ||
| ALL_CDS_VIEWS | view | from | List of all cds views | |
| ANA_AQD_C_QUERIES | view | from | List of custom analytical queries | |
| ANA_AQD_C_QUERIES_WITH_FILTER | view | from | List of filtered custom queries | |
| ANA_AQD_RELEASED_QUERIES | view | inner | List of released queries | |
| ANA_AQD_V_USER_DESC | view | from | Get User Description for Last Changed By | |
| APS_V_CKE_DDL_DATE_TIME | view | from | last change date and time of the DDL | |
| APS_V_CKE_USAGES_BY_CUST_VIEWS | view | inner | List of views which are used by custom CDS Views | |
| APS_V_GKE_CDS_C1_VH | view | inner | Value help for C1 views | |
| APS_V_GKE_VIEW_LIST_DRAFT | view | left_outer | List of draft Custom CDS views | |
| APS_V_GKE_VIEW_LIST_RELEASED | view | inner | List of released CDS views) | |
| APS_V_GKE_VIEW_LIST_RELEASED | view | left_outer | List of released CDS views) | |
| APS_V_RCV_CDS_LIST | view | from | Get CDS Views List | |
| AQS_QUERIES_LIST | view_entity | from | List of custom and released queries | |
| AQS_V_USER_DESC | view_entity | from | Get User Description for Last Changed By | |
| AQS_V3_QUERIES_LIST | view_entity | left_outer | List of custom and released queries | |
| AQS_V3_SRVD_QUERIES_LIST | view_entity | inner | List of custom and released queries | |
| ars_demo_cdsviews_c1 | view | inner | Demo: CDS Views Released for C1 | |
| ars_demo_cdsviews_c2 | view | inner | Demo: CDS Views Released for C2 | |
| ars_demo_cdsviews_same_group | view | inner | Demo: CDS Views Released for Same Group | |
| C_ABI_Analytical_Query | view_entity | from | CONSUMPTION | Analytical Query List |
| Cds_Field_Annotation_Query | view | from | CDS Field Annotations Query | |
| CDS_REPAIR_SEARCH_HELP | view_entity | from | View for F4 Search Help for CDS_REPAIR | |
| Cds_View_All | view | from | All CDS Views with Analytic/Non-Analytic categorization | |
| Cds_View_Cubes | view | from | All Analytical Cubes | |
| CDS_VIEW_NONCUBES | view | from | All Analytical Non-Cubes | |
| Cds_Views | view | union_all | List of All CDS Views | |
| CDS_Views_Extension | view | union_all | CDS Views with extension | |
| Cds_Views_Extn | view | union_all | List of All CDS Views | |
| CSN_EXPOSURE_CDS | view | inner | CSN Entities | |
| CSN_EXPOSURE_CDS_DEFAULT_FT | view | inner | CSN Entities with feature flag | |
| CSN_EXPOSURE_CDS_DEFAULT_NFT | view | inner | CSN Entities with no feature flag | |
| CSRV_MAPPED_ITEMS | view_entity | left_outer | Service Binding Mapped Items List | |
| CSRV_SS_MAPPED_ITEMS | view_entity | left_outer | Service Binding Mapped Items List | |
| DDCDS_BOE_HIERARCHY_TOP | view_entity | left_outer | asdf | |
| DDCDS_BOE_OBJINFO_PROCESSING_2 | view | left_outer | Compilation of all object info | |
| ddcds_ddlsource | view_entity | from | DDL Sources | |
| ddcds_ddlsource | view_entity | inner | DDL Sources | |
| ddcds_ddlsource | view_entity | union_all | DDL Sources | |
| DDCDS_ENTITY_HEADER | view_entity | inner | CDS Entities: Header Information | |
| DDCDS_LANG_VRS_OBJ_ACTIVE_DDLS | view_entity | from | DDLS: ABAP Language Version of Active Objects | |
| DDCDS_LANG_VRS_OBJ_EDIT_DDLS | view_entity | from | DDLS: ABAP Language Version of Edited Objects | |
| ddcds_table_entity_4_sddic_chk | view_entity | from | Returns all act TABLE ENTITY f SDDIC chk | |
| ddddls_viewstack_object_names | view_entity | from | ||
| DDIC_ACTIVE_TYPE | view_entity | from | ||
| DDIC_COUNT | view_entity | from | ||
| DDL_OBJECT_NAMES | view_entity | from | Zuordnung der Namen eines CDS-Objekts | |
| DDL_OBJECT_NAMES_COPY | view | from | Zuordnung der Namen von DDL,Entität,DB_View,Extendbasisview | |
| dhadm_cds_all_ddic_obj | view_entity | from | All Tables, Views and Data Definitions | |
| dhadm_cds_all_entities | view_entity | from | All CDS Entities | |
| DHADM_CDS_ENTITY_EXTENDS | view_entity | from | All CDS Entities | |
| DHAMB_BASE_DP_CDS_NODES | view_entity | inner | DI meta data browser: list of CDS views | |
| I_CAQS_VIEW_ROOT | view_entity | left_outer | Custom Query View Root Entity | |
| I_CCV_DATASOURCE_HELPER | view_entity | inner | Custom CDS View Datasource Helper | |
| I_CCV_DataSource_VH_1 | view_entity | inner | CCV Datasource VH primary || associated | |
| I_CCV_NOT_MIGRATED | view_entity | inner | View for not migrated Custom CDS Views | |
| I_CCV_USAGES_BY_CCV | view | inner | CCV Rework - Views which are used by CCV | |
| I_CustomCDSViewDatasource_VH | view_entity | inner | BASIC | List of released CDS views |
| I_DD_RUT_RC_EXTEND_LIST | view_entity | inner | Abap Dictionary: List of extends of released objects | |
| I_DD_RUT_RC_OBJECT_SUB_TYPE | view_entity | inner | ABAP Dictionary: List of Object Subtypes | |
| I_DSP_DRAFT_ENTITY_TYPE | view_entity | inner | DSP: Draft Entity Type | |
| I_DSP_MY_DRAFTS_BASE | view_entity | inner | DSP: My drafts base | |
| I_EntSrchCDSModelOther | view | from | BASIC | Enterprise Search models not created from Search Modeler |
| I_ReviewBookletDataSource | view_entity | left_outer | COMPOSITE | Review Booklet Data Source |
| P_CDSVIEWATTR | view | from | BASIC | |
| P_Cfd_Associable_Cds_View | view_entity | inner | Associable CDS Views | |
| P_Ddddlssrc | view | from | BASIC | |
| P_ISLM2_RELEASED_CDS | view_entity | inner | List of released CDS views | |
| PDdddlssrc | view | from | BASIC | |
| QB_CDS_VIEWS | view | from | List of All CDS Views | |
| QB_CDSVIEWS_COUNT_FINAL_QUERY | view | union_all | Final Count of Query | |
| QB_V2_V3_QUERY | view | from | Get direct base objects | |
| R_Sitn2ObjStructureCDSVH | view_entity | inner | COMPOSITE | Situation Object Structure |
| R_Sitn2ObjStructureCDSVH | view_entity | union | COMPOSITE | Situation Object Structure |
| ris_ddl_tadir | view | from | DDL Sources and TADIR information | |
| RS_P_ANA_UMM2_RELEASED_CDS | view | inner | List of released CDS views | |
| RSODP_ABAP_CDS_ODPNAME_ANNO | view_entity | from | Derive ODP Name | |
| rsodp_abap_cds_odpname_cds | view_entity | from | Derive ODP Name | |
| rsodp_abap_cds_odpname_cds | view_entity | union_all | Derive ODP Name | |
| rsodp_abap_cds_odpname_sql | view_entity | from | Derive ODP Name from SQL View | |
| sdsh_ddl_obj_names | view | from | List of all cds entities | |
| SSCH_CMS_CDS_FT | view | inner | CDS Entities with Feature Toggle | |
| SSCH_CMS_CDS_NFT | view | inner | CDS Entities without Feature Toggle | |
| VB_CDS_SQLVIEWNAME | view | from | Getting sqlviewname for cds 2.0 cds | |
| VB_CDS_SQLVIEWNAME | view | union_all | Getting sqlviewname for cds 2.0 cds | |
| VB_CDS_SQLVIEWNAME_EXTENSION | view | from | Getting sqlviewname for cds 2.0 cds | |
| VB_CDS_SQLVIEWNAME_EXTENSION | view | union_all | Getting sqlviewname for cds 2.0 cds | |
| VB_CDS_SQLVIEWNAME_EXTN | view | from | CDS SQL View Name with Extension | |
| VB_CDS_SQLVIEWNAME_EXTN | view | union_all | CDS SQL View Name with Extension | |
| VB_CDS_VIEWS | view | from | List of All CDS Views | |
| VB_CDS_VIEWS | view | union_all | List of All CDS Views | |
| VB_CDS_VIEWS_EXTN | view | from | List of All CDS Views with view extn | |
| VB_CDS_VIEWS_EXTN | view | union_all | List of All CDS Views with view extn | |
| VB_DEPRECATED_STATUS | view | from | Views with statuses for cloud |
Fields (12)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | ddlname | DDLNAME | DDL Source Name | |||
| KEY | as4local | AS4LOCAL | Activation State | |||
| as4user | AS4USER | Last Changed By | ||||
| as4date | AS4DATE | Date | ||||
| as4time | AS4TIME | Time | ||||
| source | DDDDLSOURCE | DDL Source | ||||
| parentname | DDLPARENT | Source Parent | ||||
| actflag | DDACTFLAG | DD: Flag for required actions | ||||
| chgflag | DDCHGFLAG | DD: What changes have been made | ||||
| source_type | DDDDLSRCTYPE | DD: Type of source - for example, extend, table function,... | ||||
| source_origin | DDDDLSRCORIGIN | DD: Editor from which the DDL source was generated | ||||
| abap_language_version | ABAP_LANGUAGE_VERSION | Language Version |
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.
-- DDL Sources
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DDDDLSRC (
DDLNAME, -- DDL Source Name [DDLNAME]
AS4LOCAL, -- Activation State [AS4LOCAL]
AS4USER, -- Last Changed By [AS4USER]
AS4DATE, -- Date [AS4DATE]
AS4TIME, -- Time [AS4TIME]
SOURCE, -- DDL Source [DDDDLSOURCE]
PARENTNAME, -- Source Parent [DDLPARENT]
ACTFLAG, -- DD: Flag for required actions [DDACTFLAG]
CHGFLAG, -- DD: What changes have been made [DDCHGFLAG]
SOURCE_TYPE, -- DD: Type of source - for example, extend, table function,... [DDDDLSRCTYPE]
SOURCE_ORIGIN, -- DD: Editor from which the DDL source was generated [DDDDLSRCORIGIN]
ABAP_LANGUAGE_VERSION, -- Language Version [ABAP_LANGUAGE_VERSION]
PRIMARY KEY (DDLNAME, 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