P_UniAllocTagObjectAssignment

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PUNIALLOTAGASGN'
@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_UniAllocTagObjectAssignment
//  with parameters

//    P_AllocationTagID :fco_tag_id


  as select from            I_AllocationCycle as _Cycle

    inner join              I_AllocationSegment as _Segment        on  _Cycle.AllocationType          = _Segment.AllocationType
                                                                  and _Cycle.AllocationCycle          = _Segment.AllocationCycle
                                                                  and _Cycle.AllocationCycleStartDate = _Segment.AllocationCycleStartDate

//    left outer to many join P_AllocTagObjectAssignment(P_AllocationTagID:$parameters.P_AllocationTagID) as _AllocTagAssign 

//    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' or _AllocTagAssign.AllocationCycleSegment = _Segment.AllocationCycleSegment )

{

  key _Cycle.AllocationType,

  key _Cycle.AllocationCycle,

  key _Cycle.AllocationCycleStartDate,

//      @UI.hidden: true

  key _Segment.AllocationCycleSegment,

      _Segment.SegmentName,

//      cast( '' as fco_alloc_tag ) as AllocationTagID,


      cast ('U' as fco_alloc_tag_assignment)  as AllocTagAssignmentStatus,
//      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",
"I_ALLOCATIONSEGMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/