DDLS_OSL_TEST_DATA

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'DDLS test data'
define root view entity DDLS_OSL_TEST_DATA as

  select distinct from tadir
    inner join         euobjedit     on tadir.object = euobjedit.tadir
    left outer join    wbobjecttypes on  tadir.object                  = wbobjecttypes.objecttype
                                     and wbobjecttypes.is_main_subtype = 'X'
{
  key tadir.obj_name   as object_name,
  key tadir.object     as object_type,
  tadir.author     as author,
  tadir.devclass   as devclass,
  tadir.created_on as created_on,
  tadir.masterlang as masterlang,
  tadir.srcsystem  as source_system,
  tadir.object     as alias_type,
  tadir.obj_name   as alias_name,
  '   '            as wb_type,
  tadir.genflag    as genflag,
  ' '              as use_alias,
  case when wbobjecttypes.wbobjectlist is initial
            or wbobjecttypes.objecttype = 'SUSH' // Authorization default values

       then 'X' else ''
  end              as is_virtual // X -> display in quicksearch but not in project explorer

}
where
      tadir.pgmid   =  'R3TR'
  and tadir.delflag <> 'X'
  // handled specially:

  and tadir.object  <> 'TABL' // Structures / Database Tables

  and tadir.object  <> 'PROG' // Programs / Includes

  and tadir.object  <> 'WDCC' // Web Dynpro Component Configurations

  and tadir.object  <> 'WDCA' // Web Dynpro Application Configurations / FPM Application Configurations

  and tadir.object  <> 'WDYA' // Web Dynpro Applications / FPM Applications

  and tadir.object  <> 'WDYN' // Web Dynpro

  and tadir.object  <> 'SPRX' // Enterprise Services

  and tadir.object  <> 'HOTA' // HANA repository objects (v1.0) / HDI Namespace (v2.0)

  and tadir.object  <> 'SHI3' // Generic hierarchal objects / area menus

  //  and tadir.object  <> 'ENHO' // Enhancement Objects

  // hidden:

  and tadir.object  <> 'SOTR' // OTR Short Texts

  and tadir.object  <> 'BMFR' // Application Components

  and tadir.object  <> 'SUSC' // Authorization Object Classes

  and tadir.object  <> 'SQAQ' // Implementation Questions

  //and tadir.object  <> 'SCP2' // Business Configuration Sets

  and tadir.object  <> 'AVAS' // Classifications

  and tadir.object  <> 'CASV' // Check Aspect Values

  and tadir.object  <> 'IAML' // Language-Dependent MIME Objects

  and tadir.object  <> 'IAMU' // Mime Objects

  and tadir.object  <> 'IATU' // HTML Templates / Flog Logic

  and tadir.object  <> 'SMIM' // MIME Objects

  and tadir.object  <> 'STOB' // CDS Entities

  and tadir.object  <> 'IWSV' // OData V2 Gateway Service / only for API state

  and tadir.object  <> 'G4BA' // Gateway Service Group / only for API state

  and tadir.object  <> 'APIS' // API State