P_RSHWCBaseUtilizationPerWeek

DDL: P_RSHWCBASEUTILIZATIONPERWEEK SQL: PRSHWCBASEUTILPW Type: view CONSUMPTION

P_RSHWCBaseUtilizationPerWeek is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_RSHWCCapacityPerWorkDay) and exposes 8 fields with key field CapacityInternalID.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
P_RSHWCCapacityPerWorkDay Capacity 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 P_RSHWCCapacityPerWorkDay CapacityInternalID
WorkCenter P_RSHWCCapacityPerWorkDay WorkCenter
WorkCenterInternalID P_RSHWCCapacityPerWorkDay WorkCenterInternalID
WorkCenterTypeCode P_RSHWCCapacityPerWorkDay WorkCenterTypeCode
WorkCenterCategoryCode P_RSHWCCapacityPerWorkDay WorkCenterCategoryCode
Plant P_RSHWCCapacityPerWorkDay 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_RSHWCCapacityPerWorkDay 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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_RSHWCCAPACITYPERWORKDAY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More