I_OCMergeOptionText

DDL: I_OCMERGEOPTTXT SQL: IOCMERGEOPTTXT Type: view BASIC Package: APOC_OUTPUT_CONTROL_IMPL

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. Part of development package APOC_OUTPUT_CONTROL_IMPL.

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
KEY ddlanguage ddlanguage
KEY as4local as4local
KEY valpos valpos
KEY as4vers as4vers
MergeOptionText ddtext
_MergeOpt _MergeOpt
_Language _Language
@AbapCatalog.sqlViewName: 'IOCMERGEOPTTXT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Search.searchable: true
@ObjectModel: {
   usageType.serviceQuality: #A,
   usageType.sizeCategory: #S,
   usageType.dataClass: #META,
   dataCategory: #TEXT,
   resultSet.sizeCategory: #XS
}
@EndUserText.label: 'Merge Option - Text'
define view I_OCMergeOptionText
  as select from dd07t
  association [0..1] to I_OCMergeOption as _MergeOpt on  $projection.domname    = _MergeOpt.domname
                                                     and $projection.as4local   = _MergeOpt.as4local
                                                     and $projection.valpos     = _MergeOpt.valpos
                                                     and $projection.as4vers    = _MergeOpt.as4vers
  association [0..1] to I_Language      as _Language on  $projection.ddlanguage = _Language.Language
{
      @UI.hidden: true   
  key domname,
      @Semantics.language
      @ObjectModel.foreignKey.association: '_Language'
  key ddlanguage,
      @UI.hidden: true
  key as4local,
      @UI.hidden: true
  key valpos,
      @UI.hidden: true
  key as4vers,
         
      @Semantics.text
      @Search: { defaultSearchElement: true,
                 fuzzinessThreshold: 1,
                 ranking: #LOW
               }
      ddtext as MergeOptionText,

      //Association

      _MergeOpt,
      _Language
}
where domname  = 'APOC_MERGE_OPTIONS'
  and as4local = 'A'