Ehhss_Samples_At_Location

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_Samples_At_Location.
-- 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_SMPL4LOC
-- Parameters: p_def_langu : lang, p_sy_datlo : syst_datlo, p_sy_langu : lang

CREATE VIEW Ehhss_Samples_At_Location AS
SELECT
  Ehhss_Sampling_Campaign_Result.Sampling_Campaign_key AS Sampling_Campaign_key,
  Ehhss_Sampling_Campaign_Result.job_key_ref AS job_key_ref,
  Ehhss_Sampling_Campaign_Result.cma_key_ref AS cma_key_ref,
  Ehhss_Sampling_Campaign_Result.op_status AS op_status,
  Ehhss_Sampling_Campaign_Result.subject_name AS subject_name,
  Ehhss_Sampling_Campaign_Result.ListedSubstanceCndnCode AS ListedSubstanceCndnCode,
  Ehhss_Sampling_Campaign_Result.subjecttype AS subjecttype,
  Ehhss_Sampling_Campaign_Result.value AS value,
  Ehhss_Sampling_Campaign_Result.valueunit AS valueunit,
  Ehhss_Sampling_Campaign_Result.valuetype AS valuetype,
  Ehhss_Sampling_Campaign_Result.status AS status,
  Ehhss_Sampling_Campaign_Result.blank_type AS blank_type,
  Ehhss_Sampling_Campaign_Result.start_date AS start_date,
  Ehhss_Sampling_Campaign_Result.start_time AS start_time,
  Ehhss_Sampling_Campaign_Result.end_date AS end_date,
  Ehhss_Sampling_Campaign_Result.end_time AS end_time,
  Ehhss_Sampling_Campaign_Result.equipment_id AS equipment_id,
  Ehhss_Sampling_Campaign_Result.sample_id AS sample_id,
  Ehhss_Sampling_Campaign_Result.media_id AS media_id,
  Ehhss_Sampling_Campaign_Result.ppe_worn AS ppe_worn,
  Ehhss_Sampling_Campaign_Result.validity AS validity,
  Ehhss_Sampling_Campaign_Result.method_ref AS method_ref,
  Ehhss_Sampling_Campaign_Result.sample_count AS sample_count,
  Ehhss_Sampling_Campaign_Result.technician AS technician,
  Ehhss_Sampling_Campaign_Result.planned_date AS planned_date,
  Ehhss_Job_Name.name AS job_name,
  Ehhss_Sampling_Campaign_Result.plant_id AS plant_id,
  Ehhss_Sampling_Campaign_Result.cost_center AS cost_center,
  Ehhss_Sampling_Campaign_Result.company_code AS company_code,
  Ehhss_Sampling_Campaign_Result.buss_area AS buss_area,
  Ehhss_Sampling_Campaign_Result.country AS country,
  Ehhss_Sampling_Campaign_Result.region AS region,
  Ehfnd_SamplingMethod_Name.name AS method_text,
  Ehfnd_Samplingmethod_Media.name AS media_text,
  Ehfnd_Control_Name.name AS ppe_title
FROM Ehhss_Sampling_Campaign_Result
INNER JOIN Ehfnd_Lhr_Locations ON /* join condition not captured in parsed metadata */
;