Symptom
In area of responsibility (AOR), when selecting more than 1000 entries of Production Supervisor or Work Center, you got below warning message.
"Selecting more than 1000 entries may influence app performance. Continue with the selection?"
Environment
SAP S/4HANA Cloud
Reproducing the Issue
- Open app e.g. Manage production order.
- Go to AOR
- Add Production Supervisor and choose more than 1000 entries.
- Click on Select
Cause
Each entry selected in AOR will be executed as an OR condition for each supervisor or for work center. If there are too many entries, OR conditions make the SQL statement too long.
The app reads data from many big backend tables. This is complex already with getting all these data into a single layer and expose it to the app. For a few of AOR it works fast. But the time it takes to load keeps increasing with the number of AOR’s. 1000 is the limit set for max performance tolerance as end user (Not KPI) . Any more than that makes the app loading takes longer.
Resolution
As the app is aimed at individual Production Supervisors who are responsible for a subset of materials and plants, please choose fewer entries at one time.
Keywords
Manage production order, AOR, Production Supervisor, Work Center, Selecting more than 1000 entries may influence app performance , KBA , PP-FIO-SFC-2CL , Fiori UI for Production Orders (Public Cloud) , Problem