What is I_GroupReportingFSItem in SAP S/4HANA?

I_GroupReportingFSItem is a basic CDS view in SAP S/4HANA. Financial Statement Item It contains 13 fields.

Which tables does I_GroupReportingFSItem read from?

I_GroupReportingFSItem reads data from: fincs_fsitem.

What VDM layer is I_GroupReportingFSItem?

I_GroupReportingFSItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_GroupReportingFSItem

DDL: I_GROUPREPORTINGFSITEM Type: view BASIC

13 Fields 1 Data Sources 7 Associations

Financial Statement Item

I_GroupReportingFSItem (Basic)

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

Group Reporting

I_GroupReportingFSItem is a Basic CDS View (Dimension) that provides data about "Financial Statement Item" in SAP S/4HANA. It reads from 1 data source (fincs_fsitem) and exposes 13 fields with key fields ConsolidationChartOfAccounts, FinancialStatementItem. It has 7 associations to related views.

SAP API Hub

State	C1
Line of Business	Group Reporting
Application Component	FIN-CS-MD
Capabilities	Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select, Analytical Dimension
Package	Group Reporting for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides access to the master data for financial statement (FS) items in financial consolidation. </p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the consolidation chart of accounts of my FS items?</p></li> <li><p>Is a certain FS item a value item, totals item, or text item?</p></li> <li><p>Is a certain FS item used as an asset item, liability/equity item, income statement item, or statistical item?</p></li> <li><p>What is the debit/credit sign of my FS items?</p></li> <li><p>What are the subassignments for my FS items?</p></li> </ul>

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 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
fincs_fsitem	fincs_fsitem	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..*]	I_CnsldtnChartOfAccountsT	_ConsChartOfAccountsText	`$projection.ConsolidationChartOfAccounts = _ConsChartOfAccountsText.ConsolidationChartOfAccounts`
[0..*]	I_CnsldtnFinStmntItemText	_Text	`$projection.ConsolidationChartOfAccounts = _Text.ConsolidationChartOfAccounts and $projection.FinancialStatementItem = _Text.FinancialStatementItem`
[0..*]	I_CnsldtnFinStmntItemLongText	_LongText	`$projection.ConsolidationChartOfAccounts = _LongText.ConsolidationChartOfAccounts and $projection.FinancialStatementItem = _LongText.FinancialStatementItem`
[0..*]	I_GroupReportingFSItemHierNode	_FinStmntItmHierNode	`$projection.ConsolidationChartOfAccounts = _FinStmntItmHierNode.ConsolidationChartOfAccounts and $projection.FinancialStatementItem = _FinStmntItmHierNode.FinancialStatementItem`
[0..1]	I_CnsldtnFinStmntItemType	_FinStmntItmType	`$projection.FinancialStatementItemType = _FinStmntItmType.ConsolidationFSItemType`
[0..1]	I_BreakdownCategory	_BreakdownCat	`$projection.ConsolidationChartOfAccounts = _BreakdownCat.ConsolidationChartOfAccounts and $projection.BreakdownCategory = _BreakdownCat.BreakdownCategory`
[1..1]	I_CnsldtnChartOfAccounts	_ConsChartOfAccounts	`$projection.ConsolidationChartOfAccounts = _ConsChartOfAccounts.ConsolidationChartOfAccounts`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	ICCFSITEM	view
AbapCatalog.preserveKey	true	view
AbapCatalog.buffering.status	#ACTIVE	view
AbapCatalog.buffering.type	#FULL	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.representativeKey	FinancialStatementItem	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
Analytics.dataCategory	#DIMENSION	view
VDM.viewType	#BASIC	view
EndUserText.label	Financial Statement Item	view

Fields (13)

Key	Field	Source Field	Description
KEY	ConsolidationChartOfAccounts	itclg	Consolidation Chart of Accounts
KEY	FinancialStatementItem		Financial Statement Item
	FinancialStatementItemType	itclass	Financial Statement Item Type
	BreakdownCategory	itbrkdwn	Breakdown Category
	IsConsolidationItem	itcitem	Is Consolidation Item
	FinancialStatementItemIsBlkd	itblkd	Blocked for Posting
	_ConsChartOfAccounts	_ConsChartOfAccounts
	_FinStmntItmType	_FinStmntItmType
	_BreakdownCat	_BreakdownCat
	_FinStmntItmHierNode	_FinStmntItmHierNode
	_Text	_Text
	_LongText	_LongText
	_ConsChartOfAccountsText	_ConsChartOfAccountsText

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 I_GroupReportingFSItem.
-- 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.

CREATE VIEW I_GroupReportingFSItem AS
SELECT
  itclg AS ConsolidationChartOfAccounts,
  cast(item as fc_item preserving type ) AS FinancialStatementItem,
  itclass AS FinancialStatementItemType,
  itbrkdwn AS BreakdownCategory,
  itcitem AS IsConsolidationItem,
  itblkd AS FinancialStatementItemIsBlkd
FROM fincs_fsitem
LEFT OUTER JOIN I_CnsldtnChartOfAccountsT AS _ConsChartOfAccountsText ON ConsolidationChartOfAccounts = _ConsChartOfAccountsText.ConsolidationChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnFinStmntItemText AS _Text ON ConsolidationChartOfAccounts = _Text.ConsolidationChartOfAccounts AND FinancialStatementItem = _Text.FinancialStatementItem  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnFinStmntItemLongText AS _LongText ON ConsolidationChartOfAccounts = _LongText.ConsolidationChartOfAccounts AND FinancialStatementItem = _LongText.FinancialStatementItem  -- association [0..*]
LEFT OUTER JOIN I_GroupReportingFSItemHierNode AS _FinStmntItmHierNode ON ConsolidationChartOfAccounts = _FinStmntItmHierNode.ConsolidationChartOfAccounts AND FinancialStatementItem = _FinStmntItmHierNode.FinancialStatementItem  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnFinStmntItemType AS _FinStmntItmType ON FinancialStatementItemType = _FinStmntItmType.ConsolidationFSItemType  -- association [0..1]
LEFT OUTER JOIN I_BreakdownCategory AS _BreakdownCat ON ConsolidationChartOfAccounts = _BreakdownCat.ConsolidationChartOfAccounts AND BreakdownCategory = _BreakdownCat.BreakdownCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _ConsChartOfAccounts ON ConsolidationChartOfAccounts = _ConsChartOfAccounts.ConsolidationChartOfAccounts  -- association [1..1]
;

Depth:

I_GroupReportingFSItem view

fincs_fsitem