C_BOMMassMaintJob

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 C_BOMMassMaintJob.
-- 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 C_BOMMassMaintJob AS
SELECT
  job_name AS BOMJobName,
  job_run_count AS BOMJobSymbol,
  job_text AS BOMJobDescription,
  job_catalog_entry_name AS BOMJobCatalogEntryName,
  job_catalog_entry_text AS BOMJobCatalogEntryText,
  job_template_name AS BOMJobTemplateName,
  job_template_text AS BOMJobTemplateText,
  job_created_at AS BOMJobCreatedDateTime,
  job_created_by AS CreatedByUser,
  job_created_by_formatted_name AS CreatedByName,
  job_user AS UserID,
  job_user_formatted_name AS UserName,
  job_run_status AS BOMJobStatus,
  _StatusText.BOMJobStatusText AS BOMJobStatusText,
  job_run_planned_start_datetime AS BOMJobRunPlannedStartDateTime,
  job_recurrency AS BOMJobRecurrence,
  $session.user AS BOMJobSystemUser,
  cast ( ' ' as bom_mass_proc_st) AS BOMJobProcessStatus,
  cast ( ' ' as bom_mass_proc_st_txt) AS BOMJobProcessStatusText,
  cast ( ' ' as bom_mass_result_txt) AS BOMJobProcessResultText,
  cast ( ' ' as bom_mass_maint_op_type) AS BOMMassMaintOperationType,
  cast ( ' ' as flag ) AS BOMMassMaintHeaderFlag
FROM I_APJ_JOB_USR_OVERVIEW
LEFT OUTER JOIN I_BOMMassMaintJobStsTxtVH AS _StatusText ON BOMJobStatus = _StatusText.BOMJobStatusValue  -- association [0..1]
;