A_UnivAllocRunResultMappingAI

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 A_UnivAllocRunResultMappingAI.
-- 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 A_UnivAllocRunResultMappingAI AS
SELECT
  UniversalAllocationRun,
  AllocationCycle,
  AllocationCycleStartDate,
  AllocationCycleSegment,
  AllocationRunSenderItem,
  AllocationRunReceiverItem,
  _ReceiverResult.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ReceiverResult.GlobalCurrency AS GlobalCurrency,
  _ReceiverResult.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _ReceiverResult.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _ReceiverResult.AllocationCycleName AS AllocationCycleName,
  _ReceiverResult.AllocationCycleNameText AS AllocationCycleNameText,
  cast(_ReceiverResult.AllocationType as fco_allocation_context preserving type) AS AllocationType,
  _ReceiverResult.Ledger AS Ledger,
  _ReceiverResult.LedgerName AS LedgerName,
  _ReceiverResult.AllocationActualPlanVariant AS AllocationActualPlanVariant,
  _ReceiverResult.AllocActualPlanVariantText AS AllocActualPlanVariantText,
  _ReceiverResult.AllocationPostingType AS AllocationPostingType,
  _ReceiverResult.AllocationPostingTypeText AS AllocationPostingTypeText,
  _ReceiverResult.GLAccount AS GLAccount,
  _ReceiverResult.GLAccountName AS GLAccountName,
  _ReceiverResult.SegmentName AS SegmentName,
  _ReceiverResult.SegmentNameDescription AS SegmentNameDescription,
  _ReceiverResult.FiscalPeriod AS FiscalPeriod,
  cast(_ReceiverResult.LedgerFiscalYear as fis_gjahr_no_conv preserving type) AS LedgerFiscalYear,
  _ReceiverResult.AllocationRunTracingFactorQty AS AllocationRunTracingFactorQty,
  _ReceiverResult.VariablePortion AS VariablePortion,
  _ReceiverResult.VariablePortionText AS VariablePortionText,
  _ReceiverResult.VariablePortionType AS VariablePortionType,
  _ReceiverResult.VariablePortionTypeText AS VariablePortionTypeText,
  _ReceiverResult.AllocRunTracingFctrQtyUnit AS AllocRunTracingFctrQtyUnit,
  _ReceiverResult.AllocationRunIsTest AS AllocationRunIsTest,
  _ReceiverResult.AllocationCycleIsReversed AS AllocationCycleIsReversed
FROM I_AllocationRunResultMapping
LEFT OUTER JOIN A_AllocationRunResult AS _SenderResult ON _SenderResult.UniversalAllocationRun = UniversalAllocationRun AND _SenderResult.AllocationCycle = AllocationCycle AND _SenderResult.AllocationCycleStartDate = AllocationCycleStartDate AND _SenderResult.AllocationCycleSegment = AllocationCycleSegment AND _SenderResult.AllocationRunDataCategory = 'S' AND _SenderResult.AllocationRunResultItem = AllocationRunSenderItem  -- association [0..1]
LEFT OUTER JOIN A_AllocationRunResult AS _ReceiverResult ON _ReceiverResult.UniversalAllocationRun = UniversalAllocationRun AND _ReceiverResult.AllocationCycle = AllocationCycle AND _ReceiverResult.AllocationCycleStartDate = AllocationCycleStartDate AND _ReceiverResult.AllocationCycleSegment = AllocationCycleSegment AND _ReceiverResult.AllocationRunDataCategory = 'R' AND _ReceiverResult.AllocationRunResultItem = AllocationRunReceiverItem  -- association [0..1]
;