Skip to Content
author's profile photo Former Member
Former Member

Performance issue in mb51

Dear All ,

i'm executing the T.Code--MB51 (Program--RM07DOCS , Include RM07DOCS_GENERATED ) one table(MKPF) is taking too much time . here i'm presenting the query pls help me.

select (g_t_fields)
into corresponding fields of table itab
from mkpf inner join mseg
on mkpf~mandt = mseg~mandt
and mkpf~mblnr = mseg~mblnr
and mkpf~mjahr = mseg~mjahr
WHERE MKPF~BUDAT in BUDAT
and MSEG~BWART in BWART
and MSEG~CHARG in CHARG
and MSEG~KUNNR in KUNNR
and MSEG~LGORT in LGORT
and MSEG~LIFNR in LIFNR
and MSEG~MATNR in MATNR
and MSEG~SOBKZ in SOBKZ
and MKPF~USNAM in USNAM
and MKPF~VGART in VGART
and MSEG~WERKS in WERKS
and MKPF~XBLNR in XBLNR
%_HINTS
ORACLE '&SUBSTITUTE VALUES&' .


Please find and suggest me.

Thanks & Regards,

Krishna



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jun 07, 2012 at 05:28 AM

    Hi

    Pass value in maxium selection in selction-screen as u can.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for your reply..

      but here i'm giving(Selection Screen) Material , Plant , Storage Location , Movement type , Posting Date ,User Name then also it is taking time .

      I Created Secondary Index for MKPF (For fields MANDT, BUDAT ,USNAM , VGART ,XBLNR) with these fields then also no use.

      Please Suggest.

      Thanks ,

      Krishna

  • Posted on Jun 07, 2012 at 11:13 AM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.