ARS_API_SUCCESSOR

DDL: ARS_API_SUCCESSOR SQL: ARS_API_SUCCSSR Type: view

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.

2 data source(s) 3 fields

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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ARS_W_API_SCCSSR",
"ARS_W_API_STATE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More