C_AllocationCycleVH

@AbapCatalog.sqlViewName: 'CALOCYCLEVH'
//@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Allocation Cycle Value Help'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'AllocationCycle'
@AccessControl.privilegedAssociations:  ['_CreatedByUserContactCard']

@Search.searchable: true
define view C_AllocationCycleVH
  as
  //with parameters P_AllocationType: FCO_ALLOCATION_CONTEXT

  //as

  select from  P_AllocationCycle
    inner join C_AllocationContextVH as _context on P_AllocationCycle.AllocationType = _context.AllocationType

  association [1..1] to P_AllocationCycle as _AllocationCycleCalc      on  $projection.AllocationType           = _AllocationCycleCalc.AllocationType
                                                                       and $projection.AllocationCycle          = _AllocationCycleCalc.AllocationCycle
                                                                       and $projection.AllocationCycleStartDate = _AllocationCycleCalc.AllocationCycleStartDate

  association [1..1] to I_UserContactCard as _CreatedByUserContactCard on  $projection.CreatedByUser = _CreatedByUserContactCard.ContactCardID

  //association [1..1] to I_AllocationContextType as _AllocationType      on $projection.AllocationType = _AllocationType.AllocationType

{
      @UI.hidden: true
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.5 }
  key AllocationCycle,
      @UI.hidden: true
      @ObjectModel.text.element: ['AllocationContextTypeText']
      @Consumption.labelElement: 'AllocationContextTypeText'
  key P_AllocationCycle.AllocationType,
  
      @Semantics.businessDate.from: true
      @Consumption.filter.multipleSelections: false
      @Consumption.filter.selectionType: #SINGLE  
  key AllocationCycleStartDate,

      _context.AllocationContextTypeText,

      @ObjectModel.text.element: ['AllocationCycleNameText']
      @Consumption.labelElement: 'AllocationCycleNameText'
      _AllocationCycleCalc.AllocationCycleName,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.5 }
      _AllocationCycleCalc.AllocationCycleNameText,
      _CreatedByUserContactCard.FullName,
      @UI.hidden: true
      CreatedByUser,
      @UI.hidden: true
      Ledger,
      AllocationPostingType,
      AllocationActualPlanVariant,

      _CreatedByUserContactCard
}
//where AllocationType = P_AllocationType

//where

//  AllocationType = 'ACDOC_CC'

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