aps_com_cs_read_cs_outbnd

DDL: APS_COM_CS_READ_CS_OUTBND Type: view_entity Package: SR_APS_COM_PUB_ODATA_CS_READ

Outbound Users

aps_com_cs_read_cs_outbnd is a CDS View that provides data about "Outbound Users" in SAP S/4HANA. It reads from 1 data source (aps_cs_d_outbnd) and exposes 5 fields with key fields CommunicationSystemID, OutboundUUID, commsystoutboundusernameendasUserName. It has 1 association to related views. It is exposed through 1 OData service (APS_COM_API_CS_READ). Part of development package SR_APS_COM_PUB_ODATA_CS_READ.

1 data source(s) Exposed by 1 service(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
aps_cs_d_outbnd cs_outb from

Associations (1)

CardinalityTargetAliasCondition
[0..1] aps_com_cs_read_auth _Auth cs_outb.systemauthenticationmode = _Auth.AuthMethodCode

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Outbound Users view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
APS_COM_API_CS_READ APS_COM_API_CS_READ V4 C2 C1

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CommunicationSystemID cs commsyst
KEY OutboundUUID aps_cs_d_outbnd db_key
KEY commsystoutboundusernameendasUserName
CertificateID aps_cs_d_outbnd certificatetext
AuthMethod _Auth AuthMethod 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Outbound Users'
@Metadata.ignorePropagatedAnnotations: true

define view entity aps_com_cs_read_cs_outbnd
  as select from aps_cs_d_outbnd as cs_outb
    join         aps_cs_d_root   as cs on cs.db_key = cs_outb.parent_key

  // Authentication Method

  association [0..1] to aps_com_cs_read_auth as _Auth on cs_outb.systemauthenticationmode = _Auth.AuthMethodCode
{
      @EndUserText: { label: 'Communication System ID', quickInfo: 'Communication System ID' }
  key cs.commsyst             as CommunicationSystemID,

      @EndUserText: { label: 'Outbound UUID', quickInfo: 'Outbound UUID' }
  key cs_outb.db_key          as OutboundUUID,

      @EndUserText: { label: 'Communication User Name', quickInfo: 'Communication User Name' }
  key case
        when cs_outb.systemauthenticationmode = '4' then '' // oauth2

        when cs_outb.systemauthenticationmode = '8' then '' // oauth2_mtls

        
        when cs_outb.systemauthenticationmode = '41' then ''
        when cs_outb.systemauthenticationmode = '42' then ''
        when cs_outb.systemauthenticationmode = '43' then ''
        when cs_outb.systemauthenticationmode = '44' then ''
        
        else cs_outb.commsystoutboundusername
      end                     as UserName,

      @EndUserText: { label: 'OAuth 2.0 Client ID', quickInfo: 'OAuth 2.0 Client ID' }
  key case
        when cs_outb.systemauthenticationmode = '4' then cs_outb.commsystoutboundusername // oauth2

        when cs_outb.systemauthenticationmode = '8' then cs_outb.commsystoutboundusername // oauth2_mtls

        
        when cs_outb.systemauthenticationmode = '41' then cs_outb.commsystoutboundusername
        when cs_outb.systemauthenticationmode = '42' then cs_outb.commsystoutboundusername
        when cs_outb.systemauthenticationmode = '43' then cs_outb.commsystoutboundusername
        when cs_outb.systemauthenticationmode = '44' then cs_outb.commsystoutboundusername
        
        else ''
      end                     as OAuth2ClientID,

      @EndUserText: { label: 'Certificate ID', quickInfo: 'Certificate ID' }
      cs_outb.certificatetext as CertificateID,

      @EndUserText: { label: 'Authentication Method', quickInfo: 'Authentication Method' }
      _Auth.AuthMethod        as AuthMethod

      //      @Consumption.hidden: true

      //      cs_outb.parent_key      as ParentKey

}
where
  (
       cs.commsysttype = '1'
    or cs.commsysttype = ''
  )
  and  cs.commsyst     not like 'SAP_%'

Learn More