Skip to Content
1
Former Member
Jul 13, 2007 at 01:30 PM

Performance Tuning

17 Views

Hi experts,

Performance seems to take to long here in the select statement. Anybody knows a view table to enhance the selection? Thanks.

  • Retrieve data from LTAP

SELECT tanum

matnr

werks

charg

meins

qdatu

vsolm

maktx

lgort

FROM ltap

INTO TABLE i_ltap

FOR ALL ENTRIES IN i_ltak

WHERE tanum EQ i_ltak-tanum

AND matnr IN s_matnr

AND werks IN s_werks

AND qdatu IN r_date

AND lgort IN s_lgort

AND vltyp IN i_lgtyp.