I_OrgUnitText

@AbapCatalog.sqlViewName: 'IORGUNITTEXT'
@VDM.viewType:  #BASIC
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel.dataCategory: #TEXT
@EndUserText.label: 'OrganizationUnit text'
@ObjectModel.representativeKey: 'OrganizationalUnit'

@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #CUSTOMIZING 
@ObjectModel.usageType.serviceQuality: #A 
@ObjectModel.usageType.sizeCategory: #L

define view I_OrgUnitText 
//as select distinct from /shcm/hrp5090 as details

//

//association[0..1] to I_Language as _Language on $projection.Language = _Language.Language

//

//{

//  key   case

//    when details.department_id <> ''

//         then details.department_id

//         else case

//                when details.division_id <> ''

//                    then details.division_id

//                    else details.business_unit_id

//              end

//  end as OrganizationalUnit,

//   

//  @Semantics.language: true

//  @ObjectModel.foreignKey.association: '_Language'

//  'E' as Language, 

//  

//  case

//    when details.department_id <> ''

//         then details.department_name

//         else case

//                when details.division_id <> ''

//                    then details.division_name

//                    else details.business_unit_name

//              end

//  end as OrganizationalUnitName,

//  

//  _Language 

//

//} where details.department_id <> '' or details.division_id <> '' or details.business_unit_id <> ''


//union all


as select distinct from t527x 

association[0..1] to I_Language as _Language on t527x.sprsl = _Language.Language

{
  @Semantics.language: true
  @ObjectModel.foreignKey.association: '_Language'
  key sprsl     as Language,
  
  key orgeh     as OrganizationalUnit,
    
  @Semantics.text: true
  orgtx     as OrganizationalUnitName,
  
  _Language
}
where
      t527x.begda <= $session.system_date
  and t527x.endda >= $session.system_date