I_PersonWorkAgrmtJobText

@AbapCatalog.sqlViewName: 'IPERWKAGRJBTXT'
@VDM.viewType: #BASIC
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@Analytics.dataExtraction.enabled: true
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'Job'
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Person Work Agreement Jobs with Text'
@ObjectModel.supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT,
                                     #SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET,
                                     #EXTRACTION_DATA_SOURCE]

define view I_PersonWorkAgrmtJobText
///*  

as select from P_PersonWorkAgrmtJobText as jobcodet
  association [0..1] to I_Language as _Language on jobcodet.Language = _Language.Language
{
  key Job,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key cast( Language as langu preserving type ) as Language,
      @Semantics.businessDate.from: true
  key cast(StartDate as begdatum ) as StartDate,
      @Semantics.businessDate.to: true
  key cast(EndDate as enddatum )   as EndDate,
      JobShortName,
      @Semantics.text: true
      JobName,
      _Language
}

//*/

/*//  as select from P_PersonWorkAgrmtJobText

  as select from WFD_TF_PersonWorkAgrmtJobText( p_client : $session.client )
  association [0..1] to I_Language as _Language on WFD_TF_PersonWorkAgrmtJobText.Language = _Language.Language
{
  key Job,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key Language,
      @Semantics.businessDate.from: true
  key StartDate,
      @Semantics.businessDate.to: true
  key EndDate,
      JobShortName,
      @Semantics.text: true
      JobName,
      _Language
}

*/

//define view I_PersonWorkAgrmtJobText

//  as select from P_PersonWorkAgrmtJobText

//

//{

//  key Job,

//      @Semantics.language: true

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

//  key Language,

//      @Semantics.businessDate.from: true

//  key StartDate,

//      @Semantics.businessDate.to: true

//  key EndDate,

//      JobShortName,

//      @Semantics.text: true

//      JobName,

//      _Language

//}



//   as select distinct from hrp1000 as HRP1000

//    inner join            t77s0   as systemtable on  grpid = 'PLOGI'

//                                                 and semid = 'PLOGI'

//                                                 and gsval = hrp1000.plvar

//  association [0..1] to I_Language as _Language on hrp1000.langu = _Language.Language

//{

//  key hrp1000.objid as Job,

//      @Semantics.language: true

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

//  key hrp1000.langu as Language,

//      @Semantics.businessDate.from: true

//  key begda         as StartDate,

//      @Semantics.businessDate.to: true

//  key endda         as EndDate,

//      hrp1000.short as JobShortName,

//      @Semantics.text: true

//      hrp1000.stext as JobName,

//      _Language

//}

//where

//      hrp1000.otype = 'C'

//  and hrp1000.istat = '1'

//