I_RELEASESTATE

DDL: I_RELEASESTATE Type: view_entity Package: S_ESH_VB
8 Fields 1 Data Sources 1 Associations

CDS View Browser Release State

I_RELEASESTATE is a CDS View that provides data about "CDS View Browser Release State" in SAP S/4HANA. It reads from 1 data source (ars_w_api_state) and exposes 8 fields with key fields ObjectId, ObjectType, SubObjectType, SubObjectName, CompatibilityContract. It has 1 association to related views. Part of development package S_ESH_VB.

Data Sources (1)

SourceAliasJoin Type
ars_w_api_state ars_w_api_state from

Associations (1)

CardinalityTargetAliasCondition
[0..1] dd07t _dd07t _dd07t.domname = 'ARS_RELEASE_CONTRACT' and _dd07t.ddlanguage = $session.system_language and _dd07t.domvalue_l = $projection.CompatibilityContract and _dd07t.as4local = 'A' and _dd07t.as4vers = '0000'

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View Browser Release State view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ObjectId ars_w_api_state object_id Transaction ID
KEY ObjectType ars_w_api_state object_type Type
KEY SubObjectType ars_w_api_state sub_object_type Subobject Type
KEY SubObjectName ars_w_api_state sub_object_name Subobject Name
KEY CompatibilityContract ars_w_api_state compatibility_contract Release Contract
ObjectName ars_w_api_state object_name Technical Name
ReleaseState ars_w_api_state release_state Release Status
ReleaseContractDesc _dd07t ddtext Short text

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 I_RELEASESTATE.
-- 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.

CREATE VIEW I_RELEASESTATE AS
SELECT
  ars_w_api_state.object_id AS ObjectId,
  ars_w_api_state.object_type AS ObjectType,
  ars_w_api_state.sub_object_type AS SubObjectType,
  ars_w_api_state.sub_object_name AS SubObjectName,
  ars_w_api_state.compatibility_contract AS CompatibilityContract,
  ars_w_api_state.object_name AS ObjectName,
  ars_w_api_state.release_state AS ReleaseState,
  _dd07t.ddtext AS ReleaseContractDesc
FROM ars_w_api_state
LEFT OUTER JOIN dd07t AS _dd07t ON _dd07t.domname = 'ARS_RELEASE_CONTRACT' AND _dd07t.ddlanguage = $session.system_language AND _dd07t.domvalue_l = CompatibilityContract AND _dd07t.as4local = 'A' AND _dd07t.as4vers = '0000'  -- association [0..1]
;

Learn More