aps_com_cs_read_auth

DDL: APS_COM_CS_READ_AUTH Type: view_entity Package: SR_APS_COM_PUB_ODATA_CS_READ

CS - Authentication Methods

aps_com_cs_read_auth is a CDS View that provides data about "CS - Authentication Methods" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 1 field with key field AuthMethodCode. Part of development package SR_APS_COM_PUB_ODATA_CS_READ.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
dd07l dd from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CS - Authentication Methods view
Metadata.ignorePropagatedAnnotations true view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY AuthMethodCode dd07l domvalue_l 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CS - Authentication Methods'
@Metadata.ignorePropagatedAnnotations: true

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view entity aps_com_cs_read_auth
  as select from dd07l as dd
{
  key dd.domvalue_l as AuthMethodCode,
      cast(
        case
          when ($projection.AuthMethodCode = '1') then 'x509'
          when ($projection.AuthMethodCode = '2') then 'basic'
          when ($projection.AuthMethodCode = '3') then 'none'
          when ($projection.AuthMethodCode = '4') then 'oauth2'
          when ($projection.AuthMethodCode = '5') then 'sso2'
          when ($projection.AuthMethodCode = '6') then 'oauth1'
          when ($projection.AuthMethodCode = '7') then 'princ_prop'
          when ($projection.AuthMethodCode = '8') then 'oauth2_mtls'
          when ($projection.AuthMethodCode = '9') then 'oidc'
          
          when ($projection.AuthMethodCode = '41') then 'oauth2'
          when ($projection.AuthMethodCode = '42') then 'oauth2_mtls'
          when ($projection.AuthMethodCode = '43') then 'oauth2'
          when ($projection.AuthMethodCode = '44') then 'oauth2'
          
          else 'unknown'
        end
      as text20)    as AuthMethod
}
where
  dd.domname = 'APS_CS_SYS_AUTH_MC'
//  as select distinct from aps_cs_d_inbound as cs_inb

//{

//  key cs_inb.systemauthenticationmode as AuthMethodCode,

//      case

//        when ($projection.AuthMethodCode = '1') then 'x509'

//        when ($projection.AuthMethodCode = '2') then 'basic'

//        when ($projection.AuthMethodCode = '3') then 'none'

//        when ($projection.AuthMethodCode = '4') then 'oauth2'

//        when ($projection.AuthMethodCode = '5') then 'sso2'

//        when ($projection.AuthMethodCode = '6') then 'oauth1'

//        when ($projection.AuthMethodCode = '7') then 'princ_prop'

//        when ($projection.AuthMethodCode = '8') then 'oauth2_mtls'

//        else 'unknown'

//      end                             as AuthMethod

//}

//union select distinct from aps_cs_d_outbnd as cs_out

//{

//  key cs_out.systemauthenticationmode as AuthMethodCode,

//      case

//        when ($projection.AuthMethodCode = '1') then 'x509'

//        when ($projection.AuthMethodCode = '2') then 'basic'

//        when ($projection.AuthMethodCode = '3') then 'none'

//        when ($projection.AuthMethodCode = '4') then 'oauth2'

//        when ($projection.AuthMethodCode = '5') then 'sso2'

//        when ($projection.AuthMethodCode = '6') then 'oauth1'

//        when ($projection.AuthMethodCode = '7') then 'princ_prop'

//        when ($projection.AuthMethodCode = '8') then 'oauth2_mtls'

//        else 'unknown'

//      end                             as AuthMethod

//}

Learn More