ATOV_EXIST_ITEM_TYPES

DDL: ATOV_EXIST_ITEM_TYPES SQL: ATOV_E_ITEM_TYPE Type: view

ato item types existing current system

ATOV_EXIST_ITEM_TYPES is a CDS View that provides data about "ato item types existing current system" in SAP S/4HANA. It reads from 2 data sources (ato_item_header, ato_pk_items).

2 data source(s)

Data Sources (2)

SourceAliasJoin Type
ato_item_header ato_item_header union
ato_pk_items ato_pk_items from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ATOV_E_ITEM_TYPE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ato item types existing current system view 
@AbapCatalog.sqlViewName: 'ATOV_E_ITEM_TYPE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'ato item types existing current system'
define view ATOV_EXIST_ITEM_TYPES
  as select from ato_pk_items
{
  item_type
}
union select from ato_item_header
{
  item_type
}
where item_type <> '' // there was an error with an initial type

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATO_ITEM_HEADER",
"ATO_PK_ITEMS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More