C_FinStmntCashFlowItemQuery

Cash Flow Statements for ACR - Query | view: CFS_ITEM_CF_Q | Extraction: Not supported | Component: Localization Financials (generic parts)
Tables used: SCAL_TT_DATE, FIRUD_FSTM_RPICF, ACDOCA, BKPF, BSEG, PRPS, T001, T014, FIRUC_CF_ITEM, FINSC_LEDGER_REP
Column Name Description
FinancialStatementLeafItem Hierarchy node
StatryRptgEntity Reporting Entity
StatryRptCategory Report Category ID
StatryRptRunID Report Run ID
CashFlowStatementHierVersion Cash Flow Statement Version
CompanyCode Company Code
AccountingDocument Journal Entry
LedgerGLLineItem Six-Character Posting Item for Ledger
FiscalYear Fiscal Year
ClearedInvoiceNumber Cleared Invoice Number
ClearedInvoiceYear Invoice Year
Column Name Description
💲 Currency Key (Currency):
PeriodBalAmtInDspCrcy Period Balance Amount
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
JrnlEntryCntrySpecificDate4 Payment Order Date
Column Name Description
CashFlowStmntReportingPeriod Reporting Period Code for Cash Flow Statement Show values
ItemType Cash Flow Statement Item Type Show values
FinancialStmntCashFlowItemMode Cash Flow Statement Item Calculation Mode Show values
ItemSignIsReversed Change Item Sign in Reporting Show values
ItemIsHiddenInReporting Cash Flow Statement Item Hide in Reporting Show values
FinancialStatementFormType Financial Statement Form Type Show values
Column Name Description Domain name
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
AssignmentReference Assignment Reference ZUONR
AccountingDocumentItem Journal Entry Posting View Item BUZEI
CommitmentItem Commitment Item FM_FIPEX
FiscalPeriod Fiscal Period POPER
ParentItem Cash Flow Statement Parent Item CHAR10
DocumentReferenceID Document Reference ID XBLNR1
AccountingDocumentHeaderText Document Header Text TEXT25
JrnlEntryCntrySpecificRef4 Payment Order Number CHAR30
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == T003.MANDT
Alternative G/L Account Number In Company Code
  • Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • C_FINSTMNTCASHFLOWITEMQUERY.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == SKA1.MANDT
Asset Class
  • Asset Class
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.ASSETCLASS == ANKA.ANLKL
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == ANKA.MANDT
Business Area
  • Business Area
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.BUSINESSAREA == TGSB.GSBER
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.CHARTOFACCOUNTS == T004.KTOPL
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == T004.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.CONTROLLINGAREA == TKA01.KOKRS
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • ?
  • Controlling Area
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.COSTCENTER == CSKS.KOSTL
  • C_FINSTMNTCASHFLOWITEMQUERY.[column in domain "DATBI"] == CSKS.DATBI
  • C_FINSTMNTCASHFLOWITEMQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == CSKS.MANDT
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.CUSTOMER == KNA1.KUNNR
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == KNA1.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == FM01.MANDT
Asset Subnumber
  • Fixed Asset
  • Asset Subnumber
  • ?
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.MASTERFIXEDASSET == ANLA.ANLN1
  • C_FINSTMNTCASHFLOWITEMQUERY.FIXEDASSET == ANLA.ANLN2
  • C_FINSTMNTCASHFLOWITEMQUERY.[column in domain "BUKRS"] == ANLA.BUKRS
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == ANLA.MANDT
Functional Area
  • Functional Area
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.FUNCTIONALAREA == TFKB.FKBER
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == TFKB.MANDT
Funds Management Center
  • ?
  • Financial Management Area
  • Funds Management Center
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • C_FINSTMNTCASHFLOWITEMQUERY.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • C_FINSTMNTCASHFLOWITEMQUERY.FUNDSCENTER == FMFCTR.FICTR
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == FMFCTR.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.SOURCECOMPANYCODE == SKB1.BUKRS
  • C_FINSTMNTCASHFLOWITEMQUERY.GLACCOUNT == SKB1.SAKNR
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == SKB1.MANDT
Inventory Valuation Type
  • Inventory Valuation Type
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == T149D.MANDT
Material Number
  • Material Number
  • Product Number
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.MATERIAL == MARA.MATNR
  • C_FINSTMNTCASHFLOWITEMQUERY.PRODUCT == MARA.MATNR
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == MARA.MANDT
Plant
  • Plant
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.PLANT == T001W.WERKS
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == T001W.MANDT
Product Number
  • Material Number
  • Product Number
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.MATERIAL == MARA.MATNR
  • C_FINSTMNTCASHFLOWITEMQUERY.PRODUCT == MARA.MATNR
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == MARA.MANDT
Profit Center
  • ?
  • Profit Center
  • Controlling Area
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.[column in domain "DATBI"] == CEPC.DATBI
  • C_FINSTMNTCASHFLOWITEMQUERY.PROFITCENTER == CEPC.PRCTR
  • C_FINSTMNTCASHFLOWITEMQUERY.CONTROLLINGAREA == CEPC.KOKRS
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == FAGL_SEGM.MANDT
  • C_FINSTMNTCASHFLOWITEMQUERY.SEGMENT == FAGL_SEGM.SEGMENT
Company Code
  • Company Code
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.SOURCECOMPANYCODE == T001.BUKRS
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == T001.MANDT
Supplier
  • Supplier
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.SUPPLIER == LFA1.LIFNR
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == LFA1.MANDT
Valuation area
  • Valuation area
  • Client
  • C_FINSTMNTCASHFLOWITEMQUERY.VALUATIONAREA == T001K.BWKEY
  • C_FINSTMNTCASHFLOWITEMQUERY.MANDT == T001K.MANDT