I_SchedulingRunRequestResult

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_SchedulingRunRequestResult.
-- 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.

CREATE VIEW I_SchedulingRunRequestResult AS
SELECT
  result_uuid AS SchedulingRunResultUUID,
  request_uuid AS SchedulingRunRequestUUID,
  run_uuid AS SchedulingRunUUID,
  activity_id AS SchedulingActivity,
  sequence_no AS SchedgActivitySequenceNumber,
  timestamp_start AS SchedgActivityStartDateTime,
  timestamp_end AS SchedulingActivityEndDateTime,
  tzone AS SchedulingActivityTimeZone,
  iana_tzone AS TimeZoneIANACode,
  gross_duration AS SchedgGrossDurationInSeconds,
  duration_day AS SchedulingDurationInDays,
  duration_hour AS SchedulingDurationInHours,
  calendar AS SchedulingCalendar,
  working_time AS SchedulingWorkingTimeID,
  date_type_start AS SchedulingStartDateType,
  date_type_end AS SchedulingEndDateType
FROM bps_result
LEFT OUTER JOIN I_SchedulingRun AS _SchedulingRun ON SchedulingRunUUID = _SchedulingRun.SchedulingRunUUID  -- association [1..1]
LEFT OUTER JOIN I_TimeZoneIANACodeMap AS _IANATimeZone ON TimeZoneIANACode = _IANATimeZone.TimeZoneIANACode  -- association [1..1]
LEFT OUTER JOIN I_SchedulingActivity AS _Activity ON SchedulingActivity = _Activity.SchedulingActivity  -- association [0..1]
LEFT OUTER JOIN I_SchedulingDateType AS _StartDateType ON SchedulingStartDateType = _StartDateType.SchedulingDateType  -- association [0..1]
LEFT OUTER JOIN I_SchedulingDateType AS _EndDateType ON SchedulingEndDateType = _EndDateType.SchedulingDateType  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _Calendar ON SchedulingCalendar = _Calendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_SchedulingWorkingTime AS _WorkingTime ON SchedulingWorkingTimeID = _WorkingTime.SchedulingWorkingTimeID AND SchedulingCalendar = _WorkingTime.SchedulingCalendar  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _TimeZone ON SchedulingActivityTimeZone = _TimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_SchedgRsltDetermination AS _Determination ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_SchedgRsltWrkgTmeInterval AS _Interval ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_SchedulingResultMessage AS _Message ON /* condition not available in parsed metadata */  -- association [0..*]
;