SRF_RUVATReturnHelperRelevFlag

@AbapCatalog.sqlViewName: 'SRFRUVATHELPRLF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Helper for relevance flag'
@ObjectModel.usageType.serviceQuality: #P
define view SRF_RUVATReturnHelperRelevFlag
  with parameters
    rlvnc_flag_sect8  : abap.char( 1 ),
    rlvnc_flag_sect81 : abap.char( 1 ),
    rlvnc_flag_sect9  : abap.char( 1 ),
    rlvnc_flag_sect91 : abap.char( 1 ),
    rlvnc_flag_sect10 : abap.char( 1 ),
    rlvnc_flag_sect11 : abap.char( 1 ),
    rlvnc_flag_sect12 : abap.char( 1 ),
    phase             : abap.char( 5 )

  as select from I_SAPClient
{
  case :phase
    when 'STAND' then ''
    else LEFT( :rlvnc_flag_sect8, 1 )
  end as relevance_flag_sect8,

  case :phase
    when 'STAND' then ''
    else LEFT( :rlvnc_flag_sect81, 1 )
  end as relevance_flag_sect81,

  case :phase
    when 'STAND' then ''
    else LEFT( :rlvnc_flag_sect9, 1 )
  end as relevance_flag_sect9,

  case :phase
    when 'STAND' then ''
    else LEFT( :rlvnc_flag_sect91, 1 )
  end as relevance_flag_sect91,

  case :phase
    when 'STAND' then ''
    else LEFT( :rlvnc_flag_sect10, 1 )
  end as relevance_flag_sect10,

  case :phase
    when 'STAND' then ''
    else LEFT( :rlvnc_flag_sect11, 1 )
  end as relevance_flag_sect11,

  case :phase
    when 'STAND' then ''
    else LEFT( :rlvnc_flag_sect12, 1 )
  end as relevance_flag_sect12
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SAPCLIENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/