RSRTS_QF4_DirectBaseCDSViews

DDL: RSRTS_QF4_DIRECTBASECDSVIEWS SQL: RSRTS_QF4_DBCDSV Type: view

List direct base objects

RSRTS_QF4_DirectBaseCDSViews is a CDS View that provides data about "List direct base objects" in SAP S/4HANA. It reads from 10 data sources and exposes 1 field with key field entity_name.

Data Sources (10)

SourceAliasJoin Type
ddldependency _from_cds inner
ddldependency _from_sql inner
dd2526v dd2526v inner
dd2526v dd2526v inner
ddcds_fromclause from_clause from
ddldependency stob_dep union
ddldependency stob_dep union
ddldependency stob_dep_dbo inner
ddldependency view_dep inner
ddldependency view_dep inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName RSRTS_QF4_DBCDSV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label List direct base objects view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY entity_name ddcds_fromclause entity_name Entity Name Upper Case

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view RSRTS_QF4_DirectBaseCDSViews.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: RSRTS_QF4_DBCDSV

CREATE VIEW RSRTS_QF4_DirectBaseCDSViews AS
SELECT
  from_clause.entity_name AS entity_name
FROM ddcds_fromclause AS from_clause
INNER JOIN ddldependency AS view_dep ON /* join condition not captured in parsed metadata */
INNER JOIN dd2526v ON /* join condition not captured in parsed metadata */
INNER JOIN ddldependency AS _from_sql ON /* join condition not captured in parsed metadata */
INNER JOIN ddldependency AS _from_cds ON /* join condition not captured in parsed metadata */
INNER JOIN ddldependency AS stob_dep_dbo ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): ddldependency
;