I_RSHPROJECTASSIGNMENTKPI

@AbapCatalog.sqlViewName: 'IRSHPROJASGKPI'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Project Assignment KPI'

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

/*
CONTRACT**********************************************************************************************************************

Name:                       Project Assignment KPIs
Specification:              As with other tables, we need to add few more fields than what is persisted in the database.
                            Hence this view where we add the additional fields we need in the draft table.
Requires:                   NA
Ensures:                    The draft table has all the fields that we need :)
Owners:                     PSP
Contributors:               CF, PSP
Unit Test required Y/N:     Y
Additional comments         None
END OF CONTRACT***************************************************************************************************************
*/

define view I_RSHProjectAssignmentKPI
  as select from rsh_d_projasgkpi

  association [1..1] to I_RSHProjectAssignment as _ProjectAssignment on _ProjectAssignment.ProjAssignmentUUID = $projection.ProjAssignmentUUID
{
  key projassignmentkpiuuid as ProjAssignmentKPIUUID,
      projassignmentuuid    as ProjAssignmentUUID,
      cast('' as rsh_ps_proj_asg_kpi_label) as ProjAssignmentKPILabel,
      cast('' as rsh_ps_proj_asg_kpi_before_val) as ProjAssignmentKPIBeforeValue,
      cast('' as rsh_ps_proj_asg_kpi_after_val) as ProjAssignmentKPIAfterValue,

      // Associations

      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      _ProjectAssignment
}