Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to correct error

Former Member
0 Kudos

i am getting error like " large table zvtpmheader : no field of a table index in where condition in code inspector for one of my report.

please tell me what is the problem and how to solve it.

code is like below,

SELECT prgnumb prgtype descript requestor FROM zvtpmheader "+JK01

INTO TABLE t_zvtpmheader "+JK01

WHERE requestor IN s_inireq AND "+JK01

requestor NE p_chareq AND "+JK01

prgstatus = 90 "+JK01

ORDER BY prgtype prgnumb.

2 REPLIES 2

Former Member
0 Kudos

you have to use at least one primary key field in the WHERE condition. Ideally you should use any one combination of the INDEXES available for that table.

This is suggested interms of performance.

ThomasZloch
Active Contributor
0 Kudos

Vague subject, plus the message is somewhat clear, isn't it? Please study the longtext for that message and search for basic concepts like "table indexes".

Thread locked

Thomas