P_FORECASTBALANCE_90DAYS

DDL: P_FORECASTBALANCE_90DAYS SQL: PFCSBAL90 Type: view_entity COMPOSITE Package: FCLM_LA
8 Fields 2 Data Sources

Liquidity Forecast Balance in 90 Days

P_FORECASTBALANCE_90DAYS is a Composite CDS View that provides data about "Liquidity Forecast Balance in 90 Days" in SAP S/4HANA. It reads from 2 data sources (P_CASHFLOWFORECASTBAL, P_CashPositionCashFlow) and exposes 8 fields with key fields CompanyCode, TransactionDate, TransactionCurrency, TransactionDate, TransactionCurrency. Part of development package FCLM_LA.

Data Sources (2)

SourceAliasJoin Type
P_CASHFLOWFORECASTBAL P_CASHFLOWFORECASTBAL from
P_CashPositionCashFlow P_CashPositionCashFlow union

Parameters (2)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_CashPoolBalCalcPrfl prof_name

Annotations (8)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Liquidity Forecast Balance in 90 Days view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode _Flow CompanyCode Receiver Company Code
KEY TransactionDate _Flow TransactionDate Value Date
KEY TransactionCurrency _Flow TransactionCurrency Transaction Currency
P_KeyDate
CompanyCodeasCompanyCode
KEY TransactionDate Value Date
KEY TransactionCurrency _csflow TransactionCurrency Transaction Currency
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_FORECASTBALANCE_90DAYS.
-- 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: PFCSBAL90
-- Parameters: P_KeyDate : vdm_v_key_date, P_CashPoolBalCalcPrfl : prof_name

CREATE VIEW P_FORECASTBALANCE_90DAYS AS
SELECT
  _Flow.CompanyCode AS CompanyCode,
  _Flow.TransactionDate AS TransactionDate,
  _Flow.TransactionCurrency AS TransactionCurrency,
  sum(_Flow.AmountInTransactionCurrency) as AmountInTransactionCurrency AS P_KeyDate,
  sum(_csflow.AmountInTransactionCurrency) AS AmountInTransactionCurrency
FROM P_CASHFLOWFORECASTBAL
-- UNION with additional select branch(es): P_CashPositionCashFlow
;

Learn More