ATOV_NAMESPACE_KUA_ACTIVATION

DDL: ATOV_NAMESPACE_KUA_ACTIVATION SQL: ATOV_NSP_KUA Type: view Package: S_ATO_NAMESPACE_KUA_ACTIVATION

ATO: Key User Extensibility Activation

ATOV_NAMESPACE_KUA_ACTIVATION is a CDS View that provides data about "ATO: Key User Extensibility Activation" in SAP S/4HANA. It reads from 1 data source (ato_prefix_kua) and exposes 3 fields with key field namespace. It has 2 associations to related views. Part of development package S_ATO_NAMESPACE_KUA_ACTIVATION.

Data Sources (1)

SourceAliasJoin Type
ato_prefix_kua extensibility_activation from

Associations (2)

CardinalityTargetAliasCondition
[0..1] ATOV_KUA_ACTIVATION_STATUS_TXT _status_description _status_description.value = extensibility_activation.activation_status and _status_description.language = $session.system_language
[0..1] ATOV_KUA_ACTIVATION_STATUS_TXT _english_status_description _english_status_description.value = extensibility_activation.activation_status and _english_status_description.language = 'E'

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATOV_NSP_KUA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label ATO: Key User Extensibility Activation view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY namespace dev_prefix Namespace
resource_id resource_id UUID Internal
sc_created sc_created Truth Value

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_NAMESPACE_KUA_ACTIVATION.
-- 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_NSP_KUA

CREATE VIEW ATOV_NAMESPACE_KUA_ACTIVATION AS
SELECT
  dev_prefix AS namespace,
  resource_id,
  sc_created
FROM ato_prefix_kua AS extensibility_activation
LEFT OUTER JOIN ATOV_KUA_ACTIVATION_STATUS_TXT AS _status_description ON _status_description.value = extensibility_activation.activation_status AND _status_description.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN ATOV_KUA_ACTIVATION_STATUS_TXT AS _english_status_description ON _english_status_description.value = extensibility_activation.activation_status AND _english_status_description.language = 'E'  -- association [0..1]
;