P_AllocFieldGroupInformation

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_AllocFieldGroupInformation.
-- 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: PALLOFLDGRPINFO

CREATE VIEW P_AllocFieldGroupInformation AS
SELECT
  AllocationType,
  AllocationPostingType,
  AllocationActualPlanVariant,
  AllocationFieldGroup,
  AllocVariablePortingType,
  AllocFldActlPlnVarValue,
  AllocationDataFieldName1,
  AllocationDataFieldName2,
  AllocationDataFieldName3,
  AllocationDataFieldName4,
  AllocationDataFieldName5,
  AllocationDataFieldName6,
  AllocationDataFieldName7,
  AllocationDataFieldName8,
  AllocationDataFieldName9,
  AllocationDataFieldName10
FROM P_AllocFldGroupDataInformation
LEFT OUTER JOIN P_AllocationInformation AS _AllocInformation1 ON AllocationType = _AllocInformation1.AllocationType AND AllocationActualPlanVariant = _AllocInformation1.AllocationActualPlanVariant AND AllocationPostingType = _AllocInformation1.AllocationPostingType AND AllocationDataFieldName1 = _AllocInformation1.AllocationFieldName  -- association [0..1]
LEFT OUTER JOIN P_AllocationInformation AS _AllocInformation2 ON AllocationType = _AllocInformation2.AllocationType AND AllocationActualPlanVariant = _AllocInformation2.AllocationActualPlanVariant AND AllocationPostingType = _AllocInformation2.AllocationPostingType AND AllocationDataFieldName2 = _AllocInformation2.AllocationFieldName  -- association [0..1]
LEFT OUTER JOIN P_AllocationInformation AS _AllocInformation3 ON AllocationType = _AllocInformation3.AllocationType AND AllocationActualPlanVariant = _AllocInformation3.AllocationActualPlanVariant AND AllocationPostingType = _AllocInformation3.AllocationPostingType AND AllocationDataFieldName3 = _AllocInformation3.AllocationFieldName  -- association [0..1]
LEFT OUTER JOIN P_AllocationInformation AS _AllocInformation4 ON AllocationType = _AllocInformation4.AllocationType AND AllocationActualPlanVariant = _AllocInformation4.AllocationActualPlanVariant AND AllocationPostingType = _AllocInformation4.AllocationPostingType AND AllocationDataFieldName4 = _AllocInformation4.AllocationFieldName  -- association [0..1]
LEFT OUTER JOIN P_AllocationInformation AS _AllocInformation5 ON AllocationType = _AllocInformation5.AllocationType AND AllocationActualPlanVariant = _AllocInformation5.AllocationActualPlanVariant AND AllocationPostingType = _AllocInformation5.AllocationPostingType AND AllocationDataFieldName5 = _AllocInformation5.AllocationFieldName  -- association [0..1]
LEFT OUTER JOIN P_AllocationInformation AS _AllocInformation6 ON AllocationType = _AllocInformation6.AllocationType AND AllocationActualPlanVariant = _AllocInformation6.AllocationActualPlanVariant AND AllocationPostingType = _AllocInformation6.AllocationPostingType AND AllocationDataFieldName6 = _AllocInformation6.AllocationFieldName  -- association [0..1]
LEFT OUTER JOIN P_AllocationInformation AS _AllocInformation7 ON AllocationType = _AllocInformation7.AllocationType AND AllocationActualPlanVariant = _AllocInformation7.AllocationActualPlanVariant AND AllocationPostingType = _AllocInformation7.AllocationPostingType AND AllocationDataFieldName7 = _AllocInformation7.AllocationFieldName  -- association [0..1]
LEFT OUTER JOIN P_AllocationInformation AS _AllocInformation8 ON AllocationType = _AllocInformation8.AllocationType AND AllocationActualPlanVariant = _AllocInformation8.AllocationActualPlanVariant AND AllocationPostingType = _AllocInformation8.AllocationPostingType AND AllocationDataFieldName8 = _AllocInformation8.AllocationFieldName  -- association [0..1]
LEFT OUTER JOIN P_AllocationInformation AS _AllocInformation9 ON AllocationType = _AllocInformation9.AllocationType AND AllocationActualPlanVariant = _AllocInformation9.AllocationActualPlanVariant AND AllocationPostingType = _AllocInformation9.AllocationPostingType AND AllocationDataFieldName9 = _AllocInformation9.AllocationFieldName  -- association [0..1]
LEFT OUTER JOIN P_AllocationInformation AS _AllocInformation10 ON AllocationType = _AllocInformation10.AllocationType AND AllocationActualPlanVariant = _AllocInformation10.AllocationActualPlanVariant AND AllocationPostingType = _AllocInformation10.AllocationPostingType AND AllocationDataFieldName10 = _AllocInformation10.AllocationFieldName  -- association [0..1]
;