ARS_V_API_VERSION_HEADER

DDL: ARS_V_API_VERSION_HEADER SQL: ARS_V_API_V_H Type: view

Software Component of Objects

ARS_V_API_VERSION_HEADER is a CDS View that provides data about "Software Component of Objects" in SAP S/4HANA. It reads from 3 data sources (cvers, tadir, tdevc) and exposes 4 fields.

Data Sources (3)

SourceAliasJoin Type
cvers cvers left_outer
tadir tadir from
tdevc tdevc inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ARS_V_API_V_H view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Software Component of Objects view

Fields (4)

KeyFieldSource TableSource FieldDescription
program_id tadir pgmid
object_type tadir object
object_name tadir obj_name
package_name tadir devclass
@AbapCatalog.sqlViewName: 'ARS_V_API_V_H'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Software Component of Objects'
define view ARS_V_API_VERSION_HEADER
  as select from    tadir
    inner join      tdevc on tdevc.devclass = tadir.devclass
    left outer join cvers on cvers.component = tdevc.dlvunit
{
  tadir.pgmid      as program_id,
  tadir.object     as object_type,
  tadir.obj_name   as object_name,
  tadir.devclass   as package_name,
  tdevc.dlvunit    as software_component,
  coalesce(cvers.release, '0000000000') as major_release,
  cvers.extrelease as minor_release
}
where
  tadir.delflag = #ABAP_BOOLEAN.' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CVERS",
"TADIR",
"TDEVC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/