atov_collection_type_import

DDL: ATOV_COLLECTION_TYPE_IMPORT Type: view_entity

Collection type for use at import

atov_collection_type_import is a CDS View that provides data about "Collection type for use at import" in SAP S/4HANA. It reads from 3 data sources (atov_cbc_collections_import, atov_cbc_collections_import, ato_cols) and exposes 1 field.

3 data source(s) 1 fields

Data Sources (3)

SourceAliasJoin Type
atov_cbc_collections_import atov_cbc_collections_import union_all
atov_cbc_collections_import cbc left_outer
ato_cols col from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Collection type for use at import view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (1)

KeyFieldSource TableSource FieldDescription
category 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Collection type for use at import'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity atov_collection_type_import
  
  // Select all but CBC collections

  as select from    ato_cols                    as col
    left outer join atov_cbc_collections_import as cbc on col.collection_id = cbc.collection_id
{
  key col.collection_id,
      col.collection_type,
      col.category
}
where
  cbc.collection_id is null

union all

// Select only CBC collections

select from atov_cbc_collections_import
{
  key collection_id,
      'X' as collection_type, // CBC

      '' as category
}

Learn More