P_RECNCLNCASHFLOWBASIC

CDS View
24 Fields 3 CDS Views

Basic view

P_RECNCLNCASHFLOWBASIC is a CDS View in S/4HANA. Basic view. It contains 24 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_BkStmntCshFlwWithRcnlnPrfl view_entity from COMPOSITE Bank Statement Flow with Reconciliation Profile
P_CashFlowForRcnlnPrfl view_entity from COMPOSITE Cash Flow Amount by Reconciliation Strategy
P_FcstCshFlwWthRcnlnPrfl view_entity from COMPOSITE Forecasted Flow with Reconciliation Profile

Fields (24)

KeyField CDS FieldsUsed in Views
KEY BankAccountInternalID BankAccountInternalID 3
KEY CashFlow CashFlow 2
KEY CertaintyLevel CertaintyLevel 3
KEY OriginApplication OriginApplication 3
KEY OriginDocument OriginDocument 2
KEY OriginSystem OriginSystem 2
KEY OriginTransaction OriginTransaction 2
KEY OriginTransactionQualifier OriginTransactionQualifier 2
KEY PlanningLevel PlanningLevel 3
KEY TransactionCurrency TransactionCurrency 3
AccountingDocument AccountingDocument 1
AccountingDocumentItem AccountingDocumentItem 1
AccountingDocumentType AccountingDocumentType 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 2
CompanyCode CompanyCode 2
CompanyCodeCurrency CompanyCodeCurrency 1
Customer Customer 1
DocumentItemText DocumentItemText 2
FinancialAccountType FinancialAccountType 1
LiquidityItem LiquidityItem 2
MemoRecord MemoRecord 1
Supplier Supplier 1
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.

-- Basic view
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RECNCLNCASHFLOWBASIC (
    BANKACCOUNTINTERNALID,
    CASHFLOW,
    CERTAINTYLEVEL,
    ORIGINAPPLICATION,
    ORIGINDOCUMENT,
    ORIGINSYSTEM,
    ORIGINTRANSACTION,
    ORIGINTRANSACTIONQUALIFIER,
    PLANNINGLEVEL,
    TRANSACTIONCURRENCY,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CUSTOMER,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    LIQUIDITYITEM,
    MEMORECORD,
    SUPPLIER,
    TRANSACTIONDATE,
    PRIMARY KEY (BANKACCOUNTINTERNALID, CASHFLOW, CERTAINTYLEVEL, ORIGINAPPLICATION, ORIGINDOCUMENT, ORIGINSYSTEM, ORIGINTRANSACTION, ORIGINTRANSACTIONQUALIFIER, PLANNINGLEVEL, TRANSACTIONCURRENCY)
);

Learn More