I_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 I_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: ALLOCCYCLETP

CREATE VIEW I_AllocationCycleTP AS
SELECT
  I_AllocationCycle.AllocationType AS AllocationType,
  AllocationCycle,
  cast( case when AllocationCycleStartDate is null then '20180101' else AllocationCycleStartDate end as fco_alloc_valid_from ) AS AllocationCycleStartDate,
  cast( AllocationCycleEndDate as fco_alloc_valid_to ) AS AllocationCycleEndDate,
  I_AllocationCycle._Text.AllocationCycleNameText AS AllocationCycleNameText,
  AllocationStatus,
  AllocationFrequency,
  AllocationCreateDate,
  CreatedByUser,
  cast(LastChangeTime as hash160) AS LastChangeTime,
  LastChangeDate,
  AllocationCycleChangeTime,
  LastChangedByUser,
  AllocationLastExecutedDate,
  AllocationLastExecutedByUser,
  AllocationLastExecutionTime,
  AllocationIsProcessed,
  AllocationCycleSet,
  ScaleNegativeTracingFactor,
  AllocationPostingType,
  AllocationActualPlanVariant,
  AllocationJob,
  AllocationIsCumulative,
  AllocIsCumulativeOptimized,
  AllocHasAggregatedProcess,
  AllocationCycleRunGroup,
  AllocationSubstitutionName,
  AllocFundMgmtIsActive,
  AllocationIsBalanceSheetActive,
  AllocHasDerivdFundFrmRcpnt,
  AllocIsDerivdFuncAreaFrmRcpnt,
  AllocIsDerivdGrantFrmRcpnt,
  AllocIsDerivdBudgedPerdRcpnt,
  AllocationLedgerGroup,
  AllocationIsPeriodShiftActive,
  AllocationPeriodDeltaSize,
  AllocIsProdnMnthDerivd,
  AllocationIsVariableQuantity,
  AllocationValuationType,
  AllocationCycleIsIterative,
  cast('' as fis_bukrs) AS CompanyCodeForEdit,
  cast('' as fis_rldnr) AS LedgerForEdit,
  cast('' as fcom_category) AS AllocationCycleCategoryForEdit,
  cast ('' as fco_alloc_template ) AS TopDwnDistrTmplName,
  cast('' as boolean) AS AllocationCycleIsConsistent,
  cast('' as fco_tag_id) AS AllocationTagID,
  CycleIsDeltaProcessEnabled,
  CycleIsParallelLedgerEnabled,
  CycleIsAttributedLineItmEnbld
FROM I_AllocationCycle
INNER JOIN I_AllocationContextType AS Context ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AllocTopDwnDistrCycTmplTP AS _Template ON AllocationType = _Template.AllocationType AND AllocationCycle = _Template.AllocationCycle AND AllocationCycleStartDate = _Template.AllocationCycleStartDate  -- association [0..1]
LEFT OUTER JOIN I_AllocationSegmentTP AS _Segment ON AllocationType = _Segment.AllocationType AND AllocationCycle = _Segment.AllocationCycle AND AllocationCycleStartDate = _Segment.AllocationCycleStartDate  -- association [0..*]
LEFT OUTER JOIN I_AllocationCycleKeyFieldTP AS _Field ON AllocationType = _Field.AllocationType AND AllocationCycle = _Field.AllocationCycle AND AllocationCycleStartDate = _Field.AllocationCycleStartDate  -- association [0..*]
LEFT OUTER JOIN I_AllocationCycleFieldGroupTP AS _FieldGroup ON AllocationType = _FieldGroup.AllocationType AND AllocationCycle = _FieldGroup.AllocationCycle AND AllocationCycleStartDate = _FieldGroup.AllocationCycleStartDate  -- association [0..*]
LEFT OUTER JOIN I_AllocationFieldDerivationTP AS _FieldDerivation ON AllocationType = _FieldDerivation.AllocationType AND AllocationCycle = _FieldDerivation.AllocationCycle AND AllocationCycleStartDate = _FieldDerivation.AllocationCycleStartDate  -- association [0..*]
LEFT OUTER JOIN I_AllocationCycleNoteTP AS _CycleNote ON AllocationType = _CycleNote.AllocationType AND AllocationCycle = _CycleNote.AllocationCycle AND AllocationCycleStartDate = _CycleNote.AllocationCycleStartDate  -- association [0..*]
LEFT OUTER JOIN I_AllocTagObjectAssignmentTP AS _CycleTag ON AllocationType = _CycleTag.AllocationType AND AllocationCycle = _CycleTag.AllocationCycle AND AllocationCycleStartDate = _CycleTag.AllocationCycleStartDate  -- association [0..*]
;