aps_iam_app_core

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'IAM: App - App Core View'

define view entity aps_iam_app_core
  as select distinct from aps_iam_w_app             as app

  // Remove AAV that are not in a migrated catalog (Internal system: ready for testing treated as finished)

    left outer join       aps_iam_w_bc_app          as bc_app on bc_app.app_id = app.app_id
    left outer join       aps_iam_w_bu_cat          as bc     on bc.bu_catalog_id = bc_app.bu_catalog_id
    left outer join       tadir                     as td     on  td.pgmid    = 'R3TR'
                                                              and td.object   = 'DEVC'
                                                              and td.obj_name = 'SR_APS_IAM_IAM_HOME'

  // Only show Scope Dependent Apps if they are in scope

    left outer join       aps_iam_c_app             as scope  on scope.app_id = app.app_id

  // Only show AAV if feature toggle is enabled

    inner join            p_aps_iam_feature_scope_c as toggl  on toggl.FeatureToggle = 'APS_IAM_APP_AS_ENTITY'
{
  key app.app_id                  as AppID,

      cast(
        app.read_only
      as boole_d preserving type) as ReadOnly,

      app.tcode                   as TransactionCode,
      app.ui_app_id               as UIAppID,

      app.change_timestamp        as ChangedOn,
      app.change_user             as ChangedBy,

      cast(
        app.forbid_use_with_successor
      as boole_d preserving type) as ForbiddenWithSuccessors,
      cast(
        app.no_direct_assignment
      as boole_d preserving type) as NoDirectAssignment,
      cast(
        app.exclude_start_auth
      as boole_d preserving type) as ExcludeStartAuthorization,

      app.app_type                as AppType,
      app.abap_language_version   as ABAPLanguageVersion,

      scope.scope_state           as ScopeState,
      app.scope_dependent         as ScopeDependent
}
where
  // In customer systems only show apps of type TRAN if they are assigned to a migrated Business Catalog

  // In internal systems show every app of type TRAN if they are assigned to any Business Catalog

  (
          app.app_type            <> 'TRAN'
    or    bc.app_migration_status =  '3'
    //    or(

    //          bc.app_migration_status =  '2'

    //      and td.obj_name             =  'SR_APS_IAM_HOME'

    //    )

    or(
          bc.bu_catalog_id        is not initial
      and td.obj_name             =  'SR_APS_IAM_IAM_HOME'
    )
  )
  // Only show scope dependent apps if they are in scope

  and(
          app.scope_dependent     <> 'X'
    or    scope.scope_state       <> '1'
  )
  // Only show apps of type TRAN if feature toggle is enabled

  and(
          app.app_type            <> 'TRAN'
    or    toggl.Status            =  'X'
  )