C_AllocCashFlowPlanPosting

DDL: C_ALLOCCASHFLOWPLANPOSTING Type: view_entity CONSUMPTION Package: ODATA_ALLOCATION_FLOW
42 Fields 1 Data Sources 6 Associations 1 OData Services

Allocation Flow Plan Postings

C_AllocCashFlowPlanPosting is a Consumption CDS View that provides data about "Allocation Flow Plan Postings" in SAP S/4HANA. It reads from 1 data source (P_AllocationRunResult) and exposes 42 fields with key fields UniversalAllocationRun, AllocationCycle, AllocationCycleSegment, AllocationCycleStartDate, AllocationRunDataCategory. 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_AllocationRunResult P_AllocationRunResult 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 Plan 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 (42)

KeyFieldSource TableSource FieldDescription
KEY UniversalAllocationRun UniversalAllocationRun
KEY AllocationCycle AllocationCycle Cycle
KEY AllocationCycleSegment AllocationCycleSegment Segment Number
KEY AllocationCycleStartDate AllocationCycleStartDate Valid From
KEY AllocationRunDataCategory AllocationRunDataCategory
KEY AllocationRunResultItem AllocationRunResultItem
FiscalYear LedgerFiscalYear
FiscalPeriod FiscalPeriod Tax period
AccountingDocument AccountingDocument Journal Entry
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
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
CreationDateTime CreationDateTime Timestamp
AllocationCycleIsReversed AllocationCycleIsReversed
ControllingDebitCreditCode ControllingDebitCreditCode Dr/Cr ind. CO
OriginCtrlgDebitCreditCode OriginCtrlgDebitCreditCode Debit/CreditInd
Fund Fund Sender Fund
FundName _FundText FundName Long Text
AllocationCycleCategory AllocationCycleCategory Plan Category
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_AllocCashFlowPlanPosting.
-- 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_AllocCashFlowPlanPosting AS
SELECT
  UniversalAllocationRun,
  AllocationCycle,
  AllocationCycleSegment,
  AllocationCycleStartDate,
  AllocationRunDataCategory,
  AllocationRunResultItem,
  LedgerFiscalYear AS FiscalYear,
  FiscalPeriod,
  AccountingDocument,
  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,
  PostingDate,
  DocumentDate,
  CreationDateTime,
  AllocationCycleIsReversed,
  ControllingDebitCreditCode,
  OriginCtrlgDebitCreditCode,
  Fund,
  _FundText.FundName AS FundName,
  AllocationCycleCategory,
  FunctionalArea,
  _FunctionalAreaText.FunctionalAreaName AS FunctionalAreaName,
  GrantID,
  _GrantText.GrantName AS GrantName
FROM P_AllocationRunResult
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