ARS_RUNTIME_API_STATE

CDS View

APIs Runtime View

ARS_RUNTIME_API_STATE is a CDS View in S/4HANA. APIs Runtime View. It contains 15 fields. 15 CDS views read from this table.

Used by 15 CDS view(s) 15 fields

CDS Views using this table (15)

ViewTypeJoinVDMDescription
ABAP_DOCU_RELEASED_APIS view_entity from List of released APIs
ARS_ADT_ACTIVE_APIS view_entity from sdfdsfdsf
ARS_ADT_ACTIVE_APIS view_entity union_all sdfdsfdsf
ARS_ADT_API_FILTER view from ADT API Filter
ARS_ADT_API_FILTER view union_all ADT API Filter
ARS_API_STATE view_entity from API State of Objects
ARS_APIS_RELEASED_C1_ALL view from All APIs Released for Contract C1
ARS_APIS_RELEASED_FOR_C0 view from APIs Released for C0 Contract and more
ARS_APIS_RELEASED_FOR_C0_SCP view from APIs Released for Use in Cloud Dev.
ARS_APIS_RELEASED_FOR_C1 view from APIs Released for Use in Key User Apps
ARS_APIS_RELEASED_FOR_C1_SCP view from APIs Released for Use in Cloud Dev.
ARS_APIS_RELEASED_FOR_C2 view from APIs Released for C2 Contract
ARS_APIS_RELEASED_FOR_C3 view from APIs Released for C3 Contract
ARS_APIS_RELEASED_FOR_C4 view from APIs Released for C4 Contract
I_APIsWithCloudDevSuccessor view_entity inner APIs with Cloud Development Successors

Fields (15)

KeyField CDS FieldsUsed in Views
KEY compatibility_contract compatibility_contract 1
KEY object_name object_name,tadir_obj_name 10
KEY object_type object_type,tadir_object 10
KEY sub_object_name object_key,sub_object_name 10
KEY sub_object_type object_type,sub_object_type 10
last_changed_at last_changed_at 1
release_state release_state,state 6
successor_classification successor_classification 4
successor_concept_name successor_concept_name 3
successor_object_name successor_tadir_obj_name 4
successor_object_type successor_tadir_object 4
successor_sub_object_name successor_object_key 4
successor_sub_object_type successor_object_type 4
use_in_key_user_apps use_in_key_user_apps 3
use_in_sap_cloud_platform use_in_cloud_development,use_in_sap_cloud_platform 3 
@AbapCatalog.sqlViewName: 'ARS_REL_RUNT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'APIs Runtime View'
define view ARS_RUNTIME_API_STATE
  as select from ars_w_api_state as api
{
      //api

  key object_id,
  key object_type,
  key sub_object_type,
  key sub_object_name,
  key compatibility_contract,
      object_name,
      release_state,
      use_in_key_user_apps,
      use_in_sap_cloud_platform,
      software_release_name,
      feature_toggle_id,
      successor_classification,
      successor_object_type,
      successor_object_name,
      successor_sub_object_type,
      successor_sub_object_name,
      successor_concept_name,
      created_at,
      created_by,
      last_changed_at,
      last_changed_by
}
where
  api.release_state <> 'RELEASED_WITH_FEATURE_TOGGLE'

union all select from ars_w_api_state  as api
  inner join          ars_l_ftgl_activ as feature_toggle on  feature_toggle.feature_toggle_id = api.feature_toggle_id
                                                         and feature_toggle.is_active         = #abap_boolean.'X'
{
      //api

  key api.object_id,
  key api.object_type,
  key api.sub_object_type,
  key api.sub_object_name,
  key api.compatibility_contract,
      api.object_name,
      'RELEASED' as release_state,
      api.use_in_key_user_apps,
      api.use_in_sap_cloud_platform,
      api.software_release_name,
      api.feature_toggle_id,
      api.successor_classification,
      api.successor_object_type,
      api.successor_object_name,
      api.successor_sub_object_type,
      api.successor_sub_object_name,
      api.successor_concept_name,
      api.created_at,
      api.created_by,
      api.last_changed_at,
      api.last_changed_by
}
where
  api.release_state = 'RELEASED_WITH_FEATURE_TOGGLE'

Learn More