P_RSHEXOPSPERIODFORSCHED

CDS View

P_RSHEXOPSPERIODFORSCHED is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RSHCapInExOpsPeriodForSched view cross CONSUMPTION 
@AbapCatalog.sqlViewName: 'PRSHEXOPPER'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

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

Name:                       Operations Time Frame
Specification:              This view will return the effective/largest date interval that is spanned by the in process and disptached 
                            operations and sub operations relevant for scheduling
Requires:                   NA
Ensures:                    Date interval spanned by in process and dispatched operations of the schedule is returned
                           
Owners:                     PRP
Contributors:               CK, AN
Unit Test required Y/N:     Yes
Additional comments         None

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

define view P_RSHExOpsPeriodForSched

  with parameters
    P_StartDate : datum,
    P_EndDate   : datum
  
  as select from P_RSHExOpsPeriod2ForSched(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        
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_RSHEXOPSPERIOD2FORSCHED"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More