APS_COM_CS_READ_CS_OIDC

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Open ID Connect Provider'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity APS_COM_CS_READ_CS_OIDC
  as select from aps_cs_d_oidc as oidc
    join         aps_cs_d_root as cs on cs.db_key = oidc.parent_key
{
      @EndUserText: { label: 'Communication System ID', quickInfo: 'Communication System ID' }
  key cs.commsyst               as CommunicationSystemID,
      @EndUserText: { label: 'OpenID Connect Provider ID', quickInfo: 'OpenID Connect (OIDC) Provider ID' }
  key oidc.db_key               as OIDCProviderID,
      @EndUserText: { label: 'Communication System UUID', quickInfo: 'Communication System UUID' }
      oidc.parent_key           as CsUUID,
      oidc.oidcenabled          as OidcEnabled,
      oidc.oidcprovider         as OidcProvider,
      oidc.oidcclientid         as OidcClientID,
      oidc.oidcclientsecret     as OidcClientSecret,
      oidc.oidcclientsecretuuid as OidcClientSecretUUID,
      oidc.oidcclientsslid      as OidcClientSslID,
      oidc.oidcsslclientdep     as OidcSslClientDep,
      oidc.oidctokenendpointurl as OidcTokenEndPointUrl,
      oidc.oidcauthendpointurl  as OidcAuthEndPointUrl,
      oidc.oidcredirecturl      as OidcRedirectUrl,
      oidc.oidcidtokenmaxage    as OidcIDTokenMaxAge,
      oidc.oidcauthmech         as OidcAuthMech,
      oidc.oidcmodebearer       as OidcModeBearer,
      oidc.oidcmodeinteractive  as OidcModeInteractive,
      oidc.oidcusermapping      as OidcUserMapping,
      oidc.oidcusermappingclaim as OidcUserMappingClaim,
      oidc.oidccustomclaim      as OidcCustomClaim,
      oidc.oidccustomscope      as OidcCustomScope,
      oidc.oidcaudienceeval     as OidcAudienceEval,
      oidc.oidcimportwebkeys    as OidcImportWebKeys,
      oidc.oidcwebkeysurl       as OidcWebKeysUrl
      //  creationdatetime as Creationdatetime,

      //  createdbyuser as Createdbyuser,

      //  lastchangedatetime as Lastchangedatetime,

      //  lastchangedbyuser as Lastchangedbyuser

}
where
  (
       cs.commsysttype = '1'
    or cs.commsysttype = ''
  )
  and  cs.commsyst     not like 'SAP_%'