Atov_Package_Map

DDL: ATOV_PACKAGE_MAP SQL: ATO_V_PACK_MAP Type: view

map itemtype / itemid to package

Atov_Package_Map is a CDS View that provides data about "map itemtype / itemid to package" in SAP S/4HANA. It reads from 2 data sources (Atov_Item_Map, tadir) and exposes 7 fields with key fields item_type, item_id.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
Atov_Item_Map item_map from
tadir tadir inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_PACK_MAP view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label map itemtype / itemid to package view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY item_type Atov_Item_Map item_type
KEY item_id Atov_Item_Map item_id
pgmid tadir pgmid
object tadir object
obj_name tadir obj_name
devclass tadir devclass
srcsystem tadir srcsystem 
@AbapCatalog.sqlViewName: 'ATO_V_PACK_MAP'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@EndUserText.label: 'map itemtype / itemid to package'
define view Atov_Package_Map as 

select from Atov_Item_Map as item_map

 inner join tadir as tadir
    on tadir.pgmid         = item_map.pgmid and
       tadir.object        = item_map.object and
       tadir.obj_name      = item_map.item_id

 {
    key item_map.item_type, 
    key item_map.item_id,
    tadir.pgmid,
    tadir.object,
    tadir.obj_name,
    tadir.devclass,
    tadir.srcsystem   
}   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_ITEM_MAP",
"TADIR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More