P_CAPOPMAXMINDTE

CDS View

Maximum and Minimum Date for Operations of Workcenter

P_CAPOPMAXMINDTE is a CDS View in S/4HANA. Maximum and Minimum Date for Operations of Workcenter. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_WorkCenterCapMaxMinDte view left_outer COMPOSITE Get the Minimum and Maximum date for orders of a capacity 
@AbapCatalog.sqlViewName: 'PCAPOPMINMAXDTE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM: {
  private: true
}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_CapOpMaxMinDte 
    with parameters    p_sapclient : abap.clnt,
                       P_fromdate: datum,
                       P_todate: datum
    as select from P_WorkCenterCapPplineOp as orders
 
               
{
    min(orders.OperationLatestStartDate) as OperationMinimumDate,
    max(orders.OperationLatestEndDate) as OperationMaximumDate
}
where 
      mandt = $parameters.p_sapclient and
      OperationLatestStartDate <= $parameters.P_todate
      and  OperationLatestEndDate >= $parameters.P_fromdate
//      and orders.CapacityInternalID = '10001207'

Learn More