I_AllocationCycle

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_AllocationCycle.
-- 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: ALLOCCYCLE

CREATE VIEW I_AllocationCycle AS
SELECT
  cast(tab as fco_allocation_context) AS AllocationType,
  cycle AS AllocationCycle,
  cast(sdate as fco_alloc_valid_from) AS AllocationCycleStartDate,
  cast(edate as fco_alloc_valid_to ) AS AllocationCycleEndDate,
  rstatus AS AllocationStatus,
  freq AS AllocationFrequency,
  crdate AS AllocationCreateDate,
  cast(puser as fco_tag_created_user) AS CreatedByUser,
  moddate AS LastChangeDate,
  cast(moduser as fco_tag_changed_user) AS LastChangedByUser,
  cast(lastexec as fco_alloc_last_execute_data) AS AllocationLastExecutedDate,
  lexecby AS AllocationLastExecutedByUser,
  timeexec AS AllocationLastExecutionTime,
  iterflag AS AllocationIsProcessed,
  cycleset AS AllocationCycleSet,
  negtest AS ScaleNegativeTracingFactor,
  cast(alart as fco_alloc_posting_type) AS AllocationPostingType,
  cast(ipknz as fco_alloc_ipknz ) AS AllocationActualPlanVariant,
  job AS AllocationJob,
  kumuflag AS AllocationIsCumulative,
  xxkumuflag AS AllocIsCumulativeOptimized,
  rckumuflag AS AllocHasAggregatedProcess,
  proc_group AS AllocationCycleRunGroup,
  substid AS AllocationSubstitutionName,
  fm_derive AS AllocFundMgmtIsActive,
  gl_xbilk AS AllocationIsBalanceSheetActive,
  fm_derive_fonds AS AllocHasDerivdFundFrmRcpnt,
  fm_derive_fkber AS AllocIsDerivdFuncAreaFrmRcpnt,
  fm_derive_grant AS AllocIsDerivdGrantFrmRcpnt,
  fm_derive_budpd AS AllocIsDerivdBudgedPerdRcpnt,
  gl_ldgrp AS AllocationLedgerGroup,
  period_lag AS AllocationIsPeriodShiftActive,
  period_delta AS AllocationPeriodDeltaSize,
  kalc_prodper AS AllocIsProdnMnthDerivd,
  variabel AS AllocationIsVariableQuantity,
  valutyp_alloc AS AllocationValuationType,
  cast(substring(cycle, 3, 8) as fco_alloc_cycle) AS AllocationCycleName,
  cast(substring(cycle, 1, 3) as fis_rldnr) AS Ledger,
  cast(enable_delta_process as fco_alloc_delta_process_enable) AS CycleIsDeltaProcessEnabled,
  _Change.LastChangeTime AS LastChangeTime
FROM t811c
LEFT OUTER JOIN P_AllocationCycleChange AS _Change ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AllocActualPlanVariantText AS _ActualPlanText ON AllocationActualPlanVariant = _ActualPlanText.AllocationActualPlanVariant  -- association [0..*]
LEFT OUTER JOIN I_AllocationContextType AS _Context ON AllocationType = _Context.AllocationType  -- association [0..1]
LEFT OUTER JOIN I_AllocAssmtDistrLongText AS _Text ON AllocationType = _Text.AllocationType AND AllocationCycle = _Text.AllocationCycle AND AllocationCycleStartDate = _Text.AllocationCycleStartDate AND _Text.LanguageCode = $session.system_language AND _Text.AllocationCycleSegment = '0000'  -- association [0..1]
;