ARS_V_DISTR_SNAP_SYST_STATE

DDL: ARS_V_DISTR_SNAP_SYST_STATE SQL: ARS_V_VSNPSST Type: view Package: S_ARS_API_VERSIONS_UI
5 Fields 2 Data Sources

API Snapshot Distrib.: State

ARS_V_DISTR_SNAP_SYST_STATE is a CDS View that provides data about "API Snapshot Distrib.: State" in SAP S/4HANA. It reads from 2 data sources (ars_l_snap_job_h, ars_l_snap_state) and exposes 5 fields. Part of development package S_ARS_API_VERSIONS_UI.

Data Sources (2)

SourceAliasJoin Type
ars_l_snap_job_h job inner
ars_l_snap_state state from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ARS_V_VSNPSST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label API Snapshot Distrib.: State view

Fields (5)

KeyFieldSource TableSource FieldDescription
api_context ars_l_snap_state api_context
counter ars_l_snap_state counter Version
action ars_l_snap_state action User action
system_id ars_l_snap_state system_id System ID
timestamp ars_l_snap_state timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

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_DISTR_SNAP_SYST_STATE.
-- 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_VSNPSST

CREATE VIEW ARS_V_DISTR_SNAP_SYST_STATE AS
SELECT
  state.api_context AS api_context,
  state.counter AS counter,
  state.action AS action,
  state.system_id AS system_id,
  state.timestamp AS timestamp
FROM ars_l_snap_state AS state
INNER JOIN ars_l_snap_job_h AS job ON /* join condition not captured in parsed metadata */
;

Learn More