I_EHSLOCATION

@AbapCatalog:{
    sqlViewName: 'ILOCATION',
    compiler.compareFilter: true,
    preserveKey:true 
}
@EndUserText.label: 'EHS Location'
@AccessControl.authorizationCheck: #CHECK
@Analytics: { dataCategory:#DIMENSION , dataExtraction.enabled:true }
@VDM.viewType: #BASIC --#COMPOSITE
@ObjectModel:{
    representativeKey: 'EHSLocationUUID',
    // used for BOBF Master Data Object

    usageType:{ serviceQuality: #C,        // < 15 msec

                             sizeCategory:  #M,         // < 100.000

                             dataClass: #MASTER }
  }


// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions:true
// Begin correction 2765428 - 07.03.2019  **************************

@Consumption.filter.businessDate.at: true
// End correction 2765428 - 07.03.2019  ****************************



define view I_EHSLocation
  as select from I_EHSLocationRevision
  association [0..*] to I_EHSLocationHierarchy as _EHSLocationHierarchy on $projection.EHSLocationUUID = _EHSLocationHierarchy.EHSLocationUUID
  association [1..1] to I_EHSLocationRoot      as _EHSLocationRoot      on $projection.EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID
{
      @ObjectModel.hierarchy.association: '_EHSLocationHierarchy'
      @ObjectModel.text.association: '_EHSLocationRevisionName'
  key I_EHSLocationRevision.EHSLocationUUID,

      @Semantics.businessDate.to
  key I_EHSLocationRevision.RevisionEndDate,


      @Semantics.businessDate.from
      I_EHSLocationRevision.RevisionStartDate,
      I_EHSLocationRevision.EHSLocationRevisionUUID,

      I_EHSLocationRevision.CreationDateTime,
      I_EHSLocationRevision.CreatedByUser,
      I_EHSLocationRevision.LastChangeDateTime,
      I_EHSLocationRevision.LastChangedByUser,

      I_EHSLocationRevision.EHSLocationType,
      I_EHSLocationRevision.EHSLocationStatus,
      I_EHSLocationRevision.Plant,
      I_EHSLocationRevision.EHSLocationPhone,
      
      //--[ GENERATED:012:29JlHNUf7jY4oS0yl5vKTW

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
      // ]--GENERATED

      I_EHSLocationRevision.CompanyCode,
      //--[ GENERATED:012:29JlHNUf7jY4oS0yl5vKTW

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_BusinessAreaStdVH',
                     element: 'BusinessArea' }
        }]
      // ]--GENERATED

      I_EHSLocationRevision.BusinessArea,
      //--[ GENERATED:012:29JlHNUf7jY4oS0yl5vKTW

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CostCenterStdVH',
                     element: 'CostCenter' },
          additionalBinding: [{ localElement: 'ControllingArea',
                                element: 'ControllingArea' }]
        }]
      // ]--GENERATED

      I_EHSLocationRevision.CostCenter,
      I_EHSLocationRevision.ControllingArea,
      I_EHSLocationRevision.OrganizationalUnit,
      I_EHSLocationRevision.StorageLocation,
      I_EHSLocationRevision.EHSLocationAuthorizationGroup,
      I_EHSLocationRevision.Country,
      I_EHSLocationRevision.Region,
      I_EHSLocationRevision.CityName,
      I_EHSLocationRevision.StreetName,
      I_EHSLocationRevision.PostalCode,

      //--[ GENERATED:012:29JlHNUf7jY4oS0yl5vKTW

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_EquipmentStdVH',
                     element: 'Equipment' }
        }]
      // ]--GENERATED

      I_EHSLocationRevision.Equipment,
      //--[ GENERATED:012:29JlHNUf7jY4oS0yl5vKTW

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_FunctionalLocationStdVH',
                     element: 'FunctionalLocation' }
        }]
      // ]--GENERATED

      I_EHSLocationRevision.FunctionalLocation,

      I_EHSLocationRevision.Latitude,
      I_EHSLocationRevision.Longitude,

      _EHSLocationRoot.EHSLocationID,

      /* Associations */
      I_EHSLocationRevision._BusinessArea,
      I_EHSLocationRevision._CompanyCode,
      I_EHSLocationRevision._ControllingArea,
      I_EHSLocationRevision._OrganizationalUnit,
      I_EHSLocationRevision._StorageLocation,
      //        I_EHSLocationRevision._CostCenter,

      I_EHSLocationRevision._Country,
      I_EHSLocationRevision._CreatedByUser,
      I_EHSLocationRevision._EHSLocationRevisionName,
      I_EHSLocationRevision._EHSLocationAuthGroup,
      I_EHSLocationRevision._EHSLocationStatus,
      I_EHSLocationRevision._EHSLocationType,
      I_EHSLocationRevision._LastChangedByUser,
      I_EHSLocationRevision._Plant,
      I_EHSLocationRevision._Region,
      I_EHSLocationRevision._Equipment,
      I_EHSLocationRevision._FunctionalLocation,
      _EHSLocationRoot,
      _EHSLocationHierarchy
      //        ,

      //        _EHSLocationHierarchy.EHSLocHierarchyUUID,

      //        _EHSLocationHierarchy._EHSLocationHierarchyRevision

}
where
       I_EHSLocationRevision.RevisionStartDate <= $session.system_date
  and  I_EHSLocationRevision.RevisionEndDate   >= $session.system_date // consider current location revisions only

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EHSLOCATIONREVISION",
"I_EHSLOCATIONROOT"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COUNTRY",
"I_EHSLOCATIONAUTHZNGROUP",
"I_EHSLOCATIONHIERARCHY",
"I_EHSLOCATIONREVISIONNAMET",
"I_EHSLOCATIONROOT",
"I_EHSLOCATIONSTATUS",
"I_EHSLOCATIONTYPE",
"I_EQUIPMENT",
"I_FUNCTIONALLOCATION",
"I_ORGUNIT",
"I_PLANT",
"I_REGION",
"I_STORAGELOCATION",
"I_USER"
],
"BASE":
[
"I_EHSLOCATIONREVISION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/