10-04-2012 12:42 PM
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
10-04-2012 12:54 PM
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
10-04-2012 12:54 PM
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