aps_com_ca_read_ca_inbnd

DDL: APS_COM_CA_READ_CA_INBND Type: view_entity Package: SR_APS_COM_PUB_ODATA_CA_READ

Inbound Users

aps_com_ca_read_ca_inbnd is a CDS View that provides data about "Inbound Users" in SAP S/4HANA. It reads from 4 data sources (aps_ca_d_root, aps_ca_d_dinbnd, aps_cs_d_root, aps_cs_d_inbound) and exposes 6 fields with key fields CommunicationArrangementUUID, UserID. It has 4 associations to related views. It is exposed through 1 OData service (APS_COM_API_CA_READ). Part of development package SR_APS_COM_PUB_ODATA_CA_READ.

4 data source(s) Exposed by 1 service(s) 6 fields

Data Sources (4)

SourceAliasJoin Type
aps_ca_d_root ca from
aps_ca_d_dinbnd ca_inb inner
aps_cs_d_root cs inner
aps_cs_d_inbound cs_inb inner

Associations (4)

CardinalityTargetAliasCondition
[0..1] aps_com_w_cscn _CommScen ca.communicationscenario = _CommScen.communication_scenario_id
[0..1] aps_iam_customeruser_ddl _ChangeUser cs_inb.commsystinboundusername = _ChangeUser.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_CA_READ APS_COM_API_CA_READ V4 C2 C1

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CommunicationArrangementUUID aps_ca_d_root db_key
KEY UserID aps_cs_d_inbound commsystinboundusername
UserName _ChangeUser 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_ca_read_ca_inbnd
  as select from aps_ca_d_root    as ca
    inner join   aps_cs_d_root    as cs     on ca.commsyst = cs.db_key

    inner join   aps_ca_d_dinbnd  as ca_inb on ca.db_key = ca_inb.parent_key

    inner join   aps_cs_d_inbound as cs_inb on  cs.db_key     = cs_inb.parent_key
                                            and cs_inb.db_key = ca_inb.commsystinbounduser

  // Communication Scenario

  association [0..1] to aps_com_w_cscn            as _CommScen   on ca.communicationscenario = _CommScen.communication_scenario_id

  // User Information

  association [0..1] to aps_iam_customeruser_ddl  as _ChangeUser on cs_inb.commsystinboundusername = _ChangeUser.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
{
      //@Consumption.hidden: true

      @EndUserText: { label: 'Communication Arrangement UUID', quickInfo: 'Communication Arrangement UUID' }
  key ca.db_key                      as CommunicationArrangementUUID,

      //      @Consumption.hidden: true

      //  key ca.commarrgmtname              as CommunicationArrangementName,


      @EndUserText: { label: 'Communication User ID', quickInfo: 'Communication User ID' }
  key cs_inb.commsystinboundusername as UserID,
      @EndUserText: { label: 'Communication User Name', quickInfo: 'Communication User Name' }
      _ChangeUser.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
}
where
  _CommScen.communication_scenario_type = '1' // Not managed by SAP

Learn More