C_AllocationRunDocument

DDL: C_ALLOCATIONRUNDOCUMENT SQL: CALLOCRUNDOC Type: view CONSUMPTION Package: ODATA_RUN_ALLOCATION
13 Fields 1 Data Sources 2 OData Services

Allocation Run Document

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

Data Sources (1)

SourceAliasJoin Type
P_AllocationRunDocument P_AllocationRunDocument from

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CALLOCRUNDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Allocation Run Document view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F3548 ASQL_F3548 C2 NOT_RELEASED
ASQL_F4363 ASQL_F4363 C2 NOT_RELEASED

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY UniversalAllocationRun UniversalAllocationRun
KEY AllocCycleWithExecutionLedger AllocCycleWithExecutionLedger Cycle
KEY AllocationCycleStartDate AllocationCycleStartDate Valid From
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY AllocDocumentSequenceNumber AllocDocumentSequenceNumber
AllocationType AllocationType Table
AllocationActualPlanVariant AllocationActualPlanVariant Actual/Plan
AllocationPostingType AllocationPostingType Posting Type
AllocationCycle AllocationCycle Cycle
AllocationCycleIsReversed AllocationCycleIsReversed
AllocationCycleName AllocationCycleName Allocation Cycle
Ledger Ledger Ledger

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 C_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: CALLOCRUNDOC

CREATE VIEW C_AllocationRunDocument AS
SELECT
  UniversalAllocationRun,
  AllocCycleWithExecutionLedger,
  AllocationCycleStartDate,
  FiscalYear,
  FiscalPeriod,
  AllocDocumentSequenceNumber,
  AllocationType,
  AllocationActualPlanVariant,
  AllocationPostingType,
  AllocationCycle,
  AllocationCycleIsReversed,
  AllocationCycleName,
  Ledger
FROM P_AllocationRunDocument
;

Learn More