ESH_PS_CDS_BOOSTS

DDL: ESH_PS_CDS_BOOSTS SQL: ESH_PS_BOOST Type: view

Boosts

ESH_PS_CDS_BOOSTS is a CDS View that provides data about "Boosts" in SAP S/4HANA. It reads from 3 data sources (esh_om_ardim, esh_om_ardims, esh_om_ardimt) and exposes 11 fields with key field boost_id.

Data Sources (3)

SourceAliasJoin Type
esh_om_ardim esh_om_ardim left_outer
esh_om_ardims esh_om_ardims from
esh_om_ardimt esh_om_ardimt left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ESH_PS_BOOST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Boosts view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY boost_id s rdims_guid Boost Id
maint_type d maint_type Maint. Type
ps_provider d ps_provider Pers. Srch Provider
significance s significance Significance
user_id s user_id Ranking Factor Attribute
attribute a rdim_attr Attribute
sign ss sign Type of SIGN component in row type of a Ranges type
opt ss opt Type of OPTION component in row type of a Ranges type
low ss low Value from
high ss high Value up to
changed_on s timestmp_mod_seg Changed On

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 ESH_PS_CDS_BOOSTS.
-- 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: ESH_PS_BOOST

CREATE VIEW ESH_PS_CDS_BOOSTS AS
SELECT
  s.rdims_guid AS boost_id,
  d.maint_type AS maint_type,
  d.ps_provider AS ps_provider,
  s.significance AS significance,
  s.user_id AS user_id,
  a.rdim_attr AS attribute,
  ss.sign AS sign,
  ss.opt AS opt,
  ss.low AS low,
  ss.high AS high,
  s.timestmp_mod_seg AS changed_on
FROM esh_om_ardims
LEFT OUTER JOIN esh_om_ardim ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN esh_om_ardimt ON /* join condition not captured in parsed metadata */
;