A_SitnDefTemplateActionText

DDL: A_SITNDEFTEMPLATEACTIONTEXT SQL: ASITNDEFTMPLACTT Type: view COMPOSITE
4 Fields 2 Data Sources

Situation Action for Sitn Tmpl - Text

A_SitnDefTemplateActionText is a Composite CDS View that provides data about "Situation Action for Sitn Tmpl - Text" in SAP S/4HANA. It reads from 2 data sources (I_SitnDefTemplateActionText, I_Language) and exposes 4 fields with key fields SitnActionID, Language.

Data Sources (2)

SourceAliasJoin Type
I_SitnDefTemplateActionText _ActionText from
I_Language _Language inner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ASITNDEFTMPLACTT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey SitnActionID view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Situation Action for Sitn Tmpl - Text view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SitnActionID I_SitnDefTemplateActionText SitnActionID Action ID
KEY Language I_SitnDefTemplateActionText LanguageISOCode Language ISO Code
SitnActionName I_SitnDefTemplateActionText SitnActionName Action Name
SitnActionDescription I_SitnDefTemplateActionText SitnActionDescription Description of Act

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 A_SitnDefTemplateActionText.
-- 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: ASITNDEFTMPLACTT

CREATE VIEW A_SitnDefTemplateActionText AS
SELECT
  _ActionText.SitnActionID AS SitnActionID,
  _ActionText.LanguageISOCode AS Language,
  _ActionText.SitnActionName AS SitnActionName,
  _ActionText.SitnActionDescription AS SitnActionDescription
FROM I_SitnDefTemplateActionText AS _ActionText
INNER JOIN I_Language AS _Language ON /* join condition not captured in parsed metadata */
;

Learn More