AQS_V3_SRVD_QUERIES_LIST

DDL: AQS_V3_SRVD_QUERIES_LIST Type: view_entity
4 Fields 2 Data Sources

List of custom and released queries

AQS_V3_SRVD_QUERIES_LIST is a CDS View that provides data about "List of custom and released queries" in SAP S/4HANA. It reads from 2 data sources (ddddlsrc, DDCDS_ENTITY_HEADER) and exposes 4 fields with key fields name, state.

Data Sources (2)

SourceAliasJoin Type
ddddlsrc _src inner
DDCDS_ENTITY_HEADER _v3List from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label List of custom and released queries view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY name DDCDS_ENTITY_HEADER entity_name Table Name
KEY state DDCDS_ENTITY_HEADER state Vehicle Region
description
SourceOrigin ddddlsrc source_origin Source Origin

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 AQS_V3_SRVD_QUERIES_LIST.
-- 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.

CREATE VIEW AQS_V3_SRVD_QUERIES_LIST AS
SELECT
  _v3List.entity_name AS name,
  _v3List.state AS state,
  ltrim(rtrim(_v3List.label_text, ''''),'''') AS description,
  _src.source_origin AS SourceOrigin
FROM DDCDS_ENTITY_HEADER AS _v3List
INNER JOIN ddddlsrc AS _src ON /* join condition not captured in parsed metadata */
;

Learn More