Ehhss_Sampling_Samples

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_Samples.
-- 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_SPLNG_SPL

CREATE VIEW Ehhss_Sampling_Samples AS
SELECT
  ehfndd_splng_spl.blank_type AS blank_type,
  ehfndd_splng_spl.id AS sample_id,
  ehfndd_splng_spl.media_id AS media_id,
  ehfndd_splng_spl.equipment_id AS equipment_id,
  ehfndd_splng_spl.ppe_worn AS ppe_worn,
  ehfndd_splng_spl.validity AS validity,
  ehfndd_splng_spl.is_reviewed AS is_reviewed,
  ehfndd_splng.status AS status,
  ehfndd_splng.method_ref AS method_ref,
  ehfndd_splng.sample_count AS sample_count,
  ehfndd_splng.technician AS technician,
  ehfndd_splng.planned_date AS planned_date,
  Ehhss_Sampling_Amounts.subjecttype AS subjecttype,
  Ehhss_Sampling_Amounts.value AS value,
  Ehhss_Sampling_Amounts.valueunit AS valueunit,
  Ehhss_Sampling_Amounts.valuetype AS valuetype
FROM ehfndd_splng_spl
INNER JOIN ehfndd_splng ON /* join condition not captured in parsed metadata */
INNER JOIN Ehhss_Sampling_Amounts ON /* join condition not captured in parsed metadata */
;