I_ProcMonThresholdLog

DDL: I_PROCMONTHRESHOLDLOG SQL: IPOCTHLDLOG Type: view BASIC Package: BS_POC_CDS

Process Observer: Threshold Log

I_ProcMonThresholdLog is a Basic CDS View that provides data about "Process Observer: Threshold Log" in SAP S/4HANA. It reads from 1 data source (poc_d_track_thr2) and exposes 10 fields with key fields ProcObsvrProcessUUID, ProcObsvrKPIDefinition, ValuationNumber, ProcObsvrThresholdDefinition. Part of development package BS_POC_CDS.

Data Sources (1)

SourceAliasJoin Type
poc_d_track_thr2 poc_d_track_thr2 from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPOCTHLDLOG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Process Observer: Threshold Log view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ProcObsvrProcessUUID process_id Process Instance ID
KEY ProcObsvrKPIDefinition kpi_type_id KPI Definition
KEY ValuationNumber valuation_id Valuation ID
KEY ProcObsvrThresholdDefinition thr_def_id Threshold
ProcObsvrCountThreshold thr_count Count Threshold
ProcObsvrDurationThreshold thr_duration Dur. Threshold
ProcObsvrDurationThresholdUnit thr_dura_unit Unit
ProcObsvrThldNotifUTCDateTime thr_notif_time Notif.Time
ProcObsvrThldNotifSystDate thr_notif_sydate Current Date
ProcObsvrThldNotifSystTime thr_notif_sytime Time

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 I_ProcMonThresholdLog.
-- 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: IPOCTHLDLOG

CREATE VIEW I_ProcMonThresholdLog AS
SELECT
  process_id AS ProcObsvrProcessUUID,
  kpi_type_id AS ProcObsvrKPIDefinition,
  valuation_id AS ValuationNumber,
  thr_def_id AS ProcObsvrThresholdDefinition,
  thr_count AS ProcObsvrCountThreshold,
  thr_duration AS ProcObsvrDurationThreshold,
  thr_dura_unit AS ProcObsvrDurationThresholdUnit,
  thr_notif_time AS ProcObsvrThldNotifUTCDateTime,
  thr_notif_sydate AS ProcObsvrThldNotifSystDate,
  thr_notif_sytime AS ProcObsvrThldNotifSystTime
FROM poc_d_track_thr2
;