/SSB/ALERTS_JOB_USER_DETAILS

DDL: /SSB/ALERTS_JOB_USER_DETAILS SQL: /SSB/JOBALERTS Type: view
8 Fields 2 Data Sources

Details of user and job for alerts

/SSB/ALERTS_JOB_USER_DETAILS is a CDS View that provides data about "Details of user and job for alerts" in SAP S/4HANA. It reads from 2 data sources (/ssb/notif_job, /ssb/notif_kpis) and exposes 8 fields with key field kpi_user.

Data Sources (2)

SourceAliasJoin Type
/ssb/notif_job notify_job from
/ssb/notif_kpis notify_kpis inner

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName /SSB/JOBALERTS view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Details of user and job for alerts view
ObjectModel.usageType.serviceQuality #P view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY kpi_user kpi_user User ID
tile_id tile_id Tile ID
job_name /ssb/notif_kpis job_name Job No.
sap_client /ssb/notif_job sap_client SAP Client
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

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/ALERTS_JOB_USER_DETAILS.
-- 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/JOBALERTS

CREATE VIEW /SSB/ALERTS_JOB_USER_DETAILS AS
SELECT
  kpi_user,
  tile_id,
  notify_kpis.job_name AS job_name,
  notify_job.sap_client AS sap_client,
  created_by,
  created_on,
  changed_by,
  changed_on
FROM /ssb/notif_job AS notify_job
INNER JOIN /ssb/notif_kpis AS notify_kpis ON /* join condition not captured in parsed metadata */
;

Learn More