I_EnvWstTranspDocWasteLocation

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_EnvWstTranspDocWasteLocation.
-- 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.

CREATE VIEW I_EnvWstTranspDocWasteLocation AS
SELECT
  _Location.EHSLocationUUID AS EnvrmtWasteGnrtrUUID,
  _Location.EHSLocationID AS EHSLocationID,
  _Location.EHSLocationPhone AS EHSLocationPhone,
  _Location.Country AS Country,
  _Location.Region AS Region,
  _Location.CityName AS CityName,
  _Location.StreetName AS StreetName,
  _Location.PostalCode AS PostalCode,
  cast(_Location.EHSLocationAuthorizationGroup as ehfnd_loc_auth_group_nc preserving type) AS EHSLocationAuthorizationGroup,
  _Location.Plant AS Plant,
  _Location.CostCenter AS CostCenter,
  _Location.EHSLocationType AS EHSLocationType,
  _Location.EHSLocationStatus AS EHSLocationStatus,
  _Location.CompanyCode AS CompanyCode,
  _Location.BusinessArea AS BusinessArea,
  cast(count(distinct _LocRespManager.EHSLocationResponsibleUUID) as abap.int1) AS EHSLocationIsAssigned,
  _Location._EHSLocationRoot AS _EHSLocationRoot
FROM I_EHSLocation AS _Location
LEFT OUTER JOIN I_EnvrmtWasteGnrtrText AS _LocationText ON _LocationText.EnvrmtWasteGnrtrUUID = EnvrmtWasteGnrtrUUID  -- association [1..*]
LEFT OUTER JOIN I_CountryText AS _CountryText ON _CountryText.Country = Country  -- association [1..*]
LEFT OUTER JOIN I_RegionText AS _RegionText ON _RegionText.Region = Region AND _RegionText.Country = Country  -- association [1..*]
LEFT OUTER JOIN I_EnvrmtWasteMethCodeGrpT AS _MethodCodeGroupText ON _MethodCodeGroupText.EnvrmtWasteMgmtMethCodeCntry = Country  -- association [1..*]
;