I_AllocationSegment

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_AllocationSegment.
-- 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: ALLOCSEGMENT

CREATE VIEW I_AllocationSegment AS
SELECT
  cast(tab as fco_allocation_type) AS AllocationType,
  cycle AS AllocationCycle,
  cast(sdate as fco_alloc_valid_from ) AS AllocationCycleStartDate,
  cast(seqnr as fco_alloc_segment_number ) AS AllocationCycleSegment,
  cast(name as fco_segment_name ) AS SegmentName,
  seqpos AS AllocationSegmentPosition,
  cast(srule as fco_alloc_sender_rule) AS AllocationSenderRule,
  cast(rrule as fco_alloc_receiver_rule) AS AllocationReceiverRule,
  active 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) 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,
  rcdata AS AllocationFieldGroup,
  asacc 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) AS ManipulationRuleForCyclicMaint,
  cast( absch as fco_allocation_structure ) AS AllocationStructure,
  ersch AS AllocationTransferStructure,
  sweight_fact AS AllocSndrFctrPercent,
  rweight_fact AS AllocRcvrFctrPercent
FROM t811s
LEFT OUTER JOIN I_AllocationCycle AS _Cycle ON AllocationType = _Cycle.AllocationType AND AllocationCycle = _Cycle.AllocationCycle AND AllocationCycleStartDate = _Cycle.AllocationCycleStartDate  -- association [1]
LEFT OUTER JOIN I_AllocAssmtDistrLongText AS _Text ON AllocationType = _Text.AllocationType AND AllocationCycle = _Text.AllocationCycle AND AllocationCycleStartDate = _Text.AllocationCycleStartDate AND _Text.LanguageCode = $session.system_language AND AllocationCycleSegment = _Text.AllocationCycleSegment  -- association [0..1]
;