Skip to Content

S/4HANA Cloud Data Model

Hi All,

I have to create quite a few Custom CDS views and Custom Analytical Queries for reporting purposes but find it hard to find where (CDS views) the data I see at the "front-end" actually resides in the "back-end".

For example, if I wanted to create a Custom CDS view that joins Project data with Transactions data, how would I know which out of the box CDS views to use and join together? Is there perhaps a data model somewhere out there? That would make my life alot easier!!

Help would be greatly appreciated

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 28 at 06:39 AM

    I have come to realise that no such thing as a "data model" exists for SAP S/4HANA Cloud.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 24 at 07:32 AM

    Hi Nem,

    Details about the SAP S/4HANA Cloud virtual data model can be found here:

    https://help.sap.com/viewer/788fa4c7585e415187e347e904010cee/latest/en-US/8573b810511948c8a99c0672abc159aa.html

    Besides, the app View Browser is helpful to search, browse and navigate within CDS views:

    https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('F2170')/S13OP

    Best, mathias

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Mathias,

      thank you kindly for your answer!

      I have taken a look at the Virtual Data Model but unless I missed it, I am not sure how this can help me. I am after a data model like the example below:

      http://www.databaseanswers.org/data_models/enterprise_data_model_for_retail/images/retail_logical_model.gif

      I was aware of the View Browser and have used it before but to me it is kind of like "blindly" poking around. We are currently using Dynamics AX 2012 R2 and the business had made the decision to move to SAP S/4HANA Cloud.

      In AX for example I can look at something (say Project Name) and right click on it and select "Personalise" and it would actually tell me the table where it is pulling the Project Name from. Hopefully you can see how useful this is in understanding the back-end data from within the front-end.

      Does S/4HANA Cloud have something similar to AX?

      many thanks!