R_BKSTMNTCSHFLWWITHRCNLNPRFL

CDS View
23 Fields 2 CDS Views

Bank Statement Flow

R_BKSTMNTCSHFLWWITHRCNLNPRFL is a CDS View in S/4HANA. Bank Statement Flow. It contains 23 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_BkStmntCshFlwWithRcnlnPrfl view from CONSUMPTION Bank Statement Flow
R_BkStmntCshFlwWithRcnlnBndl view from COMPOSITE Bank Statement Flow

Fields (23)

KeyField CDS FieldsUsed in Views
KEY CashFlow CashFlow 2
KEY CashFlowReconciliationProfile CashFlowReconciliationProfile 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
BankStatementItem BankStatementItem 2
BankStatementShortID BankStatementShortID 2
CashFlowReconciliationBundle CashFlowReconciliationBundle 2
CertaintyLevel CertaintyLevel 2
CompanyCode CompanyCode 1
DocumentItemText DocumentItemText 2
LiquidityItem LiquidityItem 1
OriginDocumentValue OriginDocumentValue 1
PlanningLevel PlanningLevel 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.

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

Learn More