EITV_EXP_ITEMS_ADD_BASE

DDL: EITV_EXP_ITEMS_ADD_BASE SQL: EIT_V_EXP_IADDB Type: view

Basic View for Add Items to Templates

EITV_EXP_ITEMS_ADD_BASE is a CDS View that provides data about "Basic View for Add Items to Templates" in SAP S/4HANA. It reads from 5 data sources (ato_cols, ato_item_header, ato_items, ato_prefix_set, EITV_EXP_ITEM_TYPE) and exposes 5 fields with key fields template_id, item_type, item_id.

5 data source(s) 5 fields

Data Sources (5)

SourceAliasJoin Type
ato_cols cols inner
ato_item_header item_head from
ato_items items inner
ato_prefix_set prefix_setting inner
EITV_EXP_ITEM_TYPE supported_type inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName EIT_V_EXP_IADDB view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Basic View for Add Items to Templates view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY template_id ato_cols collection_id
KEY item_type ato_item_header item_type
KEY item_id ato_item_header item_id
changed_by ato_items changed_by
changed_at ato_items last_notification 
@AbapCatalog.sqlViewName: 'EIT_V_EXP_IADDB'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Basic View for Add Items to Templates'
define view EITV_EXP_ITEMS_ADD_BASE as select from ato_item_header as item_head
inner join ato_cols as cols on
      cols.category  = 'T' and
      cols.status   <> 'H'

inner join ato_prefix_set as prefix_setting on
  prefix_setting.dev_prefix = item_head.prefix
  
inner join ato_items as items on
  items.item_type = item_head.item_type and
  items.item_id   = item_head.item_id     and
  items.timestamp = 0  
    
 inner join EITV_EXP_ITEM_TYPE as supported_type on
   items.item_type = supported_type.item_type  
  
 {
 key cols.collection_id as template_id,   
 key item_head.item_type,
 key item_head.item_id,
 items.item_description,
 items.changed_by,
 items.last_notification as changed_at
   
 
}
where prefix_setting.is_template_export_allowed =  'X' and
      items.item_status                         <> 'D'

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

Learn More