ARS_APIS_RELEASED_FOR_C3

DDL: ARS_APIS_RELEASED_FOR_C3 SQL: ARS_API_C3 Type: view Package: S_ARS_PUBLIC
4 Fields 1 Data Sources 1 Associations

APIs Released for C3 Contract

ARS_APIS_RELEASED_FOR_C3 is a CDS View that provides data about "APIs Released for C3 Contract" in SAP S/4HANA. It reads from 1 data source (ARS_RUNTIME_API_STATE) and exposes 4 fields. It has 1 association to related views. Part of development package S_ARS_PUBLIC.

Data Sources (1)

SourceAliasJoin Type
ARS_RUNTIME_API_STATE api from

Associations (1)

CardinalityTargetAliasCondition
[0..1] ARS_RELEASE_STATE_DESCRIPTIONS _text _text.state = api.release_state

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ARS_API_C3 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label APIs Released for C3 Contract view

Fields (4)

KeyFieldSource TableSource FieldDescription
tadir_object ARS_RUNTIME_API_STATE object_type Type
object_type ARS_RUNTIME_API_STATE sub_object_type Subobject Type
object_key ARS_RUNTIME_API_STATE sub_object_name Subobject Name
state

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ARS_APIS_RELEASED_FOR_C3.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ARS_API_C3

CREATE VIEW ARS_APIS_RELEASED_FOR_C3 AS
SELECT
  api.object_type AS tadir_object,
  api.sub_object_type AS object_type,
  api.sub_object_name AS object_key,
  cast(api.release_state as abap.char(184)) AS state
FROM ARS_RUNTIME_API_STATE AS api
LEFT OUTER JOIN ARS_RELEASE_STATE_DESCRIPTIONS AS _text ON _text.state = api.release_state  -- association [0..1]
;

Learn More