We’re experiencing severe performance degradation with our custom CDS views built for project accounting analytics in S/4HANA 2020. The views are used to aggregate project costs, revenues, and profitability metrics across multiple dimensions.
The main issue is query execution time - what used to take 8-12 seconds now takes 45-60 seconds for the same data volume. We’re pulling from standard tables like PRPS, COEP, and BSEG with around 2.3M records. I’ve noticed the delta extraction annotations might not be properly configured, and I’m wondering if switching to HANA calculation views would help.
The CDS views have multiple joins and aggregations, but I’m not sure if we’re following optimization best practices. Has anyone dealt with similar performance issues in project accounting reporting? Should we be looking at view redesign or infrastructure changes?
Check your HANA execution plan through HANA Studio. Navigate to the SQL console and run your view query with the execution plan enabled. Look for table scans where you should have index access, and check if your join operations are happening in the optimal order. Project accounting queries hitting COEP and BSEG are notorious for performance issues if the fiscal year and company code filters aren’t pushed down early. Also, are you using @Analytics.query: true on your consumption view? That enables additional query optimizations. And verify your session variables - sometimes SY-DATUM or SY-UNAME in WHERE clauses prevent proper optimization.
What’s your view hierarchy like? Are you stacking multiple CDS views on top of each other? I’ve found that project accounting analytics often suffer from over-layering. Sometimes consolidating 4-5 view layers into 2-3 makes a huge difference.