P_RSHMaintSchedUtilBaseKPI

DDL: P_RSHMAINTSCHEDUTILBASEKPI SQL: PRSHUTILBASEKPI Type: view CONSUMPTION Package: RSH_CDS_MAINT_SCHED_SIM

Base view for Utilization KPI calculation

P_RSHMaintSchedUtilBaseKPI is a Consumption CDS View that provides data about "Base view for Utilization KPI calculation" in SAP S/4HANA. It reads from 2 data sources (P_RSHMaintSchedAddlConfBase, P_RSHMaintSchedOpConfBase) and exposes 8 fields with key fields MaintSchedSimlnUUID, MaintOrderRoutingNumber, MaintOrderOperationCounter, MaintOrderConf, MaintOrderRoutingNumber. Part of development package RSH_CDS_MAINT_SCHED_SIM.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
P_RSHMaintSchedAddlConfBase P_RSHMaintSchedAddlConfBase from
P_RSHMaintSchedOpConfBase P_RSHMaintSchedOpConfBase union_all

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRSHUTILBASEKPI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Base view for Utilization KPI calculation view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MaintSchedSimlnUUID MaintSchedSimlnUUID
KEY MaintOrderRoutingNumber MaintOrderRoutingNumber
KEY MaintOrderOperationCounter MaintOrderOperationCounter
KEY MaintOrderConf P_RSHMaintSchedAddlConfBase MaintOrderConf
KEY MaintOrderRoutingNumber MaintOrderRoutingNumber
KEY MaintOrderOperationCounter MaintOrderOperationCounter
KEY MaintOrderConf P_RSHMaintSchedOpConfBase MaintOrderConf
TotalConfirmedWork 
@AbapCatalog.sqlViewName: 'PRSHUTILBASEKPI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Base view for Utilization KPI calculation'

/*
CONTRACT*************************************************************************************************************************
Name:                       Total duration from confirmations in the schedule
Specification:              This view returns total confirmations within the schedule period per schedule
                            - First part of the union returns finally confirmed/partially confirmed
                              duration from additional confirmations
                            - Second part of the union returns finally confirmed/partially confirmed
                              duration of operations in the schedule

Requires:                   NA
Ensures:                    Total Confirmed duration per schedule is returned
Owners:
Contributors:
Unit Test required Y/N:     Yes
Additional comments         None

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


define view P_RSHMaintSchedUtilBaseKPI
  as select from P_RSHMaintSchedAddlConfBase

{
  key MaintSchedSimlnUUID,
  key MaintOrderRoutingNumber,
  key MaintOrderOperationCounter,
  key P_RSHMaintSchedAddlConfBase.MaintOrderConf,
      sum ( ActualWork ) as TotalConfirmedWork

}
group by
  MaintSchedSimlnUUID,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  P_RSHMaintSchedAddlConfBase.MaintOrderConf

union all select from P_RSHMaintSchedOpConfBase
{
  key MaintSchedSimlnUUID,
  key MaintOrderRoutingNumber,
  key MaintOrderOperationCounter,
  key P_RSHMaintSchedOpConfBase.MaintOrderConf,
      sum ( ActualWork ) as TotalConfirmedWork
}
group by
  MaintSchedSimlnUUID,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  P_RSHMaintSchedOpConfBase.MaintOrderConf

Learn More