ARSV_SWCMP_INSTALLED

DDL: ARSV_SWCMP_INSTALLED SQL: ARS_V_SCWMPI Type: view

Is Software Componsnts installed

ARSV_SWCMP_INSTALLED is a CDS View that provides data about "Is Software Componsnts installed" in SAP S/4HANA. It reads from 2 data sources (cvers, cvers_ext) and exposes 2 fields with key field component.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
cvers cvers from
cvers_ext cvers_ext left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ARS_V_SCWMPI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Is Software Componsnts installed view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY component cvers component
componentwhenthenelseXendasis_intalled 
@AbapCatalog.sqlViewName: 'ARS_V_SCWMPI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Is Software Componsnts installed'
define view ARSV_SWCMP_INSTALLED as select from cvers as cvers
// INSTALLED Software COmponents exist in CVERS_EXT


left outer join cvers_ext as cvers_ext on cvers.component = cvers_ext.component 
{
key cvers.component as component,
case coalesce(cvers_ext.component, '')  when '' then ' '
     else 'X' 
     end as is_intalled
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CVERS",
"CVERS_EXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More