ATOV_ST_CURRENT_VERSION_ACTION

DDL: ATOV_ST_CURRENT_VERSION_ACTION SQL: ATO_V_ST_CVA Type: view Package: S_ATO_SYSTEM_TRANSFER
9 Fields 2 Data Sources

Current collection version action

ATOV_ST_CURRENT_VERSION_ACTION is a CDS View that provides data about "Current collection version action" in SAP S/4HANA. It reads from 2 data sources (ATOV_ST_ACTION_MAX_TIMESTAMP, ato_col_versions) and exposes 9 fields with key fields timestamp, version. Part of development package S_ATO_SYSTEM_TRANSFER.

Data Sources (2)

SourceAliasJoin Type
ATOV_ST_ACTION_MAX_TIMESTAMP max_timestamp from
ato_col_versions version inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_ST_CVA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Current collection version action view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY timestamp ato_col_versions timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
KEY version ato_col_versions version XML Vers.
resource_id ato_col_versions resource_id UUID Internal
status ato_col_versions status Workflow Status
action ato_col_versions action User action
job_name ato_col_versions job_name Job No.
job_count ato_col_versions job_count Job No.
exec_client ato_col_versions exec_client
imported_at ato_col_versions imported_at Timestamp of Import

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 ATOV_ST_CURRENT_VERSION_ACTION.
-- 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: ATO_V_ST_CVA

CREATE VIEW ATOV_ST_CURRENT_VERSION_ACTION AS
SELECT
  version.timestamp AS timestamp,
  version.version AS version,
  version.resource_id AS resource_id,
  version.status AS status,
  version.action AS action,
  version.job_name AS job_name,
  version.job_count AS job_count,
  version.exec_client AS exec_client,
  version.imported_at AS imported_at
FROM ATOV_ST_ACTION_MAX_TIMESTAMP AS max_timestamp
INNER JOIN ato_col_versions AS version ON /* join condition not captured in parsed metadata */
;

Learn More