P_PROCCAPREQOPDURN

CDS View

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

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_MntrWrkCtrOrderOperations view left_outer COMPOSITE
P_SchedOperations view left_outer COMPOSITE
P_SchedProdnOperationBasic view left_outer COMPOSITE
P_WorkCenterCapPplineOp view left_outer COMPOSITE 
@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAPACITYREQUIREMENTITEMCAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More