ANA_AQD_DERIVATION_FILTER

DDL: ANA_AQD_DERIVATION_FILTER SQL: ANA_AQD_DERIV_F Type: view Package: RS_ANA_AQD_API
6 Fields 3 Data Sources

List of look up entities with filters

ANA_AQD_DERIVATION_FILTER is a CDS View that provides data about "List of look up entities with filters" in SAP S/4HANA. It reads from 3 data sources (ANA_AQD_ANNO_DERIVATION, ddheadanno, ddheadanno) and exposes 6 fields with key fields name, pos. Part of development package RS_ANA_AQD_API.

Data Sources (3)

SourceAliasJoin Type
ANA_AQD_ANNO_DERIVATION _der_filter left_outer
ddheadanno a_ddheadanno1 from
ddheadanno a_ddheadanno2 union

Parameters (2)

NameTypeDefault
p_field_name abap.char( 30 )
p_dim_name abap.char( 30 )

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ANA_AQD_DERIV_F view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label List of look up entities with filters view

Fields (6)

KeyFieldSource TableSource FieldDescription
strucobjn ddheadanno strucobjn DD: Name of a structured object (e.g. entity, context)
name ddheadanno name Zone name
pos ddheadanno position Test Position
KEY name name Zone name
KEY pos position Test Position
value 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_FILTER.
-- 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_F
-- Parameters: p_field_name : abap.char( 30 ), p_dim_name : abap.char( 30 )

CREATE VIEW ANA_AQD_DERIVATION_FILTER AS
SELECT
  a_ddheadanno1.strucobjn AS strucobjn,
  a_ddheadanno1.name AS name,
  a_ddheadanno1.position AS pos,
  value
FROM ddheadanno AS a_ddheadanno1
LEFT OUTER JOIN ANA_AQD_ANNO_DERIVATION AS _der_filter ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): ddheadanno
;

Learn More