I_CurEHSLocationInclRoot

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 I_CurEHSLocationInclRoot.
-- 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: ICUREHSLOCINCLR

CREATE VIEW I_CurEHSLocationInclRoot AS
SELECT
  I_EHSLocation.EHSLocationUUID AS EHSLocationUUID,
  I_EHSLocation.RevisionEndDate AS RevisionEndDate,
  I_EHSLocation.RevisionStartDate AS RevisionStartDate,
  _LocTextDesc.EHSLocationName AS EHSLocationName,
  I_EHSLocationRevisionBasic.EHSLocationType AS EHSLocationType,
  I_EHSLocationRevisionBasic.EHSLocationStatus AS EHSLocationStatus,
  I_EHSLocationHierarchyNode.EHSParentLocationUUID AS EHSParentLocationUUID,
  I_EHSLocationRevisionBasic.Plant AS Plant,
  I_EHSLocation.EHSLocationID AS EHSLocationID,
  case when MyEHSLocation.EHSLocationUUID is null then cast( hextobin( 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFE' ) as ehfnd_location_uuid_ref preserving type) else MyEHSLocation.EHSLocationUUID end as MyEHSLocationUUID AS EHSLocationUUIDendasMyEHSLocationUUID,
  _EHSLocationTypeText.EHSLocationTypeText AS EHSLocationTypeText,
  _EHSLocAllClassifiersText.EHSLocClassifiersText AS EHSLocClassifiersText,
  cast( I_EHSLocationRevisionBasic.EHSLocationAuthorizationGroup as ehfnd_loc_auth_group_nc preserving type ) AS EHSLocationAuthorizationGroup,
  I_EHSLocationRevisionBasic.CostCenter AS CostCenter,
  I_EHSLocationRevisionBasic.CompanyCode AS CompanyCode,
  I_EHSLocationRevisionBasic.BusinessArea AS BusinessArea,
  cast( hextobin( '00000000000000000000000000000000' ) as ehfnd_location_uuid_ref preserving type ) AS EHSLocationRevisionUUID
FROM I_EHSLocation
INNER JOIN I_EHSLocationHierarchyRevision ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSLocationHierarchyNode ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSLocationRevisionBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MyEHSLocation AS MyEHSLocation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSLocNameRevsnFallbackLang AS _LocTextDesc ON EHSLocationRevisionUUID = _LocTextDesc.EHSLocationRevisionUUID  -- association [1..1]
LEFT OUTER JOIN I_EHSLocationTypeText AS _EHSLocationTypeText ON EHSLocationType = _EHSLocationTypeText.EHSLocationType AND _EHSLocationTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_CurEHSLocationInclRoot AS _ParentLocation ON EHSParentLocationUUID = _ParentLocation.EHSLocationUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSLocAllClassifiersText AS _EHSLocAllClassifiersText ON EHSLocationUUID = _EHSLocAllClassifiersText.EHSLocationUUID  -- association [0..1]
LEFT OUTER JOIN I_OTRText AS _OTRLocationsText ON _OTRLocationsText.OnlnTxtRpstryConceptID = '4544824ECF3DF419E10000000A428B9F' AND _OTRLocationsText.Language = $session.system_language  -- association [0..1]
-- UNION with additional select branch(es): I_SAPClient
;