P_AllocationCashFlowCostCenter

DDL: P_ALLOCATIONCASHFLOWCOSTCENTER SQL: PALOCFLOWOBJ Type: view CONSUMPTION Package: ODATA_ALLOCATION_FLOW
34 Fields 1 Data Sources 3 Associations

Allocation Flow Object

P_AllocationCashFlowCostCenter is a Consumption CDS View that provides data about "Allocation Flow Object" in SAP S/4HANA. It reads from 1 data source (I_AllocationRunResultMapping) and exposes 34 fields with key fields UniversalAllocationRun, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment, AllocationRunSenderItem. It has 3 associations to related views. Part of development package ODATA_ALLOCATION_FLOW.

Data Sources (1)

SourceAliasJoin Type
I_AllocationRunResultMapping I_AllocationRunResultMapping from

Parameters (4)

NameTypeDefault
P_AllocDisplayCurrencyType fco_alloc_ng_currency_type
P_FiscalPeriod poper
P_FiscalYear fis_gjahr
P_AllocationActualPlanVariant fco_alloc_ipknz

Associations (3)

CardinalityTargetAliasCondition
[1] I_AllocationRun _Run $projection.UniversalAllocationRun = _Run.UniversalAllocationRun
[0..1] P_AllocationRunResult _SenderResult _SenderResult.UniversalAllocationRun = $projection.UniversalAllocationRun and _SenderResult.AllocationCycle = $projection.AllocationCycle and _SenderResult.AllocationCycleStartDate = $projection.AllocationCycleStartDate and _SenderResult.AllocationCycleSegment = $projection.AllocationCycleSegment and _SenderResult.AllocationRunDataCategory = 'S' and _SenderResult.AllocationRunResultItem = $projection.AllocationRunSenderItem
[0..1] P_AllocationRunResult _ReceiverResult _ReceiverResult.UniversalAllocationRun = $projection.UniversalAllocationRun and _ReceiverResult.AllocationCycle = $projection.AllocationCycle and _ReceiverResult.AllocationCycleStartDate = $projection.AllocationCycleStartDate and _ReceiverResult.AllocationCycleSegment = $projection.AllocationCycleSegment and _ReceiverResult.AllocationRunDataCategory = 'R' and _ReceiverResult.AllocationRunResultItem = $projection.AllocationRunReceiverItem

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PALOCFLOWOBJ view
AbapCatalog.buffering.status #NOT_ALLOWED view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Allocation Flow Object view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY UniversalAllocationRun UniversalAllocationRun UUID
KEY AllocationCycle AllocationCycle Cycle
KEY AllocationCycleStartDate AllocationCycleStartDate Valid From
KEY AllocationCycleSegment AllocationCycleSegment Segment Number
KEY AllocationRunSenderItem AllocationRunSenderItem Result Pos.
KEY AllocationRunReceiverItem AllocationRunReceiverItem Result Pos.
SenderGLAccount _SenderResult GLAccount General Ledger
SenderCostCenter _SenderResult CostCenter Cost Center
ReceiverGLAccount _ReceiverResult GLAccount General Ledger
ReceiverCostCenter _ReceiverResult CostCenter Cost Center
ReceiverWBSElement _ReceiverResult WBSElement WBS Internal ID
AllocationDisplayCurrencyType
CompanyCode _ReceiverResult CompanyCode Receiver Company Code
CompanyCodeCurrency _ReceiverResult CompanyCodeCurrency Local Currency
GlobalCurrency _ReceiverResult GlobalCurrency GM Billing Element: Global Currency
AmountInCompanyCodeCurrency _ReceiverResult AmountInCompanyCodeCurrency Local Crcy Amt
AmountInGlobalCurrency _ReceiverResult AmountInGlobalCurrency Amount in Global Currency
AllocationType _ReceiverResult AllocationType Table
AllocationCycleName _ReceiverResult AllocationCycleName Allocation Cycle
SegmentName _ReceiverResult SegmentName Segment Name
AllocationCycleCategory _ReceiverResult AllocationCycleCategory Plan Category
WBSElement _ReceiverResult WBSElement WBS Internal ID
WBSElementLangBsdDescription _ReceiverResult WBSElementLangBsdDescription
AllocationActualPlanVariant _Run AllocationActualPlanVariant Actual/Plan
AllocActualPlanVariantText _Run AllocActualPlanVariantText
AllocationPostingType _Run AllocationPostingType Posting Type
AllocationPostingTypeText _Run AllocationPostingTypeText
AllocationRunIsTest _Run AllocationRunIsTest
Ledger _Run Ledger Ledger
FiscalYear _Run FiscalYear G/L Fiscal Year
FiscalPeriod _ReceiverResult FiscalPeriod Tax period
_SenderResult _SenderResult
_ReceiverResult _ReceiverResult
_Run _Run

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_AllocationCashFlowCostCenter.
-- 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: PALOCFLOWOBJ
-- Parameters: P_AllocDisplayCurrencyType : fco_alloc_ng_currency_type, P_FiscalPeriod : poper, P_FiscalYear : fis_gjahr, P_AllocationActualPlanVariant : fco_alloc_ipknz

