R_UniversalAllocationSegmentTP

DDL: R_UNIVERSALALLOCATIONSEGMENTTP Type: view_entity TRANSACTIONAL Package: ODATA_MANAGE_ALLOCATION_V2_RAP

Universal Allocation Segment Draft

R_UniversalAllocationSegmentTP is a Transactional CDS View that provides data about "Universal Allocation Segment Draft" in SAP S/4HANA. It reads from 1 data source (I_UniversalAllocationSegment) and exposes 70 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment. It has 12 associations to related views. Part of development package ODATA_MANAGE_ALLOCATION_V2_RAP.

Data Sources (1)

SourceAliasJoin Type
I_UniversalAllocationSegment I_UniversalAllocationSegment from

Associations (12)

CardinalityTargetAliasCondition
[0..*] I_AllocationStructureText _StructureText $projection.AllocationStructure = _StructureText.AllocationStructure
[0..*] I_CurrencyText _CurrencyText $projection.AllocationCurrency = _CurrencyText.Currency
[0..*] R_UnivAllocVirtualKeyField _VirtualKeyField $projection.AllocationType = _VirtualKeyField.AllocationType and $projection.AllocationCycle = _VirtualKeyField.AllocationCycle and $projection.AllocationCycleStartDate = _VirtualKeyField.AllocationCycleStartDate and $projection.AllocationCycleSegment = _VirtualKeyField.AllocationCycleSegment
[0..*] R_UnivAllocSenderKeyFieldTP _SenderKeyField
[0..*] R_UnivAllocSndrValKeyFieldTP _SenderValueKeyField
[0..*] R_UnivAllocReceiverKeyFieldTP _ReceiverKeyField
[0..*] R_UnivAllocRcvrFctrKeyFieldTP _ReceiverTracingFactorKeyFld
[0..*] R_UnivAllocReceiverElementTP _ReceiverElement
[0..*] R_UnivAllocSenderElementTP _SenderElement
[0..*] R_UnivAllocRcvrFctrElementTP _ReceiverWeightingFactorElem
[0..*] R_UnivAllocTagSgmtAssignmentTP _TagToSegmentAssignment
[0..*] R_UnivAllocationSegmentTextTP _Text

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Universal Allocation Segment Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (70)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
KEY AllocationCycleSegment AllocationCycleSegment
SegmentName SegmentName
AllocationSegmentPosition AllocationSegmentPosition
AllocationSenderRule AllocationSenderRule
AllocationReceiverRule AllocationReceiverRule
AllocationSegmentIsLocked AllocationSegmentIsLocked
AllocScNgtvTracingFctr AllocScNgtvTracingFctr
SenderTracingFieldGroup SenderTracingFieldGroup
SenderFieldGroup SenderFieldGroup
ReceiverFieldGroup ReceiverFieldGroup
ReceiverTracingFieldGroup ReceiverTracingFieldGroup
AllocationSenderFixedField1 AllocationSenderFixedField1
AllocationSenderFixedField2 AllocationSenderFixedField2
AllocationSenderFixedField3 AllocationSenderFixedField3
AllocationSenderFixedField4 AllocationSenderFixedField4
AllocationSenderFixedField5 AllocationSenderFixedField5
AllocationSenderFixedField6 AllocationSenderFixedField6
AllocationSenderFixedField7 AllocationSenderFixedField7
AllocationSenderFixedField8 AllocationSenderFixedField8
AllocationSenderFixedField9 AllocationSenderFixedField9
AllocationSenderFixedField10 AllocationSenderFixedField10
AllocationCurrency AllocationCurrency
AllocationReceiverFixedField1 AllocationReceiverFixedField1
AllocationReceiverFixedField2 AllocationReceiverFixedField2
AllocationReceiverFixedField3 AllocationReceiverFixedField3
AllocationReceiverFixedField4 AllocationReceiverFixedField4
AllocationReceiverFixedField5 AllocationReceiverFixedField5
AllocationReceiverFixedField6 AllocationReceiverFixedField6
AllocationReceiverFixedField7 AllocationReceiverFixedField7
AllocationReceiverFixedField8 AllocationReceiverFixedField8
AllocationReceiverFixedField9 AllocationReceiverFixedField9
AllocationReceiverFixedField10 AllocationReceiverFixedField10
AllocationFieldGroup AllocationFieldGroup
AssessmentCostElement AssessmentCostElement
AllocationFixedCostCenterCost AllocationFixedCostCenterCost
AllocationVariableCostCtrCost AllocationVariableCostCtrCost
AllocationAccountAssignment AllocationAccountAssignment
AllocationSegmentSortField AllocationSegmentSortField
AllocIsSndrExclAsRcvr AllocIsSndrExclAsRcvr
ManipulationRuleForCyclicMaint ManipulationRuleForCyclicMaint
AllocationStructure AllocationStructure
AllocationTransferStructure AllocationTransferStructure
AllocSndrFctrPercent AllocSndrFctrPercent
AllocRcvrFctrPercent AllocRcvrFctrPercent
AllocSegmentShareInPercent AllocSegmentShareInPercent
NoteText
CycleIsAttributedLineItmEnbld _Cycle CycleIsAttributedLineItmEnbld
AllocationTagID
AllocationReferenceLedger
AllocationSenderValueIsNew
PlanningCategory
_ReceiverRule _ReceiverRule
_SenderRule _SenderRule
_SegmentStatus _SegmentStatus
_Cycle _Cycle
_SenderKeyField _SenderKeyField
_SenderValueKeyField _SenderValueKeyField
_ReceiverKeyField _ReceiverKeyField
_ReceiverTracingFactorKeyFld _ReceiverTracingFactorKeyFld
_ReceiverElement _ReceiverElement
_SenderElement _SenderElement
_ReceiverWeightingFactorElem _ReceiverWeightingFactorElem
_TagToSegmentAssignment _TagToSegmentAssignment
_Text _Text
_StructureText _StructureText
_CurrencyText _CurrencyText
_AllocationFieldGroupText _AllocationFieldGroupText
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Universal Allocation Segment Draft'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #CUSTOMIZING }
@VDM: { viewType: #TRANSACTIONAL,
        lifecycle.contract.type: #SAP_INTERNAL_API }
define view entity R_UniversalAllocationSegmentTP
  as select from I_UniversalAllocationSegment

  association        to parent R_UniversalAllocationCycleTP as _Cycle           on  $projection.AllocationType           = _Cycle.AllocationType
                                                                                and $projection.AllocationCycle          = _Cycle.AllocationCycle
                                                                                and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate

  association [0..*] to I_AllocationStructureText           as _StructureText   on  $projection.AllocationStructure = _StructureText.AllocationStructure
  association [0..*] to I_CurrencyText                      as _CurrencyText    on  $projection.AllocationCurrency  = _CurrencyText.Currency
  association [0..*] to R_UnivAllocVirtualKeyField          as _VirtualKeyField on  $projection.AllocationType           = _VirtualKeyField.AllocationType
                                                                                and $projection.AllocationCycle          = _VirtualKeyField.AllocationCycle
                                                                                and $projection.AllocationCycleStartDate = _VirtualKeyField.AllocationCycleStartDate
                                                                                and $projection.AllocationCycleSegment   = _VirtualKeyField.AllocationCycleSegment

  composition [0..*] of R_UnivAllocSenderKeyFieldTP         as _SenderKeyField
  composition [0..*] of R_UnivAllocSndrValKeyFieldTP        as _SenderValueKeyField
  composition [0..*] of R_UnivAllocReceiverKeyFieldTP       as _ReceiverKeyField
  composition [0..*] of R_UnivAllocRcvrFctrKeyFieldTP       as _ReceiverTracingFactorKeyFld
  composition [0..*] of R_UnivAllocReceiverElementTP        as _ReceiverElement
  composition [0..*] of R_UnivAllocSenderElementTP          as _SenderElement
  composition [0..*] of R_UnivAllocRcvrFctrElementTP        as _ReceiverWeightingFactorElem
  composition [0..*] of R_UnivAllocTagSgmtAssignmentTP      as _TagToSegmentAssignment
  composition [0..*] of R_UnivAllocationSegmentTextTP       as _Text

{
  key AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,
  key AllocationCycleSegment,

      SegmentName,

      AllocationSegmentPosition,
      AllocationSenderRule,
      AllocationReceiverRule,
      @Semantics.booleanIndicator: true
      AllocationSegmentIsLocked,
      AllocScNgtvTracingFctr,
      SenderTracingFieldGroup,
      SenderFieldGroup,
      ReceiverFieldGroup,
      ReceiverTracingFieldGroup,
      AllocationSenderFixedField1,
      AllocationSenderFixedField2,
      AllocationSenderFixedField3,
      AllocationSenderFixedField4,
      AllocationSenderFixedField5,
      AllocationSenderFixedField6,
      AllocationSenderFixedField7,
      AllocationSenderFixedField8,
      AllocationSenderFixedField9,
      AllocationSenderFixedField10,
      AllocationCurrency,
      AllocationReceiverFixedField1,
      AllocationReceiverFixedField2,
      AllocationReceiverFixedField3,
      AllocationReceiverFixedField4,
      AllocationReceiverFixedField5,
      AllocationReceiverFixedField6,
      AllocationReceiverFixedField7,
      AllocationReceiverFixedField8,
      AllocationReceiverFixedField9,
      AllocationReceiverFixedField10,
      AllocationFieldGroup,
      AssessmentCostElement,
      AllocationFixedCostCenterCost,
      AllocationVariableCostCtrCost,
      AllocationAccountAssignment,
      AllocationSegmentSortField,
      AllocIsSndrExclAsRcvr,
      ManipulationRuleForCyclicMaint,
      AllocationStructure,
      AllocationTransferStructure,
      AllocSndrFctrPercent,
      AllocRcvrFctrPercent,
      AllocSegmentShareInPercent,

      cast( _Note.NoteText as fcoua_segment_note ) as NoteText,
      _Cycle.CycleIsAttributedLineItmEnbld,

      cast('' as fco_tag_id)                       as AllocationTagID,
      cast('' as fco_alloc_reference_ledger)       as AllocationReferenceLedger,
      cast(' ' as boolean)                         as AllocationSenderValueIsNew,

      cast( _VirtualKeyField[1:AllocationFieldName = 'CATEGORY'].AllocationFieldMinimumValue as fcom_category ) as PlanningCategory,
      cast(
      case substring(AllocationFieldGroup, 1, 4)
        when 'VMSL' 
          then _VirtualKeyField[1:AllocationFieldName = 'RVUNIT'].AllocationFieldMinimumValue
        else 
          _VirtualKeyField[1:AllocationFieldName = 'RUNIT'].AllocationFieldMinimumValue
      end as meins )   as UnitOfMeasure,

      _ReceiverRule,
      _SenderRule,
      _SegmentStatus,

      _Cycle,
      _SenderKeyField,
      _SenderValueKeyField,
      _ReceiverKeyField,
      _ReceiverTracingFactorKeyFld,
      _ReceiverElement,
      _SenderElement,
      _ReceiverWeightingFactorElem,
      _TagToSegmentAssignment,
      _Text,
      _StructureText,
      _CurrencyText,
      _AllocationFieldGroupText
}