I_CSHFLWRCNLNBNDLITEM

CDS View

Bundle Item

I_CSHFLWRCNLNBNDLITEM is a CDS View in S/4HANA. Bundle Item. It contains 20 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_CashFlwRcnlnBndlItemAggrgn view from COMPOSITE Recncln Bundle Item Aggregation
P_CshFlwRcnlnBndlBkStmntFlw view from COMPOSITE Bank Statement Flow of Bundle
P_CshFlwRcnlnBndlFcstCshFlw view from COMPOSITE Forecast Cash Flow of Bundle
P_CshFlwRcnlnBndlWthRcnldAmt view from COMPOSITE Bundle with Reconciled Amount

Fields (20)

KeyField CDS FieldsUsed in Views
KEY BankAccountInternalID BankAccountInternalID 3
KEY CashFlow CashFlow 3
KEY CashFlowReconciliationBundle CashFlowReconciliationBundle 3
KEY CashFlowReconciliationResult CashFlowReconciliationResult 1
KEY OriginApplication OriginApplication 3
KEY OriginDocument OriginDocument 3
KEY OriginSystem OriginSystem 3
KEY OriginTransaction OriginTransaction 3
KEY OriginTransactionQualifier OriginTransactionQualifier 3
AmountInBankAccountCurrency AmountInBankAccountCurrency 2
AmountInTransactionCurrency AmountInTransactionCurrency 2
BankAccountCurrency BankAccountCurrency 3
BankStatementItem BankStatementItem 2
BankStatementShortID BankStatementShortID 2
CertaintyLevel CertaintyLevel 2
ExchangeRateType ExchangeRateType 2
PlanningLevel PlanningLevel 2
TransactionCurrency TransactionCurrency 2
TransactionDate TransactionDate 2
ValidFrom ValidFrom 3

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.

-- Bundle Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CSHFLWRCNLNBNDLITEM (
    BANKACCOUNTINTERNALID,
    CASHFLOW,
    CASHFLOWRECONCILIATIONBUNDLE,
    CASHFLOWRECONCILIATIONRESULT,
    ORIGINAPPLICATION,
    ORIGINDOCUMENT,
    ORIGINSYSTEM,
    ORIGINTRANSACTION,
    ORIGINTRANSACTIONQUALIFIER,
    AMOUNTINBANKACCOUNTCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BANKACCOUNTCURRENCY,
    BANKSTATEMENTITEM,
    BANKSTATEMENTSHORTID,
    CERTAINTYLEVEL,
    EXCHANGERATETYPE,
    PLANNINGLEVEL,
    TRANSACTIONCURRENCY,
    TRANSACTIONDATE,
    VALIDFROM,
    PRIMARY KEY (BANKACCOUNTINTERNALID, CASHFLOW, CASHFLOWRECONCILIATIONBUNDLE, CASHFLOWRECONCILIATIONRESULT, ORIGINAPPLICATION, ORIGINDOCUMENT, ORIGINSYSTEM, ORIGINTRANSACTION, ORIGINTRANSACTIONQUALIFIER)
);