To have a multiple associated CDS view with Enterprise project in SAP Public Cloud

[gunadharshini]

Hello team

Can we have many related CDS views in One CDS View? I need a sales order created for an enterprise project in the public cloud that includes the quantity, customer, net price, and other details. If I have completed any procurement processes, I also need to see the details of those processes, including the PR's and the purchase order details that were created. Can I combine all three of these into a single CDS view? If so, what all CDS views I must give in the JOIN CONDITION under Data Source. Is it feasible to display all of these data in a single CDS view?

Regards,

Gunadharshini

[erickgoulardt]

Dear Colleague, I hope you find yourself well! Thank you for joining the community. As soon as possible, a technical expert will contact you to clarify your question. I am adjusting the tags to redirect the issue to the right team. Best Regards, Erick Goulardt SAP Support

[junwu]

yes, .......

just look at those standard cds to get some idea

[gunadharshini]

Hi Junwu, I have checked the Standard CDS view, But there are no such one CDS view for all these three. Atleast i need any of Two Cobination like EPPM Project and the Sales Order Details Or EPPM Project and the Procurement details. If I could get any one of these also would be great.

[junwu]

"check standard cds" means trying to get some idea how cds build connection, not asking you to find a standard cds to serve your exact business requirement

[gunadharshini]

Hi Junwu, I have checked the STD CDS of how it is having the Build connection. But there are no CDS which have common fields related to any these three. Suppose the only connection between the Sales order and the Project is the WBS element, I have checked all the CDS view but there is no Fields in Sales order CDS with the WBS ID. So should we have any customization with help of ABAP or any other idea I can proceed with