ATOV_SOFTWARE_COMP_OF_OBJECT

DDL: ATOV_SOFTWARE_COMP_OF_OBJECT SQL: ATO_V_SWCOMP Type: view

Get Software Comp of DEV Object in Dev System

ATOV_SOFTWARE_COMP_OF_OBJECT is a CDS View that provides data about "Get Software Comp of DEV Object in Dev System" in SAP S/4HANA. It reads from 3 data sources (ARS_SOFTWARE_COMPONENTS_SCP, tadir, tdevc) and exposes 4 fields.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
ARS_SOFTWARE_COMPONENTS_SCP abap_config left_outer
tadir tadir from
tdevc tdevc inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_SWCOMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Get Software Comp of DEV Object in Dev System view

Fields (4)

KeyFieldSource TableSource FieldDescription
program_id tadir pgmid
object_type tadir object
object_name tadir obj_name
is_generated tadir genflag 
@AbapCatalog.sqlViewName: 'ATO_V_SWCOMP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Get Software Comp of DEV Object in Dev System'
define view ATOV_SOFTWARE_COMP_OF_OBJECT
  as select from    tadir                       as tadir
    inner join      tdevc                       as tdevc       on tdevc.devclass = tadir.devclass
    left outer join ARS_SOFTWARE_COMPONENTS_SCP as abap_config on abap_config.software_component = tdevc.dlvunit
{
  tadir.pgmid                                           as program_id,
  tadir.object                                          as object_type,
  tadir.obj_name                                        as object_name,
  tadir.devclass                                        as development_package,
  tadir.genflag                                         as is_generated,
  tadir.srcsystem                                       as source_system,
  coalesce(abap_config.software_component, '')          as custom_dev_software_component,
  coalesce(abap_config.is_installed_component, '')      as installed_component,
  coalesce(abap_config.is_local_software_component, '') as local_software_component

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

Learn More