ATOV_PREFIX_ADAPT_TYPE_SUP_U

DDL: ATOV_PREFIX_ADAPT_TYPE_SUP_U SQL: ATOV_PREF_SUPP_U Type: view

Supported Adaptation Types per Namespace

ATOV_PREFIX_ADAPT_TYPE_SUP_U is a CDS View that provides data about "Supported Adaptation Types per Namespace" in SAP S/4HANA. It reads from 25 data sources and exposes 7 fields.

Data Sources (25)

SourceAliasJoin Type
EITV_EXP_ITEM_TYPE content_type left_outer
ATOV_ADAPT_TYPES_FILTER_LOCKED content_type left_outer
ATOV_ADAPT_TYPES_FILTER_LOCKED content_type left_outer
ATOV_ADAPT_TYPES_FILTER_LOCKED content_type left_outer
ATOV_ADAPT_TYPES_FILTER_LOCKED content_type left_outer
ATOV_ADAPT_TYPES_FILTER_LOCKED content_type left_outer
ato_adapt_typest content_type_text inner
ato_adapt_typest content_type_text inner
ato_adapt_typest content_type_text inner
ato_adapt_typest content_type_text inner
ato_adapt_typest content_type_text inner
ato_adapt_typest content_type_text left_outer
ato_adapt_typest content_type_text inner
ato_prefix_set prefix from
ato_prefix_set prefix union
ato_prefix_set prefix union
ato_prefix_set prefix union
ato_prefix_set prefix union
ato_prefix_set prefix union
ATOV_PK_NAMESPACE prefix union
ato_setup setup inner
ato_setup setup inner
ato_setup setup inner
ato_setup setup inner
ato_setup setup inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATOV_PREF_SUPP_U view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Supported Adaptation Types per Namespace view

Fields (7)

KeyFieldSource TableSource FieldDescription
namespace ATOV_PK_NAMESPACE dev_prefix SerialNo.Prefix
namespace ATOV_PK_NAMESPACE dev_prefix SerialNo.Prefix
namespace ATOV_PK_NAMESPACE dev_prefix SerialNo.Prefix
namespace ATOV_PK_NAMESPACE dev_prefix SerialNo.Prefix
namespace ATOV_PK_NAMESPACE dev_prefix SerialNo.Prefix
namespace ATOV_PK_NAMESPACE dev_prefix SerialNo.Prefix
namespace ATOV_PK_NAMESPACE prefix SerialNo.Prefix

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_PREFIX_ADAPT_TYPE_SUP_U.
-- 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_PREF_SUPP_U

CREATE VIEW ATOV_PREFIX_ADAPT_TYPE_SUP_U AS
SELECT
  prefix.dev_prefix AS namespace
FROM ato_prefix_set AS prefix
LEFT OUTER JOIN EITV_EXP_ITEM_TYPE AS content_type ON /* join condition not captured in parsed metadata */
INNER JOIN ato_adapt_typest AS content_type_text ON /* join condition not captured in parsed metadata */
INNER JOIN ato_setup AS setup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_ADAPT_TYPES_FILTER_LOCKED AS content_type ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ato_adapt_typest AS content_type_text ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): ato_prefix_set, ATOV_PK_NAMESPACE
;