CASHFLOW

63 Fields

CASHFLOW is an SAP database table in S/4HANA. It contains 63 fields.

Fields (63)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CashFlow CashFlow 1
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 2
KEY GLAccountHierarchy GLAccountHierarchy 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY OriginApplication OriginApplication 1
KEY OriginDocument OriginDocument 1
KEY OriginSystem OriginSystem 1
KEY OriginTransaction OriginTransaction 1
KEY OriginTransactionQualifier OriginTransactionQualifier 1
KEY SemanticTag SemanticTag 1
KEY SourceLedger SourceLedger 1
KEY ValidityEndDate ValidityEndDate 1
KEY ValidityStartDate ValidityStartDate 1
_AccountingDocumentCategory _AccountingDocumentCategory 1
_AlternativeGLAccount _AlternativeGLAccount 1
_ChartOfAccounts _ChartOfAccounts 1
_CompanyCode _CompanyCode 1
_CountryChartOfAccounts _CountryChartOfAccounts 1
_FiscalYear _FiscalYear 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 1
_Hierarchy _Hierarchy 1
_JournalEntry _JournalEntry 1
_Ledger _Ledger 1
_SemanticTag _SemanticTag 1
_SourceLedger _SourceLedger 1
AccountingDocumentCategory AccountingDocumentCategory 1
AcctsOthPyblAmtInCCCrcy AcctsOthPyblAmtInCCCrcy 1
AcctsOthRblAmtInCCCrcy AcctsOthRblAmtInCCCrcy 1
AcctsPyblAmtInCCCrcy AcctsPyblAmtInCCCrcy 1
AcctsRblAmtInCCCrcy AcctsRblAmtInCCCrcy 1
ActualAmountInCompanyCodeCrcy AmountInCompanyCodeCurrency 1
ActualAmountInTransactionCrcy AmountInTransactionCurrency 1
AlternativeGLAccount AlternativeGLAccount 1
AmountInReportingCurrency AmountInReportingCurrency 1
CashAndCashEqvlntAmtInCCCrcy CashAndCashEqvlntAmtInCCCrcy 1
CashFlowDirection CashFlowDirection 1
ChartOfAccounts ChartOfAccounts 1
CommonStockAmtInCCCrcy CommonStockAmtInCCCrcy 1
CompanyCodeCurrency CompanyCodeCurrency 1
CountryChartOfAccounts CountryChartOfAccounts 1
FiscalPeriod FiscalPeriod 1
FiscalQuarter FiscalQuarter 1
FiscalYearPeriod FiscalYearPeriod 1
FixedAssetRtrmtAmtInCCCrcy FixedAssetRtrmtAmtInCCCrcy 1
GLAccount GLAccount 1
GLAcctNetIncomeAmtInCCCrcy GLAcctNetIncomeAmtInCCCrcy 1
IntangibleAstAmtInCCCrcy IntangibleAstAmtInCCCrcy 1
IntngblAssetAmtznAmtInCCCrcy IntngblAssetAmtznAmtInCCCrcy 1
InventoryAmtInCCCrcy InventoryAmtInCCCrcy 1
LedgerFiscalYear LedgerFiscalYear 1
LiquidityItemName LiquidityItemName 1
LongTermInvmtAmtInCCCrcy LongTermInvmtAmtInCCCrcy 1
NotesReceivableAmtInCCCrcy NotesReceivableAmtInCCCrcy 1
PnLResultAmtInCCCrcy PnLResultAmtInCCCrcy 1
ProvisionAmtInCCCrcy ProvisionAmtInCCCrcy 1
ReportingCurrency ReportingCurrency 1
TangibleAstAmtInCCCrcy TangibleAstAmtInCCCrcy 1
TangibleAstDeprAmtInCCCrcy TangibleAstDeprAmtInCCCrcy 1
TransactionCurrency TransactionCurrency 1
TransactionDate TransactionDate 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CASHFLOW (
    ACCOUNTINGDOCUMENT,
    CASHFLOW,
    COMPANYCODE,
    FISCALYEAR,
    GLACCOUNTHIERARCHY,
    LEDGER,
    LEDGERGLLINEITEM,
    ORIGINAPPLICATION,
    ORIGINDOCUMENT,
    ORIGINSYSTEM,
    ORIGINTRANSACTION,
    ORIGINTRANSACTIONQUALIFIER,
    SEMANTICTAG,
    SOURCELEDGER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    _ACCOUNTINGDOCUMENTCATEGORY,
    _ALTERNATIVEGLACCOUNT,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _COUNTRYCHARTOFACCOUNTS,
    _FISCALYEAR,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _HIERARCHY,
    _JOURNALENTRY,
    _LEDGER,
    _SEMANTICTAG,
    _SOURCELEDGER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCTSOTHPYBLAMTINCCCRCY,
    ACCTSOTHRBLAMTINCCCRCY,
    ACCTSPYBLAMTINCCCRCY,
    ACCTSRBLAMTINCCCRCY,
    ACTUALAMOUNTINCOMPANYCODECRCY,
    ACTUALAMOUNTINTRANSACTIONCRCY,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINREPORTINGCURRENCY,
    CASHANDCASHEQVLNTAMTINCCCRCY,
    CASHFLOWDIRECTION,
    CHARTOFACCOUNTS,
    COMMONSTOCKAMTINCCCRCY,
    COMPANYCODECURRENCY,
    COUNTRYCHARTOFACCOUNTS,
    FISCALPERIOD,
    FISCALQUARTER,
    FISCALYEARPERIOD,
    FIXEDASSETRTRMTAMTINCCCRCY,
    GLACCOUNT,
    GLACCTNETINCOMEAMTINCCCRCY,
    INTANGIBLEASTAMTINCCCRCY,
    INTNGBLASSETAMTZNAMTINCCCRCY,
    INVENTORYAMTINCCCRCY,
    LEDGERFISCALYEAR,
    LIQUIDITYITEMNAME,
    LONGTERMINVMTAMTINCCCRCY,
    NOTESRECEIVABLEAMTINCCCRCY,
    PNLRESULTAMTINCCCRCY,
    PROVISIONAMTINCCCRCY,
    REPORTINGCURRENCY,
    TANGIBLEASTAMTINCCCRCY,
    TANGIBLEASTDEPRAMTINCCCRCY,
    TRANSACTIONCURRENCY,
    TRANSACTIONDATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, CASHFLOW, COMPANYCODE, FISCALYEAR, GLACCOUNTHIERARCHY, LEDGER, LEDGERGLLINEITEM, ORIGINAPPLICATION, ORIGINDOCUMENT, ORIGINSYSTEM, ORIGINTRANSACTION, ORIGINTRANSACTIONQUALIFIER, SEMANTICTAG, SOURCELEDGER, VALIDITYENDDATE, VALIDITYSTARTDATE)
);

Learn More