What is C_CshFlwIndrctBsdOnAcctType in SAP S/4HANA?

C_CshFlwIndrctBsdOnAcctType is a consumption CDS view in SAP S/4HANA. Cash Flow Statement with Net Income from G/L Account Type It contains 62 fields.

Which tables does C_CshFlwIndrctBsdOnAcctType read from?

C_CshFlwIndrctBsdOnAcctType reads data from: I_GLAccountLineItemSemTag.

What VDM layer is C_CshFlwIndrctBsdOnAcctType?

C_CshFlwIndrctBsdOnAcctType is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CshFlwIndrctBsdOnAcctType

DDL: C_CSHFLWINDRCTBSDONACCTTYPE SQL: CFICSHFLINDGL Type: view CONSUMPTION

62 Fields 1 Data Sources

Cash Flow Statement with Net Income from G/L Account Type

C_CshFlwIndrctBsdOnAcctType (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

C_CshFlwIndrctBsdOnAcctType is a Consumption CDS View that provides data about "Cash Flow Statement with Net Income from G/L Account Type" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItemSemTag) and exposes 62 fields with key fields GLAccountHierarchy, CompanyCode, LedgerFiscalYear, Ledger.

SAP Help Documentation

Category	CDS Views for Master Data
Data Category	Query

Purpose
This CDS view is designed to generate a cash flow statement using the indirect method, based on general ledger account types. It provides a detailed breakdown of cash flows from operating, investing, and financing activities, along with adjustments for non-cash transactions and changes in assets and liabilities. This CDS view provides the data to answer the following business questions: What is the cash flow from operating activities, including net income and adjustments for non-cash transactions? How do changes in assets and liabilities affect the cash flow from operating activities? What is the cash flow from investing activities, including purchases and sales of fixed and intangible assets? How do long-term investments impact the cash flow from investing activities? What is the cash flow from financing activities, including changes in common stocks and borrowings? What is the net cash flow for the period, combining operating, investing, and financing activities? How does the net cash flow compare to the cash and cash equivalents at the end of the period for validation purposes? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view need to access it via another CDS view (privileged mode).

Structure
Parameters The parameters of the CDS view are as follows: Parameter Name Label P_ToFiscalPeriod To Fiscal Period P_FromFiscalPeriod From Fiscal Period Fields Used for Filtering The main filters are as follows: Field Name Label GLAccountHierarchy Financial Statement Version CompanyCode Company Code LedgerFiscalYear Fiscal Year of Ledger Ledger Ledger Important Fields Important fields in this view include the following: Field Name Label GLAccountHierarchy Financial Statement Version CompanyCode Company Code LedgerFiscalYear Fiscal Year of Ledger Ledger Ledger AssetAccountingKeyFigure Asset Accounting Key Figure FiscalPeriod Fiscal Period FiscalQuarter Fiscal Quarter DebitCreditCode Debit/Credit Code AssetTransactionType Asset Transaction Type FinancialTransactionType Financial Transaction Type AccountingDocumentType Journal Entry Type SemanticTag Semantic Tag GLAccount G/L Account FunctionalArea Functional Area CostCenter Cost Center ProfitCenter Profit Center AccountingDocument Journal Entry PostingDate Posting Date Segment Segment BusinessArea Business Area CompanyCodeCurrency Company Code Currency AmountInCompanyCodeCurrency Amount in Company Code Currency CashFlowAmount Cash Flow Statement (Indirect Method) OperatingCashFlowAmount Cash flow from Operating Activities GLAcctNetIncomeAmtInCCCrcy Profit for the period IncomeAdjustmentAmount Adjustments for income and expenses not involving cashflows OpgTngblAssetDeprAmtInCCCrcy Depreciation of property, plant and equipment OpgIntngblAstAmtznAmtInCCCrcy Amortization of intangible assets OpgFxdAstRtrmtAmtInCCCrcy Gain/Loss from fixed asset retirement AssetLiabilityAmount Changes in assets and liabilities ProvisionAmtInCCCrcy Increase (Decrease) of provisions InventoryAmtInCCCrcy Increase (Decrease) of inventories AcctsRblAmtInCCCrcy Increase (Decrease) in accounts receivables (net) AcctsOthRblAmtInCCCrcy Increase (Decrease) in other receivables (net) AcctsPyblAmtInCCCrcy Increase (Decrease) in accounts payables AcctsOthPyblAmtInCCCrcy Increase (Decrease) in other payables OperatingActyCashAmtInCCCrcy Net cash generated from continuing operating activities InvestingCashFlowAmount Cash Flow from Investing Activities FixedAssetAmount Purchase (Sale) of fixed assets TangibleAssetAmount Purchase (Sale) of tangible assets TangibleAst

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-GL-IS
Capabilities	Analytical Query
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_GLAccountLineItemSemTag	I_GLAccountLineItemSemTag	from

