C_AllocationCycleTP

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 C_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.
-- SQL view name: CALLOCCYCLE

CREATE VIEW C_AllocationCycleTP AS
SELECT
  I_AllocationCycleTP.AllocationType AS AllocationType,
  AllocationCycle,
  AllocationCycleStartDate,
  _CycleCalc.AllocationCycleName AS AllocationCycleName,
  AllocationCycleNameText,
  AllocationCycleEndDate,
  _CycleCalc.CriticalityCode AS CriticalityCode,
  _CycleCalc.AllocationStatus AS AllocationStatus,
  _CycleCalc._AllocationStatus._Text[1:Language = $session.system_language].AllocationStatusDescription AS AllocationStatusDescription,
  AllocationFrequency,
  AllocationCreateDate,
  CreatedByUser,
  cast(_CreatedByUser.FullName as fco_create_usr_name) AS CreatedByUserName,
  LastChangeDate,
  LastChangedByUser,
  cast(_LastChangeUser.FullName as fco_change_usr_name) AS LastChangedByUserName,
  AllocationLastExecutedDate,
  AllocationLastExecutedByUser,
  cast(_LastExecUser.FullName as fco_last_exec_usr_name) AS AllocLastExecutedByUserName,
  AllocationLastExecutionTime,
  AllocationIsProcessed,
  AllocationCycleSet,
  ScaleNegativeTracingFactor,
  cast(AllocationPostingType as fco_alloc_posting_type preserving type) AS AllocationPostingType,
  AllocationActualPlanVariant,
  _CycleCalc.AllocActualPlanVariantText AS AllocActualPlanVariantText,
  _CycleCalc.AllocationContextTypeText AS AllocationContextTypeText,
  AllocationJob,
  AllocationIsCumulative,
  AllocIsCumulativeOptimized,
  AllocHasAggregatedProcess,
  cast(AllocationCycleRunGroup as alloc_cycle_run_group preserving type) AS AllocationCycleRunGroup,
  _CycleCalc.AllocationCycleRunGroupText AS AllocationCycleRunGroupText,
  AllocationSubstitutionName,
  AllocFundMgmtIsActive,
  AllocationIsBalanceSheetActive,
  AllocHasDerivdFundFrmRcpnt,
  AllocIsDerivdFuncAreaFrmRcpnt,
  AllocIsDerivdGrantFrmRcpnt,
  AllocIsDerivdBudgedPerdRcpnt,
  AllocationLedgerGroup,
  AllocationIsPeriodShiftActive,
  AllocationPeriodDeltaSize,
  AllocIsProdnMnthDerivd,
  AllocationIsVariableQuantity,
  AllocationValuationType,
  _CycleCalc.CompanyCode AS CompanyCode,
  CompanyCodeForEdit,
  _CycleCalc.CompanyCodeName AS CompanyCodeName,
  _CycleCalc.Ledger AS Ledger,
  _CycleCalc.LedgerName AS LedgerName,
  LedgerForEdit,
  _CycleCalc.AllocationCycleCategory AS AllocationCycleCategory,
  AllocationCycleCategoryForEdit,
  _CycleCalc.AllocationCostElement AS AllocationCostElement,
  _Template.TopDwnDistrTmplName AS TopDwnDistrTmplName,
  cast(_CycleCalc.AllocationCycleIsConsistent as fco_alloc_consistency) AS AllocationCycleIsConsistent,
  _CycleCalc.AllocCycleIsConsistentText AS AllocCycleIsConsistentText,
  cast( _Field[1:AllocationFieldName = 'KOKRS'].AllocationFieldMinimumValue as fis_kokrs ) AS ControllingArea,
  cast('' as boolean) AS ManipulationRuleIsAvailable,
  AllocationTagID,
  AllocationCycleIsIterative,
  CycleIsDeltaProcessEnabled,
  CycleIsParallelLedgerEnabled,
  CycleIsAttributedLineItmEnbld,
  _CycleNote.NoteText AS NoteText
