P_UniAllocTagCycleAssignment

DDL: P_UNIALLOCTAGCYCLEASSIGNMENT SQL: PUNIALLOCYCASGN Type: view COMPOSITE
13 Fields 1 Data Sources

P_UniAllocTagCycleAssignment is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_AllocationCycle) and exposes 13 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment.

Data Sources (1)

SourceAliasJoin Type
I_AllocationCycle _Cycle from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PUNIALLOCYCASGN view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY AllocationType I_AllocationCycle AllocationType Table
KEY AllocationCycle I_AllocationCycle AllocationCycle Cycle
KEY AllocationCycleStartDate I_AllocationCycle AllocationCycleStartDate Valid From
KEY AllocationCycleSegment
AllocationTagID _AllocTagAssign AllocationTagID Allocation Tags
AllocationCycleEndDate AllocationCycleEndDate Valid To
AllocationFrequency AllocationFrequency Frequency ID
AllocationCreateDate I_AllocationCycle AllocationCreateDate Entered On
CreatedByUser CreatedByUser User Name
LastChangeDate I_AllocationCycle LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
AllocationPostingType Posting Type
AllocationActualPlanVariant AllocationActualPlanVariant Actual/Plan

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_UniAllocTagCycleAssignment.
-- 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: PUNIALLOCYCASGN

CREATE VIEW P_UniAllocTagCycleAssignment AS
SELECT
  _Cycle.AllocationType AS AllocationType,
  _Cycle.AllocationCycle AS AllocationCycle,
  _Cycle.AllocationCycleStartDate AS AllocationCycleStartDate,
  cast( 0000 as fco_segment_name ) AS AllocationCycleSegment,
  _AllocTagAssign.AllocationTagID AS AllocationTagID,
  AllocationCycleEndDate,
  AllocationFrequency,
  _Cycle.AllocationCreateDate AS AllocationCreateDate,
  CreatedByUser,
  _Cycle.LastChangeDate AS LastChangeDate,
  LastChangedByUser,
  cast(AllocationPostingType as fco_alloc_posting_type preserving type) AS AllocationPostingType,
  AllocationActualPlanVariant
FROM I_AllocationCycle AS _Cycle
;

Learn More