I_OTRText

DDL: I_OTRTEXT SQL: IOTRTEXT Type: view BASIC
6 Fields 1 Data Sources

OTR Text

I_OTRText is a Basic CDS View that provides data about "OTR Text" in SAP S/4HANA. It reads from 1 data source (sotr_text) and exposes 6 fields with key fields OnlnTxtRpstryConceptID, Language, OnlnTxtObjectID.

Data Sources (1)

SourceAliasJoin Type
sotr_text sotr_text from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName IOTRTEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label OTR Text view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY OnlnTxtRpstryConceptID concept Logical OTR ID
KEY Language langu Primary lang.
_Language _Language
KEY OnlnTxtObjectID object TRFM Object
OnlinePrimaryFlag flag_cntxt Indicator
Text text User Group

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 I_OTRText.
-- 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: IOTRTEXT

CREATE VIEW I_OTRText AS
SELECT
  concept AS OnlnTxtRpstryConceptID,
  langu AS Language,
  object AS OnlnTxtObjectID,
  flag_cntxt AS OnlinePrimaryFlag,
  Text
FROM sotr_text
;

Learn More