Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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


1 ACCEPTED SOLUTION

0 Kudos

Hi,

You cannot use inner joins for those tables. so Use For all entries technique in addition you can create custom secondary index for MSEG and BSEG.

Thanks,

Vinoth 

1 REPLY 1

0 Kudos

Hi,

You cannot use inner joins for those tables. so Use For all entries technique in addition you can create custom secondary index for MSEG and BSEG.

Thanks,

Vinoth