P_FcstCshFlwWthRcnlnPrfl

DDL: P_FCSTCSHFLWWTHRCNLNPRFL Type: view_entity COMPOSITE Package: FCLM_RCN_IMP
24 Fields 3 Data Sources

Forecasted Flow with Reconciliation Profile

P_FcstCshFlwWthRcnlnPrfl is a Composite CDS View that provides data about "Forecasted Flow with Reconciliation Profile" in SAP S/4HANA. It reads from 3 data sources (I_CashFlowRcnlnPrfl, I_CshFlwRcnlnPrflPlngLvlAssgmt, P_RecnclnCashFlowBasic) and exposes 24 fields with key fields OriginSystem, OriginApplication, OriginDocument, OriginTransaction, OriginTransactionQualifier. Part of development package FCLM_RCN_IMP.

Data Sources (3)

SourceAliasJoin Type
I_CashFlowRcnlnPrfl CashFlowRcnlnPrfl inner
I_CshFlwRcnlnPrflPlngLvlAssgmt PlngLvlAssgmt inner
P_RecnclnCashFlowBasic RecnclnCashFlowBasic from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY OriginSystem P_RecnclnCashFlowBasic OriginSystem LogSys: Formula
KEY OriginApplication P_RecnclnCashFlowBasic OriginApplication Origin Application
KEY OriginDocument P_RecnclnCashFlowBasic OriginDocument
KEY OriginTransaction P_RecnclnCashFlowBasic OriginTransaction
KEY OriginTransactionQualifier P_RecnclnCashFlowBasic OriginTransactionQualifier
KEY CashFlow P_RecnclnCashFlowBasic CashFlow
KEY CashFlowReconciliationProfile I_CshFlwRcnlnPrflPlngLvlAssgmt CashFlowReconciliationProfile Reconciliation Profile
KEY CashFlowReconciliationStrategy I_CashFlowRcnlnPrfl CashFlowReconciliationStrategy Reconciliation Strategy
CertaintyLevel P_RecnclnCashFlowBasic CertaintyLevel
LiquidityItem P_RecnclnCashFlowBasic LiquidityItem Liquidity Item
DocumentItemText P_RecnclnCashFlowBasic DocumentItemText Text
TransactionDate P_RecnclnCashFlowBasic TransactionDate Value Date
BankAccountInternalID P_RecnclnCashFlowBasic BankAccountInternalID Technical ID
CompanyCode P_RecnclnCashFlowBasic CompanyCode Receiver Company Code
PlanningLevel P_RecnclnCashFlowBasic PlanningLevel Planning Level
AmountInTransactionCurrency P_RecnclnCashFlowBasic AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency P_RecnclnCashFlowBasic TransactionCurrency Transaction Currency
AccountingDocument P_RecnclnCashFlowBasic AccountingDocument Journal Entry
AccountingDocumentItem P_RecnclnCashFlowBasic AccountingDocumentItem Posting View Item
AccountingDocumentType P_RecnclnCashFlowBasic AccountingDocumentType Journal Entry Type
FinancialAccountType P_RecnclnCashFlowBasic FinancialAccountType Fin. Account Type
Supplier P_RecnclnCashFlowBasic Supplier Supplier
Customer P_RecnclnCashFlowBasic Customer Sold-to Party
CashFlowReconciliationBundle CshFlwRcnlnBndlItem CashFlowReconciliationBundle Reconciliation Bundle

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_FcstCshFlwWthRcnlnPrfl.
-- 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 P_FcstCshFlwWthRcnlnPrfl AS
SELECT
  RecnclnCashFlowBasic.OriginSystem AS OriginSystem,
  RecnclnCashFlowBasic.OriginApplication AS OriginApplication,
  RecnclnCashFlowBasic.OriginDocument AS OriginDocument,
  RecnclnCashFlowBasic.OriginTransaction AS OriginTransaction,
  RecnclnCashFlowBasic.OriginTransactionQualifier AS OriginTransactionQualifier,
  RecnclnCashFlowBasic.CashFlow AS CashFlow,
  PlngLvlAssgmt.CashFlowReconciliationProfile AS CashFlowReconciliationProfile,
  CashFlowRcnlnPrfl.CashFlowReconciliationStrategy AS CashFlowReconciliationStrategy,
  RecnclnCashFlowBasic.CertaintyLevel AS CertaintyLevel,
  RecnclnCashFlowBasic.LiquidityItem AS LiquidityItem,
  RecnclnCashFlowBasic.DocumentItemText AS DocumentItemText,
  RecnclnCashFlowBasic.TransactionDate AS TransactionDate,
  RecnclnCashFlowBasic.BankAccountInternalID AS BankAccountInternalID,
  RecnclnCashFlowBasic.CompanyCode AS CompanyCode,
  RecnclnCashFlowBasic.PlanningLevel AS PlanningLevel,
  RecnclnCashFlowBasic.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  RecnclnCashFlowBasic.TransactionCurrency AS TransactionCurrency,
  RecnclnCashFlowBasic.AccountingDocument AS AccountingDocument,
  RecnclnCashFlowBasic.AccountingDocumentItem AS AccountingDocumentItem,
  RecnclnCashFlowBasic.AccountingDocumentType AS AccountingDocumentType,
  RecnclnCashFlowBasic.FinancialAccountType AS FinancialAccountType,
  RecnclnCashFlowBasic.Supplier AS Supplier,
  RecnclnCashFlowBasic.Customer AS Customer,
  CshFlwRcnlnBndlItem.CashFlowReconciliationBundle AS CashFlowReconciliationBundle
FROM P_RecnclnCashFlowBasic AS RecnclnCashFlowBasic
INNER JOIN I_CshFlwRcnlnPrflPlngLvlAssgmt AS PlngLvlAssgmt ON /* join condition not captured in parsed metadata */
INNER JOIN I_CashFlowRcnlnPrfl AS CashFlowRcnlnPrfl ON /* join condition not captured in parsed metadata */
;

Learn More