P_RSHWCBaseUtilizationPerWeek

DDL: P_RSHWCBASEUTILIZATIONPERWEEK SQL: PRSHWCBASEUTILPW Type: view CONSUMPTION Package: RSH_CDS_MAINT_SCHED_SIM

Base Utilization Per Week

P_RSHWCBaseUtilizationPerWeek is a Consumption CDS View that provides data about "Base Utilization Per Week" in SAP S/4HANA. It reads from 1 data source (P_RSHWCCapPerWorkDayForPrd_1) and exposes 8 fields with key field CapacityInternalID. Part of development package RSH_CDS_MAINT_SCHED_SIM.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
P_RSHWCCapPerWorkDayForPrd_1 P_RSHWCCapPerWorkDayForPrd_1 from

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PRSHWCBASEUTILPW view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID Capacity CapacityInternalID
WorkCenter Capacity WorkCenter
WorkCenterInternalID Capacity WorkCenterInternalID
WorkCenterTypeCode Capacity WorkCenterTypeCode
WorkCenterCategoryCode Capacity WorkCenterCategoryCode
Plant Capacity Plant
OperatingDurationInSeconds
TotOperatingDurationInSeconds 
@AbapCatalog.sqlViewName: 'PRSHWCBASEUTILPW'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE

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

Name:                       Work Center Base Utilization
Specification:              This View reads the work center base capacity and aggregates on per week basis
Requires:                   NA
Ensures:                    Base capacity of work center per week basis is returned
Owners:                     AN
Contributors:               AN
Unit Test required Y/N:     Yes
Additional comments

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

define view P_RSHWCBaseUtilizationPerWeek
  with parameters
    P_StartDate : datum,
    P_EndDate   : datum
  as select from P_RSHWCCapPerWorkDayForPrd_1( P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate ) as Capacity

{


  key       Capacity.CapacityInternalID,
            Capacity.WorkCenter,
            Capacity.WorkCenterInternalID,
            Capacity.WorkCenterTypeCode,
            Capacity.WorkCenterCategoryCode,
            Capacity.Plant,
            sum ( Capacity.OperatingDurationInSeconds )                  as OperatingDurationInSeconds,
            sum ( Capacity.TotOperatingDurationInSeconds)                as TotOperatingDurationInSeconds

}

where
  (
    Capacity.CalendarDate between $parameters.P_StartDate and $parameters.P_EndDate
  )
group by
  CapacityInternalID,
  WorkCenterInternalID,
  WorkCenter,
  Plant,
  WorkCenterTypeCode,
  WorkCenterCategoryCode,
  Plant

Learn More