I_ALLOCATIONSEGMENT

CDS View

Allocation Segment

I_ALLOCATIONSEGMENT is a CDS View in S/4HANA. Allocation Segment. It contains 6 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_AllocationSegmentTP view from TRANSACTIONAL Allocation Segment TP
P_AllocationStatus view inner CONSUMPTION Allocation Status
P_CycleSegmentHierSourceParam view from CONSUMPTION Cycle Segment Hierarchy Source with parameter
P_UniAllocTagObjectAssignment view inner COMPOSITE Assign tag to cycle and segment

Fields (6)

KeyField CDS FieldsUsed in Views
KEY AllocationCycleSegment AllocationCycleSegment 2
KEY AllocationSegmentIsLocked AllocationSegmentIsLocked 1
KEY AllocationType AllocationType 1
AllocationCycle AllocationCycle 1
AllocationCycleStartDate AllocationCycleStartDate 1
SegmentName SegmentName 2
@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

}