Parameters (2)

Name	Type	Default
P_FromFiscalPeriod	fins_fagl_fiscper_from
P_ToFiscalPeriod	fins_fagl_fiscper_to

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	CFICSHFLINDGL	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Cash Flow Statement with Net Income from G/L Account Type	view
VDM.viewType	#CONSUMPTION	view
Analytics.query	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.modelingPattern	#ANALYTICAL_QUERY	view
ObjectModel.supportedCapabilities	#ANALYTICAL_QUERY	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view

Fields (62)

Key	Field	Source Field	Description
KEY	GLAccountHierarchy	GLAccountHierarchy	Financial Statement Version
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	LedgerFiscalYear	LedgerFiscalYear	Fiscal Year of Ledger
KEY	Ledger	Ledger	Ledger in General Ledger Accounting
	AssetAccountingKeyFigure	AssetAccountingKeyFigure	Key Figure for Asset Accounting
	FiscalPeriod	FiscalPeriod	Fiscal Period
	FiscalQuarter	FiscalQuarter	Fiscal Quarter
	DebitCreditCode	DebitCreditCode	Single-Character Flag
	AssetTransactionType	AssetTransactionType	Asset Transaction Type
	FinancialTransactionType	FinancialTransactionType	Financial Transaction Type
	AccountingDocumentType	AccountingDocumentType	Journal Entry Type
	SemanticTag	SemanticTag	Semantic Tag of a Hierarchy Node
	GLAccount	GLAccount	General Ledger
	FunctionalArea	FunctionalArea	Sendr Fctl Area
	CostCenter	CostCenter	Cost Center
	ProfitCenter	ProfitCenter	Profit Center
	AccountingDocument	AccountingDocument	Journal Entry
	PostingDate	PostingDate	Posting Date for GR
	Segment	Segment	Segment for Segmental Reporting
	BusinessArea	BusinessArea	Business Area
	CompanyCodeCurrency	CompanyCodeCurrency	Company Code Currency
	AmountInCompanyCodeCurrency	AmountInCompanyCodeCurrency	Amount in Company Code Currency
	CashFlowAmount		Cash Flow Statement (Indirect Method)
	OperatingCashFlowAmount		Cash flow from Operating Activities
	GLAcctNetIncomeAmtInCCCrcy	GLAcctNetIncomeAmtInCCCrcy	Net Income Amount In Company Code Currency
	IncomeAdjustmentAmount		Adjustments for income and expenses not involving cashflows
	OpgTngblAssetDeprAmtInCCCrcy		Depreciation of property, plant and equipment
	OpgIntngblAstAmtznAmtInCCCrcy		Amortization of intangible assets
	OpgFxdAstRtrmtAmtInCCCrcy		Gain/Loss from fixed asset retirement
	AssetLiabilityAmount		Changes in assets and liabilities
	ProvisionAmtInCCCrcy		Increase (Decrease) of provisions
	InventoryAmtInCCCrcy		Increase (Decrease) of inventories
	AcctsRblAmtInCCCrcy		Increase (Decrease) in accounts receivables (net)
	AcctsOthRblAmtInCCCrcy		Increase (Decrease) in other receivables (net)
	AcctsPyblAmtInCCCrcy	AcctsPyblAmtInCCCrcy	Increase (Decrease) in Accounts Payable (Net)
	AcctsOthPyblAmtInCCCrcy	AcctsOthPyblAmtInCCCrcy	Increase (Decrease) in Accounts Other Payables (Net)
	InvestingCashFlowAmount		Cash Flow from Investing Activities
	FixedAssetAmount		Purchase (Sale) of fixed assets
	TangibleAssetAmount		Purchase (Sale) of tangible assets
	TangibleAstAmtInCCCrcy		Purchase (Sale) of tangible assets
	TangibleAstDeprAmtInCCCrcy	TangibleAstDeprAmtInCCCrcy	Depreciation of tangible assets
	IntangibleAssetAmount		Purchase (Sale) of intangible assets
	IntangibleAstAmtInCCCrcy		Purchase (Sale) of intangible assets
	IntngblAssetAmtznAmtInCCCrcy	IntngblAssetAmtznAmtInCCCrcy	Amortization of intangible assets
	InvstgFxdAstRtrmtAmtInCCCrcy	FixedAssetRtrmtAmtInCCCrcy	Gain/Loss from retirement of fixed assets
	LongTermInvmtAmtInCCCrcy		Increase (Decrease) in long-term investments
	InvestingActyCashAmtInCCCrcy	InvestingActyCashAmtInCCCrcy	Net cash used in continuing investing activities
	FinancingCashFlowAmount		Cash Flow from Financing Activities
	CommonStockAmtInCCCrcy	CommonStockAmtInCCCrcy	Increase (Decrease) in common stocks
	NotesReceivableAmtInCCCrcy	NotesReceivableAmtInCCCrcy	Increase (Decrease) in Notes Receivable
	FinancingActyCashAmtInCCCrcy	FinancingActyCashAmtInCCCrcy	Net cash generated from financing activities
	CashAndCashEqvlntAmtInCCCrcy	CashAndCashEqvlntAmtInCCCrcy	Change (Increase/ Decrease) in cash and cash equivalents
	CashValidationBalAmtInCCCrcy	0	Validation Balance
	ChartOfAccounts	ChartOfAccounts	Chart of Accounts
	FiscalYearVariant	FiscalYearVariant	Fiscal Year Variant
	FiscalYear	FiscalYear	G/L Fiscal Year
	ControllingArea	ControllingArea	Controlling Area
	_GLAccountInChartOfAccounts	_GLAccountInChartOfAccounts
	_FiscalYearVariant	_FiscalYearVariant
	_FiscalYear	_FiscalYear
	_ProfitCenter	_ProfitCenter
	_CostCenter	_CostCenter

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CshFlwIndrctBsdOnAcctType.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CFICSHFLINDGL
-- Parameters: P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to

