ALL_CDS_VIEWS_TEXT

DDL: ALL_CDS_VIEWS_TEXT SQL: ALLCDSVIEWSTEXT Type: view Package: S_ANA_BEX_LAS

Label of all cds views

ALL_CDS_VIEWS_TEXT is a CDS View that provides data about "Label of all cds views" in SAP S/4HANA. It reads from 1 data source (ddddlsrc02bt) and exposes 3 fields with key fields DDLSourceName, Language, CDSName. Part of development package S_ANA_BEX_LAS.

Data Sources (1)

SourceAliasJoin Type
ddddlsrc02bt ddddlsrc02bt from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ALLCDSVIEWSTEXT view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Label of all cds views view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName ddlname DDL Source Name
KEY Language ddlanguage Lang.
KEY CDSName strucobjn DD: Name of a structured object (e.g. entity, context)

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 ALL_CDS_VIEWS_TEXT.
-- 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: ALLCDSVIEWSTEXT

CREATE VIEW ALL_CDS_VIEWS_TEXT AS
SELECT
  ddlname AS DDLSourceName,
  ddlanguage AS Language,
  strucobjn AS CDSName
FROM ddddlsrc02bt
;