R_UniversalAllocationCycleTP

DDL: R_UNIVERSALALLOCATIONCYCLETP Type: view_entity TRANSACTIONAL Package: ODATA_MANAGE_ALLOCATION_V2_RAP

Allocation Cycle Draft

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

Data Sources (1)

SourceAliasJoin Type
R_UniversalAllocationCycle R_UniversalAllocationCycle from

Associations (6)

CardinalityTargetAliasCondition
[0..*] R_UniversalAllocationSegmentTP _Segment
[0..*] R_UnivAllocFieldDerivationTP _FieldDerivation
[0..*] R_UnivAllocCycleFieldGroupTP _FieldGroup
[0..*] R_UnivAllocTagCycAssignmentTP _TagAssignment
[0..*] R_UnivAllocationCycleTextTP _Text
[0..1] R_UnivAllocTopDwnDistrTmplTP _TopDownDistributionTemplate

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Allocation Cycle Draft view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.sapObjectNodeType.name AllocationCycle view

Fields (70)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
AllocationCycleName AllocationCycleName
Ledger Ledger
CompanyCode CompanyCode
AllocationCycleCategory AllocationCycleCategory
ControllingArea ControllingArea
OperatingConcern OperatingConcern
AllocationCycleEndDate AllocationCycleEndDate
AllocationFrequency AllocationFrequency
AllocationCreateDate AllocationCreateDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
LastChangedByUser LastChangedByUser
AllocationLastExecutedDate AllocationLastExecutedDate
AllocationLastExecutedByUser AllocationLastExecutedByUser
AllocationLastExecutionTime AllocationLastExecutionTime
AllocationCycleSet AllocationCycleSet
ScaleNegativeTracingFactor ScaleNegativeTracingFactor
AllocationPostingType AllocationPostingType
AllocationActualPlanVariant AllocationActualPlanVariant
AllocationJob AllocationJob
AllocationIsCumulative AllocationIsCumulative
AllocIsCumulativeOptimized AllocIsCumulativeOptimized
AllocHasAggregatedProcess AllocHasAggregatedProcess
AllocationCycleRunGroup AllocationCycleRunGroup
AllocationSubstitutionName AllocationSubstitutionName
AllocFundMgmtIsActive AllocFundMgmtIsActive
AllocationIsBalanceSheetActive AllocationIsBalanceSheetActive
AllocHasDerivdFundFrmRcpnt AllocHasDerivdFundFrmRcpnt
AllocIsDerivdFuncAreaFrmRcpnt AllocIsDerivdFuncAreaFrmRcpnt
AllocIsDerivdGrantFrmRcpnt AllocIsDerivdGrantFrmRcpnt
AllocIsDerivdBudgedPerdRcpnt AllocIsDerivdBudgedPerdRcpnt
AllocationLedgerGroup AllocationLedgerGroup
AllocationIsPeriodShiftActive AllocationIsPeriodShiftActive
AllocationPeriodDeltaSize AllocationPeriodDeltaSize
AllocIsProdnMnthDerivd AllocIsProdnMnthDerivd
AllocationIsVariableQuantity AllocationIsVariableQuantity
AllocationValuationType AllocationValuationType
CycleIsDeltaProcessEnabled CycleIsDeltaProcessEnabled
AllocationCycleIsIterative AllocationCycleIsIterative
CycleIsParallelLedgerEnabled CycleIsParallelLedgerEnabled
CycleIsAttributedLineItmEnbld CycleIsAttributedLineItmEnbld
AllocationStatus AllocationStatus
LastChangeDateTime LastChangeDateTime
LocalLastChangeDateTime LastChangeDateTime
NoteText
AllocationTagID
LanguageCode
_Segment _Segment
_FieldDerivation _FieldDerivation
_FieldGroup _FieldGroup
_CycleNote _CycleNote
_TagAssignment _TagAssignment
_Text _Text
_TopDownDistributionTemplate _TopDownDistributionTemplate
_AllocationPostingTypeText _AllocationPostingTypeText
_CycleCalc _CycleCalc
_CycleRunGroup _CycleRunGroup
_LedgerText _LedgerText
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_LastExecByUser _LastExecByUser
_AllocationStatus _AllocationStatus
_ActualPlanVariant _ActualPlanVariant
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_Context _Context
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Allocation Cycle Draft'
@VDM: { viewType: #TRANSACTIONAL,
        lifecycle.contract.type: #SAP_INTERNAL_API }
@ObjectModel: {
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #C,
    sizeCategory: #M },
  sapObjectNodeType.name: 'AllocationCycle',
  semanticKey: [ 'AllocationType','AllocationCycle', 'AllocationCycleStartDate' ] }
@AccessControl.privilegedAssociations: [ '_CreatedByUser' ]
define root view entity R_UniversalAllocationCycleTP
  as select from R_UniversalAllocationCycle

  composition [0..*] of R_UniversalAllocationSegmentTP as _Segment
  composition [0..*] of R_UnivAllocFieldDerivationTP   as _FieldDerivation
  composition [0..*] of R_UnivAllocCycleFieldGroupTP   as _FieldGroup
  composition [0..*] of R_UnivAllocTagCycAssignmentTP  as _TagAssignment
  composition [0..*] of R_UnivAllocationCycleTextTP    as _Text
  composition [0..1] of R_UnivAllocTopDwnDistrTmplTP   as _TopDownDistributionTemplate
{
  key AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,
      //AllocationCycleTimeZone,

      AllocationCycleName,
      Ledger,
      CompanyCode,
      AllocationCycleCategory,
      ControllingArea,
      OperatingConcern,
      AllocationCycleEndDate,
      AllocationFrequency,
      @Semantics.systemDate.createdAt: true
      AllocationCreateDate,
      @Semantics.user.createdBy: true
      CreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,
      @Semantics.systemTime.lastChangedAt: true
      LastChangeTime,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      AllocationLastExecutedDate,
      AllocationLastExecutedByUser,
      AllocationLastExecutionTime,
      AllocationCycleSet,
      ScaleNegativeTracingFactor,
      AllocationPostingType,
      AllocationActualPlanVariant,
      AllocationJob,
      AllocationIsCumulative,
      AllocIsCumulativeOptimized,
      AllocHasAggregatedProcess,
      AllocationCycleRunGroup,
      AllocationSubstitutionName,
      AllocFundMgmtIsActive,
      AllocationIsBalanceSheetActive,
      AllocHasDerivdFundFrmRcpnt,
      AllocIsDerivdFuncAreaFrmRcpnt,
      AllocIsDerivdGrantFrmRcpnt,
      AllocIsDerivdBudgedPerdRcpnt,
      AllocationLedgerGroup,
      AllocationIsPeriodShiftActive,
      AllocationPeriodDeltaSize,
      AllocIsProdnMnthDerivd,
      AllocationIsVariableQuantity,
      AllocationValuationType,
      CycleIsDeltaProcessEnabled,
      AllocationCycleIsIterative,
      CycleIsParallelLedgerEnabled,
      CycleIsAttributedLineItmEnbld,
      AllocationStatus,
      cast ( case AllocationStatus
        when 'P' then 2 //yellow

        when 'L' then 1 //red

        else 3 //green

      end as eve_tv_criticality ) as CriticalityCode,

      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime,
      @Semantics.systemDateTime.localInstanceLastChangedAt: true
      LastChangeDateTime as LocalLastChangeDateTime,
      @Semantics.text: true
      cast( _CycleNote.NoteText as fcoua_cycle_note ) as NoteText,

      cast('' as fco_tag_id)                          as AllocationTagID,
      $session.system_language      as LanguageCode,
      
      @Semantics.booleanIndicator: true
      cast (case when AllocationType = 'ACDOC_PA' and AllocationPostingType = 'K'
                 then //TDD cycle

                    case when UnivAllocTopDwnDistrCycleHash = _TemplateHeader.TopDwnDistrTmplHash
                      then 'X'
                      else ''
                    end
                  else //other cycles

                    'X'
          end as fco_alloc_consistency preserving type) as AllocationCycleIsConsistent,
      
      _Segment,
      _FieldDerivation,
      _FieldGroup,
      _CycleNote,
      _TagAssignment,
      _Text,
      _TopDownDistributionTemplate,
      //Texts

      _AllocationPostingTypeText,
      _CycleCalc,
      _CycleRunGroup,
      _LedgerText,
      _CreatedByUser,
      _ChangedByUser,
      _LastExecByUser,
      _AllocationStatus,
      _ActualPlanVariant,
      _CompanyCode,
      _ControllingArea,
      _Context

}