C_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 C_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: CALLOCSEGMENT

CREATE VIEW C_AllocationSegmentTP AS
SELECT
  I_AllocationSegmentTP.AllocationType AS AllocationType,
  AllocationCycle,
  AllocationCycleStartDate,
  AllocationCycleSegment,
  SegmentName,
  SegmentNameDescription,
  AllocationSegmentPosition,
  AllocationSenderRule,
  _AllocationSenderRule._Text[1:Language = $session.system_language].AllocationSenderRuleText AS AllocationSenderRuleText,
  AllocationReceiverRule,
  _AllocationReceiverRule._Text[1:Language = $session.system_language].AllocationReceiverRuleText AS AllocationReceiverRuleText,
  _SegmentTest._Text[1:Language = $session.system_language].AllocationStatusDescription AS AllocationStatusDescription,
  AllocationSegmentIsLocked,
  _SegmentTest.CriticalityCode AS CriticalityCode,
  _SegmentTest.AllocationStatus AS AllocationStatus,
  AllocScNgtvTracingFctr,
  _AllocScNgtvTracingFactor._Text[1:Language = $session.system_language].AllocScNgtvTracingFctrText AS AllocScNgtvTracingFctrText,
  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,
  cast(AllocationFieldGroup as fco_alloc_var_portion_type preserving type) AS AllocationFieldGroup,
  AllocationTagID,
  cast(AssessmentCostElement as fco_alloc_asacc preserving type) AS AssessmentCostElement,
  cast( '' as kltxt ) AS CostElementDescription,
  AllocationFixedCostCenterCost,
  AllocationVariableCostCtrCost,
  AllocationAccountAssignment,
  AllocationSegmentSortField,
  AllocIsSndrExclAsRcvr,
  ManipulationRuleForCyclicMaint,
  AllocationStructure,
  AllocationTransferStructure,
  AllocSndrFctrPercent,
  AllocRcvrFctrPercent,
  AllocSegmentShareInPercent,
  _Cycle.AllocationActualPlanVariant AS AllocationActualPlanVariant,
  _Cycle.AllocationPostingType AS AllocationPostingType,
  _Cycle.AllocationPostingTypeText AS AllocationPostingTypeText,
  _CycleCalc.CompanyCode AS CompanyCode,
  _Cycle.TopDwnDistrTmplName AS TopDwnDistrTmplName,
  _Cycle.ControllingArea AS ControllingArea,
  AllocationReferenceLedger,
  PlanningCategory,
  UnitOfMeasure,
  AllocationSenderValueIsNew
