P_RSHOPERATIONTIMEFRAME

@AbapCatalog.sqlViewName: 'PRSHOPERTF'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE

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

Name:                       Operations Time Frame
Specification:              This view will return the effective/largest date interval that is spanned by the operations and sub 
                            operations under the maintenance orders as well as under the maintenance plans (The Maintenence Plan  
                            interval will be same as the four week period, since maintencne plan operations will not span more                 
                            than one day)
Requires:                   NA
Ensures:                    Date interval spanned by the operations and sub operations under the maintenance orders 
                            as well as under the maintenance plans are returned
Owners:                     PRP
Contributors:               CK, AN
Unit Test required Y/N:     Yes
Additional comments         None

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

define view P_RSHOperationTimeFrame

  with parameters
    P_StartDate : datum,
    P_EndDate   : datum
  
  as select from P_RSHOrderOperationTimeFrame(P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate) as OrderOperationsTimeFrame
  
{       
       // Calculate the begin date for the time interval

       key  case when OrderOperationsTimeFrame.OperationTimeFrameStartDate <= OrderOperationsTimeFrame.CurrentTimeFrameStartDate
                 then OrderOperationsTimeFrame.OperationTimeFrameStartDate
                 else OrderOperationsTimeFrame.CurrentTimeFrameStartDate
            end as OperationTImeFrameStartDate,

        // Calculate the end date for the time interval

        key case when OrderOperationsTimeFrame.OperationTimeFrameEndDate >= OrderOperationsTimeFrame.CurrentTimeFrameEndDate
          then OrderOperationsTimeFrame.OperationTimeFrameEndDate
          else OrderOperationsTimeFrame.CurrentTimeFrameEndDate
        end as OperationTImeFrameEndDate        
}