SHSM_V_PRPVB

@AbapCatalog.sqlViewName: 'SHSMVPRPVB'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'cds view for search help PRPVB'
define view SHSM_V_PRPVB    as select from vsprps_cn
    inner join   I_ProjectVersion on I_ProjectVersion.ProjectInternalID = vsprps_cn.psphi
    inner join   vskopf           on  vskopf.objnr_pd = I_ProjectVersion.ProjectObject
                                  and vskopf.vsnmr    = vsprps_cn.vsnmr
                                  and vskopf.vsnmr    = I_ProjectVersion.Version
                                  
  association [1..1] to I_ProjectResponsiblePerson as _ResponsiblePerson on $projection.ResponsiblePerson = _ResponsiblePerson.ResponsiblePerson

  association [1..1] to I_ProjectApplicant         as _ProjectApplicant  on $projection.ApplicantCode = _ProjectApplicant.ApplicantCode                                  
{
  vsprps_cn.vsnmr as vsnmr,
  vskopf.vskat    as vskat,
  vsprps_cn.post1 as post1,  
  vsprps_cn.postu as postu,
  vsprps_cn.posid as posid,
  vsprps_cn.fakkz as fakkz,
  vskopf.vsinact  as vsinact,
  
   @Consumption.hidden: true
  vsprps_cn.prart          as ProjectType,
  @Consumption.hidden: true
  vsprps_cn.pkokr          as ControllingArea,
  @Consumption.hidden: true
  vsprps_cn.fkstl          as ResponsibleCostCenter,
  @Consumption.hidden: true
  vsprps_cn.fkokr          as RespCostCenterControllingArea,
  @Consumption.hidden: true
  vsprps_cn.prctr          as ProfitCenter,
  @Consumption.hidden: true
  vsprps_cn.usr00          as FreeDefinedAttribute01,
  @Consumption.hidden: true
  vsprps_cn.usr01          as FreeDefinedAttribute02,
  @Consumption.hidden: true
  vsprps_cn.usr03          as FreeDefinedAttribute04,
  @Consumption.hidden: true
  vsprps_cn.usr02          as FreeDefinedAttribute03,
  @Consumption.hidden: true
  vsprps_cn.usr10          as FreeDefinedIndicator1,
  @Consumption.hidden: true
  vsprps_cn.usr10          as FreeDefinedIndicator2,
  @Consumption.hidden: true
  vsprps_cn.vernr          as ResponsiblePerson,
  @Consumption.hidden: true
  vsprps_cn.astnr          as ApplicantCode,
  @UI.hidden: true
  @Consumption.hidden: true
  _ResponsiblePerson,
  @UI.hidden: true
  @Consumption.hidden: true
  _ProjectApplicant
}
 where vsprps_cn.fakkz <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTVERSION",
"VSKOPF",
"VSPRPS_CN"
],
"ASSOCIATED":
[
"I_PROJECTAPPLICANT",
"I_PROJECTRESPONSIBLEPERSON"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/