P_AllocationDocument

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_AllocationDocument.
-- 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: PALLOCDOC

CREATE VIEW P_AllocationDocument AS
SELECT
  Document.AllocationType AS AllocationType,
  Document.AllocationCycle AS AllocationCycle,
  Document.AllocationCycleStartDate AS AllocationCycleStartDate,
  Document.FiscalYear AS FiscalYear,
  Document.FiscalPeriod AS FiscalPeriod,
  Document.AllocDocumentSequenceNumber AS AllocDocumentSequenceNumber,
  Document.ReferenceDocumentNumber AS ReferenceDocumentNumber,
  Document.PostingDate AS PostingDate,
  Document.AllocationCycleIsReversed AS AllocationCycleIsReversed,
  Document.AllocationCycleName AS AllocationCycleName,
  Document.Ledger AS Ledger,
  Document.AllocationCycleVersionValue AS AllocationCycleVersionValue,
  _RunDocument.UniversalAllocationRun AS UniversalAllocationRun,
  _RunDocument._AllocationRun.AllocationRunStartDate AS AllocationRunStartDate,
  _RunDocument._AllocationRun.AllocationRunStartTime AS AllocationRunStartTime,
  _RunDocument._AllocationRun.AllocationRunType AS AllocationRunType
FROM I_AllocationDocument AS Document
LEFT OUTER JOIN I_AllocationRunDocument AS _RunDocument ON Document.AllocationType = _RunDocument.AllocationType AND Document.AllocationCycle = _RunDocument.AllocationCycle AND Document.AllocationCycleStartDate = _RunDocument.AllocationCycleStartDate AND Document.FiscalYear = _RunDocument.FiscalYear AND Document.FiscalPeriod = _RunDocument.FiscalPeriod AND Document.AllocDocumentSequenceNumber = _RunDocument.AllocDocumentSequenceNumber  -- association [0..1]
;