I_EHSLocationRevisionBasic

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_EHSLocationRevisionBasic.
-- 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_EHSLocationRevisionBasic AS
SELECT
  db_key AS EHSLocationRevisionUUID,
  cast( parent_key as ehfnd_location_uuid_ref preserving type ) AS EHSLocationUUID,
  cast( crea_date_time as ehfnd_bo_crea_date_time preserving type ) AS CreationDateTime,
  cast( crea_uname as ehfnd_bo_crea_uname preserving type ) AS CreatedByUser,
  cast( lchg_date_time as ehfnd_bo_lchg_date_time preserving type ) AS LastChangeDateTime,
  cast( lchg_uname as ehfnd_bo_lchg_uname preserving type ) AS LastChangedByUser,
  revision_descr AS RevisionDescription,
  split_date AS RevisionStartDate,
  end_date AS RevisionEndDate,
  cast( type as ehfnd_loc_type_code_nc preserving type ) AS EHSLocationType,
  cast( status as ehfnd_loc_status_nc preserving type ) AS EHSLocationStatus,
  cast( funct_loc_id as ehfnd_funct_loc_id_nc preserving type ) AS EHSFunctionalLocation,
  equipment_id AS Equipment,
  plant_id AS Plant,
  company_code AS CompanyCode,
  buss_area AS BusinessArea,
  cost_center AS CostCenter,
  controlling_area AS ControllingArea,
  cast( org_unit as ehfnd_org_unit_id_nc preserving type ) AS OrganizationalUnit,
  cast( auth_group as ehfnd_loc_auth_group_nc preserving type ) AS EHSLocationAuthorizationGroup,
  city1 AS CityName,
  post_code1 AS PostalCode,
  street AS StreetName,
  Country,
  Region,
  phone AS EHSLocationPhone,
  cast( longitute as ehfnd_geoloc_longitude_nc preserving type ) AS Longitude,
  cast( latitude as ehfnd_geoloc_latitude_nc preserving type ) AS Latitude,
  cast( 'DEG' as ehfnd_geo_longitude_unit_code ) AS LongitudeUnit,
  cast( 'DEG' as ehfnd_geo_latitude_unit_code ) AS LatitudeUnit,
  storage_loc AS StorageLocation
FROM ehfndd_loc_rev
;