ARS_V_DISTR_SYS_CONF

DDL: ARS_V_DISTR_SYS_CONF SQL: ARS_V_SNPSYSCNF Type: view Package: S_ARS_API_VERSIONS_UI
5 Fields 3 Data Sources

API Snapshot Distrib.: System Config

ARS_V_DISTR_SYS_CONF is a CDS View that provides data about "API Snapshot Distrib.: System Config" in SAP S/4HANA. It reads from 3 data sources (ars_sw_trgt_sys, ars_snap_conf, ars_trgt_sys) and exposes 5 fields with key fields component, destination, destination. Part of development package S_ARS_API_VERSIONS_UI.

Data Sources (3)

SourceAliasJoin Type
ars_sw_trgt_sys ars_sw_trgt_sys union_all
ars_snap_conf conf from
ars_trgt_sys trgt_sys left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ARS_V_SNPSYSCNF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label API Snapshot Distrib.: System Config view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY component sw_component Softw. Comp.
KEY destination rfc_destination Remote System
description description Well Code Des.
KEY destination rfc_destination Remote System
description description Well Code Des.

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 ARS_V_DISTR_SYS_CONF.
-- 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_SNPSYSCNF

CREATE VIEW ARS_V_DISTR_SYS_CONF AS
SELECT
  sw_component AS component,
  rfc_destination AS destination,
  description
FROM ars_snap_conf AS conf
LEFT OUTER JOIN ars_trgt_sys AS trgt_sys ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): ars_sw_trgt_sys
;

Learn More