P_AllocCashFlowCostCenter1

DDL: P_ALLOCCASHFLOWCOSTCENTER1 SQL: PALOCFLOWOBJ1 Type: view CONSUMPTION

Allocation Flow Object

P_AllocCashFlowCostCenter1 is a Consumption CDS View that provides data about "Allocation Flow Object" in SAP S/4HANA. It reads from 1 data source (P_AllocationCashFlowObject1) and exposes 27 fields with key fields UniversalAllocationRun, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment, AllocationRunSenderItem.

Data Sources (1)

SourceAliasJoin Type
P_AllocationCashFlowObject1 P_AllocationCashFlowObject1 from

Parameters (7)

NameTypeDefault
P_CompanyCode fis_bukrs
P_CostCenter kostl
P_AllocDisplayCurrencyType fco_alloc_ng_currency_type
P_FiscalPeriod poper
P_FiscalYear fis_gjahr
P_AllocationActualPlanVariant fco_alloc_ipknz
P_Ledger fins_ledger

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PALOCFLOWOBJ1 view
AbapCatalog.buffering.status #NOT_ALLOWED view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED 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 (27)

KeyFieldSource TableSource FieldDescription
KEY UniversalAllocationRun UniversalAllocationRun
KEY AllocationCycle AllocationCycle Cycle
KEY AllocationCycleStartDate AllocationCycleStartDate Valid From
KEY AllocationCycleSegment AllocationCycleSegment Segment Number
KEY AllocationRunSenderItem AllocationRunSenderItem
KEY AllocationRunReceiverItem AllocationRunReceiverItem
SenderGLAccount SenderGLAccount
SenderCostCenter SenderCostCenter Sender Cost Center
ReceiverGLAccount ReceiverGLAccount GL Account From
ReceiverCostCenter ReceiverCostCenter
ReceiverWBSElement ReceiverWBSElement
WBSElement WBSElement WBS Internal ID
AllocationDisplayCurrencyType AllocationDisplayCurrencyType
DisplayCurrency DisplayCurrency Display Currency
AllocationType AllocationType Table
AllocationCycleName AllocationCycleName Allocation Cycle
Ledger Ledger Ledger
LedgerName LedgerName Ledger Name
AllocationCycleCategory AllocationCycleCategory Plan Category
CompanyCode CompanyCode Receiver Company Code
ChartOfAccounts ChartOfAccounts Node Class
ControllingArea ControllingArea Controlling Area
AllocationActualPlanVariant AllocationActualPlanVariant Actual/Plan
AllocActualPlanVariantText AllocActualPlanVariantText
AllocationPostingType AllocationPostingType Posting Type
AllocationPostingTypeText AllocationPostingTypeText
AllocationCycleNameText _CycleText AllocationCycleNameText Cycle Description

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_AllocCashFlowCostCenter1.
-- 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: PALOCFLOWOBJ1
-- Parameters: P_CompanyCode : fis_bukrs, P_CostCenter : kostl, P_AllocDisplayCurrencyType : fco_alloc_ng_currency_type, P_FiscalPeriod : poper, P_FiscalYear : fis_gjahr, P_AllocationActualPlanVariant : fco_alloc_ipknz, P_Ledger : fins_ledger

CREATE VIEW P_AllocCashFlowCostCenter1 AS
SELECT
  UniversalAllocationRun,
  AllocationCycle,
  AllocationCycleStartDate,
  AllocationCycleSegment,
  AllocationRunSenderItem,
  AllocationRunReceiverItem,
  SenderGLAccount,
  SenderCostCenter,
  ReceiverGLAccount,
  ReceiverCostCenter,
  ReceiverWBSElement,
  WBSElement,
  AllocationDisplayCurrencyType,
  DisplayCurrency,
  AllocationType,
  AllocationCycleName,
  Ledger,
  LedgerName,
  AllocationCycleCategory,
  CompanyCode,
  ChartOfAccounts,
  ControllingArea,
  AllocationActualPlanVariant,
  AllocActualPlanVariantText,
  AllocationPostingType,
  AllocationPostingTypeText,
  _CycleText.AllocationCycleNameText AS AllocationCycleNameText
FROM P_AllocationCashFlowObject1
;