MM standard reports MB51 and MB52 very slow processing

[former_member430534]

We are using standard reports of MM MB51 and MB52, they are taking too much time to execute and display the results. can any please let us know what precautionary measures we can take to make these reports to execute fast.

Thanks in advance.

[Former Member · Accepted solution]

Yes Agreed ,this might be SAP note issue , please find latest sap note ,you can refer above said repots also

921164 - MB51: Improving the runtime using database hints

902675- MB51: Database hints to improve runtime / 4.70

1283280- MB51: Enhancements to multiple account assignment display

1233616- MB51: Bad performance by selection material numbers

555893- MB51: Preventing runtime error DBIF_RSQL_INVALID_RSQL

1159120- MB51: Selection of material numbers not quite correctly

531604- MB52: Performance improvement

540257- MB52: Performance improvement (only for Release 4.5B)

129599- MB52: Performance, incorrect display

Regards,

Sandesh Sawant

[former_member329706]

Refer the belwo performnace OSS notes for MB51 and MB52 it may help you.

Note 151479 - MB51: Performance

Note 531604 - MB52: Performance improvement

[Former Member]

Hi,

Type MB59-Material Document List , MB53-stock as on date.

MB5B- Stock as on date.

MC.1 ,MC.2,MC.9 -this both reports are giving very quickest output.

Also try S_P00_07000139

Regards,

Sandesh Sawant

[former_member646648]

Hi

Be sure that you are not overloading the selection critaria. Secondly please have a discussion with your basis and run Txn ST05 to check for which table its taking longer time. May be from basis side they need to do maintainance.

Regards

Basab

[madhu_vadlamani]

Hi Danish,

That reports performance is fine. Just try with different selection criteria.

Regards,

Madhu