TPLogsFileIDs

@AbapCatalog.sqlViewName: 'TPLOGS_FILE_IDS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CTS: log file letters of tp-steps'
define view TPLogsFileIDs
  as select from dd07l as dom_val
{
  key dom_val.valpos     as pos,
      dom_val.domvalue_l as value,

      case dom_val.domvalue_l
      //when 'e' then 'E'

        when 'f' then 'E'

        when 'm' then 'L'

        when 'w' then 'V'
        when 'W' then 'V'
      //when 'F' then 'V' // only trbatfunc


        when 'O' then 'N'
      //when 'Y' then 'N'

        when '8' then 'N'

        when 'J' then 'A'
      //when 'P' then '6'

      //when 'B' then 'X'


        else upper( dom_val.domvalue_l )
      end                as log_letter,

      case dom_val.domvalue_l
        when 'S' then 'DS' // DD distribution

      //when 'N' then 'N ' // DD conversion

      //when 'n' then 'N ' // DD conversion (mc/enq)

        when '6' then 'P ' // move nametabs

        when '<' then 'B ' // addtobuffer

      //when 'Q' then 'Q ' // feedback after export or import

        when 'g' then 'TC' // transmitbuffer/commitbuffer

        when 't' then 'TT' // tp connect

      //when '5' then '5'  // HANA Repository Deployment

      //when 'D' then 'D'  // Transfer Readables

        when 'I' then 'INDCHK'   // index check in exchange upgrade

        when 'E' then 'CUSTEXP'  // customer export in exchange upgrade

        when 'C' then 'DDCHECK'
        when 'X' then 'MODTADIR' // set TADIR-genflags in exchange upgrade

        when 'A' then 'VTRUMANA' // analyse POOL->TRANSP tables (RSVTRANA)

        when 'B' then 'VTRUMCRE' // create transparent tables for POOL->TRANSP (RSVTRCRE)

        else upper( dom_val.domvalue_l )
      end                as log_letter_all
}

where
      dom_val.domname  = 'TRTPSTEP'
  and dom_val.as4local = 'A'
  and dom_val.as4vers  = '0000'
// there is also 'trbatfunc', cf. RDDIMPDP