Atov_Pk_Package_With_Local

@AbapCatalog.sqlViewName: 'ATO_V_PK_PACK_WL'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Registered packages with local packages'
define view Atov_Pk_Package_With_Local as 

  select from ato_pk_package as Package
  {
    key Package.package_name, 
    Package.auto_transp_creation, 
    Package.auto_task_creation,
    Package.last_changed_by, 
    Package.last_changed_at
  }
    
  union 
  
  select from ato_setup as Setup
  {
    key Setup.local_package as package_name,
    '' as auto_transp_creation,
    '' as auto_task_creation,
    Setup.last_changed_by,
    Setup.last_changed_at
  }
  where Setup.local_package <> '';