P_AllocCycleForScheduling

DDL: P_ALLOCCYCLEFORSCHEDULING SQL: PALLOCCYCLESCHED Type: view CONSUMPTION Package: ODATA_RUN_ALLOCATION
12 Fields 1 Data Sources 1 Associations

Allocation Cycle

P_AllocCycleForScheduling is a Consumption CDS View that provides data about "Allocation Cycle" in SAP S/4HANA. It reads from 1 data source (I_AllocationCycle) and exposes 12 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate. It has 1 association to related views. Part of development package ODATA_RUN_ALLOCATION.

Data Sources (1)

SourceAliasJoin Type
I_AllocationCycle I_AllocationCycle from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_AllocationKeyField _Field $projection.AllocationType = _Field.AllocationType and $projection.AllocationCycle = _Field.AllocationCycle and $projection.AllocationCycleStartDate = _Field.AllocationCycleStartDate and _Field.AllocationSetType = '0' and _Field.AllocationCycleSegment = '0000'

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PALLOCCYCLESCHED view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType Table
KEY AllocationCycle AllocationCycle Cycle
KEY AllocationCycleStartDate AllocationCycleStartDate Valid From
AllocationCycleName AllocationCycleName Allocation Cycle
AllocationCycleNameText _Text AllocationCycleNameText Cycle Description
AllocationPostingType AllocationPostingType Posting Type
AllocationActualPlanVariant AllocationActualPlanVariant Actual/Plan
Ledger Ledger Ledger
AllocationCycleCategory
CompanyCode
ControllingArea
AllocationCycleSemanticKey

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 P_AllocCycleForScheduling.
-- 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: PALLOCCYCLESCHED

CREATE VIEW P_AllocCycleForScheduling AS
SELECT
  AllocationType,
  AllocationCycle,
  AllocationCycleStartDate,
  AllocationCycleName,
  _Text.AllocationCycleNameText AS AllocationCycleNameText,
  AllocationPostingType,
  AllocationActualPlanVariant,
  Ledger,
  cast( _Field[1:AllocationFieldName = 'CATEGORY'].AllocationFieldMinimumValue as fcom_category) AS AllocationCycleCategory,
  cast( _Field[1:AllocationFieldName = 'RBUKRS'].AllocationFieldMinimumValue as fis_bukrs) AS CompanyCode,
  cast( _Field[1:AllocationFieldName = 'KOKRS'].AllocationFieldMinimumValue as fis_kokrs ) AS ControllingArea,
  cast( concat_with_space( AllocationCycleName, AllocationCycleStartDate, 1) as ke_kscyc_sdate ) AS AllocationCycleSemanticKey
FROM I_AllocationCycle
LEFT OUTER JOIN I_AllocationKeyField AS _Field ON AllocationType = _Field.AllocationType AND AllocationCycle = _Field.AllocationCycle AND AllocationCycleStartDate = _Field.AllocationCycleStartDate AND _Field.AllocationSetType = '0' AND _Field.AllocationCycleSegment = '0000'  -- association [0..*]
;

Learn More