P_MaintPlngBucketMaintOrdBasic

@VDM: {
  viewType: #CONSUMPTION,
  private: true
}
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations:['_LocationAccountAssignment']
@AbapCatalog: { sqlViewName: 'PMTPLGBKTMORDBSC', compiler.compareFilter, preserveKey }
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL

define view P_MaintPlngBucketMaintOrdBasic
  as select from I_MaintenanceOrder
  association [0..*] to I_FunclocationLabelInternal as _FuncnlLocationLabel on _FuncnlLocationLabel.FunctionalLocation = $projection.functionallocation
  //  association [0..1] to I_LocationAccountAssignment   as _LocationAccountAssignment  on  $projection.MaintObjectLocAcctAssgmtNmbr = _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr

  //  association [0..1] to I_Equipment                   as _Equipment                  on  $projection.Equipment = _Equipment.Equipment

{

  key I_MaintenanceOrder.MaintenanceOrder,
      I_MaintenanceOrder.MaintObjectLocAcctAssgmtNmbr,
      I_MaintenanceOrder.Equipment,
      _LocationAccountAssignment.FunctionalLocation,
      _LocationAccountAssignment.PlantSection,
      I_MaintenanceOrder.MaintenancePlanningPlant,
      I_MaintenanceOrder.MaintenancePlannerGroup,
      I_MaintenanceOrder.MaintenanceRevision,
      I_MaintenanceOrder.WorkCenterInternalID,
      I_MaintenanceOrder.WorkCenterTypeCode,
      I_MaintenanceOrder.MaintOrderRoutingNumber,
      I_MaintenanceOrder.MaintenanceOrderType,
      I_MaintenanceOrder.MaintenanceOrderDesc,
      I_MaintenanceOrder.MaintOrdBasicStartDate,
      I_MaintenanceOrder.MaintOrdBasicStartTime,
      I_MaintenanceOrder.MaintOrdBasicEndDate,
      I_MaintenanceOrder.MaintOrdBasicEndTime,
      I_MaintenanceOrder.ScheduledBasicStartDate,
      I_MaintenanceOrder.ScheduledBasicStartTime,
      I_MaintenanceOrder.ScheduledBasicEndDate,
      I_MaintenanceOrder.ScheduledBasicEndTime,
      I_MaintenanceOrder.MaintenancePlant,
      I_MaintenanceOrder.MainWorkCenter,
      I_MaintenanceOrder.MaintOrdProcessPhaseCode,

      /* Associations */
      _LocationAccountAssignment,
      _Equipment,
      _FuncnlLocationLabel
}

where
        I_MaintenanceOrder.MaintenanceProcessingPhase < '4'
  or(
        I_MaintenanceOrder.MaintenanceProcessingPhase = '6'
    and I_MaintenanceOrder.TechnicalCompletionDate != '00000000'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCEORDER"
],
"ASSOCIATED":
[
"I_EQUIPMENT",
"I_FUNCLOCATIONLABELINTERNAL",
"I_LOCATIONACCOUNTASSIGNMENT"
],
"BASE":
[
"I_MAINTENANCEORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/