I_AllocationSegmentTP

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_AllocationSegmentTP.
-- 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: ALLOCSEGMENTTP

CREATE VIEW I_AllocationSegmentTP AS
SELECT
  I_AllocationSegment.AllocationType AS AllocationType,
  AllocationCycle,
  AllocationCycleStartDate,
  AllocationCycleSegment,
  SegmentName,
  AllocationSegmentPosition,
  AllocationSenderRule,
  AllocationReceiverRule,
  AllocationSegmentIsLocked,
  AllocScNgtvTracingFctr,
  SenderTracingFieldGroup,
  SenderFieldGroup,
  ReceiverFieldGroup,
  ReceiverTracingFieldGroup,
  AllocationSenderFixedField1,
  AllocationSenderFixedField2,
  AllocationSenderFixedField3,
  AllocationSenderFixedField4,
  AllocationSenderFixedField5,
  AllocationSenderFixedField6,
  AllocationSenderFixedField7,
  AllocationSenderFixedField8,
  AllocationSenderFixedField9,
  AllocationSenderFixedField10,
  AllocationCurrency,
  AllocationReceiverFixedField1,
  AllocationReceiverFixedField2,
  AllocationReceiverFixedField3,
  AllocationReceiverFixedField4,
  AllocationReceiverFixedField5,
  AllocationReceiverFixedField6,
  AllocationReceiverFixedField7,
  AllocationReceiverFixedField8,
  AllocationReceiverFixedField9,
  AllocationReceiverFixedField10,
  AllocationFieldGroup,
  AssessmentCostElement,
  AllocationFixedCostCenterCost,
  AllocationVariableCostCtrCost,
  AllocationAccountAssignment,
  AllocationSegmentSortField,
  AllocIsSndrExclAsRcvr,
  ManipulationRuleForCyclicMaint,
  AllocationStructure,
  AllocationTransferStructure,
  AllocSndrFctrPercent,
  AllocRcvrFctrPercent,
  AllocSegmentShareInPercent,
  _Cycle.AllocationActualPlanVariant AS AllocationActualPlanVariant,
  _Cycle.AllocationPostingType AS AllocationPostingType,
  cast(I_AllocationSegment._Text.AllocationCycleNameText as fco_alloc_segment_decs) AS SegmentNameDescription,
  cast(_TDDVirtualField[1:AllocationFieldName = 'RLDNR'].AllocationFieldMinimumValue as fco_alloc_reference_ledger) AS AllocationReferenceLedger,
  cast(_TDDVirtualField[1:AllocationFieldName = 'CATEGORY'].AllocationFieldMinimumValue as fcom_category) AS PlanningCategory,
  cast( '' as boolean ) AS AllocationSenderValueIsNew,
  cast('' as fco_tags_id) AS AllocationTagID
FROM I_AllocationSegment
INNER JOIN I_AllocationContextType AS Context ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AllocationCycleTP AS _Cycle ON AllocationType = _Cycle.AllocationType AND AllocationCycle = _Cycle.AllocationCycle AND AllocationCycleStartDate = _Cycle.AllocationCycleStartDate  -- association [1..1]
LEFT OUTER JOIN I_AllocationSenderKeyFieldTP AS _SenderField ON AllocationType = _SenderField.AllocationType AND AllocationCycle = _SenderField.AllocationCycle AND AllocationCycleStartDate = _SenderField.AllocationCycleStartDate AND AllocationCycleSegment = _SenderField.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN I_AllocReceiverKeyFieldTP AS _ReceiverField ON AllocationType = _ReceiverField.AllocationType AND AllocationCycle = _ReceiverField.AllocationCycle AND AllocationCycleStartDate = _ReceiverField.AllocationCycleStartDate AND AllocationCycleSegment = _ReceiverField.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN I_AllocSenderValueKeyFieldTP AS _SenderValueField ON AllocationType = _SenderValueField.AllocationType AND AllocationCycle = _SenderValueField.AllocationCycle AND AllocationCycleStartDate = _SenderValueField.AllocationCycleStartDate AND AllocationCycleSegment = _SenderValueField.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN I_AllocRcvrTracingKeyFieldTP AS _ReceiverTracingField ON AllocationType = _ReceiverTracingField.AllocationType AND AllocationCycle = _ReceiverTracingField.AllocationCycle AND AllocationCycleStartDate = _ReceiverTracingField.AllocationCycleStartDate AND AllocationCycleSegment = _ReceiverTracingField.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN I_AllocationSenderElementTP AS _SenderElement ON AllocationType = _SenderElement.AllocationType AND AllocationCycle = _SenderElement.AllocationCycle AND AllocationCycleStartDate = _SenderElement.AllocationCycleStartDate AND AllocationCycleSegment = _SenderElement.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN I_AllocReceiverElementTP AS _ReceiverElement ON AllocationType = _ReceiverElement.AllocationType AND AllocationCycle = _ReceiverElement.AllocationCycle AND AllocationCycleStartDate = _ReceiverElement.AllocationCycleStartDate AND AllocationCycleSegment = _ReceiverElement.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN I_AllocRcvrFactorElementTP AS _ReceiverWeightingElement ON AllocationType = _ReceiverWeightingElement.AllocationType AND AllocationCycle = _ReceiverWeightingElement.AllocationCycle AND AllocationCycleStartDate = _ReceiverWeightingElement.AllocationCycleStartDate AND AllocationCycleSegment = _ReceiverWeightingElement.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN P_TDDVirtualField AS _TDDVirtualField ON AllocationType = _TDDVirtualField.AllocationType AND AllocationCycle = _TDDVirtualField.AllocationCycle AND AllocationCycleStartDate = _TDDVirtualField.AllocationCycleStartDate AND AllocationCycleSegment = _TDDVirtualField.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN I_AllocationSegmentNoteTP AS _SegmentNote ON AllocationType = _SegmentNote.AllocationType AND AllocationCycle = _SegmentNote.AllocationCycle AND AllocationCycleStartDate = _SegmentNote.AllocationCycleStartDate AND AllocationCycleSegment = _SegmentNote.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN I_AllocTagSegmentAssignmentTP AS _SegmentTag ON AllocationType = _SegmentTag.AllocationType AND AllocationCycle = _SegmentTag.AllocationCycle AND AllocationCycleStartDate = _SegmentTag.AllocationCycleStartDate AND AllocationCycleSegment = _SegmentTag.AllocationCycleSegment  -- association [0..*]
;