ARS_ADT_ACTIVE_APIS

DDL: ARS_ADT_ACTIVE_APIS Type: view_entity

sdfdsfdsf

ARS_ADT_ACTIVE_APIS is a CDS View that provides data about "sdfdsfdsf" in SAP S/4HANA. It reads from 4 data sources (ARS_RUNTIME_API_STATE, ARS_RUNTIME_API_STATE, ARS_API_CATALOG_ASSIGNMENT, ARS_API_CAT_OBJECTS_STATE_ON) and exposes 4 fields with key fields object_type, object_name, object_name.

4 data source(s) 4 fields

Data Sources (4)

SourceAliasJoin Type
ARS_RUNTIME_API_STATE api from
ARS_RUNTIME_API_STATE api union_all
ARS_API_CATALOG_ASSIGNMENT assignment left_outer
ARS_API_CAT_OBJECTS_STATE_ON assignment inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label sdfdsfdsf view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY object_type ARS_RUNTIME_API_STATE object_type
KEY object_name ARS_RUNTIME_API_STATE object_name
object_type
KEY object_name ARS_RUNTIME_API_STATE object_name 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'sdfdsfdsf'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity ARS_ADT_ACTIVE_APIS
  // Objects without API catalog assignment

  as select from    ARS_RUNTIME_API_STATE      as api
    left outer join ARS_API_CATALOG_ASSIGNMENT as assignment on  assignment.tadir_object   = api.object_type
                                                             and assignment.tadir_obj_name = api.object_name
                                                             and assignment.object_type    = api.sub_object_type
                                                             and assignment.object_key     = api.sub_object_name
{
  key api.object_type,
  key api.object_name,
  key api.sub_object_type,
  key api.sub_object_name,
  key api.compatibility_contract,
      api.release_state,
      api.use_in_key_user_apps,
      api.use_in_sap_cloud_platform
}
where
  assignment.api_catalog_id is null

// Objects with API catalog assignment, where the API catalog has state ON

union all select from ARS_RUNTIME_API_STATE        as api
  inner join          ARS_API_CAT_OBJECTS_STATE_ON as assignment on  assignment.object_type     = api.object_type
                                                                 and assignment.object_name     = api.object_name
                                                                 and assignment.sub_object_type = api.sub_object_type
                                                                 and assignment.sub_object_name = api.sub_object_name
{
  key api.object_type,
  key api.object_name,
  key api.sub_object_type,
  key api.sub_object_name,
  key api.compatibility_contract,
      api.release_state,
      api.use_in_key_user_apps,
      api.use_in_sap_cloud_platform
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ARS_API_CATALOG_ASSIGNMENT",
"ARS_API_CAT_OBJECTS_STATE_ON",
"ARS_RUNTIME_API_STATE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More