SOURCE_TYPE in DDDDLSRC
DD: Type of source - for example, extend, table function,... (DE: DD: Typ der Source z.B. Extend, Tabellenfunktion, ...)
SOURCE_TYPE is a field in SAP table DDDDLSRC (DDL Sources). It represents "DD: Type of source - for example, extend, table function,...". Data element: DDDDLSRCTYPE. Available in 79 CDS view(s) as SourceType, source_type, CDS_OBJECT_TYPE.
Business Meaning
| Description (EN) | DD: Type of source - for example, extend, table function,... |
|---|---|
| Beschreibung (DE) | DD: Typ der Source z.B. Extend, Tabellenfunktion, ... |
| Data Element | DDDDLSRCTYPE |
| Key Field | No |
CDS Views & Technical Names (79)
DDDDLSRC.SOURCE_TYPE is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
SourceType
(57 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /SSB/ALL_CDS_VIEWS | direct | All views including CDS 2.0 views | ||
| /SSB/ALL_VIEW_NAMES | direct | All views for SSB | ||
| /SSB/ANALYTICS_CDS1_LIST | direct | Fetches CDS 1.0 Analytical Queries | ||
| /SSB/ANALYTICS_CDS2_LIST | direct | Fetches CDS 2.0 Analytical Queries | ||
| /SSB/ANALYTICS_CDS3_LIST | direct | Fetches CDS 3.0 Analytical Queries | ||
| /SSB/CDS_2_VIEWS_INFO | direct | CDS 2.0 views information | ||
| Cds_Views | direct | List of All CDS Views | ||
| CDS_Views_Extension | direct | CDS Views with extension | ||
| Cds_Views_Extn | direct | List of All CDS Views | ||
| RSODP_ABAP_CDS_ODPNAME_ANNO | direct | Derive ODP Name | ||
| rsodp_abap_cds_odpname_cds | direct | Derive ODP Name | ||
| rsodp_abap_cds_odpname_sql | direct | Derive ODP Name from SQL View | ||
| VB_CDS_SQLVIEWNAME | direct | Getting sqlviewname for cds 2.0 cds | ||
| VB_CDS_SQLVIEWNAME_EXTENSION | direct | Getting sqlviewname for cds 2.0 cds | ||
| VB_CDS_SQLVIEWNAME_EXTN | direct | CDS SQL View Name with Extension | ||
| VB_CDS_VIEWS | direct | List of All CDS Views | ||
| VB_CDS_VIEWS_EXTN | direct | List of All CDS Views with view extn | ||
| /ssb/core_cds_Views | via 2 level | SSB: List of all CDS Views | ||
| /SSB/VIEW_RECO_RELEASED | via 2 level | Released view recommendation | ||
| /SSB/VIEW_RECOMMENDATION | via 2 level | Expose recent view for recommendation | ||
| Cds_Views_Info | via 2 level | List of All CDS Views with details | ||
| Cds_Views_Info_Extn | via 2 level | List of All CDS Views with details-Extn | ||
| DDIC_VFS_ACTIVE_TYPE | via 2 level | |||
| QB_CDS_DEFINITION_QUERY | via 2 level | CDS View Definition Query | ||
| VB_CORE_CDS_VIEWS | via 2 level | View Browser Core CDS Views | ||
| VB_CORE_CDS_VIEWS_EXTN | via 2 level | View Browser Core CDS Views | ||
| VB_PUBLIC_CDS_VIEWS_CE | via 2 level | List of All CDS Views | ||
| VB_PUBLIC_CDS_VIEWS_CE_EXTN | via 2 level | List of All CDS Views WITH EXTN | ||
| VB_PUBLIC_CDS_VIEWS_EXTN_CE | via 2 level | List of All CDS Views | ||
| VB_ALL_VIEWS_CE | via 3 levels | Views with statuses for cloud | ||
| VB_ALL_VIEWS_CE_EXTN | via 3 levels | Views with statuses for cloud | ||
| VB_ALL_VIEWS_EXTN_CE | via 3 levels | Views with statuses for cloud | ||
| VB_CDS_QUERY_DATAEXT_VIEWS | via 3 levels | View Browser CDS Views | ||
| VB_CDS_QUERY_VIEWS | via 3 levels | View Browser CDS Views | ||
| VB_CDS_QUERY_VIEWS_EXTN | via 3 levels | View Browser CDS Views | ||
| Vb_Core_Cdsviews | via 3 levels | View Browser Core CDS Views | ||
| Vb_Core_Cdsviews_Extn | via 3 levels | View Browser Core CDS Views With Extn | ||
| VB_BASIC_SEARCH_CDS_VIEWS | via 4 levels | CDS View for Basic Search on columns | ||
| VB_BASIC_SEARCH_DATAEXT_VIEWS | via 4 levels | CDS View for Basic Search on columns | ||
| VB_CDSVIEW_MAPPING | via 4 levels | CDS view for View Browser for mapping | ||
| VB_CDSVIEW_MAPPING_EXTN | via 4 levels | CDS views with Extension | ||
| VB_CDSVIEWS_DATAEXT_SEARCH_TAG | via 4 levels | View Browser CDS Views Tag Search | ||
| VB_CDSVIEWS_SEARCH_TAG | via 4 levels | View Browser CDS Views Tag Search | ||
| VB_CORE_CDS_VIEWS_CE | via 4 levels | View Browser Core CDS Views | ||
| VB_CORE_CDS_VIEWS_CE_EXTN | via 4 levels | View Browser Core CDS Views | ||
| VB_QUERY_VIEW_DETAILS | via 4 levels | View Browser CDS Views | ||
| VB_QUERY_VIEW_DETAILS_EXTN | via 4 levels | View Browser CDS Views | ||
| VB_FINAL_QUERY_CE | via 5 levels | Final CDS view | ||
| VB_FINAL_QUERY_DATAEXT_CE | via 5 levels | Final CDS view | ||
| VB_FINAL_QUERY_EXTN_CE | via 5 levels | Final CDS view | ||
| VB_BASIC_SEARCH_CDS_DATAEXT_CE | via 6 levels | Basic Search on columns for cloud | ||
| VB_BASIC_SEARCH_CDS_VIEWS_CE | via 6 levels | Basic Search on columns for cloud | ||
| VB_CDSVIEWS_DEXT_SEARCH_TAG_CE | via 6 levels | View Browser CDS Views Tag Search in CE | ||
| VB_CDSVIEWS_SEARCH_TAG_CE | via 6 levels | View Browser CDS Views Tag Search in CE | ||
| VB_QUERY_VIEW_DETAILS_CE | via 6 levels | Final CDS view | ||
| VB_VIEW_DETAILS_CE | via 6 levels | Final CDS view | ||
| VB_VIEW_DETAILS_EXTN_CE | via 6 levels | Final CDS view |
source_type
(8 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| DDIC_ACTIVE_TYPE | direct | |||
| dhadm_cds_all_entities | direct | All CDS Entities | ||
| DHADM_CDS_ENTITY_EXTENDS | direct | All CDS Entities | ||
| QB_CDS_VIEWS | direct | List of All CDS Views | ||
| QB_CDS_VIEWS_INFO | via 2 level | List of All CDS Views with details | ||
| QB_CORE_CDSVIEWS_U | via 3 levels | Que ry Browser Core CDS Views | ||
| Qb_Core_Cdsviews | via 4 levels | Query Browser Core CDS Views | ||
| QB_CDSVIEWS_FINAL_QUERY | via 5 levels | Query Browser CDS Views |
CDS_OBJECT_TYPE
(4 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| ddddls_viewstack_object_names | direct | |||
| DDL_OBJECT_NAMES | direct | Zuordnung der Namen eines CDS-Objekts | ||
| DDL_OBJECT_NAMES_COPY | direct | Zuordnung der Namen von DDL,Entität,DB_View,Extendbasisview | ||
| sdsh_ddl_obj_names | direct | List of all cds entities |
sub_object_type
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_DD_RUT_RC_OBJECT_SUB_TYPE | direct | ABAP Dictionary: List of Object Subtypes | ||
| I_DD_RUT_RC_RELEASED_OBJECTS | via 2 level | ABAP Dictionary: CDS View Released Obj |
ext_type
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_DD_RUT_RC_EXTEND_LIST | direct | Abap Dictionary: List of extends of released objects |
CDSViewType
(5 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| QB_SEARCH_REL_QUERY_TEXT | via 5 levels | QB Search on query texts | ||
| QB_SEARCH_RELEASED_QUERY | via 5 levels | QB Search on released Query | ||
| CDS_VIEW_SEARCH_PUBLISHED_CE | via 6 levels | Search for tags,tables on published view | ||
| Qb_Cdsviews_Query | via 6 levels | Query Browser CDS Views | ||
| Qb_Cdsviews_Query_Ce_Published | via 6 levels | Query Browser Published views |
dep_objtype
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| DDCDS_BOE_VIEWSTACK_INFO | via 2 level | View stack heirarchy using entity names | ||
| DDCDS_BOE_VIEWSTACK_INFO_UNION | via 2 level | Union of dd26s and ddcds_fromclause data |
baseobj_objtype
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| DDCDS_BOE_VIEWSTACK_INFO_UNION | via 2 level | Union of dd26s and ddcds_fromclause data |
tab_objtype
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| DDCDS_BOE_VIEWSTACK_INFO | via 2 level | View stack heirarchy using entity names |
Other Tables with Field SOURCE_TYPE (21)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /PRA/RU_OBR_OBS | /PRA/RU_OBS_SOURCE_TYPE | Observation Run Observations | |
| /SAPAPO/PSD | /SAPAPO/PSD_SOURCE_TYPE | S4PPDS: Product Storage Definition | |
| /SAPSLL/PRTCP | /SAPSLL/CLS_PRPSL_SOURCE_TYPE | Product Classification Proposal | |
| /SYCLO/PSH00 | /SYCLO/CORE_PUSH_SRCTYP_DTE | Push Scenario Definition | |
| /SYCLO/PSH01 | /SYCLO/CORE_PUSH_SRCTYP_DTE | Syclo Push Register | |
| /SYCLO/YPSH00 | /SYCLO/CORE_PUSH_SRCTYP_DTE | Push Scenario Definition - Custom Config | |
| CRMD_ICM_REL | CRM_ICM_REL_SRC_ENT_TYPE_ID | ICM Relationship: Relationship | |
| EDOCUMENT | EDOC_SOURCE_TYPE | eDocument | |
| EDOCUMENTHISTORY | EDOC_SOURCE_TYPE | eDocument: History | |
| EDOMAPCLASSDET1 | EDOC_SOURCE_TYPE | KEY | eDocument Mapping Class determination |
| EDOPROCSPINTDET1 | EDOC_SOURCE_TYPE | KEY | eDocument Process Step Interface determination |
| EDOPROCSTEPDET | EDOC_SOURCE_TYPE | KEY | eDocument Process Step determination |
| EDOSRCTYPE | EDOC_SOURCE_TYPE | KEY | eDocument: Source Type |
| EDOSRCTYPET | EDOC_SOURCE_TYPE | KEY | eDocument: Source Type Description |
| EHENVC_EXP_DS | EHENV_AMNS_SRC_TYPE | Data Selections with Source Types | |
| GHO_HIER_MAP | GHO_SOURCE_TYPE | KEY | Hierarchy Mapping |
| OIJ09_SCHEDSRC | OIJ09_SOURCE_TYPE | Scheduling Options | |
| PPH_DD_STPR_HDR | PPH_SOURCE_TYPE | Stock Level Proposal Header | |
| SEAI_TRACE | SEAI_TRACE_SOURCE_TYPE | EAI Conversation Message Trace | |
| SEAI_TRACE_STATS | SEAI_TRACE_SOURCE_TYPE | EAI Conversation Message Trace Statistic | |
| SRVC_SRC_DETAILS | SRVC_SRC_TYPE | Service Consumption Model Source Details |
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