ARS_API_SUCCESSOR

DDL: ARS_API_SUCCESSOR SQL: ARS_API_SUCCSSR Type: view Package: S_ARS_PUBLIC

API Successors

ARS_API_SUCCESSOR is a CDS View that provides data about "API Successors" in SAP S/4HANA. It reads from 2 data sources (ars_w_api_state, ars_w_api_sccssr) and exposes 3 fields with key fields tadir_object, object_type, object_key. Part of development package S_ARS_PUBLIC.

Data Sources (2)

SourceAliasJoin Type
ars_w_api_state api inner
ars_w_api_sccssr successor from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ARS_API_SUCCSSR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label API Successors view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY tadir_object ars_w_api_sccssr object_type
KEY object_type ars_w_api_sccssr sub_object_type
KEY object_key ars_w_api_sccssr sub_object_name
@AbapCatalog.sqlViewName: 'ARS_API_SUCCSSR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'API Successors'
define view ARS_API_SUCCESSOR
  as select from ars_w_api_sccssr as successor
    inner join   ars_w_api_state  as api on  successor.object_id              = api.object_id
                                         and successor.object_type            = api.object_type
                                         and successor.sub_object_type        = api.sub_object_type
                                         and successor.sub_object_name        = api.sub_object_name
                                         and successor.compatibility_contract = api.compatibility_contract
{
  key successor.object_type               as tadir_object,
  key api.object_name                     as tadir_obj_name,
  key successor.sub_object_type           as object_type,
  key successor.sub_object_name           as object_key,
  key successor.compatibility_contract,
  key successor.successor_object_type     as successor_tadir_object,
  key successor.successor_object_name     as successor_tadir_obj_name,
  key successor.successor_sub_object_type as successor_object_type,
  key successor.successor_sub_object_name as successor_object_key,
      api.use_in_key_user_apps,
      api.use_in_sap_cloud_platform
}