ANA_AQD_DERIVATION_PARAM

DDL: ANA_AQD_DERIVATION_PARAM SQL: ANA_AQD_DERIV_P Type: view
3 Fields 2 Data Sources

List of look up entities for parameters

ANA_AQD_DERIVATION_PARAM is a CDS View that provides data about "List of look up entities for parameters" in SAP S/4HANA. It reads from 2 data sources (ANA_AQD_ANNO_DERIVATION, ddheadanno) and exposes 3 fields.

Data Sources (2)

SourceAliasJoin Type
ANA_AQD_ANNO_DERIVATION _derivation from
ddheadanno a_ddheadanno left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ANA_AQD_DERIV_P view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label List of look up entities for parameters view

Fields (3)

KeyFieldSource TableSource FieldDescription
strucobjn ddheadanno strucobjn DD: Name of a structured object (e.g. entity, context)
name ddheadanno name Zone name
value ddheadanno value Value from table

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 ANA_AQD_DERIVATION_PARAM.
-- 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: ANA_AQD_DERIV_P

CREATE VIEW ANA_AQD_DERIVATION_PARAM AS
SELECT
  a_ddheadanno.strucobjn AS strucobjn,
  a_ddheadanno.name AS name,
  a_ddheadanno.value AS value
FROM ANA_AQD_ANNO_DERIVATION AS _derivation
LEFT OUTER JOIN ddheadanno AS a_ddheadanno ON /* join condition not captured in parsed metadata */
;

Learn More