I_OCMergeOption

DDL: I_OCMERGEOPT SQL: IOCMERGEOPT Type: view BASIC Package: APOC_OUTPUT_CONTROL_IMPL

Merge Option

I_OCMergeOption is a Basic CDS View that provides data about "Merge Option" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 6 fields with key fields domname, as4local, valpos, as4vers. It has 1 association to related views. Part of development package APOC_OUTPUT_CONTROL_IMPL.

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_OCMergeOptionText _Text $projection.domname = _Text.domname and $projection.as4local = _Text.as4local and $projection.valpos = _Text.valpos and $projection.as4vers = _Text.as4vers

Annotations (11)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY domname domname
KEY as4local as4local
KEY valpos valpos
KEY as4vers as4vers
MergeOption
_Text _Text
@AbapCatalog.sqlViewName: 'IOCMERGEOPT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
   usageType.serviceQuality: #A,
   usageType.sizeCategory: #S,
   usageType.dataClass: #META,
   resultSet.sizeCategory: #XS
}
@EndUserText.label: 'Merge Option'
define view I_OCMergeOption
  as select from dd07l
  association [0..*] to I_OCMergeOptionText as _Text on  $projection.domname  = _Text.domname
                                                     and $projection.as4local = _Text.as4local
                                                     and $projection.valpos   = _Text.valpos
                                                     and $projection.as4vers  = _Text.as4vers
{
      @UI.hidden: true
  key domname,
      @UI.hidden: true
  key as4local,  
      @UI.hidden: true
  key valpos,
      @UI.hidden: true
  key as4vers,  
  
      @ObjectModel.text.association: '_Text'
      substring(domvalue_l, 1, 1) as MergeOption,

  //Association

      _Text
} 
where domname  = 'APOC_MERGE_OPTIONS'
  and as4local = 'A'