Performance issue for custom Change request type in Quality system

[chetan_kumar6]

Hello Folks,

In quality system, for one of the custom CR type ZMAT011(create RAW material), system takes lot of time(around 6-7 minutes), when click on create material/CR link in my change requests/save button etc...

Whereas other CR type ZMAT010(create MRO material) takes just 3-4 seconds to load in quality system.

No performance issues in development environment for all the CR types, it works fine.

Could you please let me know what could be the reason and why it is happening only for RAW material CR type?

Also please let me know how to analyze and compare the performance issue in two different systems.

Thank you all in advance!!

Regards,

Chetan Bappankar

[Former Member]

Hi Chetan

It is very difficult to say but performance depends on many profile parameters. You need to search SAP Note for performance and implement that in your version

[chetan_kumar6]

Hi Sanjay

Thanks for your quick response!

I have noticed the difference in DEV & QA system. There is importing parameter it_sel in the method IF_USMD_PP_ACCESS~QUERY of the class CL_MDG_BS_MAT_ACCESS.

In QA, this it_sel is blank for one the instance for material entity because of which it is leading to the method EXECUTE_SEARCH and getting all the materials. Here it is taking long time and causing low performance.

it_sel should hold the value(temporary ID) for the material as per the difference i observed in both the systems.

I think we should somehow avoid the roundtrip for the blank selection parameter, am not very sure. But my question is why this it_sel is blank for only that instance. Is there any configuration settings to maintain this or need to enhance the method?

Your help is very much appreciated!

Thanks!

Chetan Bappankar