C_FcstCshFlwWthRcnlnPrfl

DDL: C_FCSTCSHFLWWTHRCNLNPRFL Type: view_entity CONSUMPTION Package: FCLM_RCN_IMP
32 Fields 1 Data Sources 7 Associations 1 OData Services

Forecast Flow

C_FcstCshFlwWthRcnlnPrfl is a Consumption CDS View that provides data about "Forecast Flow" in SAP S/4HANA. It reads from 1 data source (R_FcstCshFlwWthRcnlnPrfl) and exposes 32 fields with key fields OriginSystem, OriginApplication, OriginDocument, OriginTransaction, OriginTransactionQualifier. It has 7 associations to related views. It is exposed through 1 OData service (ASQL_F3418A). Part of development package FCLM_RCN_IMP.

Data Sources (1)

SourceAliasJoin Type
R_FcstCshFlwWthRcnlnPrfl ReconciliationForecastFlow from

Associations (7)

CardinalityTargetAliasCondition
[0..*] I_LiquidityItemText _LiquidityItemText $projection.LiquidityItem = _LiquidityItemText.LiquidityItem
[0..*] I_PlanningLevelText _PlanningLevelText $projection.PlanningLevel = _PlanningLevelText.PlanningLevel
[0..*] I_CertaintyLevelText _CertaintyLevelText $projection.CertaintyLevel = _CertaintyLevelText.CertaintyLevel
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..*] I_SourceApplicationText _SourceApplicationText $projection.OriginApplication = _SourceApplicationText.SourceApplication

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.private false view
Search.searchable true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Forecast Flow view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3418A ASQL_F3418A C2 NOT_RELEASED

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY OriginSystem R_FcstCshFlwWthRcnlnPrfl OriginSystem LogSys: Formula
KEY OriginApplication R_FcstCshFlwWthRcnlnPrfl OriginApplication Origin Application
KEY OriginDocument R_FcstCshFlwWthRcnlnPrfl OriginDocument
KEY OriginTransaction R_FcstCshFlwWthRcnlnPrfl OriginTransaction
KEY OriginTransactionQualifier R_FcstCshFlwWthRcnlnPrfl OriginTransactionQualifier
KEY CashFlow R_FcstCshFlwWthRcnlnPrfl CashFlow
KEY CashFlowReconciliationProfile R_FcstCshFlwWthRcnlnPrfl CashFlowReconciliationProfile
KEY CashFlowReconciliationStrategy R_FcstCshFlwWthRcnlnPrfl CashFlowReconciliationStrategy
KEY ExchangeRateType R_FcstCshFlwWthRcnlnPrfl ExchangeRateType Exch. Rate Type
SourceApplicationText
LiquidityItem R_FcstCshFlwWthRcnlnPrfl LiquidityItem Liquidity Item
BankAccountInternalID R_FcstCshFlwWthRcnlnPrfl BankAccountInternalID Technical ID
CompanyCode R_FcstCshFlwWthRcnlnPrfl CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
CashFlowReconciliationBundle R_FcstCshFlwWthRcnlnPrfl CashFlowReconciliationBundle Reconciliation Bundle
OriginDocumentValue R_FcstCshFlwWthRcnlnPrfl OriginDocumentValue
PlanningLevel R_FcstCshFlwWthRcnlnPrfl PlanningLevel Planning Level
AmountInBankAccountCurrency AmountInBankAccountCurrency
AmountInTransactionCurrency R_FcstCshFlwWthRcnlnPrfl AmountInTransactionCurrency Pt Crcy Amt
DocumentItemText R_FcstCshFlwWthRcnlnPrfl DocumentItemText Text
CertaintyLevel R_FcstCshFlwWthRcnlnPrfl CertaintyLevel
TransactionDate R_FcstCshFlwWthRcnlnPrfl TransactionDate Value Date
Supplier R_FcstCshFlwWthRcnlnPrfl Supplier Supplier
Customer R_FcstCshFlwWthRcnlnPrfl Customer Sold-to Party
TransactionCurrency R_FcstCshFlwWthRcnlnPrfl TransactionCurrency Transaction Currency
BankAccountCurrency R_FcstCshFlwWthRcnlnPrfl BankAccountCurrency Currency
CustomerName _Customer CustomerName Name of Customer
SupplierFullName _Supplier SupplierFullName
_LiquidityItemText _LiquidityItemText
_PlanningLevelText _PlanningLevelText
_CertaintyLevelText _CertaintyLevelText
_BankAccount _BankAccount

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_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 C_FcstCshFlwWthRcnlnPrfl AS
SELECT
  ReconciliationForecastFlow.OriginSystem AS OriginSystem,
  ReconciliationForecastFlow.OriginApplication AS OriginApplication,
  ReconciliationForecastFlow.OriginDocument AS OriginDocument,
  ReconciliationForecastFlow.OriginTransaction AS OriginTransaction,
  ReconciliationForecastFlow.OriginTransactionQualifier AS OriginTransactionQualifier,
  ReconciliationForecastFlow.CashFlow AS CashFlow,
  ReconciliationForecastFlow.CashFlowReconciliationProfile AS CashFlowReconciliationProfile,
  ReconciliationForecastFlow.CashFlowReconciliationStrategy AS CashFlowReconciliationStrategy,
  ReconciliationForecastFlow.ExchangeRateType AS ExchangeRateType,
  _SourceApplicationText[1:Language = $session.system_language].SourceApplicationText AS SourceApplicationText,
  ReconciliationForecastFlow.LiquidityItem AS LiquidityItem,
  ReconciliationForecastFlow.BankAccountInternalID AS BankAccountInternalID,
  ReconciliationForecastFlow.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ReconciliationForecastFlow.CashFlowReconciliationBundle AS CashFlowReconciliationBundle,
  ReconciliationForecastFlow.OriginDocumentValue AS OriginDocumentValue,
  ReconciliationForecastFlow.PlanningLevel AS PlanningLevel,
  AmountInBankAccountCurrency,
  ReconciliationForecastFlow.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  ReconciliationForecastFlow.DocumentItemText AS DocumentItemText,
  ReconciliationForecastFlow.CertaintyLevel AS CertaintyLevel,
  ReconciliationForecastFlow.TransactionDate AS TransactionDate,
  ReconciliationForecastFlow.Supplier AS Supplier,
  ReconciliationForecastFlow.Customer AS Customer,
  ReconciliationForecastFlow.TransactionCurrency AS TransactionCurrency,
  ReconciliationForecastFlow.BankAccountCurrency AS BankAccountCurrency,
  _Customer.CustomerName AS CustomerName,
  _Supplier.SupplierFullName AS SupplierFullName
FROM R_FcstCshFlwWthRcnlnPrfl AS ReconciliationForecastFlow
LEFT OUTER JOIN I_LiquidityItemText AS _LiquidityItemText ON LiquidityItem = _LiquidityItemText.LiquidityItem  -- association [0..*]
LEFT OUTER JOIN I_PlanningLevelText AS _PlanningLevelText ON PlanningLevel = _PlanningLevelText.PlanningLevel  -- association [0..*]
LEFT OUTER JOIN I_CertaintyLevelText AS _CertaintyLevelText ON CertaintyLevel = _CertaintyLevelText.CertaintyLevel  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SourceApplicationText AS _SourceApplicationText ON OriginApplication = _SourceApplicationText.SourceApplication  -- association [0..*]
;

Learn More