Ehhss_Sampling_Campaign_Result

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 Ehhss_Sampling_Campaign_Result.
-- 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: EHHSSV_SPLCP_RES
-- Parameters: p_def_langu : lang, p_sy_langu : lang

CREATE VIEW Ehhss_Sampling_Campaign_Result AS
SELECT
  Ehhss_Sampling_Campaign_Allres.Sampling_Campaign_key AS Sampling_Campaign_key,
  Ehhss_Sampling_Campaign_Allres.job_key_ref AS job_key_ref,
  Ehhss_Sampling_Campaign_Allres.cma_key_ref AS cma_key_ref,
  Ehhss_Sampling_Campaign_Allres.op_status AS op_status,
  Ehhss_Sampling_Campaign_Allres.is_reviewed AS is_reviewed,
  Ehhss_Sampling_Agent_Name.subject_name AS subject_name,
  Ehhss_Sampling_Agent_Name.ListedSubstanceCndnCode AS ListedSubstanceCndnCode,
  Ehhss_Sampling_Campaign_Allres.subjecttype AS subjecttype,
  Ehhss_Sampling_Campaign_Allres.value AS value,
  Ehhss_Sampling_Campaign_Allres.valueunit AS valueunit,
  Ehhss_Sampling_Campaign_Allres.valuetype AS valuetype,
  Ehhss_Sampling_Campaign_Allres.status AS status,
  Ehhss_Sampling_Campaign_Allres.blank_type AS blank_type,
  Ehhss_Sampling_Campaign_Allres.start_date AS start_date,
  Ehhss_Sampling_Campaign_Allres.start_time AS start_time,
  Ehhss_Sampling_Campaign_Allres.end_date AS end_date,
  Ehhss_Sampling_Campaign_Allres.end_time AS end_time,
  Ehhss_Sampling_Campaign_Allres.equipment_id AS equipment_id,
  Ehhss_Sampling_Campaign_Allres.sample_id AS sample_id,
  Ehhss_Sampling_Campaign_Allres.media_id AS media_id,
  Ehhss_Sampling_Campaign_Allres.ppe_worn AS ppe_worn,
  Ehhss_Sampling_Campaign_Allres.validity AS validity,
  Ehhss_Sampling_Campaign_Allres.method_ref AS method_ref,
  Ehhss_Sampling_Campaign_Allres.sample_count AS sample_count,
  Ehhss_Sampling_Campaign_Allres.technician AS technician,
  Ehhss_Sampling_Campaign_Allres.planned_date AS planned_date,
  Ehhss_Sampling_Campaign_Allres.loc_name AS loc_name,
  Ehhss_Sampling_Campaign_Allres.plant_id AS plant_id,
  Ehhss_Sampling_Campaign_Allres.cost_center AS cost_center,
  Ehhss_Sampling_Campaign_Allres.company_code AS company_code,
  Ehhss_Sampling_Campaign_Allres.buss_area AS buss_area,
  Ehhss_Sampling_Campaign_Allres.country AS country,
  Ehhss_Sampling_Campaign_Allres.region AS region
FROM Ehhss_Sampling_Campaign_Allres
INNER JOIN Ehhss_Sampling_Agent_Name ON /* join condition not captured in parsed metadata */
;