R_AllocationCycleTP

DDL: R_ALLOCATIONCYCLETP Type: view_entity TRANSACTIONAL
18 Fields 1 Data Sources 4 Associations

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 Table
KEY AllocationCycle AllocationCycle Cycle
KEY AllocationCycleStartDate AllocationCycleStartDate Valid From
AllocationCycleRunGroup AllocationCycleRunGroup Cycle Run Group
AllocationPostingType AllocationPostingType Posting Type
AllocationActualPlanVariant AllocationActualPlanVariant Actual/Plan
AllocationLastExecutedDate AllocationLastExecutedDate
Ledger Ledger Ledger
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
AllocationCycleNameText _Text AllocationCycleNameText Cycle Description
AllocationCycleName AllocationCycleName Allocation Cycle
_ActualPlanText _ActualPlanText
_Context _Context
_CycleRunGroup _CycleRunGroup
_AssignmentStatus _AssignmentStatus
_Ledger _Ledger
_AllocPostingType _AllocPostingType

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_AllocationCycleTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_AllocationCycleTP AS
SELECT
  AllocationType,
  AllocationCycle,
  AllocationCycleStartDate,
  AllocationCycleRunGroup,
  AllocationPostingType,
  AllocationActualPlanVariant,
  AllocationLastExecutedDate,
  Ledger,
  LastChangeDate,
  LastChangedByUser,
  _Text.AllocationCycleNameText AS AllocationCycleNameText,
  AllocationCycleName
FROM I_AllocationCycle
LEFT OUTER JOIN R_CycleRunGroupTP AS _CycleRunGroup ON AllocationType = _CycleRunGroup.AllocationType AND Ledger = _CycleRunGroup.Ledger AND AllocationCycleRunGroup = _CycleRunGroup.AllocationCycleRunGroup AND AllocationPostingType = _CycleRunGroup.AllocationPostingType AND AllocationActualPlanVariant = _CycleRunGroup.AllocationActualPlanVariant  -- association [0..1]
LEFT OUTER JOIN I_AllocationPostingType AS _AllocPostingType ON AllocationPostingType = _AllocPostingType.AllocationPostingType  -- association [0..1]
LEFT OUTER JOIN I_AllocCycleAssignmentStatus AS _AssignmentStatus ON AllocCycleAssignmentStatus = _AssignmentStatus.AllocCycleAssignmentStatus  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
;

Learn More