aps_com_cusr_read_cusr_ca

DDL: APS_COM_CUSR_READ_CUSR_CA Type: view_entity Package: SR_APS_COM_PUB_ODATA_CUSR_READ

Communication Arrangements

aps_com_cusr_read_cusr_ca is a CDS View that provides data about "Communication Arrangements" 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 5 fields with key fields UserID, CommunicationArrangementUUID. It has 1 association to related views. It is exposed through 1 OData service (APS_COM_API_CUSR_READ). Part of development package SR_APS_COM_PUB_ODATA_CUSR_READ.

4 data source(s) Exposed by 1 service(s) 5 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 (1)

CardinalityTargetAliasCondition
[0..1] aps_com_w_cscn _CommScen ca.communicationscenario = _CommScen.communication_scenario_id

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Communication Arrangements view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
APS_COM_API_CUSR_READ APS_COM_API_CUSR_READ V4 C2 C1

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY UserID aps_cs_d_inbound commsystinboundusername
KEY CommunicationArrangementUUID aps_ca_d_root db_key
CommunicationArrangementName aps_ca_d_root commarrgmtname
CommunicationSystemID aps_cs_d_root commsyst
CommunicationScenarioID aps_ca_d_root communicationscenario 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Communication Arrangements'
@Metadata.ignorePropagatedAnnotations: true

define view entity aps_com_cusr_read_cusr_ca
  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
{
      @EndUserText: { label: 'Communication User ID', quickInfo: 'Communication User ID' }
  key cs_inb.commsystinboundusername as UserID,

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

      @EndUserText: { label: 'Communication Arrangement Name', quickInfo: 'Communication Arrangement Name' }
      ca.commarrgmtname              as CommunicationArrangementName,

      @EndUserText: { label: 'Communication System ID', quickInfo: 'Communication System ID' }
      cs.commsyst                    as CommunicationSystemID,

      @EndUserText: { label: 'Communication Scenario ID', quickInfo: 'Communication Scenario ID' }
      ca.communicationscenario       as CommunicationScenarioID
}
where
      _CommScen.communication_scenario_type =    '1' // Not managed by SAP

  and cs_inb.commsystinboundusername        like 'CC%'

Learn More