I_CASHFLOW

CDS View
55 Fields 24 CDS Views

Cash Flow

I_CASHFLOW is a CDS View in S/4HANA. Cash Flow. It contains 55 fields. 24 CDS views read from this table.

CDS Views using this table (24)

ViewTypeJoinVDMDescription
I_CashFlowCube view from COMPOSITE Cash Flow - Cube
I_CashFlowTrainingData view from COMPOSITE training data for DALI ML
I_FinCopItemCube view_entity from COMPOSITE Cop Item - Cube
I_LiquidityAnalysisCube view_entity from COMPOSITE Liquidity Analysis - Cube
I_PaymentByBank view from COMPOSITE Payment By Bank
I_RecmddLiquidityItem view from COMPOSITE Detect abnormal liquidity items
I_RelCashFlowMD view_entity from COMPOSITE Release Cash Flows
P_ActualCashFlow view from COMPOSITE Actual Flow for Past 90 days
P_Cashflow_Base view from COMPOSITE Cash Flow for Forecast
P_CashFlowWthRecnclnSts view from COMPOSITE Cash Flow with Reconciliation Status
P_CashPositionCashFlow view from COMPOSITE Cash Position Cash Flow
P_CashPositionFlow view from COMPOSITE Cash Position (SmartTemplate) Union
P_CN_CADECashWthItem view from COMPOSITE Cash flow with document item
P_CshPosFlow view from COMPOSITE Cash Position Flow
P_FORECASTBALANCECASHFLOW view_entity from COMPOSITE Forecast Balance Cash Flow
P_FORECASTFLOWCASHFLOWC view_entity from COMPOSITE Forecast Balance Cash Flow
P_Ftr_Fs_Fqm_Ds view_entity from BASIC Financial Status - FQM data source CDS
P_FTR_FS_FQM_DS2 view_entity from COMPOSITE Financial Status - FQM data source
P_LfoCashflow view from COMPOSITE cash flow
P_LqdyAnlysDspCrcy view_entity from COMPOSITE Liquidity Analysis with Display Currency
P_LQDYANLYSFLOW view_entity from COMPOSITE Liquidity Analysis with Display Currency
P_Sep_Cash_Flows view from BASIC Cash Flows on a Given Day
P_StRpCashFLowLqdyItemBase view from COMPOSITE Help view for cash flow
PActualForecastCashFlow view from Cash Flow

Fields (55)

KeyField CDS FieldsUsed in Views
KEY BankAccountInternalID BankAccountInternalID 11
KEY CashFlow CashFlow 11
KEY CertaintyLevel CertaintyLevel 12
KEY CompanyCode CompanyCode 18
KEY GLAccount GLAccount 7
KEY OriginApplication OriginApplication 11
KEY OriginDocument OriginDocument 11
KEY OriginSystem OriginSystem 9
KEY OriginTransaction OriginTransaction 11
KEY OriginTransactionQualifier OriginTransactionQualifier 10
KEY PlanningLevel PlanningLevel 12
KEY TransactionCurrency Currency,NominalCurrency,TransactionCurrency 14
KEY TransactionDate CalendarDay,TransactionDate 15
KEY ValidFrom ValidFrom 9
KEY ValidTo ValidTo 8
_BankAccount _BankAccount 2
_CashPlanningGroup _CashPlanningGroup 1
_CompanyCode _CompanyCode 2
_LiquidityItem _LiquidityItem 1
_PlanningLevel _PlanningLevel 1
AccountingDocument AccountingDocument,ReferenceDocument 6
AccountingDocumentItem AccountingDocumentItem 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
AmountInTransactionCurrency AmountInTransactionCurrency,BookValueAmtInPositionCurrency,NominalAmountInNominalCurrency 13
BankAccountCurrency BankAccountCurrency 3
BusinessArea BusinessArea 7
BusinessPartner BusinessPartner 7
CashFlowID CashFlowID 4
CashPlanningGroup CashPlanningGroup,PlanningGroup 7
CashReleaseStatus CashReleaseStatus 1
CompanyCodeCurrency CompanyCodeCurrency 3
CostCenter CostCenter 7
Customer Customer 4
DocumentItemText DocumentItemText 2
ExpirationDate ExpirationDate 3
FinancialAccountType FinancialAccountType 2
FinancialTransactionType FinancialTransactionType 2
FiscalYear FiscalYear 6
Fund Fund 2
GrantID GrantID 2
HouseBank HouseBank 9
HouseBankAccount HouseBankAccount 9
IsValid IsValid 1
LiquidityItem LiquidityItem 9
Material Material 3
PartnerCompany PartnerCompany,TradingPartner 5
PaymentMethod PaymentMethod 3
Portfolio Portfolio 2
ProfitCenter ProfitCenter 7
SecurityClass SecurityClass 1
Segment Segment 5
SourceCompanyCode AssignedCompanyCode,SourceCompanyCode 2
Supplier Supplier,Vendor 4
WBSElement WBSElement 2
WBSElementInternalID WBSElement,WBSElementInternalID 5

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.

-- Cash Flow
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CASHFLOW (
    BANKACCOUNTINTERNALID,
    CASHFLOW,
    CERTAINTYLEVEL,
    COMPANYCODE,
    GLACCOUNT,
    ORIGINAPPLICATION,
    ORIGINDOCUMENT,
    ORIGINSYSTEM,
    ORIGINTRANSACTION,
    ORIGINTRANSACTIONQUALIFIER,
    PLANNINGLEVEL,
    TRANSACTIONCURRENCY,
    TRANSACTIONDATE,
    VALIDFROM,
    VALIDTO,
    _BANKACCOUNT,
    _CASHPLANNINGGROUP,
    _COMPANYCODE,
    _LIQUIDITYITEM,
    _PLANNINGLEVEL,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BANKACCOUNTCURRENCY,
    BUSINESSAREA,
    BUSINESSPARTNER,
    CASHFLOWID,
    CASHPLANNINGGROUP,
    CASHRELEASESTATUS,
    COMPANYCODECURRENCY,
    COSTCENTER,
    CUSTOMER,
    DOCUMENTITEMTEXT,
    EXPIRATIONDATE,
    FINANCIALACCOUNTTYPE,
    FINANCIALTRANSACTIONTYPE,
    FISCALYEAR,
    FUND,
    GRANTID,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    ISVALID,
    LIQUIDITYITEM,
    MATERIAL,
    PARTNERCOMPANY,
    PAYMENTMETHOD,
    PORTFOLIO,
    PROFITCENTER,
    SECURITYCLASS,
    SEGMENT,
    SOURCECOMPANYCODE,
    SUPPLIER,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (BANKACCOUNTINTERNALID, CASHFLOW, CERTAINTYLEVEL, COMPANYCODE, GLACCOUNT, ORIGINAPPLICATION, ORIGINDOCUMENT, ORIGINSYSTEM, ORIGINTRANSACTION, ORIGINTRANSACTIONQUALIFIER, PLANNINGLEVEL, TRANSACTIONCURRENCY, TRANSACTIONDATE, VALIDFROM, VALIDTO)
);

Learn More