FROM I_AllocationCycleTP
LEFT OUTER JOIN C_AllocTopDwnDistrCycTmplTP AS _Template ON AllocationType = _Template.AllocationType AND AllocationCycle = _Template.AllocationCycle AND AllocationCycleStartDate = _Template.AllocationCycleStartDate  -- association [0..1]
LEFT OUTER JOIN C_AllocationSegmentTP AS _Segment ON AllocationType = _Segment.AllocationType AND AllocationCycle = _Segment.AllocationCycle AND AllocationCycleStartDate = _Segment.AllocationCycleStartDate  -- association [0..*]
LEFT OUTER JOIN C_AllocationCycleInformation AS _Information ON AllocationType = _Information.AllocationType AND AllocationPostingType = _Information.AllocationPostingType AND AllocationActualPlanVariant = _Information.AllocationActualPlanVariant  -- association [0..*]
LEFT OUTER JOIN C_AllocationCycleKeyFieldTP AS _Field ON AllocationType = _Field.AllocationType AND AllocationCycle = _Field.AllocationCycle AND AllocationCycleStartDate = _Field.AllocationCycleStartDate  -- association [0..*]
LEFT OUTER JOIN C_AllocLastExecByUserVH AS _LastExecUser ON AllocationLastExecutedByUser = _LastExecUser.AllocationLastExecutedByUser  -- association [1..1]
LEFT OUTER JOIN C_AllocChangedByUserVH AS _LastChangeUser ON LastChangedByUser = _LastChangeUser.LastChangedByUser  -- association [1..1]
LEFT OUTER JOIN C_AllocCreatedByUserVH AS _CreatedByUser ON CreatedByUser = _CreatedByUser.CreatedByUser  -- association [1..1]
LEFT OUTER JOIN C_AllocationCycleVH AS _AllocationCycleVH ON AllocationType = _AllocationCycleVH.AllocationType AND AllocationCycle = _AllocationCycleVH.AllocationCycle AND AllocationCycleStartDate = _AllocationCycleVH.AllocationCycleStartDate  -- association [1..1]
LEFT OUTER JOIN P_AllocationCycle AS _CycleCalc ON AllocationType = _CycleCalc.AllocationType AND AllocationCycle = _CycleCalc.AllocationCycle AND AllocationCycleStartDate = _CycleCalc.AllocationCycleStartDate  -- association [1..1]
LEFT OUTER JOIN I_DomainFixedValue AS _AllocationPostingTypeText ON _AllocationPostingTypeText.SAPDataDictionaryDomain = 'FCO_ALLOCATION_ALART' AND _AllocationPostingTypeText.DomainValue = AllocationPostingType  -- association [0..*]
LEFT OUTER JOIN C_AllocationCycleFieldGroupTP AS _FieldGroup ON AllocationType = _FieldGroup.AllocationType AND AllocationCycle = _FieldGroup.AllocationCycle AND AllocationCycleStartDate = _FieldGroup.AllocationCycleStartDate  -- association [0..*]
LEFT OUTER JOIN C_AllocationTagForCycle AS _AllocationTagForCycle ON AllocationType = _AllocationTagForCycle.AllocationType AND AllocationCycle = _AllocationTagForCycle.AllocationCycle AND AllocationCycleStartDate = _AllocationTagForCycle.AllocationCycleStartDate AND _AllocationTagForCycle.AllocationCycleSegment = '0000'  -- association [0..*]
LEFT OUTER JOIN C_AllocationFieldDerivationTP AS _FieldDerivation ON AllocationType = _FieldDerivation.AllocationType AND AllocationCycle = _FieldDerivation.AllocationCycle AND AllocationCycleStartDate = _FieldDerivation.AllocationCycleStartDate  -- association [0..*]
LEFT OUTER JOIN C_AllocationCycleNoteTP AS _CycleNote ON AllocationType = _CycleNote.AllocationType AND AllocationCycle = _CycleNote.AllocationCycle AND AllocationCycleStartDate = _CycleNote.AllocationCycleStartDate  -- association [0..*]
LEFT OUTER JOIN C_AllocTagObjectAssignmentTP AS _CycleTag ON AllocationType = _CycleTag.AllocationType AND AllocationCycle = _CycleTag.AllocationCycle AND AllocationCycleStartDate = _CycleTag.AllocationCycleStartDate AND _CycleTag.AllocationCycleSegment = '0000'  -- association [0..*]
LEFT OUTER JOIN P_AllocationTagCount AS _AllocationTagCount ON AllocationType = _AllocationTagCount.AllocationType AND AllocationCycle = _AllocationTagCount.AllocationCycle AND AllocationCycleStartDate = _AllocationTagCount.AllocationCycleStartDate AND _AllocationTagCount.AllocationCycleSegment = '0000'  -- association [1..1]
;