I_EHSLocationRevisionBasic

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Location Revision'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #M,
  dataClass: #MASTER
}
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
@VDM.viewType: #BASIC
define view entity I_EHSLocationRevisionBasic
  as select from ehfndd_loc_rev
{
  key db_key                                                         as EHSLocationRevisionUUID,
      cast( parent_key as ehfnd_location_uuid_ref preserving type )  as EHSLocationUUID,
      crea_date_time                                                 as CreationDateTime,
      crea_uname                                                     as CreatedByUser,
      lchg_date_time                                                 as LastChangeDateTime,
      lchg_uname                                                     as LastChangedByUser,
      revision_descr                                                 as RevisionDescription,
      split_date                                                     as RevisionStartDate,
      //  split_time as SplitTime,

      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,
      //  desc_key_ref as DescKeyRef,

      //  syncup_timestamp as SyncupTimestamp,

      //  name1 as Name1,

      //  name2 as Name2,

      city1                                                          as CityName,
      post_code1                                                     as PostalCode,
      street                                                         as StreetName,
      country                                                        as Country,
      region                                                         as Region,
      phone                                                          as EHSLocationPhone,
      //  fax as Fax,

      @Semantics.geoLocation.longitude: true
      @Semantics.quantity.unitOfMeasure: 'LongitudeUnit'
      cast( longitute as ehfnd_geoloc_longitude_nc preserving type ) as Longitude,
      @Semantics.geoLocation.latitude:  true
      @Semantics.quantity.unitOfMeasure: 'LatitudeUnit'
      cast( latitude as ehfnd_geoloc_latitude_nc preserving type )   as Latitude,
      cast( 'DEG' as ehfnd_geo_unit_code )                           as LongitudeUnit,
      cast( 'DEG' as ehfnd_geo_unit_code )                           as LatitudeUnit,
      //  elevation as Elevation,

      //  time_zone as TimeZone,

      storage_loc                                                    as StorageLocation
      //  warehouse_num as WarehouseNum,

      //  storage_type as StorageType,

      //  storage_section as StorageSection,

      //  storage_bin as StorageBin,

      //  image_key_ref as ImageKeyRef,

      //  eew_ehfnd_lrev_d as EewEhfndLrevD

}