R_AllocationCycleTP

DDL: R_ALLOCATIONCYCLETP Type: view_entity TRANSACTIONAL

Allocation Cycle

R_AllocationCycleTP is a Transactional CDS View that provides data about "Allocation Cycle" in SAP S/4HANA. It reads from 1 data source (I_AllocationCycle) and exposes 18 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_AllocationCycle I_AllocationCycle from

Associations (4)

CardinalityTargetAliasCondition
[0..1] R_CycleRunGroupTP _CycleRunGroup $projection.AllocationType = _CycleRunGroup.AllocationType and $projection.Ledger = _CycleRunGroup.Ledger and $projection.AllocationCycleRunGroup = _CycleRunGroup.AllocationCycleRunGroup and $projection.AllocationPostingType = _CycleRunGroup.AllocationPostingType and $projection.AllocationActualPlanVariant = _CycleRunGroup.AllocationActualPlanVariant
[0..1] I_AllocationPostingType _AllocPostingType $projection.AllocationPostingType = _AllocPostingType.AllocationPostingType
[0..1] I_AllocCycleAssignmentStatus _AssignmentStatus $projection.AllocCycleAssignmentStatus = _AssignmentStatus.AllocCycleAssignmentStatus
[0..1] I_Ledger _Ledger $projection.Ledger = _Ledger.Ledger

Annotations (8)

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

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
AllocationCycleRunGroup AllocationCycleRunGroup
AllocationPostingType AllocationPostingType
AllocationActualPlanVariant AllocationActualPlanVariant
AllocationLastExecutedDate AllocationLastExecutedDate
Ledger Ledger
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
AllocationCycleNameText _Text AllocationCycleNameText
AllocationCycleName AllocationCycleName
_ActualPlanText _ActualPlanText
_Context _Context
_CycleRunGroup _CycleRunGroup
_AssignmentStatus _AssignmentStatus
_Ledger _Ledger
_AllocPostingType _AllocPostingType
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Allocation Cycle'
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API }
@ObjectModel.usageType: { dataClass: #CUSTOMIZING,
                          serviceQuality: #C,
                          sizeCategory: #M
            }
@AccessControl.privilegedAssociations:  [ '_Ledger' ]
@ObjectModel.sapObjectNodeType.name: 'AllocationPostingType'
define root view entity R_AllocationCycleTP
  as select from I_AllocationCycle

  association [0..1] to R_CycleRunGroupTP            as _CycleRunGroup    on  $projection.AllocationType              = _CycleRunGroup.AllocationType
                                                                          and $projection.Ledger                      = _CycleRunGroup.Ledger
                                                                          and $projection.AllocationCycleRunGroup     = _CycleRunGroup.AllocationCycleRunGroup
                                                                          and $projection.AllocationPostingType       = _CycleRunGroup.AllocationPostingType
                                                                          and $projection.AllocationActualPlanVariant = _CycleRunGroup.AllocationActualPlanVariant
  association [0..1] to I_AllocationPostingType      as _AllocPostingType on  $projection.AllocationPostingType = _AllocPostingType.AllocationPostingType
  association [0..1] to I_AllocCycleAssignmentStatus as _AssignmentStatus on  $projection.AllocCycleAssignmentStatus = _AssignmentStatus.AllocCycleAssignmentStatus
  association [0..1] to I_Ledger                     as _Ledger           on  $projection.Ledger = _Ledger.Ledger
{
  key AllocationType,
  key AllocationCycle,
      @Semantics.businessDate.from: true
  key AllocationCycleStartDate,
      AllocationCycleRunGroup,
      AllocationPostingType,
      AllocationActualPlanVariant,
      @Semantics.businessDate.at: true
      AllocationLastExecutedDate,
      Ledger,
      LastChangeDate,
      LastChangedByUser,
      @Semantics.text: true
      _Text.AllocationCycleNameText,
      AllocationCycleName,
      cast(
        case AllocationCycleRunGroup
          when '0000' then '1'
          when ''     then '1'
          else '2'
        end
      as fco_alloc_cycle_assgmt_status) as AllocCycleAssignmentStatus,

      cast(
        case AllocationCycleRunGroup
          when '0000' then '3'
          when ''     then '3'
          else '2'
        end
      as eve_tv_criticality)            as StatusCriticality,

      /* Associations */
      _ActualPlanText,
      _Context,
      _CycleRunGroup,
      _AssignmentStatus,
      _Ledger,
      _AllocPostingType
}
where
  AllocationCycleStartDate <> '00000000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ALLOCASSMTDISTRLONGTEXT",
"I_ALLOCATIONCYCLE"
],
"ASSOCIATED":
[
"I_ALLOCACTUALPLANVARIANTTEXT",
"I_ALLOCATIONCONTEXTTYPE",
"I_ALLOCATIONPOSTINGTYPE",
"I_ALLOCCYCLEASSIGNMENTSTATUS",
"I_LEDGER",
"R_CYCLERUNGROUPTP"
],
"BASE":
[
"I_ALLOCATIONCYCLE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/