C_AllocationRunSegment

DDL: C_ALLOCATIONRUNSEGMENT SQL: CALLOCRUNSEGMENT Type: view CONSUMPTION
24 Fields 1 Data Sources 3 Associations

Allocation Run Segment

C_AllocationRunSegment is a Consumption CDS View that provides data about "Allocation Run Segment" in SAP S/4HANA. It reads from 1 data source (P_AllocationRunSegment) and exposes 24 fields with key fields UniversalAllocationRun, AllocationCyclePosition, AllocationCycleSegmentPosition. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_AllocationRunSegment P_AllocationRunSegment from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_AllocationRunResult _Result _Result.UniversalAllocationRun = $projection.UniversalAllocationRun and _Result.AllocationCycle = $projection.AllocationCycle and _Result.AllocationCycleStartDate = $projection.AllocationCycleStartDate and _Result.AllocationCycleSegment = $projection.AllocationCycleSegment
[0..*] C_AllocationRunResultMapping _Mapping _Mapping.UniversalAllocationRun = $projection.UniversalAllocationRun and _Mapping.AllocationCycle = $projection.AllocationCycle and _Mapping.AllocationCycleStartDate = $projection.AllocationCycleStartDate and _Mapping.AllocationCycleSegment = $projection.AllocationCycleSegment
[0..1] C_AllocationCycle _Cycle _Cycle.AllocationType = $projection.AllocationType and _Cycle.AllocationCycle = $projection.AllocationCycle and _Cycle.AllocationCycleStartDate = $projection.AllocationCycleStartDate

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CALLOCRUNSEGMENT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Allocation Run Segment view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY UniversalAllocationRun UniversalAllocationRun
KEY AllocationCyclePosition AllocationCyclePosition
KEY AllocationCycleSegmentPosition AllocationCycleSegmentPosition
AllocationCycle AllocationCycle Cycle
AllocationCycleName AllocationCycleName Allocation Cycle
AllocationCycleNameText AllocationCycleNameText Cycle Description
AllocationCycleStartDate AllocationCycleStartDate Valid From
AllocationCycleSegment AllocationCycleSegment Segment Number
SegmentName SegmentName Segment Name
SegmentNameDescription SegmentNameDescription Segment Description
AllocationType AllocationType Table
AllocationContextTypeText _Cycle AllocationContextTypeText
Ledger Ledger Ledger
AllocationActualPlanVariant _Cycle AllocationActualPlanVariant Actual/Plan
AllocActualPlanVariantText _Cycle AllocActualPlanVariantText
ControllingArea _Cycle ControllingArea Controlling Area
AllocationPostingType _Cycle AllocationPostingType Posting Type
AllocationPostingTypeText _Cycle AllocationPostingTypeText
CompanyCode _Cycle CompanyCode Receiver Company Code
CompanyCodeName _Cycle CompanyCodeName Company Name
AllocationRunNumberOfSenders AllocationRunNumberOfSenders
AllocationRunNumberOfReceivers AllocationRunNumberOfReceivers
_Result _Result
_Mapping _Mapping

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_AllocationRunSegment.
-- 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: CALLOCRUNSEGMENT

CREATE VIEW C_AllocationRunSegment AS
SELECT
  UniversalAllocationRun,
  AllocationCyclePosition,
  AllocationCycleSegmentPosition,
  AllocationCycle,
  AllocationCycleName,
  AllocationCycleNameText,
  AllocationCycleStartDate,
  AllocationCycleSegment,
  SegmentName,
  SegmentNameDescription,
  AllocationType,
  _Cycle.AllocationContextTypeText AS AllocationContextTypeText,
  Ledger,
  _Cycle.AllocationActualPlanVariant AS AllocationActualPlanVariant,
  _Cycle.AllocActualPlanVariantText AS AllocActualPlanVariantText,
  _Cycle.ControllingArea AS ControllingArea,
  _Cycle.AllocationPostingType AS AllocationPostingType,
  _Cycle.AllocationPostingTypeText AS AllocationPostingTypeText,
  _Cycle.CompanyCode AS CompanyCode,
  _Cycle.CompanyCodeName AS CompanyCodeName,
  AllocationRunNumberOfSenders,
  AllocationRunNumberOfReceivers
FROM P_AllocationRunSegment
LEFT OUTER JOIN C_AllocationRunResult AS _Result ON _Result.UniversalAllocationRun = UniversalAllocationRun AND _Result.AllocationCycle = AllocationCycle AND _Result.AllocationCycleStartDate = AllocationCycleStartDate AND _Result.AllocationCycleSegment = AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN C_AllocationRunResultMapping AS _Mapping ON _Mapping.UniversalAllocationRun = UniversalAllocationRun AND _Mapping.AllocationCycle = AllocationCycle AND _Mapping.AllocationCycleStartDate = AllocationCycleStartDate AND _Mapping.AllocationCycleSegment = AllocationCycleSegment  -- association [0..*]
LEFT OUTER JOIN C_AllocationCycle AS _Cycle ON _Cycle.AllocationType = AllocationType AND _Cycle.AllocationCycle = AllocationCycle AND _Cycle.AllocationCycleStartDate = AllocationCycleStartDate  -- association [0..1]
;

Learn More