I_CONCURSYSTEMCONNECTION

CDS View

Connection information for Concur System

I_CONCURSYSTEMCONNECTION is a CDS View in S/4HANA. Connection information for Concur System. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ConcurSystemConnectionStdVH view_entity from COMPOSITE Concur System Connections
I_S4C_ConcurSystConncnStdVH view_entity from COMPOSITE Concur System Connections 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Connection information for Concur System'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: { representativeKey: 'ConcurSystemKey',
                supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
                                         #CDS_MODELING_DATA_SOURCE ],
                usageType: { serviceQuality: #C,
                             sizeCategory: #S,
                             dataClass: #MIXED } }
@VDM.viewType: #BASIC
define root view entity I_ConcurSystemConnection
  as select from           cte_c_connection
    inner join             rfcdes on cte_c_connection.rfc_connection = rfcdes.rfcdest
    left outer to one join rfcdoc on  rfcdoc.rfclang = $session.system_language
                                  and rfcdes.rfcdest = rfcdoc.rfcdest
{
      @ObjectModel.text.element: ['SystemConnectionDescription1']
  key cte_c_connection.system_key                                                                 as ConcurSystemKey,
      cast ( cte_c_connection.rfc_connection as rfcdest preserving type )                         as SystemConnection,

      @EndUserText.label: 'System Connection Description'
      @Semantics.text: true
      cast( concat( concat(rfcdoc.rfcdoc1, rfcdoc.rfcdoc2 ), rfcdoc.rfcdoc3) as rfcdesshorttext ) as SystemConnectionDescription1
}

Learn More