performance issue with MKPF table

[Former Member]

Hi All,

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.

Could you please suggest me on this how to proceed for getting material documents with reference to process orders?

Thanks in Advance,

Vempati

[former_member156446]

[Search results here|https://forums.sdn.sap.com/search.jspa?q=mkpf%20performance&dateRange=last90days&searchID=23205030&rankBy=10001&start=0]