I_EHSLOCATIONREVISIONBASIC

CDS View

Location Revision

I_EHSLOCATIONREVISIONBASIC is a CDS View in S/4HANA. Location Revision. It contains 15 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 15 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_EHSLocationRevisionDEX view_entity from CONSUMPTION EHS Location Revision
C_OccupationalHealthLocationVH view_entity from CONSUMPTION Occupational Health Location
I_CurEHSLocationInclRoot view inner COMPOSITE Current revision of EHS Locations
I_EHSLocationRevision view from BASIC EHS Location Revision

Fields (15)

KeyField CDS FieldsUsed in Views
KEY EHSLocationRevisionUUID EHSLocationRevisionUUID 1
KEY EHSLocationUUID EHSLocationUUID 1
BusinessArea BusinessArea 2
CompanyCode CompanyCode 2
ControllingArea ControllingArea 1
CostCenter CostCenter 2
Country Country 1
EHSLocationAuthorizationGroup EHSLocationAuthorizationGroup 1
EHSLocationStatus EHSLocationStatus 2
EHSLocationType EHSLocationType 2
OrganizationalUnit OrganizationalUnit 1
Plant Plant 2
Region Region 1
RevisionEndDate RevisionEndDate 2
RevisionStartDate RevisionStartDate 2 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Location Revision'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #M,
  dataClass: #MASTER
}
@ObjectModel: { modelingPattern: #NONE,
                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,
      @Semantics.systemDateTime.createdAt
      cast( crea_date_time as ehfnd_bo_crea_date_time preserving type ) as CreationDateTime,
      @Semantics.user.createdBy
      cast( crea_uname as ehfnd_bo_crea_uname preserving type )         as CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt
      cast( lchg_date_time as ehfnd_bo_lchg_date_time preserving type ) as LastChangeDateTime,
      @Semantics.user.lastChangedBy
      cast( lchg_uname as ehfnd_bo_lchg_uname preserving type )         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_longitude_unit_code )                    as LongitudeUnit,
      cast( 'DEG' as ehfnd_geo_latitude_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

}

Learn More