I_OrganizationalChangeActivity

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_OrganizationalChangeActivity.
-- 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: IFINOCACTIVITY

CREATE VIEW I_OrganizationalChangeActivity AS
SELECT
  _Activity.activity AS OrganizationalChangeActivity,
  _Activity.orgl_change AS OrganizationalChange,
  _Activity.job_type AS OrganizationalChangeJobType,
  _Activity.jobname AS ApplicationJobName,
  _Activity.jobcount AS ApplicationJob,
  _Activity.appl_log_number AS ApplicationLog,
  _OrglChangeApplicationLog.ApplicationLogHandle AS ApplicationLogHandle,
  _Activity.num_wmsg AS NumberOfUniqueWarnings,
  _Activity.num_emsg AS NumberOfUniqueErrors,
  case when _Activity.jobstatus='F' then 'F' when _ApplicationJob.status = '' then _Activity.jobstatus else _ApplicationJob.status end as JobStatusValue AS statusendasJobStatusValue,
  case when _Activity.jobstatus='F' then _JobStatustext.ddtext when _Statustext.ddtext = '' then _JobStatustext.ddtext else _Statustext.ddtext end as ApplicationJobStatusText AS ddtextendasApplicationJobStatusText,
  _Activity.activity_timestamp AS OrglChangeActivityDateTime,
  _Activity.triggered_by AS OrglChangeActivityProcdByUser,
  _Activity.status_to AS OrglChangeProcessingStatus
FROM finoc_activity AS _Activity
LEFT OUTER JOIN tbtco AS _ApplicationJob ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS _JobStatustext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS _Statustext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrglChangeJobTypeText AS _JobTypeText ON OrganizationalChangeJobType = _JobTypeText.OrganizationalChangeJobType  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON OrglChangeActivityProcdByUser = _UserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_OrglChangeProcgStatusText AS _OrglChangeProcgStatusText ON OrglChangeProcessingStatus = _OrglChangeProcgStatusText.OrglChangeProcessingStatus  -- association [0..*]
LEFT OUTER JOIN I_OrganizationalChange AS _OrganizationalChange ON OrganizationalChange = _OrganizationalChange.OrganizationalChange  -- association [1]
LEFT OUTER JOIN I_OrglChangeApplicationLog AS _OrglChangeApplicationLog ON ApplicationLog = _OrglChangeApplicationLog.ApplicationLog  -- association [0..1]
;