ATOV_ARS_CLOUD_CUSTOM_DEV_OBJ

DDL: ATOV_ARS_CLOUD_CUSTOM_DEV_OBJ SQL: ATO_ARS_CLD_CSTD Type: view
9 Fields 7 Data Sources

Custom development and key user objects

ATOV_ARS_CLOUD_CUSTOM_DEV_OBJ is a CDS View that provides data about "Custom development and key user objects" in SAP S/4HANA. It reads from 7 data sources and exposes 9 fields with key fields pgmid, object_type, object_name, object_type, object_name.

Data Sources (7)

SourceAliasJoin Type
ato_w_item_bom bom inner
ato_w_item header union
ATOV_ABAP_CLOUD_SWCMP swcmp left_outer
ATOV_ABAP_CLOUD_SWCMP swcmp left_outer
tadir tadir from
tadir tadir union
tdevc tdevc inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ATO_ARS_CLD_CSTD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Custom development and key user objects view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY pgmid tadir pgmid Program Name
KEY object_type tadir object TRFM Object
KEY object_name Technical Name
component_typeUthenINKelseendasorigin
KEY object_type object TRFM Object
KEY object_name Technical Name
KEY object_type ato_w_item_bom object TRFM Object
KEY object_name ato_w_item_bom object_name Technical Name
origin

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_ARS_CLOUD_CUSTOM_DEV_OBJ.
-- 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_ARS_CLD_CSTD

CREATE VIEW ATOV_ARS_CLOUD_CUSTOM_DEV_OBJ AS
SELECT
  tadir.pgmid AS pgmid,
  tadir.object AS object_type,
  cast(tadir.obj_name as trobj_name) AS object_name,
  case when swcmp.component_type = 'B' then 'INS' when swcmp.component_type = 'J' or swcmp.component_type = 'K' or swcmp.component_type is initial then 'SCP' when swcmp.component_type = 'Q' then 'KUP' when swcmp.component_type = 'U' then 'INK' else ' ' end as origin AS component_typeUthenINKelseendasorigin,
  'KUA' AS origin
FROM tadir
INNER JOIN tdevc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_ABAP_CLOUD_SWCMP AS swcmp ON /* join condition not captured in parsed metadata */
INNER JOIN ato_w_item_bom AS bom ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): tadir, ato_w_item
;

Learn More