ARS_V_SNAPSHOT

DDL: ARS_V_SNAPSHOT SQL: ARS_V_SNAP Type: view
6 Fields 1 Data Sources

API Release: Snapshot with Status

ARS_V_SNAPSHOT is a CDS View that provides data about "API Release: Snapshot with Status" in SAP S/4HANA. It reads from 1 data source (ars_l_snap_rlvnc) and exposes 6 fields with key fields api_context, counter.

Data Sources (1)

SourceAliasJoin Type
ars_l_snap_rlvnc check_relevance left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ARS_V_SNAP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label API Release: Snapshot with Status view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY api_context snapshot api_context
KEY counter snapshot counter Version
created_by snapshot created_by Version Created By
created_on snapshot created_on Variant created on
created_at snapshot created_at Uploaded On
storage snapshot storage Storage

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_V_SNAPSHOT.
-- 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_V_SNAP

CREATE VIEW ARS_V_SNAPSHOT AS
SELECT
  snapshot.api_context AS api_context,
  snapshot.counter AS counter,
  snapshot.created_by AS created_by,
  snapshot.created_on AS created_on,
  snapshot.created_at AS created_at,
  snapshot.storage AS storage
LEFT OUTER JOIN ars_l_snap_rlvnc AS check_relevance ON /* join condition not captured in parsed metadata */
;

Learn More