C_CashFlowItem

Column Name Description
OriginSystem Logical system
OriginApplication Source Application Show values
OriginDocument Source Document ID
OriginTransaction Source Transaction ID
OriginTransactionQualifier Source Transaction Qualifier
CashFlow Line Item in Source Document
CashFlowScopeForAccounting Cash Flow Scope for Accounting Show values
Column Name Description
💲 Currency (TransactionCurrency):
AmountInTransactionCurrency Transaction Amount
💲 Currency Key (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Transaction Amount
💲 Bank Account Currency (BankAccountCurrency):
AmountInBankAccountCurrency Amount in Bank Account Currency
💲 Currency of Promise to Pay (PromiseToPayCurrency):
PromisedAmount Amount Promised for Payment
Column Name Description
Column Name Description
TransactionDate Value date
PostingDate Posting Date in the Document
DocumentDate Journal Entry Date
PaymentRunDate Date on Which the Program Is to Be Run
LastPaymentDate Date of Last Payment
Column Name Description
OriginApplication Source Application Show values
CashFlowScopeForAccounting Cash Flow Scope for Accounting Show values
CertaintyLevel Certainty Level Show values
CashReleaseStatus Release Status Show values
FinancialAccountType Account type Show values
DirectDebitPreNotification Direct Debit Pre-Notification Show values
PromiseToPayStatus State of Promise to Pay Show values
PaymentBatchUrgency Urgent Payment Show values
CashFlowItemIsChanged Checkbox Show values
CashFlowDirection Cash Flow Direction Show values
ReconciliationDspStatus Reconcliation Status for UI display Show values
Column Name Description Domain name
CashFlowID Flow ID FQM_ID
CashFlowSnapshotValue null
ValidFrom UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
ValidTo UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
OriginTransactionValue Source Transaction ID FQM_ORIGIN_TRANS_ID
OriginFlowID Line Item in Source Document FQM_ORIGIN_FLOW_ID
OriginDocumentValue Origin Document ID FQM_ORIGIN_DOC_ID
CreatedByUser Created By XUBNAME
CreatedByUserDescription User Description SUIDTECHDESC
CreationDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
LastChangedByUser Last Changed By USNAM
LastChangedByUserFullName User Description SUIDTECHDESC
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
CashTransactionOwner Owner of a Business Transaction FQM_OWNER
CompanyCode Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
AccountingDocument Journal Entry BELNR
AccountingDocumentItem Number of Line Item Within Accounting Document
FiscalYear Fiscal Year GJAHR
AccountingDocumentType Document Type BLART
PaymentMethod Payment Method ZLSCH
GLAccount General Ledger Account SAKNR
DocumentItemText Item Text TEXT50
FiscalPeriod Fiscal Period
AccountingDocumentHeaderText Document Header Text TEXT25
CashPlanningGroup Planning Group FDGRP
CashPlanningGroupDescription Planning Group Long Text TEXT30
PlanningLevel Planning Level FDLEV
PlanningLevelName Planning Level Short Text TEXT10
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
BankAccountInternalID Bank Account Technical ID NUM10
BankAccountNumber Bank Account Number FCLM_BAM_ACC_NUM
SWIFTCode SWIFT/BIC for International Payments SWIFT
BankName Name of Financial Institution TEXT60
BankAccountDescription Account Description TEXT60
IBAN IBAN (International Bank Account Number) IBAN
Customer Customer Number KUNNR
Supplier Account Number of Supplier LIFNR
BusinessPartner Business Partner Number BU_PARTNER
Material Material Number MATNR
BusinessArea Business Area GSBER
ProfitCenter Profit Center PRCTR
WBSElementInternalID WBS Element PS_S4_PSPNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
PartnerCompany Company ID of Trading Partner RCOMP
CostCenter Cost Center KOSTL
Segment Segment for Segmental Reporting FB_SEGMENT
LiquidityItem Liquidity Item FLQPOS
LiquidityItemDescription Liquidity Item: Description TEXT60
SourceCompanyCode Company Code BUKRS
FinancialInstrumentProductType Product Type VVSART
FinancialTransactionType Financial Transaction Type T_SFHAART
SecurityClass Security Class ID Number WP_RANL
SecurityAccount Securities Account RLDEPO
AssetContract Contract Number CHAR13
Portfolio Portfolio RPORTB
BankStatementShortID Short Key for Bank Statement (Surrogate Key)
BankStatementItem Memo record number (line item number in bank statement)
PaymentRunID Additional Identification LAUFI
NumberOfInstallments Number of Installments in the Promise to Pay in Installments INT4
PromiseToPayLevel Level of Promise to Pay INT1
PromiseToPayGivenByPersonName Clerk That Gave the Promise to Pay TEXT40
PaymentBatch Batch Identification Number BNK_COM_BATCH_NO
PaymentBatchItem Item Count Number BNK_COM_CTR
PaymentBatchStatusText Object status TEXT30
PaymentBatchItemStatusText Object status TEXT30
Master Data Relations Join Conditions
Bank Key
  • Bank Key
  • Bank Country/Region Key
  • Client
  • C_CASHFLOWITEM.BANK == BNKA.BANKL
  • C_CASHFLOWITEM.BANKCOUNTRY == BNKA.BANKS
  • C_CASHFLOWITEM.MANDT == BNKA.MANDT
Bank Account Type ID
  • Bank Account Type ID
  • Client
Bank Country/Region Key
  • Bank Country/Region Key
  • Client
  • C_CASHFLOWITEM.BANKCOUNTRY == T005.LAND1
  • C_CASHFLOWITEM.MANDT == T005.MANDT
Balance Calculation Profile Name
  • ?
  • Balance Calculation Profile Name
  • Client
System status
  • System status
  • System status
  • C_CASHFLOWITEM.PAYMENTBATCHSTATUS == TJ02.ISTAT
  • C_CASHFLOWITEM.PAYMENTBATCHITEMSTATUS == TJ02.ISTAT
System status
  • System status
  • System status
  • C_CASHFLOWITEM.PAYMENTBATCHSTATUS == TJ02.ISTAT
  • C_CASHFLOWITEM.PAYMENTBATCHITEMSTATUS == TJ02.ISTAT