C_AllocTagObjectAssignment_2

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]
;