C_RSHSmltdWrkCtrUtilznPerDay

DDL: C_RSHSMLTDWRKCTRUTILZNPERDAY SQL: CRSHSMLTWCUTILPD Type: view CONSUMPTION

Work Center Utilization Per Day

C_RSHSmltdWrkCtrUtilznPerDay is a Consumption CDS View that provides data about "Work Center Utilization Per Day" in SAP S/4HANA. It reads from 2 data sources (I_CalendarDate, P_RSHSmltdWrkCtrUtilznPerDay) and exposes 12 fields with key fields MaintSchedSimlnUUID, WorkCenterInternalID, CapacityInternalID, CalendarDate.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_CalendarDate CalendarDate inner
P_RSHSmltdWrkCtrUtilznPerDay P_RSHSmltdWrkCtrUtilznPerDay from

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CRSHSMLTWCUTILPD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Work Center Utilization Per Day 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

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MaintSchedSimlnUUID MaintSchedSimlnUUID
KEY WorkCenterInternalID WorkCenterInternalID
KEY CapacityInternalID CapacityInternalID
KEY CalendarDate Utilization CalendarDate
WeekDay I_CalendarDate WeekDay
WorkCenter WorkCenter
WorkCenterCategoryCode WorkCenterCategoryCode
Plant Plant
WorkCenterRequiredCapacity
WorkCenterAvailableCapacity
WorkCenterUtilization
WorkCenterCapacityUnit 
@AbapCatalog.sqlViewName: 'CRSHSMLTWCUTILPD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Center Utilization Per Day'

@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL

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

Name:                       Get the work center utilization per day
Specification:              Consumed Capacity and Base capacity per day basis is returned by this view
Requires:                   NA
Ensures:                    Consumed Capacity and BaseCapacity is returned
Owners:                     PSP
Contributors:               PSP
Unit Test required Y/N:     NA

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

define view C_RSHSmltdWrkCtrUtilznPerDay
  with parameters
    P_StartDate : datum,
    P_EndDate   : datum
  as select from P_RSHSmltdWrkCtrUtilznPerDay( P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate ) as Utilization
    inner join   I_CalendarDate                                                                                           as CalendarDate on CalendarDate.CalendarDate = Utilization.CalendarDate

{

      //Utilization

  key MaintSchedSimlnUUID,
  key WorkCenterInternalID         as WorkCenterInternalID,
  key CapacityInternalID,
  key Utilization.CalendarDate,
      //    UI would require weekday to get the weekday texts to be displayed in the charts

      CalendarDate.WeekDay,
      WorkCenter,
      //     WorkCenterTypeCode,

      WorkCenterCategoryCode,
      Plant,
      sum ( UsedCapacity )         as WorkCenterRequiredCapacity,
      sum ( WorkCenterCapacity )   as WorkCenterAvailableCapacity,
      cast ( 0 as abap.dec(10,2) ) as WorkCenterUtilization,
      cast (' ' as meins )         as WorkCenterCapacityUnit

}
where
      Utilization.CalendarDate >= $parameters.P_StartDate
  and Utilization.CalendarDate <= $parameters.P_EndDate
group by
  MaintSchedSimlnUUID,
  WorkCenterInternalID,
  CapacityInternalID,
  Utilization.CalendarDate,
  CalendarDate.WeekDay,
  WorkCenter,
  //  WorkCenterTypeCode,

  WorkCenterCategoryCode,
  Plant
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE",
"P_RSHSMLTDWRKCTRUTILZNPERDAY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More