I_ProjWIPDetWBSValueHelp

@AbapCatalog.sqlViewName: 'IWBSELVALHLP'
@EndUserText.label: 'WBS Element Value Help'

@ObjectModel.dataCategory: #VALUE_HELP
@VDM.viewType: #CONSUMPTION
//@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }

@ObjectModel.representativeKey: 'WBSElement'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED

//Selects from prps and proj and various associations


define view I_ProjWIPDetWBSValueHelp
  //as select from prps

  //  inner join   proj on proj.pspnr = prps.psphi

  as select from I_WBSElement as WBSElement

  association [1..1] to I_ControllingArea as _ControllingArea on  $projection.ControllingArea = _ControllingArea.ControllingArea
  association [1..1] to I_CompanyCode     as _CompanyCode     on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_CostCenter      as _CostCenter      on  $projection.CostCenter      = _CostCenter.CostCenter
                                                              and $projection.ControllingArea = _CostCenter.ControllingArea
                                                              and $projection.CreationDate    = _CostCenter.ValidityEndDate
  association [0..1] to I_BusinessArea    as _BusinessArea    on  $projection.BusinessArea = _BusinessArea.BusinessArea
  association [0..1] to I_Plant           as _Plant           on  $projection.Plant = _Plant.Plant
  association [0..1] to I_ProfitCenter    as _ProfitCenter    on  $projection.ProfitCenter    = _ProfitCenter.ProfitCenter
                                                              and $projection.ControllingArea = _ProfitCenter.ControllingArea
                                                              and $projection.CreationDate    = _ProfitCenter.ValidityEndDate
  association [0..1] to I_Projecttype     as _ProjectType     on  $projection.ProjectType = _ProjectType.ProjectType

{
  @Search.defaultSearchElement: true
  //key prps.posid as WBSElement,

  key WBSElement,
      //prps.post1 as WBSDescription,

      WBSDescription,
      //prps.poski as WBSElementShortID,

      WBSElementShortID,
      //proj.pspid as Project,

      WBSElement._Project.Project,
      //proj.post1 as ProjectDescription,

      WBSElement._Project.ProjectDescription,  
      //prps.ernam as CreatedByUser,

      CreatedByUser,
      //prps.erdat as CreationDate,

      CreationDate,
      //prps.aenam as LastChangedByUser,

      LastChangedByUser,
      //prps.aedat as LastChangeDate,

      LastChangeDate,    
      //prps.vernr as ResponsiblePerson,  

      cast( case
              when WBSElement.ResponsiblePerson = '00000000' or WBSElement.ResponsiblePerson is null
                then WBSElement._EntProjectResponsiblePerson.PersonWorkAgreement
                else WBSElement.ResponsiblePerson
            end as persno preserving type ) as ResponsiblePerson,
      //prps.verna as ResponsiblePersonName,     

      cast( case
              when WBSElement.ResponsiblePerson = '00000000' or WBSElement.ResponsiblePerson is null
                then WBSElement._EntProjectResponsiblePerson._WorkforcePerson.PersonFullName
                else WBSElement.ResponsiblePersonName
            end as ad_namtext preserving type ) as ResponsiblePersonName,
      
      //prps.pbukr as CompanyCode,

      CompanyCode,
      //prps.pgsbr as BusinessArea,

      BusinessArea,
      //prps.pkokr as ControllingArea,

      ControllingArea,
      //prps.prctr as ProfitCenter,

      ProfitCenter,
      //prps.prart as ProjectType,

      ProjectType,
      //prps.plakz as WBSElementIsPlanningElement,

      WBSElementIsPlanningElement,
      //prps.belkz as WBSIsAccountAssignmentElement,

      WBSIsAccountAssignmentElement,
      //prps.fakkz as WBSElementIsBillingElement,

      WBSElementIsBillingElement,
      //prps.fkstl as ResponsibleCostCenter,

      ResponsibleCostCenter,
      //prps.werks as Plant,

      Plant,
      //prps.txtsp as Language,

      Language,
      //prps.kostl as CostCenter,

      CostCenter,
      //prps.stufe as WBSElementHierarchyLevel,

      WBSElementHierarchyLevel,
      //prps.abgsl as ResultAnalysisInternalID,

      ResultAnalysisInternalID,

      _ControllingArea,
      _Plant,
      _CostCenter,
      _BusinessArea,
      _CompanyCode,
      _ProfitCenter,
      _ProjectType,
      
      //For access control

      @UI.hidden: true
      @Consumption.filter.hidden: true
      WBSElement.ResponsiblePerson as ProjectResponsiblePerson,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      WBSElement._ResponsiblePerson,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      WBSElement._EntProjectResponsiblePerson,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      WBSElementInternalID

};