Atov_U_Item_Bom

DDL: ATOV_U_ITEM_BOM SQL: ATO_V_U_IBOM Type: view
6 Fields 1 Data Sources 2 Associations

Bill of Material for ATO Items

Atov_U_Item_Bom is a CDS View that provides data about "Bill of Material for ATO Items" in SAP S/4HANA. It reads from 1 data source (ATOV_U_ITEM_BOM_BASE) and exposes 6 fields with key fields item_type, item_id, bom_pgmid, bom_object. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ATOV_U_ITEM_BOM_BASE item_bom_base from

Associations (2)

CardinalityTargetAliasCondition
[0..1] ato_adapt_typest item_type_description item_type_description.adaptation_type = item_bom_base.item_type and item_type_description.language = $session.system_language
[0..1] ATOV_U_ITEM_BASE_S item_base item_base.item_type = item_bom_base.item_type and item_base.item_id = item_bom_base.item_id

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_U_IBOM view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Bill of Material for ATO Items view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY item_type ATOV_U_ITEM_BOM_BASE item_type Type
KEY item_id ATOV_U_ITEM_BOM_BASE item_id Simulation Item ID
KEY bom_pgmid ATOV_U_ITEM_BOM_BASE bom_pgmid Program ID
KEY bom_object ATOV_U_ITEM_BOM_BASE bom_object Object Type
draft_owner ATOV_U_ITEM_BOM_BASE draft_owner Vehicle Owner
is_draft ATOV_U_ITEM_BOM_BASE is_draft Is Draft

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_U_Item_Bom.
-- 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_U_IBOM

CREATE VIEW Atov_U_Item_Bom AS
SELECT
  item_bom_base.item_type AS item_type,
  item_bom_base.item_id AS item_id,
  item_bom_base.bom_pgmid AS bom_pgmid,
  item_bom_base.bom_object AS bom_object,
  item_bom_base.draft_owner AS draft_owner,
  item_bom_base.is_draft AS is_draft
FROM ATOV_U_ITEM_BOM_BASE AS item_bom_base
LEFT OUTER JOIN ato_adapt_typest AS item_type_description ON item_type_description.adaptation_type = item_bom_base.item_type AND item_type_description.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN ATOV_U_ITEM_BASE_S AS item_base ON item_base.item_type = item_bom_base.item_type AND item_base.item_id = item_bom_base.item_id  -- association [0..1]
;

Learn More