ARSV_SWCMP_INSTALLED

DDL: ARSV_SWCMP_INSTALLED SQL: ARS_V_SCWMPI Type: view Package: S_ARS_LANGUAGE_VERSION_CONFIG

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. Part of development package S_ARS_LANGUAGE_VERSION_CONFIG.

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
}