Standard CDS view for cumulative GL balances

[shyam_uthaman]

Hi All,

I am trying to find where the fiori App Display G/L Account Balances gets the cumulative Balances from. I know it can be in a CDS view or an embedded BW query but so far I have had no luck trying to find any back end model for it. The fiori app library just lists the ODATA service and quite honestly, I have no clue on how to use that to derive the back end model.

Can you please offer your suggestions here? I would like to re-use that measure from an existing model than having to calculate it all again.

Thanks,

Shyam

[Former Member · Accepted solution]

EntitySet is based on Entity types. Go to properties and double click on it like below.

[shilpabasavaraj]

Hi Shyam,

**You cannot get to know the backend data source from the fiori application(frontend). If you want to, then explore the OData in the backend.

When your odata service is FAC_GL_ACCOUNT_BALANCE_SRV, the OData built in the backend will be FAC_GL_ACCOUNT_BALANCE.

Go to SEGW->Select open project -> Give the Odata Name (FAC_GL_ACCOUNT_BALANCE) -> Enter. This will open the required OData in SAP Logon. Double click on the Entity Types where you will get the list of ABAP structures used for respective entity.

Regards,

Shilpa.

[shyam_uthaman]

Hi Shilpa,

Thanks for the update. This is good information. But now how do I know what the individual objects are?

For example, Inside this ODATA service, I see a row called GL_ACCOUNT_BALANCE.

Now how do I know what this object is? Is it a database view? An ABAP program? An alias for something else?

Double clicking on it doesn't navigate anywhere.

Regards,

Shyam

[shyam_uthaman]

Former Member Any thoughts?