Skip to Content

S4HANA Report - Custom CDS

According to the custom report need, we have to create custom CDS that contain several field from differents CDS.

  • Is there any official documentation to configure report form CDS?
  • Is there another tools beside CDS to develop custom report? Else if how to create custom CDS by script as we able dot his on HANA Studio ABAP SQL?
  • What kind of join / association that support custom CDS? Is there solution to create union CDS as multiprovider concept in SAP BW? Because we took the fields from several CDS into 1 custom CDS which give impact to the value of the latest CDS. The value were duplicated into all of the rows, so we did not get the actual value. Example as follow :

    I used 4 standard CDS, 2 of them are master CDS and the rest are transactional (the rows quite a lots rather than the header CDS).

    Regarding of that needs, I took the fields from 4 CDS into 1 custom CDS which give impact to the value of the latest CDS. The value were duplicated into all of the rows, so I didnt get the actual value.

    2018-09-26_18-09-26.jpgThis is the actual value of stock quantity of the original CDS (in Query view)

  • 2018-09-26_18-11-07.jpg

    That's the value when i already joined the field from the 4 CDS in Query view

    Add a comment
    10|10000 characters needed characters exceeded

    Related questions

    2 Answers

    • Best Answer
      Posted on Oct 22, 2018 at 10:46 AM

      You may need to add additional fields into your association to stop the duplication. Also we usually only join a couple of views and then check if they return the data as we expect.

      Add a comment
      10|10000 characters needed characters exceeded

    • Posted on Oct 22, 2018 at 08:56 AM

      Could it be a cardinality issue ?

      Add a comment
      10|10000 characters needed characters exceeded

    Before answering

    You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
    You must be Logged in to submit an answer.

    Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.