P_UniAllocTagObjectAssignment

DDL: P_UNIALLOCTAGOBJECTASSIGNMENT SQL: PUNIALLOTAGASGN Type: view COMPOSITE
14 Fields 2 Data Sources

P_UniAllocTagObjectAssignment is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_AllocationCycle, I_AllocationSegment) and exposes 14 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment.

Data Sources (2)

SourceAliasJoin Type
I_AllocationCycle _Cycle from
I_AllocationSegment _Segment inner

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PUNIALLOTAGASGN 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 (14)

KeyFieldSource TableSource FieldDescription
KEY AllocationType I_AllocationCycle AllocationType Table
KEY AllocationCycle I_AllocationCycle AllocationCycle Cycle
KEY AllocationCycleStartDate I_AllocationCycle AllocationCycleStartDate Valid From
KEY AllocationCycleSegment I_AllocationSegment AllocationCycleSegment Segment Number
SegmentName I_AllocationSegment SegmentName Segment Name
AllocTagAssignmentStatus
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_UniAllocTagObjectAssignment.
-- 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: PUNIALLOTAGASGN

CREATE VIEW P_UniAllocTagObjectAssignment AS
SELECT
  _Cycle.AllocationType AS AllocationType,
  _Cycle.AllocationCycle AS AllocationCycle,
  _Cycle.AllocationCycleStartDate AS AllocationCycleStartDate,
  _Segment.AllocationCycleSegment AS AllocationCycleSegment,
  _Segment.SegmentName AS SegmentName,
  cast ('U' as fco_alloc_tag_assignment) AS AllocTagAssignmentStatus,
  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
INNER JOIN I_AllocationSegment AS _Segment ON /* join condition not captured in parsed metadata */
;

Learn More