I_GrantCostAllocSgmt

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 I_GrantCostAllocSgmt.
-- 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.

CREATE VIEW I_GrantCostAllocSgmt AS
SELECT
  _Grant.GrantID AS GrantID,
  AllocationType,
  AllocationCycle,
  AllocationCycleStartDate AS ValidityStartDate,
  AllocationCycleSegment,
  AllocationSetType,
  AllocDocumentSequenceNumber,
  _Cycle.AllocationCycleName AS AllocationCycleName,
  _Cycle._Text[1: LanguageCode = $session.system_language ].AllocationCycleNameText AS AllocationCycleNameText,
  _Cycle.Ledger AS Ledger,
  _Cycle.AllocationLastExecutedByUser AS AllocationLastExecutedByUser,
  _Cycle.LastChangedByUser AS LastChangedByUser,
  _Cycle.AllocationLastExecutedDate AS AllocationLastExecutedDate,
  _Segment.SegmentName AS SegmentName,
  _Segment._Text[1: LanguageCode = $session.system_language ].AllocationCycleNameText AS SegmentNameText,
  cast (_Segment.AllocationSegmentIsLocked as sgmtislocked preserving type) AS AllocationSegmentIsLocked,
  _Segment.AllocationFieldGroup AS AllocationFieldGroup,
  AllocationFieldName,
  AllocationSetName,
  AllocationFieldMinimumValue,
  AllocationFieldMaximumValue,
  AllocationSetId,
  AllocKeyFieldIsInitial,
  AllocKeyFieldIsAllValues,
  _Cycle.AllocationCycleEndDate AS ValidityEndDate,
  _Cycle.AllocationActualPlanVariant AS AllocationActualPlanVariant,
  _Cycle.AllocationPostingType AS AllocationPostingType,
  cast( '' as psm_s4c_fm_fund_wu_cas_role ) AS GrantAllocationRole,
  cast( '' as psm_s4c_fm_fund_wu_cas_group ) AS GrantAllocationGroup
FROM I_AllocationKeyField
LEFT OUTER JOIN I_Grant AS _Grant ON _Grant.GrantID = AllocationFieldMinimumValue OR ( _Grant.GrantID between AllocationFieldMinimumValue AND AllocationFieldMaximumValue )  -- association [0..*]
LEFT OUTER JOIN I_AllocationPostingTypeText AS _AllocationPostingTypeText ON _AllocationPostingTypeText.AllocationPostingType = allocationpostingtype AND _AllocationPostingTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AllocationReceiverRuleText AS _AllocationReceiverRuleText ON _AllocationReceiverRuleText.AllocationReceiverRule = AllocationReceiverRule AND _AllocationReceiverRuleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AllocationSenderRuleText AS _AllocationSenderRuleText ON _AllocationSenderRuleText.AllocationSenderRule = AllocationSenderRule AND _AllocationSenderRuleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GrantGlobAcctgHier AS _GrantGAH ON AllocationSetId = _GrantGAH.AllocationSetId  -- association [1..*]
-- UNION with additional select branch(es): I_AllocationKeyField
;