ARSV_SWCMP_INSTALLED

DDL: ARSV_SWCMP_INSTALLED SQL: ARS_V_SCWMPI Type: view Package: S_ARS_LANGUAGE_VERSION_CONFIG
2 Fields 2 Data Sources

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 Softw. Comp.
componentwhenthenelseXendasis_intalled

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ARSV_SWCMP_INSTALLED.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ARS_V_SCWMPI

CREATE VIEW ARSV_SWCMP_INSTALLED AS
SELECT
  cvers.component AS component,
  case coalesce(cvers_ext.component, '') when '' then ' ' else 'X' end as is_intalled AS componentwhenthenelseXendasis_intalled
FROM cvers
LEFT OUTER JOIN cvers_ext ON /* join condition not captured in parsed metadata */
;

Learn More