CREATE VIEW P_AllocationCashFlowCostCenter AS
SELECT
  UniversalAllocationRun,
  AllocationCycle,
  AllocationCycleStartDate,
  AllocationCycleSegment,
  AllocationRunSenderItem,
  AllocationRunReceiverItem,
  _SenderResult.GLAccount AS SenderGLAccount,
  _SenderResult.CostCenter AS SenderCostCenter,
  _ReceiverResult.GLAccount AS ReceiverGLAccount,
  _ReceiverResult.CostCenter AS ReceiverCostCenter,
  _ReceiverResult.WBSElement AS ReceiverWBSElement,
  $parameters.P_AllocDisplayCurrencyType AS AllocationDisplayCurrencyType,
  _ReceiverResult.CompanyCode AS CompanyCode,
  _ReceiverResult.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ReceiverResult.GlobalCurrency AS GlobalCurrency,
  _ReceiverResult.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _ReceiverResult.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _ReceiverResult.AllocationType AS AllocationType,
  _ReceiverResult.AllocationCycleName AS AllocationCycleName,
  _ReceiverResult.SegmentName AS SegmentName,
  _ReceiverResult.AllocationCycleCategory AS AllocationCycleCategory,
  _ReceiverResult.WBSElement AS WBSElement,
  _ReceiverResult.WBSElementLangBsdDescription AS WBSElementLangBsdDescription,
  _Run.AllocationActualPlanVariant AS AllocationActualPlanVariant,
  _Run.AllocActualPlanVariantText AS AllocActualPlanVariantText,
  _Run.AllocationPostingType AS AllocationPostingType,
  _Run.AllocationPostingTypeText AS AllocationPostingTypeText,
  _Run.AllocationRunIsTest AS AllocationRunIsTest,
  _Run.Ledger AS Ledger,
  _Run.FiscalYear AS FiscalYear,
  _ReceiverResult.FiscalPeriod AS FiscalPeriod
FROM I_AllocationRunResultMapping
LEFT OUTER JOIN I_AllocationRun AS _Run ON UniversalAllocationRun = _Run.UniversalAllocationRun  -- association [1]
LEFT OUTER JOIN P_AllocationRunResult AS _SenderResult ON _SenderResult.UniversalAllocationRun = UniversalAllocationRun AND _SenderResult.AllocationCycle = AllocationCycle AND _SenderResult.AllocationCycleStartDate = AllocationCycleStartDate AND _SenderResult.AllocationCycleSegment = AllocationCycleSegment AND _SenderResult.AllocationRunDataCategory = 'S' AND _SenderResult.AllocationRunResultItem = AllocationRunSenderItem  -- association [0..1]
LEFT OUTER JOIN P_AllocationRunResult AS _ReceiverResult ON _ReceiverResult.UniversalAllocationRun = UniversalAllocationRun AND _ReceiverResult.AllocationCycle = AllocationCycle AND _ReceiverResult.AllocationCycleStartDate = AllocationCycleStartDate AND _ReceiverResult.AllocationCycleSegment = AllocationCycleSegment AND _ReceiverResult.AllocationRunDataCategory = 'R' AND _ReceiverResult.AllocationRunResultItem = AllocationRunReceiverItem  -- association [0..1]
;

Learn More