APS_COM_CS_D2_OIDC

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.
-- 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_COM_CS_OID_2

CREATE VIEW APS_COM_CS_D2_OIDC AS
SELECT
  Document.db_key AS db_key,
  Document.parent_key AS parent_key,
  Document.oidcenabled AS Oidcenabled,
  Document.oidcprovider AS Oidcprovider,
  Document.oidcclientid AS Oidcclientid,
  Document.oidcclientsecret AS Oidcclientsecret,
  Document.oidcclientsecretuuid AS Oidcclientsecretuuid,
  Document.oidcclientsslid AS Oidcclientsslid,
  Document.oidcsslclientdep AS Oidcsslclientdep,
  Document.oidctokenendpointurl AS Oidctokenendpointurl,
  Document.oidcauthendpointurl AS Oidcauthendpointurl,
  Document.oidcredirecturl AS Oidcredirecturl,
  Document.oidcidtokenmaxage AS OidcIdTokenMaxAge,
  Document.oidcauthmech AS Oidcauthmech,
  Document.oidcmodebearer AS Oidcmodebearer,
  Document.oidcmodeinteractive AS Oidcmodeinteractive,
  Document.oidcusermapping AS Oidcusermapping,
  Document.oidcusermappingclaim AS OidcUserMappingClaim,
  Document.oidccustomclaim AS OidcCustomClaim,
  Document.oidccustomscope AS OidcCustomScope,
  Document.oidcaudienceeval AS OidcAudienceEval,
  Document.oidcimportwebkeys AS Oidcimportwebkeys,
  Document.oidcwebkeysurl AS Oidcwebkeysurl,
  Document.creationdatetime AS Creationdatetime,
  Document.createdbyuser AS Createdbyuser,
  Document.lastchangedatetime AS Lastchangedatetime,
  Document.lastchangedbyuser AS Lastchangedbyuser
FROM aps_cs_d_oidc AS Document
LEFT OUTER JOIN Aps_Com_Cs_D2_Root AS _Root ON Document.parent_key = _Root.db_key  -- association [1..1]
LEFT OUTER JOIN APS_COM_CS_D2_OIDC_WB AS _WebKeys ON Document.db_key = _WebKeys.parent_key  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_D2_OIDC_AU AS _Audiences ON Document.db_key = _Audiences.parent_key  -- association [0..*]
;