ATOV_ST_CURRENT_COLS

DDL: ATOV_ST_CURRENT_COLS SQL: ATO_V_ST_COLS Type: view

Collections with imported items

ATOV_ST_CURRENT_COLS is a CDS View that provides data about "Collections with imported items" in SAP S/4HANA. It reads from 4 data sources (ato_changelists, ato_cols, ATOV_ST_CURRENT_COL_VERSIONS, ato_col_versions) and exposes 6 fields.

Data Sources (4)

SourceAliasJoin Type
ato_changelists changel inner
ato_cols col inner
ATOV_ST_CURRENT_COL_VERSIONS current_version from
ato_col_versions version inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_ST_COLS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Collections with imported items view

Fields (6)

KeyFieldSource TableSource FieldDescription
version ato_col_versions version XML Vers.
category ato_cols category Violation Category
devclass ato_cols devclass Package (Obsolete)
counter ato_cols counter Version
project_id ato_cols project_id Project UUID
exported_at ato_changelists exported_at Time Stamp

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

CREATE VIEW ATOV_ST_CURRENT_COLS AS
SELECT
  version.version AS version,
  col.category AS category,
  col.devclass AS devclass,
  col.counter AS counter,
  col.project_id AS project_id,
  changel.exported_at AS exported_at
FROM ATOV_ST_CURRENT_COL_VERSIONS AS current_version
INNER JOIN ato_cols AS col ON /* join condition not captured in parsed metadata */
INNER JOIN ato_col_versions AS version ON /* join condition not captured in parsed metadata */
INNER JOIN ato_changelists AS changel ON /* join condition not captured in parsed metadata */
;