I_OCMergeOptionText

DDL: I_OCMERGEOPTTXT SQL: IOCMERGEOPTTXT Type: view BASIC
8 Fields 1 Data Sources 2 Associations

Merge Option - Text

I_OCMergeOptionText is a Basic CDS View that provides data about "Merge Option - Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 8 fields with key fields domname, ddlanguage, as4local, valpos, as4vers. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_OCMergeOption _MergeOpt $projection.domname = _MergeOpt.domname and $projection.as4local = _MergeOpt.as4local and $projection.valpos = _MergeOpt.valpos and $projection.as4vers = _MergeOpt.as4vers
[0..1] I_Language _Language $projection.ddlanguage = _Language.Language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IOCMERGEOPTTXT view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
ObjectModel.dataCategory #TEXT view
ObjectModel.resultSet.sizeCategory #XS view
EndUserText.label Merge Option - Text view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY domname domname Domain
KEY ddlanguage ddlanguage Lang.
KEY as4local as4local Activation State
KEY valpos valpos Value key
KEY as4vers as4vers Version
MergeOptionText ddtext Short text
_MergeOpt _MergeOpt
_Language _Language

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_OCMergeOptionText.
-- 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: IOCMERGEOPTTXT

CREATE VIEW I_OCMergeOptionText AS
SELECT
  domname,
  ddlanguage,
  as4local,
  valpos,
  as4vers,
  ddtext AS MergeOptionText
FROM dd07t
LEFT OUTER JOIN I_OCMergeOption AS _MergeOpt ON domname = _MergeOpt.domname AND as4local = _MergeOpt.as4local AND valpos = _MergeOpt.valpos AND as4vers = _MergeOpt.as4vers  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON ddlanguage = _Language.Language  -- association [0..1]
;

Learn More