A017 goes via KAPOL and gives me a performance issue.


I have a query (I need to figure out werks based on a price condition ) :

select single werks from a017

into (l_werks)

where kappl = 'M'

and kschl = 'PB00'

and knumh = change_document_header-objectid.

The problem with this query is that it makes a full table scan. About 300 000 records.

I don't have any more data to add to my query.

A017 is a pooled table.

When I run this query in ST05 I can see that the query access a table name KAPOL which is a Table pool.

So... the select is on A017 and is accessed via KAPOL.

Any Pointers ?




You can use l_key+32(4) or more elegantly define a workarea with the fields LIFNR MATNR EKORG WERKS and move the content of VAKEY there to pick up <wa>-WERKS.


0 View this answer in context