P_RqdPrsnlProtectiveEquipAtLoc

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 P_RqdPrsnlProtectiveEquipAtLoc.
-- 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: PPPEATLOC

CREATE VIEW P_RqdPrsnlProtectiveEquipAtLoc AS
SELECT
  EHSRiskControl.db_key AS EHSControlInstanceUUID,
  cast( EHSRiskRoot.loc_root_key_ref as ehfnd_location_uuid_ref preserving type ) AS EHSLocationUUID,
  cast( EHSRiskRoot.job_key_ref as ehhss_job_uuid_ref preserving type ) AS EHSJobUUID,
  cast( EHSRiskControl.root_key as ehhss_risk_key_ref preserving type ) AS EHSRiskUUID,
  EHSControlRoot.catalog_code AS EHSControlCatalog,
  EHSCtrlTitleTxt.text AS EHSControlTitle,
  EHSCtrlTitleTxt.language AS language,
  cast( EHSRiskControl.impl_status as ehhss_ctrl_impl_status_nc preserving type ) AS EHSControlImplStatus
FROM ehhssd_rsk_ctrl AS EHSRiskControl
INNER JOIN ehhssd_rsk_root AS EHSRiskRoot ON /* join condition not captured in parsed metadata */
INNER JOIN ehhssd_rsk_rev AS EHSRiskRevision ON /* join condition not captured in parsed metadata */
INNER JOIN ehfndd_ctrl_root AS EHSControlRoot ON /* join condition not captured in parsed metadata */
INNER JOIN ehfndc_control AS EHSCtrlCatalog ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ehfndd_ctrl_text AS EHSCtrlTitleTxt ON /* join condition not captured in parsed metadata */
;