R_UniversalAllocationCycleTP
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)
| Source | Alias | Join Type |
|---|---|---|
| R_UniversalAllocationCycle | R_UniversalAllocationCycle | from |
Associations (6)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA