ATOV_U_ITEM_BOM_BASE

DDL: ATOV_U_ITEM_BOM_BASE SQL: ATO_V_U_IBOM_B Type: view
11 Fields 2 Data Sources

Base of ATOV_U_ITEM_BOM

ATOV_U_ITEM_BOM_BASE is a CDS View that provides data about "Base of ATOV_U_ITEM_BOM" in SAP S/4HANA. It reads from 2 data sources (ato_conti_bom, ato_draft_bom) and exposes 11 fields with key fields item_type, item_id, bom_pgmid, bom_object, item_id.

Data Sources (2)

SourceAliasJoin Type
ato_conti_bom conti_bom union_all
ato_draft_bom draft_bom from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_U_IBOM_B view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Base of ATOV_U_ITEM_BOM view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY item_type ato_draft_bom item_type Type
KEY item_id ato_draft_bom item_id Simulation Item ID
KEY bom_pgmid ato_draft_bom bom_pgmid Program ID
KEY bom_object ato_draft_bom bom_object Object Type
draft_owner ato_draft_bom owner Vehicle Owner
item_type Type
KEY item_id ato_conti_bom item_id Simulation Item ID
KEY bom_pgmid ato_conti_bom bom_pgmid Program ID
KEY bom_object ato_conti_bom bom_object Object Type
draft_owner Vehicle Owner
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_BASE.
-- 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_B

CREATE VIEW ATOV_U_ITEM_BOM_BASE AS
SELECT
  draft_bom.item_type AS item_type,
  draft_bom.item_id AS item_id,
  draft_bom.bom_pgmid AS bom_pgmid,
  draft_bom.bom_object AS bom_object,
  draft_bom.owner AS draft_owner,
  '' AS is_draft
FROM ato_draft_bom AS draft_bom
-- UNION ALL with additional select branch(es): ato_conti_bom
;

Learn More