P_AllocFldGrpExtenFldInfo

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_AllocFldGrpExtenFldInfo.
-- 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: PALFLDGRPEXTEN

CREATE VIEW P_AllocFldGrpExtenFldInfo AS
SELECT
  AllocationType,
  AllocationPostingType,
  AllocationActualPlanVariant,
  AllocationFieldName,
  ReceiverTracingSingleField,
  ReceiverTracingFieldInterval,
  ReceiverTracingFieldGroup
FROM I_AllocationInformation
LEFT OUTER JOIN I_AllocDataFldDesc AS _AllocInformation1 ON AllocationType = _AllocInformation1.AllocationType AND( AllocationFieldName = _AllocInformation1.AllocationDataFieldName1 OR AllocationFieldName = _AllocInformation1.AllocationDataFieldName2 OR AllocationFieldName = _AllocInformation1.AllocationDataFieldName3 OR AllocationFieldName = _AllocInformation1.AllocationDataFieldName4 OR AllocationFieldName = _AllocInformation1.AllocationDataFieldName5 OR AllocationFieldName = _AllocInformation1.AllocationDataFieldName6 OR AllocationFieldName = _AllocInformation1.AllocationDataFieldName7 OR AllocationFieldName = _AllocInformation1.AllocationDataFieldName8 OR AllocationFieldName = _AllocInformation1.AllocationDataFieldName9 OR AllocationFieldName = _AllocInformation1.AllocationDataFieldName10 )  -- association [0..1]
;