C_AllocCashFlowActualPosting

DDL: C_ALLOCCASHFLOWACTUALPOSTING Type: view_entity CONSUMPTION Package: ODATA_ALLOCATION_FLOW
39 Fields 1 Data Sources 6 Associations 1 OData Services

Allocation Flow Actual Postings

C_AllocCashFlowActualPosting is a Consumption CDS View that provides data about "Allocation Flow Actual Postings" in SAP S/4HANA. It reads from 1 data source (P_AllocRunJournalEntryItem1) and exposes 39 fields with key fields UniversalAllocationRun, AllocationCycle, AllocationCycleStartDate, FiscalYear, FiscalPeriod. It has 6 associations to related views. It is exposed through 1 OData service (ASQL_F4022). Part of development package ODATA_ALLOCATION_FLOW.

Data Sources (1)

SourceAliasJoin Type
P_AllocRunJournalEntryItem1 P_AllocRunJournalEntryItem1 from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_GLAccountText _GLAcctInChartOfAccountsText $projection.ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts and $projection.GLAccount = _GLAcctInChartOfAccountsText.GLAccount and _GLAcctInChartOfAccountsText.Language = $session.system_language
[0..1] I_ProfitCenterText _ProfitCenterText $projection.ProfitCenter = _ProfitCenterText.ProfitCenter and $projection.ControllingArea = _ProfitCenterText.ControllingArea and _ProfitCenterText.Language = $session.system_language and _ProfitCenterText.ValidityStartDate <= $session.system_date and _ProfitCenterText.ValidityEndDate >= $session.system_date
[0..1] I_CostCenterText _CostCenterText $projection.CostCenter = _CostCenterText.CostCenter and $projection.ControllingArea = _CostCenterText.ControllingArea and _CostCenterText.Language = $session.system_language and _CostCenterText.ValidityStartDate <= $session.system_date and _CostCenterText.ValidityEndDate >= $session.system_date
[0..1] I_FundText _FundText $projection.Fund = _FundText.Fund and _FundText.FinancialManagementArea = $projection.FinancialManagementArea and _FundText.Language = $session.system_language
[0..1] I_GrantText _GrantText $projection.GrantID = _GrantText.GrantID and _GrantText.Language = $session.system_language
[0..1] I_FunctionalAreaText _FunctionalAreaText $projection.FunctionalArea = _FunctionalAreaText.FunctionalArea and _FunctionalAreaText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Allocation Flow Actual Postings view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4022 ASQL_F4022 C2 NOT_RELEASED

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY UniversalAllocationRun UniversalAllocationRun
KEY AllocationCycle AllocationCycle Cycle
KEY AllocationCycleStartDate AllocationCycleStartDate Valid From
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY AllocDocumentSequenceNumber AllocDocumentSequenceNumber
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
AllocationType AllocationType Table
AllocationActualPlanVariant AllocationActualPlanVariant Actual/Plan
AllocationPostingType AllocationPostingType Posting Type
AllocationCycleName AllocationCycleName Allocation Cycle
ReversalReferenceDocument ReversalReferenceDocument Reversal Reference Document
Ledger Ledger Ledger
CompanyCode CompanyCode Receiver Company Code
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
ChartOfAccounts ChartOfAccounts Node Class
ControllingArea ControllingArea Controlling Area
FinancialManagementArea FinancialManagementArea FM Area
GLAccount GLAccount General Ledger
GLAccountName _GLAcctInChartOfAccountsText GLAccountName Short Text
CostCenter CostCenter Cost Center
CostCenterName _CostCenterText CostCenterName Name
ProfitCenter ProfitCenter Profit Center
ProfitCenterName _ProfitCenterText ProfitCenterName Profit Center Name
DebitCreditCode DebitCreditCode Single-Character Flag
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
CreationDateTime CreationDateTime Timestamp
Fund Fund Sender Fund
FundName _FundText FundName Long Text
AllocationRunStartDateTime AllocationRunStartDateTime
FunctionalArea FunctionalArea Sendr Fctl Area
FunctionalAreaName _FunctionalAreaText FunctionalAreaName Long Text
GrantID GrantID Sender Grant
GrantName _GrantText GrantName

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_AllocCashFlowActualPosting.
-- 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.

CREATE VIEW C_AllocCashFlowActualPosting AS
SELECT
  UniversalAllocationRun,
  AllocationCycle,
  AllocationCycleStartDate,
  FiscalYear,
  FiscalPeriod,
  AllocDocumentSequenceNumber,
  AccountingDocument,
  LedgerGLLineItem,
  AllocationType,
  AllocationActualPlanVariant,
  AllocationPostingType,
  AllocationCycleName,
  ReversalReferenceDocument,
  Ledger,
  CompanyCode,
  IsReversal,
  IsReversed,
  CompanyCodeCurrency,
  GlobalCurrency,
  ChartOfAccounts,
  ControllingArea,
  FinancialManagementArea,
  GLAccount,
  _GLAcctInChartOfAccountsText.GLAccountName AS GLAccountName,
  CostCenter,
  _CostCenterText.CostCenterName AS CostCenterName,
  ProfitCenter,
  _ProfitCenterText.ProfitCenterName AS ProfitCenterName,
  DebitCreditCode,
  PostingDate,
  DocumentDate,
  CreationDateTime,
  Fund,
  _FundText.FundName AS FundName,
  AllocationRunStartDateTime,
  FunctionalArea,
  _FunctionalAreaText.FunctionalAreaName AS FunctionalAreaName,
  GrantID,
  _GrantText.GrantName AS GrantName
FROM P_AllocRunJournalEntryItem1
LEFT OUTER JOIN I_GLAccountText AS _GLAcctInChartOfAccountsText ON ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAccountsText.GLAccount AND _GLAcctInChartOfAccountsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ProfitCenter = _ProfitCenterText.ProfitCenter AND ControllingArea = _ProfitCenterText.ControllingArea AND _ProfitCenterText.Language = $session.system_language AND _ProfitCenterText.ValidityStartDate <= $session.system_date AND _ProfitCenterText.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON CostCenter = _CostCenterText.CostCenter AND ControllingArea = _CostCenterText.ControllingArea AND _CostCenterText.Language = $session.system_language AND _CostCenterText.ValidityStartDate <= $session.system_date AND _CostCenterText.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _FundText ON Fund = _FundText.Fund AND _FundText.FinancialManagementArea = FinancialManagementArea AND _FundText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID AND _GrantText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea AND _FunctionalAreaText.Language = $session.system_language  -- association [0..1]
;

Learn More