C_RSHResourceCapacityKPITiles

DDL: C_RSHRESOURCECAPACITYKPITILES SQL: CRSHRESCAPTILES Type: view CONSUMPTION Package: RSH_CDS_RES

Resource Capacity KPI Tiles

C_RSHResourceCapacityKPITiles is a Consumption CDS View that provides data about "Resource Capacity KPI Tiles" in SAP S/4HANA. It reads from 2 data sources (P_RSHResource, P_RSHResourceCapacityKPIs) and exposes 12 fields with key fields EmploymentInternalID, YearMonth. Part of development package RSH_CDS_RES.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
P_RSHResource P_RSHResource from
P_RSHResourceCapacityKPIs P_RSHResourceCapacityKPIs inner

Parameters (2)

NameTypeDefault
P_StartDate syst_datum
P_EndDate syst_datum

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CRSHRESCAPTILES view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Resource Capacity KPI Tiles view
AccessControl.personalData.blocking #REQUIRED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY EmploymentInternalID _ResDetails EmploymentInternalId
KEY YearMonth _Capacity YearMonth
CostCenter _ResDetails CostCenter
EmployeeFullName _ResDetails PersonFullName
EmployeeStaffedHours _Capacity EmployeeStaffedHours
EmployeeAvailableHours _Capacity EmployeeAvailableHours
EmployeeUtilization _Capacity MonthlyUtilPercentage
CompanyCode _ResDetails CompanyCode
CalendarMonthShortName
NumberOfEmployees 1
IsBusinessPurposeCompleted _ResDetails IsBusinessPurposeCompleted
AuthorizationGroup _ResDetails AuthorizationGroup 
@AbapCatalog.sqlViewName: 'CRSHRESCAPTILES'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Resource Capacity KPI Tiles'
@AccessControl.personalData.blocking: #REQUIRED

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

Name:                       Resource _Capacity KPI Tiles
Specification:              Gives resource utilization info on a monthly basis between the given dates
Requires:                   Period for which the monthly _Capacity information is sought
Ensures:                    Monthly utilization percentage is returned for Resources for the specified period
Owners:                     CF
Contributors:               CF
Unit Test required Y/N:     N
Additional comments         Wrapper for OVP Tiles

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

define view C_RSHResourceCapacityKPITiles
  with parameters
    P_StartDate : syst_datum,
    P_EndDate   : syst_datum

  as select from           P_RSHResource ( P_StartDate: $parameters.P_StartDate, P_EndDate:$parameters.P_EndDate)            as _ResDetails
    inner join             P_RSHResourceCapacityKPIs( P_StartDate: $parameters.P_StartDate, P_EndDate:$parameters.P_EndDate) as _Capacity on _ResDetails.EmploymentInternalId = _Capacity.EmploymentInternalId
    left outer to one join I_RSHGetDomainText                                                                                as monthtext on  monthtext.DomainValueName = 'MONTH'
                                                                                                                                          and monthtext.DomainValue     = _Capacity.CalendarMonth
{
  key _ResDetails.EmploymentInternalId                           as EmploymentInternalID,
  key _Capacity.YearMonth,
      _ResDetails.CostCenter,
      _ResDetails.PersonFullName                                 as EmployeeFullName,
      _Capacity.EmployeeStaffedHours,
      _Capacity.EmployeeAvailableHours,
      _Capacity.MonthlyUtilPercentage                            as EmployeeUtilization,
      _ResDetails.CompanyCode,
      substring(monthtext.DomainText, 1, 3)                      as CalendarMonthShortName,
      1                                                          as NumberOfEmployees,
      @Consumption.hidden: true
      _ResDetails.IsBusinessPurposeCompleted,
      @Consumption.hidden: true
      _ResDetails.AuthorizationGroup

}
where
  _ResDetails.WorkAgreementStatus = '1'

Learn More