P_RSHMntSchdOrdOpWOExplRel

@AbapCatalog.sqlViewName: 'PRSHSCHDOPWOREL'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Schedule Operations w/o explicit rel'
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #META
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true

define view P_RSHMntSchdOrdOpWOExplRel
  as select from P_RSHMntSchdOrdWOExplRel as sim_ord

inner join   I_LogisticsOrderBasic as ord  on sim_ord.MaintOrderRoutingNumber   = ord.OrderInternalID

inner join   I_SchedulingType      as st   on ord.BasicSchedulingType           = st.SchedulingType and 
                                              st.CalcOfCapacityRqmtsIsPerformed = ''
 
// do not consider sub-operations

inner join   I_OrderOperationBasic as op on sim_ord.MaintOrderRoutingNumber     = op.OrderInternalID and
                                            op.SuperiorOperationInternalID      = '00000000'
                            
// do not consider deleted operations

  left outer to one join I_StatusObjectStatusBasic   as _OpIsDeleted   on  _OpIsDeleted.StatusObject     = op.OrderOperationInternalID
                                                                and _OpIsDeleted.StatusCode       = 'I0013'
                                                                and _OpIsDeleted.StatusIsInactive = ' '
//

//// get scheduled dates/times for relationship violation determination

//  association [0..1] to I_RSHMaintScheduleOperations as _OperationSimulation on sim_ord.MaintSchedSimlnUUID   = _OperationSimulation.MaintSchedSimlnUUID and 

//                                                                                op.OrderInternalID            = _OperationSimulation.MaintOrderRoutingNumber and

//                                                                                op.OrderOperationInternalID   = _OperationSimulation.MaintOrderOperationCounter and 

//                                                                                _OperationSimulation.MaintOrdOpSimulationStatus = '10' //Scheduled                                                                  

//

//// get original dates/times for relationship violation determination                                                             

//   association [0..1] to I_MaintOrderOperPlanningValues as _OperationPlanningValues on op.OrderInternalID          = _OperationPlanningValues.MaintOrderRoutingNumber and

//                                                                                       op.OrderOperationInternalID = _OperationPlanningValues.MaintOrderOperationCounter

//         

{

 key op.OrderInternalID, 
 key op.OrderOperationInternalID,
 MaintSchedSimlnUUID,
 
 ord.OrderID,          
 op.Operation
 
// st.SchedulingIsPerformedBackward,

 
// _OperationSimulation,

// _OperationPlanningValues

 
}                              
       
where
  _OpIsDeleted.StatusObject is null


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOGISTICSORDERBASIC",
"I_ORDEROPERATIONBASIC",
"I_SCHEDULINGTYPE",
"I_STATUSOBJECTSTATUSBASIC",
"P_RSHMNTSCHDORDWOEXPLREL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/