ARS_RUNTIME_API_STATE

DDL: ARS_RUNTIME_API_STATE SQL: ARS_REL_RUNT Type: view

APIs Runtime View

ARS_RUNTIME_API_STATE is a CDS View that provides data about "APIs Runtime View" in SAP S/4HANA. It reads from 3 data sources (ars_w_api_state, ars_w_api_state, ars_l_ftgl_activ) and exposes 10 fields with key fields object_id, object_type, object_type.

3 data source(s) 10 fields

Data Sources (3)

SourceAliasJoin Type
ars_w_api_state api from
ars_w_api_state api union_all
ars_l_ftgl_activ feature_toggle inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ARS_REL_RUNT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label APIs Runtime View view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY object_id object_id
KEY object_type object_type
object_name object_name
created_at created_at
created_by created_by
object_id
KEY object_type ars_w_api_state object_type
object_name ars_w_api_state object_name
created_at ars_w_api_state created_at
created_by ars_w_api_state created_by 
@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