P_UniAllocTagCycleAssignment

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PUNIALLOCYCASGN'
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey:true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel: {
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #S,
   usageType.dataClass: #MIXED
}
define view P_UniAllocTagCycleAssignment
//  with parameters

//    P_AllocationTagID :fco_tag_id


  as select from            I_AllocationCycle as _Cycle

    left outer to many join P_AllocTagObjectAssignment as _AllocTagAssign 
      on  _Cycle.AllocationType                    = _AllocTagAssign.AllocationType
        and _Cycle.AllocationCycle                 = _AllocTagAssign.AllocationCycle
        and _Cycle.AllocationCycleStartDate        = _AllocTagAssign.AllocationCycleStartDate
        and _AllocTagAssign.AllocationCycleSegment = '0000'
{

  key _Cycle.AllocationType,

  key _Cycle.AllocationCycle,

  key _Cycle.AllocationCycleStartDate,

//      @UI.hidden: true

  key cast( 0000 as fco_segment_name ) as AllocationCycleSegment,

      _AllocTagAssign.AllocationTagID,

      case
        when AllocationTagID is null
          then cast (('U') as fco_alloc_tag_assignment)
        else
          cast (('A') as fco_alloc_tag_assignment)
      end                                                                    as AllocTagAssignmentStatus,

      AllocationCycleEndDate,

      AllocationFrequency,
      _Cycle.AllocationCreateDate, // missing GFN

      //      @UI.lineItem: [ { type: #AS_CONTACT, label: 'Created By', value: '_CreatedByUserContactCard' } ]

      CreatedByUser,
      //      _CreatedByUserContactCard.FullName                                                                               as CreatedByUserName,

      _Cycle.LastChangeDate,

      //      @UI.lineItem: [ { type: #AS_CONTACT, label: 'Changed By', value: '_LastChangeUserContactCard', position: 100, importance: #HIGH } ]


      LastChangedByUser,

      cast(AllocationPostingType as fco_alloc_posting_type  preserving type) as AllocationPostingType,

      AllocationActualPlanVariant
}
where
       _Cycle.AllocationType           is not initial
  and  _Cycle.AllocationCycle          is not initial
  and  _Cycle.AllocationCycleStartDate is not initial
  and(
       _Cycle.AllocationType           = 'ACDOC_CC'
    or _Cycle.AllocationType           = 'ACDOC_PC'
    or _Cycle.AllocationType           = 'ACDOC_PA'
  )
//  and(

//       _AllocTagAssign.AllocationTagID = $parameters.P_AllocationTagID

//    or _AllocTagAssign.AllocationTagID is null

//  )

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