P_AllocationRunSituation

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 P_AllocationRunSituation.
-- 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: PALLOCRUNSIT

CREATE VIEW P_AllocationRunSituation AS
SELECT
  UniversalAllocationRun,
  cast(substring(UniversalAllocationRunName, 1, 45) as alloc_run_name_situation) AS UniversalAllocationRunName,
  AllocationRunStartDate,
  AllocationRunStartTime,
  AllocationRunUser,
  Ledger,
  AllocationType,
  AllocationPostingType,
  AllocationActualPlanVariant,
  AllocationRunStatus,
  FiscalYear,
  AllocationRunStartPeriod,
  AllocationRunEndPeriod,
  AllocationRunIsTest,
  AllocationRunReversalStatus,
  _MessageCount.NumberOfOpenMessages AS NumberOfOpenMessages,
  AllocationRunType,
  cast('' as alloc_extract_name ) AS AllocationExtractName,
  cast('' as cycle ) AS AllocationCycle,
  cast('' as fco_alloc_valid_from ) AS AllocationCycleStartDate,
  cast('' as fco_alloc_cycle ) AS AllocationCycleName,
  cast('' as seqname ) AS SegmentName
FROM P_AllocationRun1
LEFT OUTER JOIN P_AllocationRunMessageCount AS _MessageCount ON _MessageCount.UniversalAllocationRun = UniversalAllocationRun  -- association [0..1]
;