performance error for select single * statement

[Former Member]

Sir,

SELECT SINGLE * FROM zqcs INTO wa_zqcs WHERE coll_no = pr_coll.

              on this particular statement i am getting the performance error in the code inspector of one program.

              any aletrnative statement can be written to reslove this issue.

Thanks & Regards.ng

Moderator message : Not enough re-search before posting, discussion locked

Message was edited by: Vinod Kumar

[Former Member]

hi satish,

Make sure that the above statement is not used inside the loop.

if you are using inside the loop it will be performance error.

the alternate is select * from zqcs into table it_zqcs where coll_no = pr_coll.

then you can use

read table it_zqcs into wa_zqcs index 1.

Regards,

Vinoth

[vinoth_aruldass]

hi satish,

Make sure that the above statement is not used inside the loop.

if you are using inside the loop it will be performance error.

the alternate is select * from zqcs into table it_zqcs where coll_no = pr_coll.

then you can use

read table it_zqcs into wa_zqcs index 1.

Regards,

Vinoth