I_AllocationSegment

@AbapCatalog.sqlViewName: 'ALLOCSEGMENT'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:#NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Allocation Segment'

@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M

@VDM.viewType: #BASIC
define view I_AllocationSegment
  as select from t811s
  association [1] to I_AllocationCycle as _Cycle on  $projection.AllocationType            = _Cycle.AllocationType
                                                 and $projection.AllocationCycle          = _Cycle.AllocationCycle
                                                 and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate
                                                 
//  association [1..1] to P_AllocationCycleCalc as _CycleCalc on  $projection.AllocationCycle          = _CycleCalc.AllocationCycle

//                                                           and $projection.AllocationType           = _CycleCalc.AllocationType

//                                                           and $projection.AllocationCycleStartDate = _CycleCalc.AllocationCycleStartDate

                                                 
  association [0..1] to I_AllocAssmtDistrLongText as _Text on  $projection.AllocationType           = _Text.AllocationType
                                                           and $projection.AllocationCycle          = _Text.AllocationCycle
                                                           and $projection.AllocationCycleStartDate = _Text.AllocationCycleStartDate
                                                           and _Text.LanguageCode                   = $session.system_language
                                                           and $projection.AllocationCycleSegment   = _Text.AllocationCycleSegment                                                    
{      
  key cast(tab as fco_allocation_type) as AllocationType,
  key cycle        as AllocationCycle, 
  key cast(sdate as fco_alloc_valid_from ) as AllocationCycleStartDate, 
  key cast(seqnr as fco_alloc_segment_number ) as AllocationCycleSegment,
      cast(name as fco_segment_name ) as SegmentName,
      seqpos       as AllocationSegmentPosition, 
      cast(srule as fco_alloc_sender_rule) as AllocationSenderRule, 
      cast(rrule as fco_alloc_receiver_rule) as AllocationReceiverRule, 
      active       as AllocationSegmentIsLocked, 
      negtest      as AllocScNgtvTracingFctr, 
      scset        as SenderTracingFieldGroup,
      sset         as SenderFieldGroup,
      rset         as ReceiverFieldGroup,
      rcset        as ReceiverTracingFieldGroup,
      cast(spercent as fco_alloc_sender_share_percent) as AllocSegmentShareInPercent, 
      sffeld1      as AllocationSenderFixedField1, 
      sffeld2      as AllocationSenderFixedField2, 
      sffeld3      as AllocationSenderFixedField3, 
      sffeld4      as AllocationSenderFixedField4, 
      sffeld5      as AllocationSenderFixedField5, 
      sffeld6      as AllocationSenderFixedField6, 
      sffeld7      as AllocationSenderFixedField7, 
      sffeld8      as AllocationSenderFixedField8, 
      sffeld9      as AllocationSenderFixedField9, 
      sffeld10     as AllocationSenderFixedField10, 
      facurr       as AllocationCurrency, 
      rffeld1      as AllocationReceiverFixedField1, 
      rffeld2      as AllocationReceiverFixedField2, 
      rffeld3      as AllocationReceiverFixedField3, 
      rffeld4      as AllocationReceiverFixedField4, 
      rffeld5      as AllocationReceiverFixedField5, 
      rffeld6      as AllocationReceiverFixedField6, 
      rffeld7      as AllocationReceiverFixedField7, 
      rffeld8      as AllocationReceiverFixedField8, 
      rffeld9      as AllocationReceiverFixedField9, 
      rffeld10     as AllocationReceiverFixedField10,
//      scip         as OriginPAType, //missing GFN

      rcdata       as AllocationFieldGroup,  
      asacc        as AssessmentCostElement, 
      pafldf       as AllocationFixedCostCenterCost, 
      pafldg       as AllocationVariableCostCtrCost, 
      rrfeld1      as AllocationAccountAssignment, 
      sortfield    as AllocationSegmentSortField,
      sender_not   as AllocIsSndrExclAsRcvr, 
      cast(mrule as fco_alloc_manipulation_rule) as ManipulationRuleForCyclicMaint, 
      cast( absch as fco_allocation_structure ) as AllocationStructure, 
      ersch        as AllocationTransferStructure, 
      sweight_fact as AllocSndrFctrPercent , 
      rweight_fact as AllocRcvrFctrPercent, 
      
      _Cycle,
      _Text
//      _CycleCalc

}