Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Karl_Rock on Jun 9 at 4:40 PM If you are selecting on matnr, instead use DB table VAPMA.
| | | ---------------Original Message---------------
From: ebongue andre
Sent: Wednesday, June 04, 2014 7:54 AM
Subject: Optimize a Select from vbap
Hi Folks,
I'm dying with a performance for query in vbap.
How can I change it in other to gain in performance?
I start thinking that using a join and a for all entries is not such a good idea... :(
SELECT * FROM vbap AS a
INNER JOIN vbak AS b
ON a~vbeln = b~vbeln
INTO CORRESPONDING FIELDS OF TABLE it_vbap
FOR ALL ENTRIES IN it_final
WHERE a~matnr = it_final-matnr
AND a~erdat IN so_erdat
AND b~vbtyp = 'C'. |
| Reply to this email to post your response. __.____._ |   _.____.__ |
