Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from R. N. Wilhite on Jun 5 at 10:57 AM Part of the answer has to depend on what manipulations have been done
to it_final.
What would those be?
Neal
| | | ---------------Original Message---------------
From: halil kinik
Sent: Thursday, June 05, 2014 10:17 AM
Subject: Optimize a Select from vbap
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'. |
| Reply to this email to post your response. __.____._ |   _.____.__ |
