P_CashFlowForRcnlnPrfl

DDL: P_CASHFLOWFORRCNLNPRFL Type: view_entity COMPOSITE Package: FCLM_RCN_IMP
9 Fields 2 Data Sources

Cash Flow Amount by Reconciliation Strategy

P_CashFlowForRcnlnPrfl is a Composite CDS View that provides data about "Cash Flow Amount by Reconciliation Strategy" in SAP S/4HANA. It reads from 2 data sources (P_RecnclnCashFlowBasic, I_CashFlowRcnlnPrfl) and exposes 9 fields with key fields BankAccountInternalID, OriginApplication, CertaintyLevel, PlanningLevel, TransactionCurrency. Part of development package FCLM_RCN_IMP.

Data Sources (2)

SourceAliasJoin Type
P_RecnclnCashFlowBasic one_exposure from
I_CashFlowRcnlnPrfl recnclnprfl inner

Parameters (4)

NameTypeDefault
P_ValueDate sydate
P_ForecastStartDate sydate
P_ForecastEndDate sydate
P_CashFlowRcnlnPrfl fclm_rcn_profile

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 (9)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID P_RecnclnCashFlowBasic BankAccountInternalID Technical ID
KEY OriginApplication P_RecnclnCashFlowBasic OriginApplication Origin Application
KEY CertaintyLevel P_RecnclnCashFlowBasic CertaintyLevel
KEY PlanningLevel P_RecnclnCashFlowBasic PlanningLevel Planning Level
KEY TransactionCurrency P_RecnclnCashFlowBasic TransactionCurrency Transaction Currency
KEY CashFlowReconciliationResult bundle_item CashFlowReconciliationResult
KEY CashFlowReconciliationProfile I_CashFlowRcnlnPrfl CashFlowReconciliationProfile Reconciliation Profile
KEY CashFlowReconciliationStrategy I_CashFlowRcnlnPrfl CashFlowReconciliationStrategy Reconciliation Strategy
AmountInTransactionCurrency

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_CashFlowForRcnlnPrfl.
-- 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.
-- Parameters: P_ValueDate : sydate, P_ForecastStartDate : sydate, P_ForecastEndDate : sydate, P_CashFlowRcnlnPrfl : fclm_rcn_profile

CREATE VIEW P_CashFlowForRcnlnPrfl AS
SELECT
  one_exposure.BankAccountInternalID AS BankAccountInternalID,
  one_exposure.OriginApplication AS OriginApplication,
  one_exposure.CertaintyLevel AS CertaintyLevel,
  one_exposure.PlanningLevel AS PlanningLevel,
  one_exposure.TransactionCurrency AS TransactionCurrency,
  bundle_item.CashFlowReconciliationResult AS CashFlowReconciliationResult,
  recnclnprfl.CashFlowReconciliationProfile AS CashFlowReconciliationProfile,
  recnclnprfl.CashFlowReconciliationStrategy AS CashFlowReconciliationStrategy,
  sum(one_exposure.AmountInTransactionCurrency) AS AmountInTransactionCurrency
FROM P_RecnclnCashFlowBasic AS one_exposure
INNER JOIN I_CashFlowRcnlnPrfl AS recnclnprfl ON /* join condition not captured in parsed metadata */
;

Learn More