Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from halilkinik on Jun 5 at 10:17 AM Hi,
I think this code is faster than "all entries".
SELECT ..........
FROM mara AS a
INNER JOIN makt AS b ON b~matnr = a~matnr
And b~spras = sy-langu
Inner join vbap as c on c~matnr = a~matnr "this will be vbap_vapma for better performance
Inner join vbak as d on d~vbeln = c~vbeln
INTO CORRESPONDING FIELDS OF TABLE it_mat
WHERE a~matnr IN so_matnr
AND a~mstae IN so_mstae
AND a~mtart IN so_mtart
AND c~erdat IN so_erdat
AND d~vbtyp = 'C'.
| | | ---------------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. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
