Ehhss_Sampling_Campaign_Allres

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_Allres.
-- 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_ARS

CREATE VIEW Ehhss_Sampling_Campaign_Allres AS
SELECT
  ehhssd_splcp.db_key AS Sampling_Campaign_key,
  ehhssd_splcp_tar.job_key_ref AS job_key_ref,
  ehhssd_splcp_tar.cma_key_ref AS cma_key_ref,
  ehhssd_splcp_spl.op_status AS op_status,
  Ehhss_Sampling_Samples.subjecttype AS subjecttype,
  Ehhss_Sampling_Samples.value AS value,
  Ehhss_Sampling_Samples.valueunit AS valueunit,
  Ehhss_Sampling_Samples.valuetype AS valuetype,
  Ehhss_Sampling_Samples.status AS status,
  Ehhss_Sampling_Samples.is_reviewed AS is_reviewed,
  Ehhss_Sampling_Samples.blank_type AS blank_type,
  cast(substring(cast(Ehhss_Sampling_Samples.start_timestamp as abap.char(17)), 1, 8) as abap.dats) AS start_date,
  cast(substring(cast(Ehhss_Sampling_Samples.start_timestamp as abap.char(17)), 9, 6) as abap.tims) AS start_time,
  cast(substring(cast(Ehhss_Sampling_Samples.end_timestamp as abap.char(17)), 1, 8) as abap.dats) AS end_date,
  cast(substring(cast(Ehhss_Sampling_Samples.end_timestamp as abap.char(17)), 9, 6) as abap.tims) AS end_time,
  Ehhss_Sampling_Samples.equipment_id AS equipment_id,
  Ehhss_Sampling_Samples.sample_id AS sample_id,
  Ehhss_Sampling_Samples.media_id AS media_id,
  Ehhss_Sampling_Samples.ppe_worn AS ppe_worn,
  Ehhss_Sampling_Samples.validity AS validity,
  Ehhss_Sampling_Samples.method_ref AS method_ref,
  Ehhss_Sampling_Samples.sample_count AS sample_count,
  Ehhss_Sampling_Samples.technician AS technician,
  Ehhss_Sampling_Samples.planned_date AS planned_date,
  Ehfnd_Loc_Current_Revision.name AS loc_name,
  Ehfnd_Loc_Current_Revision.plant_id AS plant_id,
  Ehfnd_Loc_Current_Revision.cost_center AS cost_center,
  Ehfnd_Loc_Current_Revision.company_code AS company_code,
  Ehfnd_Loc_Current_Revision.buss_area AS buss_area,
  Ehfnd_Loc_Current_Revision.country AS country,
  Ehfnd_Loc_Current_Revision.region AS region
FROM ehhssd_splcp
INNER JOIN ehhssd_splcp_tar ON /* join condition not captured in parsed metadata */
INNER JOIN ehhssd_splcp_spl ON /* join condition not captured in parsed metadata */
INNER JOIN Ehhss_Sampling_Samples ON /* join condition not captured in parsed metadata */
INNER JOIN Ehfnd_Loc_Current_Revision ON /* join condition not captured in parsed metadata */
;