Skip to Content

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

Help required on 'FOR ALL ENTRIES IN'

I am using this query:

SELECT vguid qausp

INTO TABLE tb_qualif

FROM vlcadddata

FOR ALL ENTRIES IN tb_distmode1

WHERE vguid = tb_distmode1-vguid

AND aqual = 'ASPT'.

Now if the internal table contains no data tb_distmode1 then the query is giving wrong result. In fact it is ignoring the part 'FOR ALL ENTRIES IN tb_distmode1'.

Ideally my requirement is not to fetch any data if the table is empty. So can anyone suggest any suitable way so that I can get the desired result without using IF...ENDIF.

Tags:

Helpful Answer

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