CREATE VIEW C_CshFlwIndrctBsdOnAcctType AS
SELECT
  GLAccountHierarchy,
  CompanyCode,
  LedgerFiscalYear,
  Ledger,
  AssetAccountingKeyFigure,
  FiscalPeriod,
  FiscalQuarter,
  DebitCreditCode,
  AssetTransactionType,
  FinancialTransactionType,
  AccountingDocumentType,
  SemanticTag,
  GLAccount,
  FunctionalArea,
  CostCenter,
  ProfitCenter,
  AccountingDocument,
  PostingDate,
  Segment,
  BusinessArea,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS CashFlowAmount,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS OperatingCashFlowAmount,
  GLAcctNetIncomeAmtInCCCrcy,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS IncomeAdjustmentAmount,
  TangibleAstDeprAmtInCCCrcy * (-1) AS OpgTngblAssetDeprAmtInCCCrcy,
  IntngblAssetAmtznAmtInCCCrcy * (-1) AS OpgIntngblAstAmtznAmtInCCCrcy,
  FixedAssetRtrmtAmtInCCCrcy * (-1) AS OpgFxdAstRtrmtAmtInCCCrcy,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS AssetLiabilityAmount,
  ProvisionAmtInCCCrcy * (-1) AS ProvisionAmtInCCCrcy,
  InventoryAmtInCCCrcy * (-1) AS InventoryAmtInCCCrcy,
  AcctsRblAmtInCCCrcy * (-1) AS AcctsRblAmtInCCCrcy,
  AcctsOthRblAmtInCCCrcy * (-1) AS AcctsOthRblAmtInCCCrcy,
  AcctsPyblAmtInCCCrcy,
  AcctsOthPyblAmtInCCCrcy,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS InvestingCashFlowAmount,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS FixedAssetAmount,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS TangibleAssetAmount,
  TangibleAstAmtInCCCrcy * (-1) AS TangibleAstAmtInCCCrcy,
  TangibleAstDeprAmtInCCCrcy,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS IntangibleAssetAmount,
  IntangibleAstAmtInCCCrcy * (-1) AS IntangibleAstAmtInCCCrcy,
  IntngblAssetAmtznAmtInCCCrcy,
  FixedAssetRtrmtAmtInCCCrcy AS InvstgFxdAstRtrmtAmtInCCCrcy,
  LongTermInvmtAmtInCCCrcy * (-1) AS LongTermInvmtAmtInCCCrcy,
  InvestingActyCashAmtInCCCrcy,
  case when SemanticTag = '*' then AmountInCompanyCodeCurrency else 0 end AS FinancingCashFlowAmount,
  CommonStockAmtInCCCrcy,
  NotesReceivableAmtInCCCrcy,
  FinancingActyCashAmtInCCCrcy,
  CashAndCashEqvlntAmtInCCCrcy,
  0 AS CashValidationBalAmtInCCCrcy,
  ChartOfAccounts,
  FiscalYearVariant,
  FiscalYear,
  ControllingArea
FROM I_GLAccountLineItemSemTag
;

Depth:

C_CshFlwIndrctBsdOnAcctType view

I_GLAccountLineItemSemTag view