S4HANA Report - Custom CDS

[former_member592379]

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.

This is the actual value of stock quantity of the original CDS (in Query view)

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

[former_member306668 · Accepted solution]

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.

[pascalrenet]

Could it be a cardinality issue ?