How to create a fiori KPI tile showing equity ratio?

[Former Member]

Hi everybody,

since one week I have been trying to display the equity ratio in a fiori tile.

What I want:

I want to display the equity ratio in a fiori tile.

Starting position:

I have a running system with standard apps.

What I have already tried:

Since I don't know which path exactely to go, I have tried two ways. #1: Creating the tile with the query browser and #2: creating a tile with my own cds view and odata service.

1: In the Query Browser

I have searched whether there is an existing analytical view which contains something usefull. When I search for 'equity' in the Query browser I get views like C_DOCUMENTJOURNALQ0001 where the only useful columns I find is "JOINTVENTUREEQUITYTYPE" and "JOINTVENTUREEQUITYGROUP".

2: Creating CDS View and Odata service

I tried to create my own CDS view and OData service. The very first problem I face is that I don't know how to extract the equity (or private equity) and total equity from a table. I don't know which table I find it.