I_RSHPROJECTASSIGNMENTCAPKPI

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

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

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

Name:                       Assignment Capacity KPI 
Specification:              Gets the Assignment Capacity KPI
Requires:                   NA
Ensures:                    Well, we only need the capacity information at the draft level. The draft table can however only
                            be created if there is a DB. The DB contains only the two fields, two more fields relevant only
                            for the draft are added here.
Owners:                     PSP
Contributors:               CF, PSP
Unit Test required Y/N:     Y
Additional comments         None

END OF CONTRACT***************************************************************************************************************
*/

define view I_RSHProjectAssignmentCapKPI
  as select from rsh_d_prasgckpi

  association [1..1] to I_RSHProjectAssignment as _ProjectAssignment on _ProjectAssignment.ProjAssignmentUUID = $projection.ProjAssignmentUUID
{
  key projassignmentdaycapacityuuid             as ProjAssignmentDayCapacityUUID,
      projassignmentuuid                        as ProjAssignmentUUID,

      @Semantics.businessDate.at: true
      cast('' as abap.dats)                     as ProjAssignmentDate,
      cast('' as rsh_ps_proj_asg_day_capacity ) as ProjAssignmentDayCapacity,

      // Association

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