ATOV_ITEM_DEPENDENCIES

DDL: ATOV_ITEM_DEPENDENCIES SQL: ATO_V_ITEMDEP Type: view Package: S_ATO_PUBLIC

ATO Items Dependencies

ATOV_ITEM_DEPENDENCIES is a CDS View that provides data about "ATO Items Dependencies" in SAP S/4HANA. It reads from 9 data sources and exposes 3 fields with key fields item_type, item_id. Part of development package S_ATO_PUBLIC.

Data Sources (9)

SourceAliasJoin Type
ATOV_U_ITEM_DESCRIPTION dep_item_base left_outer
ATOV_REWORK_DEMAND dep_item_rework_demand left_outer
ATOV_ADAPTATION_TYPE dep_item_type left_outer
ato_adapt_typest dep_item_type_description left_outer
ATOV_U_ITEM_DESCRIPTION item_base left_outer
ato_conti_dep item_dep from
ATOV_REWORK_DEMAND item_rework_demand left_outer
ATOV_ADAPTATION_TYPE item_type left_outer
ato_adapt_typest item_type_description left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_ITEMDEP view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ATO Items Dependencies view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY item_type ato_conti_dep item_type Type
KEY item_id ato_conti_dep item_id Simulation Item ID
rework ATOV_REWORK_DEMAND Rework Rework Routing

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_ITEM_DEPENDENCIES.
-- 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_V_ITEMDEP

CREATE VIEW ATOV_ITEM_DEPENDENCIES AS
SELECT
  item_dep.item_type AS item_type,
  item_dep.item_id AS item_id,
  item_rework_demand.Rework AS rework
FROM ato_conti_dep AS item_dep
LEFT OUTER JOIN ato_adapt_typest AS item_type_description ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ato_adapt_typest AS dep_item_type_description ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_ADAPTATION_TYPE AS item_type ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_ADAPTATION_TYPE AS dep_item_type ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_U_ITEM_DESCRIPTION AS item_base ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_U_ITEM_DESCRIPTION AS dep_item_base ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_REWORK_DEMAND AS item_rework_demand ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_REWORK_DEMAND AS dep_item_rework_demand ON /* join condition not captured in parsed metadata */
;