ATOV_SOBJ_OBJECT_TABLES

DDL: ATOV_SOBJ_OBJECT_TABLES SQL: ATOV_SOBJ_TAB Type: view Package: S_ATO_COMMON_EXPORT

ATO: Tables of an Object in SOBJ

ATOV_SOBJ_OBJECT_TABLES is a CDS View that provides data about "ATO: Tables of an Object in SOBJ" in SAP S/4HANA. It reads from 2 data sources (objs, ATOV_TABU_ENTRY_TABLES) and exposes 3 fields with key fields object_name, object_type, table_name. Part of development package S_ATO_COMMON_EXPORT.

Data Sources (2)

SourceAliasJoin Type
objs object from
ATOV_TABU_ENTRY_TABLES table left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATOV_SOBJ_TAB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label ATO: Tables of an Object in SOBJ view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY object_name objectname Object name
KEY object_type objecttype Type
KEY table_name objs tabname Table/Constant 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_SOBJ_OBJECT_TABLES.
-- 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_SOBJ_TAB

CREATE VIEW ATOV_SOBJ_OBJECT_TABLES AS
SELECT
  objectname AS object_name,
  objecttype AS object_type,
  object.tabname AS table_name
FROM objs AS object
LEFT OUTER JOIN ATOV_TABU_ENTRY_TABLES AS table ON /* join condition not captured in parsed metadata */
;