I_AllocationSegmentVersion

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_AllocationSegmentVersion.
-- 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_AllocationSegmentVersion AS
SELECT
  id AS AllocCycleSegmentVersionValue,
  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,
  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 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,
  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 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 t811sv
;