P_WORKCENTERCAPMAXMINDTE

CDS View

P_WORKCENTERCAPMAXMINDTE 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_WorkCenterCapShiftOp view cross COMPOSITE 
@AbapCatalog.sqlViewName: 'PWCCAPMINMAXDTE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM: {
  private: true
}
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_WorkCenterCapMaxMinDte 
with parameters        p_sapclient : abap.clnt,
                       P_fromdate: datum,
                       P_todate: datum,
                       P_HorizonFlag: abap.char( 1 )
      as select from I_CalendarDate as date
      left outer join P_CapOpMaxMinDte(p_sapclient : $session.client,
                                      P_fromdate : $parameters.P_fromdate,
                                      P_todate : $parameters.P_todate) as orders
                                on orders.mandt = $session.client
{
      key case $parameters.P_HorizonFlag
        when 'Y' then
            cast( $parameters.P_fromdate as abap.dats)
        else
           coalesce( orders.OperationMinimumDate, $parameters.P_fromdate)
        end as OperationMinimumDate,
        
      key case $parameters.P_HorizonFlag
        when 'Y' then
            cast( dats_add_days($parameters.P_todate,1,'FAIL') as abap.dats)
        else
          coalesce( orders.OperationMaximumDate, cast( dats_add_days($parameters.P_todate,1,'FAIL') as abap.dats))
        end as OperationMaximumDate
       
}
where 
      date.CalendarDate = $session.system_date

      
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE",
"P_CAPOPMAXMINDTE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More