aps_com_cusr_read_cusr_cs

DDL: APS_COM_CUSR_READ_CUSR_CS Type: view_entity Package: SR_APS_COM_PUB_ODATA_CUSR_READ

Communication Systems

aps_com_cusr_read_cusr_cs is a CDS View that provides data about "Communication Systems" in SAP S/4HANA. It reads from 2 data sources (aps_cs_d_root, aps_cs_d_inbound) and exposes 2 fields with key fields UserID, CommunicationSystemID. It is exposed through 1 OData service (APS_COM_API_CUSR_READ). Part of development package SR_APS_COM_PUB_ODATA_CUSR_READ.

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

Data Sources (2)

SourceAliasJoin Type
aps_cs_d_root cs from
aps_cs_d_inbound cs_inb inner

Annotations (3)

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

OData Services (1)

ServiceBindingVersionContractRelease
APS_COM_API_CUSR_READ APS_COM_API_CUSR_READ V4 C2 C1

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY UserID aps_cs_d_inbound commsystinboundusername
KEY CommunicationSystemID aps_cs_d_root commsyst 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Communication Systems'
@Metadata.ignorePropagatedAnnotations: true

define view entity aps_com_cusr_read_cusr_cs
  as select from aps_cs_d_root    as cs
    inner join   aps_cs_d_inbound as cs_inb on cs.db_key = cs_inb.parent_key
{
      @EndUserText: { label: 'Communication User ID', quickInfo: 'Communication User ID' }
  key cs_inb.commsystinboundusername as UserID,

      @EndUserText: { label: 'Communication System ID', quickInfo: 'Communication System ID' }
  key cs.commsyst                    as CommunicationSystemID
}
where
  (
       cs.commsysttype                =    '1'
    or cs.commsysttype                =    ''
  )
  and  cs.commsyst                    not like 'SAP_%'
  and  cs_inb.commsystinboundusername like 'CC%'

Learn More