FROM I_AllocationSegmentTP
LEFT OUTER JOIN C_AllocationSenderInformation AS _SenderInformation ON AllocationType = _SenderInformation.AllocationType AND allocationpostingtype = _SenderInformation.AllocationPostingType AND allocationactualplanvariant = _SenderInformation.AllocationActualPlanVariant  -- association [0..*]
LEFT OUTER JOIN C_AllocationSenderKeyFieldTP AS _SenderField ON AllocationType = _SenderField.AllocationType AND AllocationCycle = _SenderField.AllocationCycle AND AllocationCycleStartDate = _SenderField.AllocationCycleStartDate AND AllocationCycleSegment = _SenderField.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN C_AllocReceiverInformation AS _ReceiverInformation ON AllocationType = _ReceiverInformation.AllocationType AND allocationpostingtype = _ReceiverInformation.AllocationPostingType AND allocationactualplanvariant = _ReceiverInformation.AllocationActualPlanVariant  -- association [0..*]
LEFT OUTER JOIN C_AllocationReceiverKeyFieldTP AS _ReceiverField ON AllocationType = _ReceiverField.AllocationType AND AllocationCycle = _ReceiverField.AllocationCycle AND AllocationCycleStartDate = _ReceiverField.AllocationCycleStartDate AND AllocationCycleSegment = _ReceiverField.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN C_AllocSenderValueInformation AS _SenderValueInformation ON AllocationType = _SenderValueInformation.AllocationType AND allocationpostingtype = _SenderValueInformation.AllocationPostingType AND allocationactualplanvariant = _SenderValueInformation.AllocationActualPlanVariant  -- association [0..*]
LEFT OUTER JOIN C_AllocSenderValueKeyFieldTP AS _SenderValueField ON AllocationType = _SenderValueField.AllocationType AND AllocationCycle = _SenderValueField.AllocationCycle AND AllocationCycleStartDate = _SenderValueField.AllocationCycleStartDate AND AllocationCycleSegment = _SenderValueField.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN C_AllocRcvrTracingInformation AS _ReceiverTracingInformation ON AllocationType = _ReceiverTracingInformation.AllocationType AND allocationpostingtype = _ReceiverTracingInformation.AllocationPostingType AND allocationactualplanvariant = _ReceiverTracingInformation.AllocationActualPlanVariant  -- association [0..*]
LEFT OUTER JOIN C_AllocRcvrTracingKeyFieldTP AS _ReceiverTracingField ON AllocationType = _ReceiverTracingField.AllocationType AND AllocationCycle = _ReceiverTracingField.AllocationCycle AND AllocationCycleStartDate = _ReceiverTracingField.AllocationCycleStartDate AND AllocationCycleSegment = _ReceiverTracingField.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN C_AllocationSenderElementTP AS _SenderElement ON AllocationType = _SenderElement.AllocationType AND AllocationCycle = _SenderElement.AllocationCycle AND AllocationCycleStartDate = _SenderElement.AllocationCycleStartDate AND AllocationCycleSegment = _SenderElement.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN C_AllocationReceiverElementTP AS _ReceiverElement ON AllocationType = _ReceiverElement.AllocationType AND AllocationCycle = _ReceiverElement.AllocationCycle AND AllocationCycleStartDate = _ReceiverElement.AllocationCycleStartDate AND AllocationCycleSegment = _ReceiverElement.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN C_AllocReceiverFactorElementTP AS _ReceiverWeightingElement ON AllocationType = _ReceiverWeightingElement.AllocationType AND AllocationCycle = _ReceiverWeightingElement.AllocationCycle AND AllocationCycleStartDate = _ReceiverWeightingElement.AllocationCycleStartDate AND AllocationCycleSegment = _ReceiverWeightingElement.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN I_AllocationSenderRule AS _AllocationSenderRule ON AllocationSenderRule = _AllocationSenderRule.AllocationSenderRule  -- association [1..1]
LEFT OUTER JOIN I_AllocationReceiverRule AS _AllocationReceiverRule ON AllocationReceiverRule = _AllocationReceiverRule.AllocationReceiverRule  -- association [1..1]
LEFT OUTER JOIN I_AllocScNgtvTracingFactor AS _AllocScNgtvTracingFactor ON AllocScNgtvTracingFctr = _AllocScNgtvTracingFactor.AllocScNgtvTracingFctr  -- association [1..1]
LEFT OUTER JOIN C_AllocationCycleTP AS _Cycle ON AllocationType = _Cycle.AllocationType AND AllocationCycle = _Cycle.AllocationCycle AND AllocationCycleStartDate = _Cycle.AllocationCycleStartDate  -- association [1..1]
LEFT OUTER JOIN P_AllocationSegmentStatusText AS _SegmentTest ON AllocationSegmentIsLocked = _SegmentTest.AllocationSegmentIsLocked  -- association [1..1]
LEFT OUTER JOIN P_AllocationCycleCalc AS _CycleCalc ON AllocationCycle = _CycleCalc.AllocationCycle AND AllocationType = _CycleCalc.AllocationType AND AllocationCycleStartDate = _CycleCalc.AllocationCycleStartDate  -- association [1..1]
LEFT OUTER JOIN C_AllocRcvrTmplItm AS _AllocRcvrTmplItm ON topdwndistrtmplname = _AllocRcvrTmplItm.TopDwnDistrTmplName AND AllocationType = _AllocRcvrTmplItm.AllocationType  -- association [0..*]
LEFT OUTER JOIN C_AllocSndrTmplItm AS _AllocSndrTmplItm ON topdwndistrtmplname = _AllocSndrTmplItm.TopDwnDistrTmplName AND AllocationType = _AllocSndrTmplItm.AllocationType  -- association [0..*]
LEFT OUTER JOIN C_AllocRcvrTracingTmplItm AS _AllocRcvrTracingTmplItm ON topdwndistrtmplname = _AllocRcvrTracingTmplItm.TopDwnDistrTmplName AND AllocationType = _AllocRcvrTracingTmplItm.AllocationType  -- association [0..*]
LEFT OUTER JOIN C_AllocSndrValTmplItm AS _AllocSndrValTmplItm ON topdwndistrtmplname = _AllocSndrValTmplItm.TopDwnDistrTmplName AND AllocationType = _AllocSndrValTmplItm.AllocationType  -- association [0..*]
LEFT OUTER JOIN C_AllocationSegmentNoteTP AS _SegmentNote ON AllocationType = _SegmentNote.AllocationType AND AllocationCycle = _SegmentNote.AllocationCycle AND AllocationCycleStartDate = _SegmentNote.AllocationCycleStartDate AND AllocationCycleSegment = _SegmentNote.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN C_AllocTagSegmentAssignmentTP AS _SegmentTag ON AllocationType = _SegmentTag.AllocationType AND AllocationCycle = _SegmentTag.AllocationCycle AND AllocationCycleStartDate = _SegmentTag.AllocationCycleStartDate AND AllocationCycleSegment = _SegmentTag.AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN C_AllocationTagForSegment AS _AllocationTagForSegment ON AllocationType = _AllocationTagForSegment.AllocationType AND AllocationCycle = _AllocationTagForSegment.AllocationCycle AND AllocationCycleStartDate = _AllocationTagForSegment.AllocationCycleStartDate AND AllocationCycleSegment = _AllocationTagForSegment.AllocationCycleSegment  -- association [0..*]
;