APS_COM_CS_READ_CS_OIDC

DDL: APS_COM_CS_READ_CS_OIDC Type: view_entity Package: SR_APS_COM_PUB_ODATA_CS_READ
24 Fields 1 Data Sources 1 OData Services

Open ID Connect Provider

APS_COM_CS_READ_CS_OIDC is a CDS View that provides data about "Open ID Connect Provider" in SAP S/4HANA. It reads from 1 data source (aps_cs_d_oidc) and exposes 24 fields with key fields CommunicationSystemID, OIDCProviderID. It is exposed through 1 OData service (APS_COM_API_CS_READ). Part of development package SR_APS_COM_PUB_ODATA_CS_READ.

Data Sources (1)

SourceAliasJoin Type
aps_cs_d_oidc oidc from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Open ID Connect Provider view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

OData Services (1)

ServiceBindingVersionContractRelease
APS_COM_API_CS_READ APS_COM_API_CS_READ V4 C2 C1

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CommunicationSystemID cs commsyst System ID
KEY OIDCProviderID aps_cs_d_oidc db_key UUID
CsUUID aps_cs_d_oidc parent_key UUID
OidcEnabled aps_cs_d_oidc oidcenabled
OidcProvider aps_cs_d_oidc oidcprovider
OidcClientID aps_cs_d_oidc oidcclientid
OidcClientSecret aps_cs_d_oidc oidcclientsecret
OidcClientSecretUUID aps_cs_d_oidc oidcclientsecretuuid
OidcClientSslID aps_cs_d_oidc oidcclientsslid
OidcSslClientDep aps_cs_d_oidc oidcsslclientdep
OidcTokenEndPointUrl aps_cs_d_oidc oidctokenendpointurl
OidcAuthEndPointUrl aps_cs_d_oidc oidcauthendpointurl
OidcRedirectUrl aps_cs_d_oidc oidcredirecturl
OidcIDTokenMaxAge aps_cs_d_oidc oidcidtokenmaxage
OidcAuthMech aps_cs_d_oidc oidcauthmech
OidcModeBearer aps_cs_d_oidc oidcmodebearer
OidcModeInteractive aps_cs_d_oidc oidcmodeinteractive
OidcUserMapping aps_cs_d_oidc oidcusermapping
OidcUserMappingClaim aps_cs_d_oidc oidcusermappingclaim
OidcCustomClaim aps_cs_d_oidc oidccustomclaim
OidcCustomScope aps_cs_d_oidc oidccustomscope
OidcAudienceEval aps_cs_d_oidc oidcaudienceeval
OidcImportWebKeys aps_cs_d_oidc oidcimportwebkeys
OidcWebKeysUrl aps_cs_d_oidc oidcwebkeysurl

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view APS_COM_CS_READ_CS_OIDC.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW APS_COM_CS_READ_CS_OIDC AS
SELECT
  cs.commsyst AS CommunicationSystemID,
  oidc.db_key AS OIDCProviderID,
  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
FROM aps_cs_d_oidc AS oidc
;

Learn More