P_PROCCAPREQOPDURN

CDS View

Total capacity duration calc for Process relevant operation

P_PROCCAPREQOPDURN is a CDS View in S/4HANA. Total capacity duration calc for Process relevant operation. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_SchedOperations view left_outer COMPOSITE Scheduled Operation details
P_SchedProdnOperationBasic view left_outer COMPOSITE Operation Basic Data
P_WorkCenterCapPplineOp view left_outer COMPOSITE Load day opr for manufacturing and planned order for Cap 
@AbapCatalog.sqlViewName: 'PPIOPDURN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_ProcCapReqOpDurn 
  as select from I_CapacityRequirementItemCap as CapRqmtItmCap
{
  key CapRqmtItmCap.CapacityRequirement,
  key CapRqmtItmCap.CapacityRqmtItemCapacity,
  key CapRqmtItmCap.SuperiorOperationInternalID,
  CapacityRequirementUnit,
  sum(CapRqmtItmCap.RemainingCapReqOpSegProcgDurn) as TotRemCapReqOpSegProcgDurn
}
where
  CapRqmtItmCap.OperationIsPhase = '2'
group by
  CapacityRequirement,
  SuperiorOperationInternalID,
  CapacityRqmtItemCapacity,
  CapacityRequirementUnit

Learn More