APS_COM_CS_D2_OIDC_C

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_C.
-- 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_OID_C_2

CREATE VIEW APS_COM_CS_D2_OIDC_C 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,
  cast('' as boole_d ) AS OIDCClientSecretIsProductive,
  cast('' as abap.sstring( 1000 )) AS OIDCRedirectURLProposal
FROM APS_COM_CS_D2_OIDC_TP AS Document
LEFT OUTER JOIN Aps_Com_Cs_D2_Root_C AS _Root ON _Root.db_key = parent_key  -- association [1..1]
LEFT OUTER JOIN APS_COM_CS_D2_OIDC_WB_C AS _OidcWB ON _OidcWB.parent_key = db_key  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_D2_OIDC_AU_C AS _Audiences ON Document.db_key = _Audiences.parent_key  -- association [0..*]
;