Atov_Item_Map

DDL: ATOV_ITEM_MAP SQL: ATO_V_ITEM_MAP Type: view

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.

1 data source(s) 4 fields

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
KEY item_id ato_pk_items item_id
pgmid tadir_map pgmid
object tadir_map object 
@AbapCatalog.sqlViewName: 'ATO_V_ITEM_MAP'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@EndUserText.label: 'mapping for items'
define view Atov_Item_Map as 

//select from ato_tadir_map as tadir_map

//

// association [0..*] to ato_items as items

//    on items.item_type     = tadir_map.item_type and

//    tadir_map.fixed_rule   = 'X' and

//    items.timestamp = 0

    
    
select from ato_pk_items as items 

   association [0..1] to ato_tadir_map as tadir_map
    on items.item_type     = tadir_map.item_type and
    tadir_map.fixed_rule   = 'X'  

 {
    key items.item_type, 
    key items.item_id,
    tadir_map.pgmid,
    tadir_map.object
}   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATO_PK_ITEMS",
"ATO_TADIR_MAP"
],
"ASSOCIATED":
[
"ATO_TADIR_MAP"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More