C_AllocTagObjectAssignment_2

DDL: C_ALLOCTAGOBJECTASSIGNMENT_2 SQL: CYCLSGMNTHIER Type: view CONSUMPTION
28 Fields 1 Data Sources 5 Associations

Cycle Segment Hier for Assignment

C_AllocTagObjectAssignment_2 is a Consumption CDS View that provides data about "Cycle Segment Hier for Assignment" in SAP S/4HANA. It reads from 1 data source (P_CycleSegmentHierSourceParam) and exposes 28 fields with key field AllocationTagHierarchy. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_CycleSegmentHierSourceParam P_CycleSegmentHierSourceParam from

Parameters (1)

NameTypeDefault
P_AllocationTagID fco_tag_id

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_AllocTagAssignmentStatus _AllocTagAssgmtStatus $projection.AllocTagAssignmentStatus = _AllocTagAssgmtStatus.AllocTagAssignmentStatus
[0..*] I_DomainFixedValue _PostingTypeText _PostingTypeText.SAPDataDictionaryDomain = 'FCO_ALLOCATION_ALART' and _PostingTypeText.DomainValue = $projection.AllocationPostingType
[0..*] I_DomainFixedValue _ActualPlanVariantText _ActualPlanVariantText.SAPDataDictionaryDomain = 'IPKNZ' and _ActualPlanVariantText.DomainValue = $projection.AllocationActualPlanVariant
[0..*] I_DomainFixedValue _AllocationTypeText _AllocationTypeText.SAPDataDictionaryDomain = 'FCO_ALLOCATION_CONTEXT' and _AllocationTypeText.DomainValue = $projection.AllocationType
[1..1] I_Ledger _Ledger $projection.Ledger = _Ledger.Ledger

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CYCLSGMNTHIER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Cycle Segment Hier for Assignment view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Allocation Tag view
UI.headerInfo.typeNamePlural Allocation Tags view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.label Allocation Tag view
UI.headerInfo.title.value AllocationTagID view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY AllocationTagHierarchy AllocationSegmentHier
AllocationCycleHierarchy AllocationCycleHier
AllocationType AllocationType Table
AllocationCycle AllocationCycle Cycle
AllocationCycleStartDate AllocationCycleStartDate Valid From
AllocationCycleSegment AllocationCycleSegment Segment Number
SegmentName SegmentName Segment Name
AllocationCycleName AllocationCycleName Allocation Cycle
AllocationActualPlanVariant AllocationActualPlanVariant Actual/Plan
AllocationPostingType AllocationPostingType Posting Type
Ledger Ledger Ledger
AllocationStatus AllocationStatus
LastChangedByUser LastChangedByUser User Name
AllocationCycleEndDate AllocationCycleEndDate Valid To
LastChangeDate LastChangeDate Time Stamp
CreatedByUser CreatedByUser User Name
AllocationCreateDate AllocationCreateDate Entered On
AllocationFrequency AllocationFrequency
CompanyCode CompanyCode Receiver Company Code
AllocationCycleCategory AllocationCycleCategory Plan Category
CompanyCodeName CompanyCodeName Company Name
AllocationCycleNameText AllocationCycleNameText Cycle Description
AllocationTagID AllocationTagID Allocation Tags
AllocTagAssignmentStatus AllocTagAssignmentStatus
AllocTagAssignmentStatusName
LedgerName
DrillState DrillState Drill State
HierarchyLevel HierarchyLevel Hierarchy Level

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_AllocTagObjectAssignment_2.
-- 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: CYCLSGMNTHIER
-- Parameters: P_AllocationTagID : fco_tag_id

CREATE VIEW C_AllocTagObjectAssignment_2 AS
SELECT
  AllocationSegmentHier AS AllocationTagHierarchy,
  AllocationCycleHier AS AllocationCycleHierarchy,
  AllocationType,
  AllocationCycle,
  AllocationCycleStartDate,
  AllocationCycleSegment,
  SegmentName,
  AllocationCycleName,
  AllocationActualPlanVariant,
  AllocationPostingType,
  Ledger,
  AllocationStatus,
  LastChangedByUser,
  AllocationCycleEndDate,
  LastChangeDate,
  CreatedByUser,
  AllocationCreateDate,
  AllocationFrequency,
  CompanyCode,
  AllocationCycleCategory,
  CompanyCodeName,
  AllocationCycleNameText,
  AllocationTagID,
  AllocTagAssignmentStatus,
  _AllocTagAssgmtStatus._Text[1:Language = $session.system_language].AllocTagAssignmentStatusName AS AllocTagAssignmentStatusName,
  _Ledger._Text[1:Language = $session.system_language].LedgerName AS LedgerName,
  DrillState,
  HierarchyLevel
FROM P_CycleSegmentHierSourceParam
LEFT OUTER JOIN I_AllocTagAssignmentStatus AS _AllocTagAssgmtStatus ON AllocTagAssignmentStatus = _AllocTagAssgmtStatus.AllocTagAssignmentStatus  -- association [1..1]
LEFT OUTER JOIN I_DomainFixedValue AS _PostingTypeText ON _PostingTypeText.SAPDataDictionaryDomain = 'FCO_ALLOCATION_ALART' AND _PostingTypeText.DomainValue = AllocationPostingType  -- association [0..*]
LEFT OUTER JOIN I_DomainFixedValue AS _ActualPlanVariantText ON _ActualPlanVariantText.SAPDataDictionaryDomain = 'IPKNZ' AND _ActualPlanVariantText.DomainValue = AllocationActualPlanVariant  -- association [0..*]
LEFT OUTER JOIN I_DomainFixedValue AS _AllocationTypeText ON _AllocationTypeText.SAPDataDictionaryDomain = 'FCO_ALLOCATION_CONTEXT' AND _AllocationTypeText.DomainValue = AllocationType  -- association [0..*]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
;

Learn More