P_CshFlwRcnlnBndlFcstCshFlw

DDL: P_CSHFLWRCNLNBNDLFCSTCSHFLW SQL: PBNDLFCSTFLW Type: view COMPOSITE
25 Fields 1 Data Sources

Forecast Cash Flow of Bundle

P_CshFlwRcnlnBndlFcstCshFlw is a Composite CDS View that provides data about "Forecast Cash Flow of Bundle" in SAP S/4HANA. It reads from 1 data source (I_CshFlwRcnlnBndlItem) and exposes 25 fields with key fields OriginSystem, OriginApplication, OriginDocument, OriginTransaction, OriginTransactionQualifier.

Data Sources (1)

SourceAliasJoin Type
I_CshFlwRcnlnBndlItem BundleItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PBNDLFCSTFLW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Forecast Cash Flow of Bundle view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY OriginSystem I_CshFlwRcnlnBndlItem OriginSystem LogSys: Formula
KEY OriginApplication I_CshFlwRcnlnBndlItem OriginApplication Origin Application
KEY OriginDocument I_CshFlwRcnlnBndlItem OriginDocument Source Doc. ID
KEY OriginTransaction I_CshFlwRcnlnBndlItem OriginTransaction Source Trans. ID
KEY OriginTransactionQualifier I_CshFlwRcnlnBndlItem OriginTransactionQualifier Trans. Qualifier
KEY CashFlow I_CshFlwRcnlnBndlItem CashFlow Source Flow ID
CashFlowReconciliationBundle I_CshFlwRcnlnBndlItem CashFlowReconciliationBundle Reconciliation Bundle
ValidFrom I_CshFlwRcnlnBndlItem ValidFrom Vers.Valid From
TransactionDate I_CshFlwRcnlnBndlItem TransactionDate Value Date
BankAccountInternalID I_CshFlwRcnlnBndlItem BankAccountInternalID Technical ID
PlanningLevel I_CshFlwRcnlnBndlItem PlanningLevel Planning Level
CertaintyLevel I_CshFlwRcnlnBndlItem CertaintyLevel Certainty Level
ExchangeRateType I_CshFlwRcnlnBndlItem ExchangeRateType Exch. Rate Type
AmountInTransactionCurrency I_CshFlwRcnlnBndlItem AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency I_CshFlwRcnlnBndlItem TransactionCurrency Transaction Currency
AmountInBankAccountCurrency I_CshFlwRcnlnBndlItem AmountInBankAccountCurrency Amount in Acct Crcy
BankAccountCurrency I_CshFlwRcnlnBndlItem BankAccountCurrency Currency
BankStatementItem I_CshFlwRcnlnBndlItem BankStatementItem Memo Record No.
BankStatementShortID I_CshFlwRcnlnBndlItem BankStatementShortID Statement Short Key
CashFlowReconciliationStrategy CashFlowReconciliationStrategy Reconciliation Strategy
CashFlowReconciliationResult CashFlowReconciliationResult Reconciliation Result
_BankAccountCurrency _BankAccountCurrency
_TransactionCurrency _TransactionCurrency
_BankAccount _BankAccount
_PlanningLevel _PlanningLevel

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_CshFlwRcnlnBndlFcstCshFlw.
-- 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: PBNDLFCSTFLW

CREATE VIEW P_CshFlwRcnlnBndlFcstCshFlw AS
SELECT
  BundleItem.OriginSystem AS OriginSystem,
  BundleItem.OriginApplication AS OriginApplication,
  BundleItem.OriginDocument AS OriginDocument,
  BundleItem.OriginTransaction AS OriginTransaction,
  BundleItem.OriginTransactionQualifier AS OriginTransactionQualifier,
  BundleItem.CashFlow AS CashFlow,
  BundleItem.CashFlowReconciliationBundle AS CashFlowReconciliationBundle,
  BundleItem.ValidFrom AS ValidFrom,
  BundleItem.TransactionDate AS TransactionDate,
  BundleItem.BankAccountInternalID AS BankAccountInternalID,
  BundleItem.PlanningLevel AS PlanningLevel,
  BundleItem.CertaintyLevel AS CertaintyLevel,
  BundleItem.ExchangeRateType AS ExchangeRateType,
  BundleItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  BundleItem.TransactionCurrency AS TransactionCurrency,
  BundleItem.AmountInBankAccountCurrency AS AmountInBankAccountCurrency,
  BundleItem.BankAccountCurrency AS BankAccountCurrency,
  BundleItem.BankStatementItem AS BankStatementItem,
  BundleItem.BankStatementShortID AS BankStatementShortID,
  CashFlowReconciliationStrategy,
  CashFlowReconciliationResult
FROM I_CshFlwRcnlnBndlItem AS BundleItem
;

Learn More