P_MaintenancePlanSearch

@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_LongText']
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'MaintenancePlan'
//@Analytics.technicalName: 'PMAINTPLANSEARCH'

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #S
@ObjectModel.usageType.dataClass: #MASTER
define view entity P_MaintenancePlanSearch
  //with parameters

     //@Consumption.hidden: true

     //@Environment.systemField: #SYSTEM_LANGUAGE

     //P_Language : abap.lang,

     //@Consumption.hidden: true

     //@Environment.systemField: #SYSTEM_DATE

     //P_KeyDate : sydate

  as select from I_MaintenancePlanBasic
  association [0..*] to I_TextObjectPlainLongText      as _LongText            on  $projection.MaintenancePlan  = _LongText.TextObjectKey
                                                                               and _LongText.TextObjectCategory = 'MPLA'
                                                                               and _LongText.TextObjectType     = 'LTXT'
  association [0..*] to I_ClfnObjectCharcValForKeyDate as _CharValueAssignment on  $projection.MaintenancePlan          = _CharValueAssignment.ClfnObjectID
                                                                               and _CharValueAssignment.ClfnObjectTable = 'MPLA'
  association [0..*] to I_ClfnObjectClassForKeyDate    as _ClassAssignment     on  $projection.MaintenancePlan      = _ClassAssignment.ClfnObjectID
                                                                               and _ClassAssignment.ClfnObjectTable = 'MPLA'
{

  key MaintenancePlan,
      MaintenancePlanDesc,
      CreationDate,
      CreatedByUser,
      LastChangeDate,
      LastChangedByUser,
      MaintenanceStrategy,
      SchedulingDuration,
      Equipment,
      FunctionalLocation,
      Customer,
      NumberOfMaintenanceItems,
      I_MaintenancePlanBasic.Language,
      CycleModificationRatio,
      I_MaintenancePlanBasic.MaintPlanSchedgIndicator,
      // _SchedulingIndicator.MaintPlanSchedgIndDesc,

      CallHorizonPercent,
      CallHorizonInDays,
      AuthorizationGroup,
      MaintenancePlanInternalID,
      MaintenanceCall,
      MaintenancePlanCategory,
      SchedulingDurationUnit,
      BasicStartDate,
      MaintPlanFreeDefinedAttrib,
      FactoryCalendar,
      MaintPlanIsLockedAgainstCalls,
      LastChangeDateTime,
      LateCompletionShiftInPercent,
      EarlyCompletionShiftInPercent,
      LateCompletionTolerancePercent,
      EarlyCompletionTolerancePct,
      MaintenanceCallHorizonCalcType,
      MaintPlanLogicalOperatorCode ,
      MultipleCounterPlanShiftFactor,
      MaintPlanStartCntrReadingValue ,
      SchedulingStartDate,
      SchedulingStartTime,
      MaintPlanEndCntrReadingValue ,
      SchedulingEndDate,
      MaintenanceLeadFloatInDays,
      PrdcssrCallObjCompltnIsRqd,
      /* Associations */
      //I_MaintenancePlan

      _Customer,
      _Equipment,
      _FactoryCalendar,
      _FunctionalLocationLabel,
      //_MaintenanceCycle,

      _MaintenancePlanCycle,
      _MaintenanceItem,
      _MaintenancePlanCatParam,
      _MaintenanceStrategy,
      _MaintPlanCallHistory,
      _MaintenanceCall,
      _SchedulingIndicator,
      _StatusObjectActiveStatus,
      _LongText,
      _CharValueAssignment,
      _ClassAssignment
}