P_SchedFirstOperation_Vers_2

@AbapCatalog.sqlViewName: 'PSCHEDFRSTOPVER2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_SchedFirstOperation_Vers_2 as select from I_SchedCapacityRqmtItemCap as CapRqmtItmCap 
// association [1..1] to I_SchedCapacityRqmtItemCap as CapRqmtItmCap on  CapRqmtItmCap.CapacityRequirement  = $projection.Dummy

 {

key CapRqmtItmCap.CapacityRequirement                                                                 as    CapacityRequirement,
//key _Capitemcap.CapacityRequirement  as Dummy,

//key CapRqmtItmCap.CapacityRequirementItem   as  CapacityRequirementItem,

//key CapRqmtItmCap.CapacityRqmtItemCapacity   as  CapacityRqmtItemCapacity,

key CapRqmtItmCap.WorkCenterInternalID                                                                as    WorkCenterInternalID,
min( CapRqmtItmCap.Operation )                                                                        as    Operation
//CapRqmtItmCap.OperationLatestStartDate  as OperationLatestStartDate ,

//

//CapRqmtItmCap.OperationLatestEndDate as OperationLatestEndDate

//CapRqmtItmCap



} 
where
//  CapRqmtItmCap.OperationIsPhase <> '2'

  CapRqmtItmCap.OperationIsPhase                 =  '0' or 
  CapRqmtItmCap.OperationIsPhase                 =  '1'

group by CapRqmtItmCap.CapacityRequirement,WorkCenterInternalID //,OperationLatestStartDate,OperationLatestEndDate


//define view P_SchedFirstOperation_Vers_2 as select distinct from I_CapacityRequirementItemCap    as kbed

//

//inner join ZDUMMY_TEST (p1: :kbed.sstad , p2: :kbed.sendd) as Paramview on  

//  Paramview.CapacityRequirement = kbed.CapacityRequirement  

//  {

//  

//  key Paramview.CapacityRequirement,

////  key cast(Paramview.bedzl as pph_bedzl preserving type) as CapacityRequirementItem,

////  key cast(Paramview.canum as pph_canum preserving type) as CapacityRqmtItemCapacity,

// key Paramview.WorkCenterInternalID ,

//  Paramview.Operation

////  kbed.phase_kz as OperationIsPhase

//  

//} 

//where

//  kbed.OperationIsPhase <> '2'


//group by kbed.bedid, kbed.arbid,kbed.phase_kz,kbed.bedzl,kbed.canum


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