P_CapacitySchedOpersCount

DDL: P_CAPACITYSCHEDOPERSCOUNT SQL: PCAPOPCOUNT Type: view COMPOSITE

P_CapacitySchedOpersCount is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CapacityRequirementItemCap, I_CapacityRequirementItemCap) and exposes 5 fields with key fields OrderID, OrderCategory, CapacityRequirementItem, CapacityRqmtItemCapacity.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_CapacityRequirementItemCap capreqmultiple inner
I_CapacityRequirementItemCap CapRqmtItmCap from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCAPOPCOUNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY OrderID
KEY OrderCategory
KEY CapacityRequirementItem I_CapacityRequirementItemCap CapacityRequirementItem
KEY CapacityRqmtItemCapacity I_CapacityRequirementItemCap CapacityRqmtItemCapacity
CapacityInternalID I_CapacityRequirementItemCap CapacityInternalID 
@AbapCatalog.sqlViewName: 'PCAPOPCOUNT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_CapacitySchedOpersCount
  as select from I_CapacityRequirementItemCap as CapRqmtItmCap
    inner join   I_CapacityRequirementItemCap as capreqmultiple on  CapRqmtItmCap.CapacityRequirement = capreqmultiple.CapacityRequirement
                                                                and CapRqmtItmCap.CapacityInternalID  = capreqmultiple.CapacityInternalID
                                                                and (
                                                                   capreqmultiple.OperationIsPhase            = '0'
                                                                   or capreqmultiple.OperationIsPhase         = '1'
                                                                 )

{
  key coalesce( CapRqmtItmCap.OrderID, CapRqmtItmCap.PlannedOrder )                                  as    OrderID,
  key coalesce(CapRqmtItmCap._Order.OrderCategory, CapRqmtItmCap._PlannedOrder.PlannedOrderCategory) as    OrderCategory,
  key CapRqmtItmCap.CapacityRequirementItem,
  key CapRqmtItmCap.CapacityRqmtItemCapacity,
      capreqmultiple.CapacityInternalID,
      count( * )                                                                                     as    countofsamecapacity
}
where
  (
       CapRqmtItmCap.OperationIsPhase = '0'
    or CapRqmtItmCap.OperationIsPhase = '1'
  )
group by
  CapRqmtItmCap._CapacityRequirement.CapacityRequirementOrigin,
  CapRqmtItmCap.PlannedOrder,
  CapRqmtItmCap.OrderID,
  CapRqmtItmCap._Order.OrderCategory,
  CapRqmtItmCap._PlannedOrder.PlannedOrderCategory,
  CapRqmtItmCap.CapacityRequirementItem,
  CapRqmtItmCap.CapacityRqmtItemCapacity,
  capreqmultiple.CapacityInternalID
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAPACITYREQUIREMENT",
"I_CAPACITYREQUIREMENTITEMCAP",
"I_LOGISTICSORDER",
"I_PLANNEDORDER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More