APS_COM_CS_D2_OIDC_WB

DDL: APS_COM_CS_D2_OIDC_WB SQL: APS_CS_OIDCWB Type: view Package: SR_APS_COM_CS

CS Draft 2.0 OIDC Webkeys View

APS_COM_CS_D2_OIDC_WB is a CDS View that provides data about "CS Draft 2.0 OIDC Webkeys View" in SAP S/4HANA. It reads from 1 data source (aps_cs_d_oidc_wb) and exposes 15 fields with key field db_key. It has 2 associations to related views. Part of development package SR_APS_COM_CS.

Data Sources (1)

SourceAliasJoin Type
aps_cs_d_oidc_wb Document from

Associations (2)

CardinalityTargetAliasCondition
[1..1] APS_COM_CS_D2_OIDC _Oidc $projection.parent_key = _Oidc.db_key
[1..1] Aps_Com_Cs_D2_Root _Root $projection.root_key = _Root.db_key

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName APS_CS_OIDCWB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CS Draft 2.0 OIDC Webkeys View view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY db_key aps_cs_d_oidc_wb db_key UUID
parent_key aps_cs_d_oidc_wb parent_key UUID
root_key aps_cs_d_oidc_wb root_key UUID
OidcWebKeyID aps_cs_d_oidc_wb oidcwebkeyid
OidcWebKeyRSAeB64 aps_cs_d_oidc_wb oidcwebkeyrsaeb64
OidcWebKeyRSAnB64 aps_cs_d_oidc_wb oidcwebkeyrsanb64
OidcWebKeyRSAe aps_cs_d_oidc_wb oidcwebkeyrsae
OidcWebKeyRSAn aps_cs_d_oidc_wb oidcwebkeyrsan
OidcWebKeyRSApem aps_cs_d_oidc_wb oidcwebkeyrsapem
Creationdatetime aps_cs_d_oidc_wb creationdatetime Timestamp
Createdbyuser aps_cs_d_oidc_wb createdbyuser User Name
Lastchangedatetime aps_cs_d_oidc_wb lastchangedatetime Timestamp
Lastchangedbyuser aps_cs_d_oidc_wb lastchangedbyuser User Name
_Oidc _Oidc
_Root _Root

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_D2_OIDC_WB.
-- 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.
-- SQL view name: APS_CS_OIDCWB

CREATE VIEW APS_COM_CS_D2_OIDC_WB AS
SELECT
  Document.db_key AS db_key,
  Document.parent_key AS parent_key,
  Document.root_key AS root_key,
  Document.oidcwebkeyid AS OidcWebKeyID,
  Document.oidcwebkeyrsaeb64 AS OidcWebKeyRSAeB64,
  Document.oidcwebkeyrsanb64 AS OidcWebKeyRSAnB64,
  Document.oidcwebkeyrsae AS OidcWebKeyRSAe,
  Document.oidcwebkeyrsan AS OidcWebKeyRSAn,
  Document.oidcwebkeyrsapem AS OidcWebKeyRSApem,
  Document.creationdatetime AS Creationdatetime,
  Document.createdbyuser AS Createdbyuser,
  Document.lastchangedatetime AS Lastchangedatetime,
  Document.lastchangedbyuser AS Lastchangedbyuser
FROM aps_cs_d_oidc_wb AS Document
LEFT OUTER JOIN APS_COM_CS_D2_OIDC AS _Oidc ON parent_key = _Oidc.db_key  -- association [1..1]
LEFT OUTER JOIN Aps_Com_Cs_D2_Root AS _Root ON root_key = _Root.db_key  -- association [1..1]
;