aps_com_cs_read_cs_inbnd

DDL: APS_COM_CS_READ_CS_INBND Type: view_entity Package: SR_APS_COM_PUB_ODATA_CS_READ

Inbound Users

aps_com_cs_read_cs_inbnd is a CDS View that provides data about "Inbound Users" in SAP S/4HANA. It reads from 1 data source (aps_cs_d_inbound) and exposes 7 fields with key fields CommunicationSystemID, InboundUUID, UserID. It has 3 associations 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) 7 fields

Data Sources (1)

SourceAliasJoin Type
aps_cs_d_inbound cs_inb from

Associations (3)

CardinalityTargetAliasCondition
[0..1] aps_iam_customeruser_ddl _User cs_inb.commsystinboundusername = _User.UserID
[0..1] aps_com_cs_read_auth _Auth cs_inb.systemauthenticationmode = _Auth.AuthMethodCode
[0..1] aps_com_cs_read_granttype _GrantType cs_inb.oauth2granttype = _GrantType.GrantTypeCode

Annotations (3)

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

OData Services (1)

ServiceBindingVersionContractRelease
APS_COM_API_CS_READ APS_COM_API_CS_READ V4 C2 C1

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CommunicationSystemID cs commsyst
KEY InboundUUID aps_cs_d_inbound db_key
KEY UserID aps_cs_d_inbound commsystinboundusername
UserName _User UserName
OAuth2ClientID aps_cs_d_inbound oauth2clientid
OAuth2GrantType _GrantType GrantType
AuthMethod _Auth AuthMethod 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Inbound Users'
@Metadata.ignorePropagatedAnnotations: true

define view entity aps_com_cs_read_cs_inbnd
  as select from aps_cs_d_inbound as cs_inb
    join         aps_cs_d_root    as cs on cs.db_key = cs_inb.parent_key

  // User Information

  association [0..1] to aps_iam_customeruser_ddl  as _User      on cs_inb.commsystinboundusername = _User.UserID

  // Authentication Method

  association [0..1] to aps_com_cs_read_auth      as _Auth      on cs_inb.systemauthenticationmode = _Auth.AuthMethodCode

  // OAuth2 Grant Type

  association [0..1] to aps_com_cs_read_granttype as _GrantType on cs_inb.oauth2granttype = _GrantType.GrantTypeCode
{
      @EndUserText: { label: 'Communication System ID', quickInfo: 'Communication System ID' }
  key cs.commsyst                    as CommunicationSystemID,

      @EndUserText: { label: 'Inbound UUID', quickInfo: 'Inbound UUID' }
  key cs_inb.db_key                  as InboundUUID,

      @EndUserText: { label: 'Communication User ID', quickInfo: 'Communication User ID' }
  key cs_inb.commsystinboundusername as UserID,

      @EndUserText: { label: 'Communication User Name', quickInfo: 'Communication User Name' }
      _User.UserName                 as UserName,

      @EndUserText: { label: 'OAuth 2.0 Client ID', quickInfo: 'OAuth 2.0 Client ID' }
      cs_inb.oauth2clientid          as OAuth2ClientID,
      @EndUserText: { label: 'OAuth 2.0 Grant Type', quickInfo: 'OAuth 2.0 Grant Type' }
      _GrantType.GrantType           as OAuth2GrantType,

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

      //      @Consumption.hidden: true

      //      cs_inb.parent_key              as ParentKey

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

Learn More