A_EHSLocationForSafetyInfo

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 A_EHSLocationForSafetyInfo.
-- 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: AEHSLOCFORSRI

CREATE VIEW A_EHSLocationForSafetyInfo AS
SELECT
  EHSLocationUUID,
  EHSLocationType,
  EHSLocationStatus,
  EHSLocationAuthorizationGroup,
  Plant,
  ControllingArea,
  CostCenter,
  CompanyCode,
  BusinessArea,
  RevisionStartDate,
  RevisionEndDate
FROM I_EHSLocationRevision
LEFT OUTER JOIN A_EHSLocationTypeText AS _EHSLocationTypeText ON EHSLocationType = _EHSLocationTypeText.EHSLocationType  -- association [0..*]
LEFT OUTER JOIN A_CurrentEHSLocationNameText AS _CurrentEHSLocationNameText ON EHSLocationUUID = _CurrentEHSLocationNameText.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN A_EHSControlForSafetyInfo AS _EHSControls ON EHSLocationUUID = _EHSControls.EHSLocationUUID AND _EHSControls.EHSJobUUIDHex = '00000000000000000000000000000000'  -- association [0..*]
LEFT OUTER JOIN A_EHSRiskForSafetyInfo AS _EHSRisks ON EHSLocationUUID = _EHSRisks.EHSLocationUUID AND _EHSRisks.EHSJobUUIDHex = '00000000000000000000000000000000'  -- association [0..*]
LEFT OUTER JOIN A_ChemicalForSafetyInfo AS _Chemicals ON EHSLocationUUID = _Chemicals.EHSLocationUUID AND _Chemicals.EHSJobUUIDHex = '00000000000000000000000000000000'  -- association [0..*]
LEFT OUTER JOIN A_EHSJobForSafetyInfo AS _EHSJobs ON EHSLocationUUID = _EHSJobs.EHSLocationUUID  -- association [0..*]
;