I_UniversalAllocationSegment

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_UniversalAllocationSegment.
-- 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_UniversalAllocationSegment AS
SELECT
  tab AS AllocationType,
  cycle AS AllocationCycle,
  sdate AS AllocationCycleStartDate,
  cast(seqnr as fco_alloc_segment_number preserving type ) AS AllocationCycleSegment,
  cast(name as fco_segment_name preserving type ) AS SegmentName,
  seqpos AS AllocationSegmentPosition,
  cast(srule as fco_alloc_sender_rule preserving type ) AS AllocationSenderRule,
  cast(rrule as fco_alloc_receiver_rule preserving type ) AS AllocationReceiverRule,
  cast( active as fcoua_segment_status preserving type ) AS AllocationSegmentIsLocked,
  negtest AS AllocScNgtvTracingFctr,
  scset AS SenderTracingFieldGroup,
  sset AS SenderFieldGroup,
  rset AS ReceiverFieldGroup,
  rcset AS ReceiverTracingFieldGroup,
  cast(spercent as fco_alloc_sender_share_percent preserving type ) AS AllocSegmentShareInPercent,
  sffeld1 AS AllocationSenderFixedField1,
  sffeld2 AS AllocationSenderFixedField2,
  sffeld3 AS AllocationSenderFixedField3,
  sffeld4 AS AllocationSenderFixedField4,
  sffeld5 AS AllocationSenderFixedField5,
  sffeld6 AS AllocationSenderFixedField6,
  sffeld7 AS AllocationSenderFixedField7,
  sffeld8 AS AllocationSenderFixedField8,
  sffeld9 AS AllocationSenderFixedField9,
  sffeld10 AS AllocationSenderFixedField10,
  facurr AS AllocationCurrency,
  rffeld1 AS AllocationReceiverFixedField1,
  rffeld2 AS AllocationReceiverFixedField2,
  rffeld3 AS AllocationReceiverFixedField3,
  rffeld4 AS AllocationReceiverFixedField4,
  rffeld5 AS AllocationReceiverFixedField5,
  rffeld6 AS AllocationReceiverFixedField6,
  rffeld7 AS AllocationReceiverFixedField7,
  rffeld8 AS AllocationReceiverFixedField8,
  rffeld9 AS AllocationReceiverFixedField9,
  rffeld10 AS AllocationReceiverFixedField10,
  cast( rcdata as fco_alloc_var_portion_type preserving type) AS AllocationFieldGroup,
  cast( asacc as fco_alloc_asacc preserving type ) AS AssessmentCostElement,
  pafldf AS AllocationFixedCostCenterCost,
  pafldg AS AllocationVariableCostCtrCost,
  rrfeld1 AS AllocationAccountAssignment,
  sortfield AS AllocationSegmentSortField,
  sender_not AS AllocIsSndrExclAsRcvr,
  cast(mrule as fco_alloc_manipulation_rule preserving type ) AS ManipulationRuleForCyclicMaint,
  cast(absch as fco_allocation_structure preserving type ) AS AllocationStructure,
  ersch AS AllocationTransferStructure,
  sweight_fact AS AllocSndrFctrPercent,
  rweight_fact AS AllocRcvrFctrPercent
FROM t811s
LEFT OUTER JOIN I_AllocationReceiverRule AS _ReceiverRule ON AllocationReceiverRule = _ReceiverRule.AllocationReceiverRule  -- association [1..1]
LEFT OUTER JOIN I_AllocationSenderRule AS _SenderRule ON AllocationSenderRule = _SenderRule.AllocationSenderRule  -- association [1..1]
LEFT OUTER JOIN I_UnivAllocationSegmentNote AS _Note ON AllocationCycle = _Note.AllocationCycle AND AllocationType = _Note.AllocationType AND AllocationCycleStartDate = _Note.AllocationCycleStartDate AND AllocationCycleSegment = _Note.AllocationCycleSegment  -- association [1..1]
LEFT OUTER JOIN I_UnivAllocationSegmentStatus AS _SegmentStatus ON AllocationSegmentIsLocked = _SegmentStatus.AllocationStatus  -- association [1..1]
LEFT OUTER JOIN I_AllocationFieldGroupText AS _AllocationFieldGroupText ON AllocationFieldGroup = _AllocationFieldGroupText.AllocationFieldGroup AND AllocationType = _AllocationFieldGroupText.AllocationType  -- association [0..*]
;