I_AllocationCycleVersion

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_AllocationCycleVersion.
-- 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 I_AllocationCycleVersion AS
SELECT
  id AS AllocationCycleVersionValue,
  tab AS AllocationType,
  cycle AS AllocationCycle,
  sdate AS AllocationCycleStartDate,
  edate AS AllocationCycleEndDate,
  usnam AS AllocCycleVersionCreatedByUser,
  del_user AS DeletedByUser,
  rstatus AS AllocationStatus,
  freq AS AllocationFrequency,
  crdate AS AllocationCreateDate,
  puser AS CreatedByUser,
  moddate AS LastChangeDate,
  moduser AS LastChangedByUser,
  lastexec AS AllocationLastExecutedDate,
  lexecby AS AllocationLastExecutedByUser,
  timeexec AS AllocationLastExecutionTime,
  iterflag AS AllocationIsProcessed,
  cycleset AS AllocationCycleSet,
  negtest AS ScaleNegativeTracingFactor,
  alart AS AllocationPostingType,
  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,
  cyclename AS AllocationCycleName,
  rldnr AS Ledger,
  rbukrs AS CompanyCode,
  kokrs AS ControllingArea,
  category AS PlanningCategory,
  erkrs AS OperatingConcern,
  id_t811s AS AllocCycleSegmentVersionValue,
  id_t811k AS AllocCycleKeyFieldVersionValue,
  id_t811f AS AllocCycleElementVersionValue,
  id_t811g AS AllocCycFieldGroupVersionValue,
  id_t811l AS AllocCycleTextVersionValue,
  id_t811km AS AllocCycFldMappingVersionValue,
  id_t811_tagged AS AllocationCycleTagVersionValue,
  id_cycle_note AS AllocCycleNoteVersionValue,
  id_segment_note AS AllocSegmentNoteVersionValue,
  id_t811derive AS AllocCycDrvtnRuleVersionValue,
  id_tdd_template AS AllocCycleTemplateVersionValue,
  enable_delta_process AS CycleIsDeltaProcessEnabled,
  iterflag AS AllocationCycleIsIterative,
  can_exec_for_other_ledger AS CycleIsParallelLedgerEnabled,
  enable_attributed_line_items AS CycleIsAttributedLineItmEnbld
FROM t811cv
;