atov_ta_import_check_relevant

DDL: ATOV_TA_IMPORT_CHECK_RELEVANT Type: view_entity

Automatic Import Check Col Versions

atov_ta_import_check_relevant is a CDS View that provides data about "Automatic Import Check Col Versions" in SAP S/4HANA. It reads from 5 data sources (ato_ta_imp_check, atov_changelist_minus_ignored, ato_cols, ATOV_CMN_NOT_IMPORTABLE, atov_col_ver_partially_importd) and exposes 2 fields.

5 data source(s) 2 fields

Data Sources (5)

SourceAliasJoin Type
ato_ta_imp_check check_result left_outer
atov_changelist_minus_ignored cl from
ato_cols col inner
ATOV_CMN_NOT_IMPORTABLE do_not_import left_outer
atov_col_ver_partially_importd partially_imported left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Automatic Import Check Col Versions view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (2)

KeyFieldSource TableSource FieldDescription
version atov_changelist_minus_ignored collection_version
invalidated ato_ta_imp_check invalidated 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Automatic Import Check Col Versions'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity atov_ta_import_check_relevant
  as select from    atov_changelist_minus_ignored  as cl
    inner join      ato_cols                       as col                on cl.collection_id = col.collection_id
    left outer join ato_ta_imp_check               as check_result       on  cl.collection_id      = check_result.collection_id
                                                                         and cl.collection_version = check_result.version
    left outer join ATOV_CMN_NOT_IMPORTABLE        as do_not_import      on  cl.collection_id      = do_not_import.collection_id
                                                                         and cl.collection_version = do_not_import.version
    left outer join atov_col_ver_partially_importd as partially_imported on  cl.collection_id      = partially_imported.collection_id
                                                                         and cl.collection_version = partially_imported.version

{
  cl.collection_id,
  cl.collection_version                        as version,
  coalesce(check_result.validation_result, '') as validation_result,
  check_result.invalidated                     as invalidated
}
where
       col.client                       = $session.client
  and  col.category                     <> 'B' // never run prevalidation checks for BC Plugin

  and  cl.status                        <> 'ID'
  and  cl.status                        <> 'I'
  and(
       check_result.validation_result   =  'D'
    or check_result.validation_result   =  'E'
    or check_result.validation_result   is null
    or check_result.invalidated         =  'X'
  )
  and  do_not_import.collection_id      is null
  and  partially_imported.collection_id is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_CHANGELIST_MINUS_IGNORED",
"ATOV_CMN_NOT_IMPORTABLE",
"ATOV_COL_VER_PARTIALLY_IMPORTD",
"ATO_COLS",
"ATO_TA_IMP_CHECK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More