Skip to Content
0
Former Member
Oct 04, 2012 at 11:42 AM

Here one "Select" query makeing a lot's of time

23 Views

Dear Experts,

Here i am creating a one report related MM.

Client need a excise detail of all Purchase material.

So i just a fetch data from MSEG and MKPF and then put in one internal table. then i fire select single query in internal table loop.

in below query i need to get two field which is match with BSET table.

But after run this report it's making a lot's of time to run and then get a time out error.

SELECT SINGLE belnr gjahr
FROM bseg
INTO (itab-belnr,itab-gjahr)
WHERE ebeln = itab-ebeln
AND ebelp = itab-ebelp.

So please kindly let me know how can i connect MSEG table with BSEG And BSET table. because existing connection getting time our error.

Thanks in Advance

Keyur Chauhan