R_FCSTCSHFLWWTHRCNLNPRFL

CDS View

Forecast Flow

R_FCSTCSHFLWWTHRCNLNPRFL is a CDS View in S/4HANA. Forecast Flow. It contains 24 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_FcstCshFlwWthRcnlnPrfl view_entity from CONSUMPTION Forecast Flow
R_FcstCshFlwWthRcnlnBndl view_entity from COMPOSITE Bank Statement Flow

Fields (24)

KeyField CDS FieldsUsed in Views
KEY CashFlow CashFlow 2
KEY CashFlowReconciliationProfile CashFlowReconciliationProfile 2
KEY CashFlowReconciliationStrategy CashFlowReconciliationStrategy 2
KEY ExchangeRateType ExchangeRateType 2
KEY OriginApplication OriginApplication 2
KEY OriginDocument OriginDocument 2
KEY OriginSystem OriginSystem 2
KEY OriginTransaction OriginTransaction 2
KEY OriginTransactionQualifier OriginTransactionQualifier 2
AmountInBankAccountCurrency AmountInBankAccountCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 2
BankAccountCurrency BankAccountCurrency 1
BankAccountInternalID BankAccountInternalID 2
CashFlowReconciliationBundle CashFlowReconciliationBundle 2
CertaintyLevel CertaintyLevel 2
CompanyCode CompanyCode 1
Customer Customer 2
DocumentItemText DocumentItemText 2
LiquidityItem LiquidityItem 1
OriginDocumentValue OriginDocumentValue 2
PlanningLevel PlanningLevel 2
Supplier Supplier 2
TransactionCurrency TransactionCurrency 2
TransactionDate TransactionDate 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Forecast Flow
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_FCSTCSHFLWWTHRCNLNPRFL (
    CASHFLOW,
    CASHFLOWRECONCILIATIONPROFILE,
    CASHFLOWRECONCILIATIONSTRATEGY,
    EXCHANGERATETYPE,
    ORIGINAPPLICATION,
    ORIGINDOCUMENT,
    ORIGINSYSTEM,
    ORIGINTRANSACTION,
    ORIGINTRANSACTIONQUALIFIER,
    AMOUNTINBANKACCOUNTCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BANKACCOUNTCURRENCY,
    BANKACCOUNTINTERNALID,
    CASHFLOWRECONCILIATIONBUNDLE,
    CERTAINTYLEVEL,
    COMPANYCODE,
    CUSTOMER,
    DOCUMENTITEMTEXT,
    LIQUIDITYITEM,
    ORIGINDOCUMENTVALUE,
    PLANNINGLEVEL,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    TRANSACTIONDATE,
    PRIMARY KEY (CASHFLOW, CASHFLOWRECONCILIATIONPROFILE, CASHFLOWRECONCILIATIONSTRATEGY, EXCHANGERATETYPE, ORIGINAPPLICATION, ORIGINDOCUMENT, ORIGINSYSTEM, ORIGINTRANSACTION, ORIGINTRANSACTIONQUALIFIER)
);