Skip to Content
5
Dec 19, 2022 at 09:18 PM

After all these years/tears - CDS Query vs BEx Query

1076 Views Last edit Jan 09, 2023 at 04:39 PM 3 rev

Hi, Would like to get some firm definition or thoughts from other developers out there on this CDS Query vs BEx Query tug of war.

Been trying to stick with CDS Query building, but finding too many deficiencies when compared to BEx Query!
My feeling is that SAP would really like us to use the CDS Analytical Query Road.

The only direction I can find is to use CDS Query as an initial effort and then BEx Query for anything where CDS Query cannot provide the needed functionality. This seems to have been the route for quite a few years now so I don't know if SAP is making an effort to level the playing field between the two.

My biggest probs with CDS View the dynamic periods columns like BEx can do.

So I'm considering all out BEx Query effort going forward for my team due to the CDS Query shortcomings.

To justify this I have a couple of questions I'd like to get from the community

1. Are you using both CDS and BEx Query strategy?

2. Is SAP trying to level the functionality gap between CDS and BEx Query? Been sooo long.

3. Will it be a problem going all BEx Query Development down the line somehow?
(Like from a security method or converting from BEx to CDS Query later on)

Thanks for any input!