Atov_Item_Map

@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
}