P_AllocationRun1

DDL: P_ALLOCATIONRUN1 SQL: PALLOCATIONRUN1 Type: view CONSUMPTION Package: ODATA_RUN_ALLOCATION
45 Fields 1 Data Sources

Allocation Run

P_AllocationRun1 is a Consumption CDS View that provides data about "Allocation Run" in SAP S/4HANA. It reads from 1 data source (P_AllocationRun) and exposes 45 fields with key field UniversalAllocationRun. Part of development package ODATA_RUN_ALLOCATION.

Data Sources (1)

SourceAliasJoin Type
P_AllocationRun P_AllocationRun from

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PALLOCATIONRUN1 view
AbapCatalog.compiler.compareFilter 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 (45)

KeyFieldSource TableSource FieldDescription
KEY UniversalAllocationRun UniversalAllocationRun
UniversalAllocationRunName UniversalAllocationRunName
AllocationRunStartDateTime
AllocationRunStartDate AllocationRunStartDate
AllocationRunStartTime AllocationRunStartTime
AllocationRunDurationInSeconds AllocationRunDurationInSeconds
AllocationRunEndDateTime
AllocationRunEndDate AllocationRunEndDate
AllocationRunEndTime AllocationRunEndTime
AllocationRunBookingDateTime
AllocationRunBookingDate AllocationRunBookingDate
AllocationRunBookingTime AllocationRunBookingTime
AllocRunBkgDurationInSeconds AllocRunBkgDurationInSeconds
AllocationRunUser AllocationRunUser
Ledger Ledger Ledger
AllocationType AllocationType Table
AllocationContextTypeText AllocationContextTypeText
AllocationPostingType AllocationPostingType Posting Type
AllocationPostingTypeText AllocationPostingTypeText
AllocationActualPlanVariant AllocationActualPlanVariant Actual/Plan
AllocActualPlanVariantText AllocActualPlanVariantText
AllocationRunStatus AllocationRunStatus
AllocationRunStatusText AllocationRunStatusText
CriticalityCode CriticalityCode Criticality
FiscalYear FiscalYear G/L Fiscal Year
AllocationRunStartPeriod AllocationRunStartPeriod
AllocationRunEndPeriod AllocationRunEndPeriod
AllocRunReferenceStartPeriod AllocRunReferenceStartPeriod
AllocRunReferenceEndPeriod AllocRunReferenceEndPeriod
AllocRunRefStartFiscalYear AllocRunRefStartFiscalYear
AllocRunRefEndFiscalYear AllocRunRefEndFiscalYear
AllocationRunIsCumulative AllocationRunIsCumulative
AllocationRunIsTest AllocationRunIsTest
AllocationRunIsTestText AllocationRunIsTestText
DocumentType DocumentType Order Type
AllocationRunScheduledJob AllocationRunScheduledJob
AllocationRunJob AllocationRunJob
AllocationRunHasReferenceData AllocationRunHasReferenceData
AllocationRunType AllocationRunType
HasNote HasNote TRUE
AllocRunHasIncrmtlProcessing AllocRunHasIncrmtlProcessing
AllocationRunTriggerSource AllocationRunTriggerSource
AllocRunHasCumulatedRefPeriods AllocRunHasCumulatedRefPeriods
NumberOfOpenMessages NumberOfOpenMessages
_UserContactCard _UserContactCard

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_AllocationRun1.
-- 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: PALLOCATIONRUN1

CREATE VIEW P_AllocationRun1 AS
SELECT
  UniversalAllocationRun,
  UniversalAllocationRunName,
  dats_tims_to_tstmp(AllocationRunStartDate, AllocationRunStartTime, '', $session.client, 'INITIAL' ) AS AllocationRunStartDateTime,
  AllocationRunStartDate,
  AllocationRunStartTime,
  AllocationRunDurationInSeconds,
  dats_tims_to_tstmp(AllocationRunEndDate, AllocationRunEndTime, '', $session.client, 'INITIAL' ) AS AllocationRunEndDateTime,
  AllocationRunEndDate,
  AllocationRunEndTime,
  dats_tims_to_tstmp(AllocationRunBookingDate, AllocationRunBookingTime, '', $session.client, 'INITIAL' ) AS AllocationRunBookingDateTime,
  AllocationRunBookingDate,
  AllocationRunBookingTime,
  AllocRunBkgDurationInSeconds,
  AllocationRunUser,
  Ledger,
  AllocationType,
  AllocationContextTypeText,
  AllocationPostingType,
  AllocationPostingTypeText,
  AllocationActualPlanVariant,
  AllocActualPlanVariantText,
  AllocationRunStatus,
  AllocationRunStatusText,
  CriticalityCode,
  FiscalYear,
  AllocationRunStartPeriod,
  AllocationRunEndPeriod,
  AllocRunReferenceStartPeriod,
  AllocRunReferenceEndPeriod,
  AllocRunRefStartFiscalYear,
  AllocRunRefEndFiscalYear,
  AllocationRunIsCumulative,
  AllocationRunIsTest,
  AllocationRunIsTestText,
  DocumentType,
  AllocationRunScheduledJob,
  AllocationRunJob,
  AllocationRunHasReferenceData,
  AllocationRunType,
  HasNote,
  AllocRunHasIncrmtlProcessing,
  AllocationRunTriggerSource,
  AllocRunHasCumulatedRefPeriods,
  NumberOfOpenMessages
FROM P_AllocationRun
;

Learn More