I_PRAProcessRunHeader

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_PRAProcessRunHeader.
-- 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_PRAProcessRunHeader AS
SELECT
  run_id AS ProcessRun,
  proc_id AS PRAProcess,
  proc_grp AS PRARunProcessGroup,
  proc_subgrp1 AS PRARunProcessSubgroup1,
  proc_subgrp2 AS PRARunProcessSubgroup2,
  proc_subgrp3 AS PRARunProcessSubgroup3,
  proc_subgrp4 AS PRARunProcessSubgroup4,
  proc_subgrp5 AS PRARunProcessSubgroup5,
  land1 AS Country,
  pri_geo_loc AS PrimaryGeogrlLocation,
  eff_from_dt AS EffectiveFromDate,
  eff_to_dt AS EffectiveToDate,
  ac_ind AS AgencyReportType,
  ver AS PRAProcessVersionValue,
  tf_ind AS PRAProcessTrialFinalFlag,
  sdlstrtdt AS ScheduledStartDate,
  sdlstrttm AS ScheduledStartTime,
  laststrtdt AS PRAJobLatestExecutionDate,
  laststrttm AS PRAJobLatestExecutionTime,
  predjob AS PRAProcessJobName,
  predjobcnt AS PRAProcessJobID,
  checkstat AS PRAJobCheckStatus,
  eventid AS PRAJobEventID,
  eventparm AS PRAJobEventParameter,
  startdttyp AS PRAJobStartDateTypeID,
  prdmins AS PRAJobDurationMinutesValue,
  prdhours AS PRAJobDurationHoursValue,
  prddays AS PRAJobDurationDaysValue,
  prdweeks AS PRAJobDurationWeeksValue,
  prdmonths AS PRAProcessDurationMonthsVal,
  periodic AS ApplicationJobPeriodicity,
  instname AS PRAServerName,
  calendarid AS PRAProcessCalendarID,
  eomcorrect AS PRAJobMnthEndCrrtnValue,
  calcorrect AS PRAJobCalcdCrrtnValue,
  imstrtpos AS PRAProcessImmediateStart,
  prdbehav AS PRAProcessPeriodBehavior,
  wdayno AS PRAProcessWorkdayValue,
  wdaycdir AS PRAJobWorkdayDirectionValue,
  notbefore AS PRAJobNotBeforeDate,
  tmzone AS DisplayTimeZone,
  change_user AS LastChangedByUser,
  change_date AS LastChangeDate,
  change_time AS LastChangeTime
FROM oiue2_run_hdr
LEFT OUTER JOIN I_PRAProcessVH AS _PRAProcess ON _PRAProcess.PRAProcess = PRAProcess  -- association [1..1]
LEFT OUTER JOIN I_PRAProcessGroupVH AS _PRAProcessGroup ON _PRAProcessGroup.PRAProcess = PRAProcess AND _PRAProcessGroup.PRARunProcessGroup = PRARunProcessGroup  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON _Country.Country = Country  -- association [0..1]
LEFT OUTER JOIN I_PrimaryGeogrlLocation AS _PrimaryGeogrlLocation ON _PrimaryGeogrlLocation.PrimaryGeogrlLocation = PrimaryGeogrlLocation AND _PrimaryGeogrlLocation.Country = Country  -- association [0..1]
LEFT OUTER JOIN I_AgencyReportType AS _AgencyReportType ON _AgencyReportType.AgencyReportType = AgencyReportType  -- association [0..1]
;