R_UniversalAllocationCycle

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_UniversalAllocationCycle.
-- 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_UniversalAllocationCycle AS
SELECT
  cast( AllocationType as fco_ua_type preserving type ) AS AllocationType,
  AllocationCycle,
  cast( AllocationCycleStartDate as fco_alloc_valid_from preserving type ) AS AllocationCycleStartDate,
  AllocationCycleName,
  Ledger,
  cast( CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  cast( AllocationCycleCategory as fcom_category preserving type ) AS AllocationCycleCategory,
  ControllingArea,
  OperatingConcern,
  cast( AllocationCycleEndDate as fco_alloc_valid_to preserving type ) AS AllocationCycleEndDate,
  AllocationFrequency,
  cast( AllocationCreateDate as fcoua_alloc_created_on preserving type ) AS AllocationCreateDate,
  cast( CreatedByUser as fco_tag_created_user preserving type ) AS CreatedByUser,
  LastChangeDate,
  LastChangeTime,
  cast( LastChangedByUser as fco_tag_changed_user preserving type ) AS LastChangedByUser,
  cast( AllocationLastExecutedDate as fco_alloc_last_execute_data preserving type ) AS AllocationLastExecutedDate,
  AllocationLastExecutedByUser,
  AllocationLastExecutionTime,
  AllocationCycleSet,
  ScaleNegativeTracingFactor,
  cast( AllocationPostingType as fco_alloc_posting_type preserving type ) AS AllocationPostingType,
  cast( AllocationActualPlanVariant as fco_alloc_ipknz preserving type ) AS AllocationActualPlanVariant,
  AllocationJob,
  AllocationIsCumulative,
  AllocIsCumulativeOptimized,
  AllocHasAggregatedProcess,
  AllocationCycleRunGroup,
  AllocationSubstitutionName,
  AllocFundMgmtIsActive,
  AllocationIsBalanceSheetActive,
  AllocHasDerivdFundFrmRcpnt,
  AllocIsDerivdFuncAreaFrmRcpnt,
  AllocIsDerivdGrantFrmRcpnt,
  AllocIsDerivdBudgedPerdRcpnt,
  AllocationLedgerGroup,
  AllocationIsPeriodShiftActive,
  AllocationPeriodDeltaSize,
  AllocIsProdnMnthDerivd,
  AllocationIsVariableQuantity,
  AllocationValuationType,
  cast( CycleIsDeltaProcessEnabled as fco_alloc_delta_process_enable preserving type ) AS CycleIsDeltaProcessEnabled,
  cast( CycleIsParallelLedgerEnabled as fco_alloc_parallel_ledger preserving type ) AS CycleIsParallelLedgerEnabled,
  cast( CycleIsAttributedLineItmEnbld as fco_alloc_enbl_attr_line_items preserving type ) AS CycleIsAttributedLineItmEnbld,
  cast( '' as fco_alloc_posting_type_text ) AS AllocationPostingTypeText,
  cast( _CycleCalc.AllocationStatus as fcoua_allocation_status preserving type ) AS AllocationStatus,
  _Template.UnivAllocTopDwnDistrCycleHash AS UnivAllocTopDwnDistrCycleHash,
  _Template.TopDwnDistrTmplName AS TopDwnDistrTmplName
FROM I_UniversalAllocationCycle
LEFT OUTER JOIN I_AllocationPostingTypeText AS _AllocationPostingTypeText ON _AllocationPostingTypeText.AllocationPostingType = AllocationPostingType  -- association [0..*]
LEFT OUTER JOIN I_UnivAllocCycleCalculation AS _CycleCalc ON _CycleCalc.AllocationCycle = AllocationCycle AND _CycleCalc.AllocationType = AllocationType AND _CycleCalc.AllocationCycleStartDate = AllocationCycleStartDate  -- association [1]
LEFT OUTER JOIN I_CycleRunGroup AS _CycleRunGroup ON AllocationType = _CycleRunGroup.AllocationType AND Ledger = _CycleRunGroup.Ledger AND AllocationPostingType = _CycleRunGroup.AllocationPostingType AND AllocationActualPlanVariant = _CycleRunGroup.AllocationActualPlanVariant AND AllocationCycleRunGroup = _CycleRunGroup.AllocationCycleRunGroup  -- association [1]
LEFT OUTER JOIN I_AllocationContextType AS _Context ON AllocationType = _Context.AllocationType  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedByUser ON LastChangedByUser = _ChangedByUser.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _LastExecByUser ON AllocationLastExecutedByUser = _LastExecByUser.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_AllocationStatus AS _AllocationStatus ON AllocationStatus = _AllocationStatus.AllocationStatus  -- association [1..1]
LEFT OUTER JOIN I_AllocActualPlanVariant AS _ActualPlanVariant ON AllocationActualPlanVariant = _ActualPlanVariant.AllocationActualPlanVariant  -- association [1..1]
LEFT OUTER JOIN I_UniversalAllocationCycleNote AS _CycleNote ON AllocationCycle = _CycleNote.AllocationCycle AND AllocationType = _CycleNote.AllocationType AND AllocationCycleStartDate = _CycleNote.AllocationCycleStartDate  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_UnivAllocTopDwnDistrTemplate AS _Template ON AllocationType = _Template.AllocationType AND AllocationCycle = _Template.AllocationCycle AND AllocationCycleStartDate = _Template.AllocationCycleStartDate  -- association [0..1]
LEFT OUTER JOIN I_UnivAllocTopDwnDistrTmplHdr AS _TemplateHeader ON _TemplateHeader.AllocationType = AllocationType AND _TemplateHeader.TopDwnDistrTmplName = topdwndistrtmplname  -- association [0..1]
;