Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

none key field at where clause


i need to pull out data from table afru but none of the field at where clause is key field in table afru.

we not allowed to create indexes so would like to know how to optimise the fetch.

SELECT SUM( lmnga ) SUM( xmnga )

INTO (wa-lmnga, wa-xmnga)

FROM afru

WHERE aufnr EQ wa-aufnr AND

vornr EQ wa-vornr AND

werks EQ wa-werks and

stokz ne 'X' and

stzhl eq '0'.


Not what you were looking for? View more on this topic or Ask a question