ATOV_COL_SETUP_BASE

DDL: ATOV_COL_SETUP_BASE SQL: ATOV_COL_SET_BAS Type: view

ATO: Cloud Setup

ATOV_COL_SETUP_BASE is a CDS View that provides data about "ATO: Cloud Setup" in SAP S/4HANA. It reads from 2 data sources (ato_col_setup, ato_setup) and exposes 7 fields with key field client.

Data Sources (2)

SourceAliasJoin Type
ato_col_setup setup from
ato_setup setup_runtime inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATOV_COL_SET_BAS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label ATO: Cloud Setup view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY client ato_col_setup client Workflow definition: Client
tms_config ato_col_setup tms_config Transport Type
tms_tr_layer ato_col_setup tms_tr_layer System
setup_by ato_col_setup setup_by Last Changed By
setup_tool ato_col_setup setup_tool Col Setup Tool
deleted ato_col_setup deleted Truth Value
locked ato_col_setup locked TRUE

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_COL_SETUP_BASE.
-- 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: ATOV_COL_SET_BAS

CREATE VIEW ATOV_COL_SETUP_BASE AS
SELECT
  setup.client AS client,
  setup.tms_config AS tms_config,
  setup.tms_tr_layer AS tms_tr_layer,
  setup.setup_by AS setup_by,
  setup.setup_tool AS setup_tool,
  setup.deleted AS deleted,
  setup.locked AS locked
FROM ato_col_setup AS setup
INNER JOIN ato_setup AS setup_runtime ON /* join condition not captured in parsed metadata */
;