Skip to Content

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

select single

hello,

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

FROM VBAK

INTO (G_SAP_ORDER)

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

Tags:
replied

Hi padmini,

[Select single|http://web.mit.edu/fss/dev/select_examples.htm]

Regards,

Sravanthi

0 View this answer in context

Helpful Answer

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