APS_COM_CA_ROOT_PROPERTY

@AbapCatalog.sqlViewName: 'APS_CA_TO_PROP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.type: #CLIENT_DEPENDENT
@EndUserText.label: 'Root Property to CA Assignment View'

define view APS_COM_CA_ROOT_PROPERTY
  as select from    aps_ca_d_root            as ca
    inner join      aps_cs_d_root            as cs             on cs.db_key = ca.commsyst
    inner join      aps_ca_d_api_key         as prop           on prop.parent_key = ca.db_key
    left outer join I_APS_COM_CA_APIKVALUE_C as propValue      on propValue.parent_key = prop.db_key
    left outer join aps_ca_d_dinbnd          as inboundDefault on inboundDefault.parent_key = ca.db_key

    inner join      aps_com_w_cscnp          as cscnp          on  cscnp.communicationscenarioid = ca.communicationscenario
                                                               and cscnp.interfacekeyid          = prop.interfacekeyid

{

  ca.db_key                as uuid,
  ca.commarrgmtname        as name,
  ca.communicationscenario as comm_scenario,
  ca.commsyst              as comm_system_uuid,
  ca.oauth2configurationid as oa2c_configuration_id,
  cs.commsyst              as comm_system_id,
  prop.interfacekeyid,
  inboundDefault.eeec_logical_port_name as eeec_destination,
  inboundDefault.dmon_logical_port_name as dmon_destination,

  case
  when prop.interfacekeyvalue is initial then propValue.InterfaceKeyValue
  else prop.interfacekeyvalue
  end                      as interfacekeyvalue,

  cscnp.interfacekeyname

}