atov_pk_setup

DDL: ATOV_PK_SETUP SQL: ATO_V_PK_SETUP Type: view

ATO setup in package based environment

atov_pk_setup is a CDS View that provides data about "ATO setup in package based environment" in SAP S/4HANA. It reads from 1 data source (ato_setup) and exposes 2 fields with key field client. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ato_setup setup from

Associations (2)

CardinalityTargetAliasCondition
[0..1] ATOV_SYSTEM_TYPE_TEXT system_type_text system_type_text.value = $projection.system_type and system_type_text.language = $session.system_language
[0..1] ATOV_SYSTEM_TYPE_TEXT _english_system_type_text _english_system_type_text.value = $projection.system_type and _english_system_type_text.language = 'E'

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_PK_SETUP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label ATO setup in package based environment view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY client client Workflow definition: Client
setup_type setup_type ATO Setup

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_pk_setup.
-- 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_PK_SETUP

CREATE VIEW atov_pk_setup AS
SELECT
  client,
  setup_type
FROM ato_setup AS setup
LEFT OUTER JOIN ATOV_SYSTEM_TYPE_TEXT AS system_type_text ON system_type_text.value = system_type AND system_type_text.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN ATOV_SYSTEM_TYPE_TEXT AS _english_system_type_text ON _english_system_type_text.value = system_type AND _english_system_type_text.language = 'E'  -- association [0..1]
;