ATOV_CMN_DEV_OBJECT_METADATA

DDL: ATOV_CMN_DEV_OBJECT_METADATA SQL: ATOV_CMN_DEV_OBJ Type: view

ATO: Development Object Metadata

ATOV_CMN_DEV_OBJECT_METADATA is a CDS View that provides data about "ATO: Development Object Metadata" in SAP S/4HANA. It reads from 4 data sources (ato_conti_bom, tadir, tdevc, ATOV_SOFTWARE_COMP_OF_OBJECT) and exposes 7 fields with key fields program_id, object_type, object_name.

Data Sources (4)

SourceAliasJoin Type
ato_conti_bom extensibility left_outer
tadir object from
tdevc package left_outer
ATOV_SOFTWARE_COMP_OF_OBJECT software_component left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATOV_CMN_DEV_OBJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label ATO: Development Object Metadata view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY program_id tadir pgmid Program Name
KEY object_type tadir object TRFM Object
KEY object_name tadir obj_name Object Name
is_generated tadir genflag Generation Flag
is_deleted tadir delflag Yes/No (X/ )
item_type
item_id

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_CMN_DEV_OBJECT_METADATA.
-- 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_CMN_DEV_OBJ

CREATE VIEW ATOV_CMN_DEV_OBJECT_METADATA AS
SELECT
  object.pgmid AS program_id,
  object.object AS object_type,
  object.obj_name AS object_name,
  object.genflag AS is_generated,
  object.delflag AS is_deleted,
  coalesce(extensibility.item_type, '') AS item_type,
  coalesce(extensibility.item_id, '') AS item_id
FROM tadir AS object
LEFT OUTER JOIN tdevc AS package ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_SOFTWARE_COMP_OF_OBJECT AS software_component ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ato_conti_bom AS extensibility ON /* join condition not captured in parsed metadata */
;