Atov_Item_Map

DDL: ATOV_ITEM_MAP SQL: ATO_V_ITEM_MAP Type: view Package: S_ATO_PK_CORE
4 Fields 1 Data Sources 1 Associations

mapping for items

Atov_Item_Map is a CDS View that provides data about "mapping for items" in SAP S/4HANA. It reads from 1 data source (ato_pk_items) and exposes 4 fields with key fields item_type, item_id. It has 1 association to related views. Part of development package S_ATO_PK_CORE.

Data Sources (1)

SourceAliasJoin Type
ato_pk_items items from

Associations (1)

CardinalityTargetAliasCondition
[0..1] ato_tadir_map tadir_map items.item_type = tadir_map.item_type and tadir_map.fixed_rule = 'X'

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_ITEM_MAP view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label mapping for items view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY item_type ato_pk_items item_type Type
KEY item_id ato_pk_items item_id Simulation Item ID
pgmid tadir_map pgmid Program Name
object tadir_map object TRFM Object

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_Map.
-- 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_ITEM_MAP

CREATE VIEW Atov_Item_Map AS
SELECT
  items.item_type AS item_type,
  items.item_id AS item_id,
  tadir_map.pgmid AS pgmid,
  tadir_map.object AS object
FROM ato_pk_items AS items
LEFT OUTER JOIN ato_tadir_map AS tadir_map ON items.item_type = tadir_map.item_type AND tadir_map.fixed_rule = 'X'  -- association [0..1]
;

Learn More