/ssb/Union_Evaluations

DDL: /SSB/UNION_EVALUATIONS SQL: /SSB/_UEV Type: view

Evaluations after union of Tables

/ssb/Union_Evaluations is a CDS View that provides data about "Evaluations after union of Tables" in SAP S/4HANA. It reads from 3 data sources (/ssb/eval_s, /ssb/evals, /SSB/SAPCLIENT) and exposes 37 fields with key fields id, is_active, is_active.

Data Sources (3)

SourceAliasJoin Type
/ssb/eval_s /ssb/eval_s from
/ssb/evals /ssb/evals union_all
/SSB/SAPCLIENT SC inner

Annotations (7)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName /SSB/_UEV view
EndUserText.label Evaluations after union of Tables view
ObjectModel.usageType.serviceQuality #P view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
KEY is_active is_active Truth Value
indicator_id indicator_id Indicator ID
namespace
scaling scaling Scaling
odata_url odata_url ODATA URL
view_name view_name View Name
column_name column_name Column Name
owner_name owner_name Name
owner_e_mail owner_e_mail E-Mail Addr.
owner_id owner_id User ID
created_by created_by Version Created By
created_on created_on Variant created on
changed_by changed_by User Name
changed_on changed_on Variant Changed on
action action User action
description Well Code Des.
goal_type goal_type Goal Type
ref_eval_id Technical Object
KEY is_active is_active Truth Value
indicator_id indicator_id Indicator ID
namespace
scaling scaling Scaling
odata_url odata_url ODATA URL
view_name view_name View Name
column_name column_name Column Name
owner_name owner_name Name
owner_e_mail owner_e_mail E-Mail Addr.
owner_id owner_id User ID
created_by created_by Version Created By
created_on created_on Variant created on
changed_by changed_by User Name
changed_on changed_on Variant Changed on
action action User action
description description Well Code Des.
goal_type goal_type Goal Type
ref_eval_id ref_id Technical Object

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 /ssb/Union_Evaluations.
-- 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: /SSB/_UEV

CREATE VIEW /ssb/Union_Evaluations AS
SELECT
  id,
  is_active,
  indicator_id,
  'S' AS namespace,
  scaling,
  odata_url,
  view_name,
  column_name,
  owner_name,
  owner_e_mail,
  owner_id,
  created_by,
  created_on,
  changed_by,
  changed_on,
  action,
  cast('' as /ssb/text) AS description,
  goal_type,
  cast('' as /ssb/id) AS ref_eval_id
FROM /ssb/eval_s
INNER JOIN /SSB/SAPCLIENT AS SC ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): /ssb/evals
;