IDEACTION_VIEW

DDL: IDEACTION_VIEW Type: view_entity

IDEACTION_VIEW is a CDS View in SAP S/4HANA. It reads from 2 data sources (saia_content_t, saia_content_t) and exposes 6 fields with key fields name, version.

Data Sources (2)

SourceAliasJoin Type
saia_content_t masterlang_content from
saia_content_t text_content left_outer

Parameters (2)

NameTypeDefault
langu syst_langu
state r3state

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY name content name Zone name
KEY version content version XML Vers.
masterlang tadir masterlang Single-Character Flag
language saia_content_t language Report Text Language
summary saia_content_t summary Summary
title saia_content_t title View Title

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 IDEACTION_VIEW.
-- 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.
-- Parameters: langu : syst_langu, state : r3state

CREATE VIEW IDEACTION_VIEW AS
SELECT
  content.name AS name,
  content.version AS version,
  tadir.masterlang AS masterlang,
  text_content.language AS language,
  text_content.summary AS summary,
  text_content.title AS title
FROM saia_content_t AS masterlang_content
LEFT OUTER JOIN saia_content_t AS text_content ON /* join condition not captured in parsed metadata */
;