P_AllocationRunDocument

DDL: P_ALLOCATIONRUNDOCUMENT SQL: PALLOCRUNDOC Type: view CONSUMPTION Package: ODATA_RUN_ALLOCATION
18 Fields 1 Data Sources

Allocation Run Document

P_AllocationRunDocument is a Consumption CDS View that provides data about "Allocation Run Document" in SAP S/4HANA. It reads from 1 data source (P_AllocationRunDocument1) and exposes 18 fields with key fields UniversalAllocationRun, AllocCycleWithExecutionLedger, AllocationCycleStartDate, FiscalYear, FiscalPeriod. Part of development package ODATA_RUN_ALLOCATION.

Data Sources (1)

SourceAliasJoin Type
P_AllocationRunDocument1 P_AllocationRunDocument1 from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PALLOCRUNDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY UniversalAllocationRun UniversalAllocationRun
KEY AllocCycleWithExecutionLedger AllocationCycle Cycle
KEY AllocationCycleStartDate AllocationCycleStartDate Valid From
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY AllocDocumentSequenceNumber AllocDocumentSequenceNumber
JournalEntryCreationDate JournalEntryCreationDate Journal Entry Creation Date
JournalEntryCreationTime JournalEntryCreationTime Journal Entry Creation Time
AllocationType AllocationType Table
AllocationContextTypeText AllocationContextTypeText
Ledger Ledger Ledger
AllocationActualPlanVariant AllocationActualPlanVariant Actual/Plan
AllocationPostingType AllocationPostingType Posting Type
AllocationCycleIsReversed AllocationCycleIsReversed
AllocationCycleName AllocationCycleName Allocation Cycle
AllocationCycle _Cycle AllocationCycle Cycle
_AllocationRun _AllocationRun
_Document _Document

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_AllocationRunDocument.
-- 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: PALLOCRUNDOC

CREATE VIEW P_AllocationRunDocument AS
SELECT
  UniversalAllocationRun,
  AllocationCycle AS AllocCycleWithExecutionLedger,
  AllocationCycleStartDate,
  FiscalYear,
  FiscalPeriod,
  AllocDocumentSequenceNumber,
  JournalEntryCreationDate,
  JournalEntryCreationTime,
  AllocationType,
  AllocationContextTypeText,
  Ledger,
  AllocationActualPlanVariant,
  AllocationPostingType,
  AllocationCycleIsReversed,
  AllocationCycleName,
  _Cycle.AllocationCycle AS AllocationCycle
FROM P_AllocationRunDocument1
;

Learn More