topic performance issue with MKPF table in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-with-mkpf-table/m-p/5285286#M1219609 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>My requirement is to get the material documents based on process orders. For this I used XBLNR(Reference Document Number ) in where condition of SELECT statement on MKPF table. But this is taking more time for accessing the table. Then I tried with Secondary Index on this field, but unfortunately it is affecting negative impact on programs. </P><P></P><P>Could you please suggest me on this how to proceed for getting material documents with reference to process orders?</P><P></P><P>Thanks in Advance,</P><P></P><P>Vempati</P></BODY></HTML> Fri, 06 Mar 2009 16:10:42 GMT Former Member 2009-03-06T16:10:42Z performance issue with MKPF table https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-with-mkpf-table/m-p/5285286#M1219609 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>My requirement is to get the material documents based on process orders. For this I used XBLNR(Reference Document Number ) in where condition of SELECT statement on MKPF table. But this is taking more time for accessing the table. Then I tried with Secondary Index on this field, but unfortunately it is affecting negative impact on programs. </P><P></P><P>Could you please suggest me on this how to proceed for getting material documents with reference to process orders?</P><P></P><P>Thanks in Advance,</P><P></P><P>Vempati</P></BODY></HTML> Fri, 06 Mar 2009 16:10:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-with-mkpf-table/m-p/5285286#M1219609 Former Member 2009-03-06T16:10:42Z Re: performance issue with MKPF table https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-with-mkpf-table/m-p/5285287#M1219610 <HTML><HEAD></HEAD><BODY><P>[Search results here|https://forums.sdn.sap.com/search.jspa?q=mkpf%20performance&amp;dateRange=last90days&amp;searchID=23205030&amp;rankBy=10001&amp;start=0]</P></BODY></HTML> Fri, 06 Mar 2009 16:23:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-with-mkpf-table/m-p/5285287#M1219610 former_member156446 2009-03-06T16:23:06Z