pls help me with the following query.
i am using Select single statement
to Identify HH order # and check for duplicates in SAP
SELECT SINGLE VBELN " Sales document
WHERE BSTDK EQ g_del_DATE "Customer PO date
and IHREZ EQ G_SO_NUMBER. "Reference number
but here, the where condition are not key fields of the table vbak . i want to select vbeln from vbak which is the primary key of this table based on conditions also....
this statement gives me performance error :
Table &V1&: No field of a table index in the WHERE condition
&V1& = Table name
The current SELECT statement cannot be processed using an index since the WHERE condition does not contain any field of a table index (or index fields only with the addition NOT or the relational operators NE or ' <>').
Due to this, you can have long response times when accessing large database tables.
Check whether you can formulate the WHERE condition to suit a table index.
Check whether an additional table index needs to be created.
How can i accomplish this?
Edited by: padmini udayakumar on Sep 10, 2008 8:55 AM