CDS Views related to Financial Reporting

To find all CDS views related to Financial Reporting in SAP S/4HANA, you can use several methods based on whether you're using SAP GUI, ADT (Eclipse), or Fiori.

---

1️⃣ Using SE16 (Table Browser)

You can search for CDS Views related to Finance by querying the metadata table DDLSOURCE:

Steps:

1. Go to SE16 or SE16N.
2. Enter Table Name: DDLSOURCE.
3. In the NAME field, use wildcard searches:
   • I_FIN_* → Standard CDS Views for Finance
   • I_GL_* → General Ledger CDS Views
   • I_AP_* → Accounts Payable
   • I_AR_* → Accounts Receivable
   • I_CO_* → Controlling
   • I_COPC_* → Product Costing
   • I_FSCM_* → Financial Supply Chain
   • C_* → Consumption Views (for reporting)
   • Z* → Custom CDS Views
4. Execute (F8) and get the list of views.

---

2️⃣ Using ADT (Eclipse - ABAP Development Tools)

If working in Eclipse with ADT, you can search for all finance-related CDS views:

Steps:

1. Open ABAP Development Tools (ADT) in Eclipse.
2. Press Ctrl + H (Search).
3. Choose ABAP Repository Search.
4. Enter I_FIN_* or C_FIN_* in the search box.
5. Execute and browse through the Data Definitions folder.

---

3️⃣ Using View Browser (Fiori App)

If your project uses SAP Fiori, the easiest way to find financial CDS views is via the View Browser app.

Steps:

1. Open Fiori Launchpad.
2. Search for the "View Browser" app.
3. Use filters to search for:
   • Category: Analytical
   • Name Contains: FIN, GL, AR, AP
   • Application Component: FIN-*
4. Review the available views and test them in Data Preview.

---

4️⃣ Using SQL Query (HANA Studio or SE38/SE80)

If you have access to the SAP HANA database, you can run a query to find all finance-related CDS views.

sql
SELECT name, sqlviewname, ddlname   FROM ddlsource   WHERE name LIKE 'I_FIN_%' OR name LIKE 'I_GL_%' OR name LIKE 'C_FIN_%'  ORDER BY name;  

This will return a list of all CDS views related to Finance.

---

5️⃣ Using TCode RSRT (BW Query Reporting)

If you're working with Embedded Analytics, you can use RSRT to find Financial CDS Views used in BW Queries.

Steps:

1. Open TCode RSRT.
2. Use F4 Help to find queries based on finance reporting needs.
3. Identify the CDS views underneath the queries.

---

📌 Key CDS Views for Financial Reporting in SAP S/4HANA

Category	CDS View Name	Description
General Ledger (GL)	I_GLAccountBalanceCube	GL Account Balances
	I_GLAccountLineItem	GL Line Items
Accounts Payable (AP)	I_APOpenItem	Open AP Items
	I_APClearedItem	Cleared AP Items
Accounts Receivable (AR)	I_AROpenItem	Open AR Items
	I_ARClearedItem	Cleared AR Items
Costing & Controlling (CO)	I_ActualCostLineItems	Cost Line Items
	I_CostCenterPlanActual	Cost Center Reporting
Profitability Analysis (COPA)	I_COPAActuals	COPA Actuals
Fixed Assets (FI-AA)	I_FixedAssetBalance	Fixed Asset Balances
Financial Documents	I_JournalEntryItem	Journal Entries
Tax Reporting	I_TaxReturnItem	Tax Return Data

---

Next Steps:

✅ If you need to extract data from these views, you can use SAP Analysis for Office, CDS Query Browser, or ABAP Reports.
✅ Let me know if you need help creating custom CDS Views for financial reporting in your project.