Skip to Content

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

select...endselect limit!

hi !

one report will occurs runtime error currently.

Runtime Errors DBIF_RSQL_INVALID_RSQL

Except. CX_SY_OPEN_SQL_DB

occuring this runtime erorr of circumstance :

When the inquiry's terms of the scope of the date of the bigger (the system used for a long time, and a large quantity of data up-to-date, the database will soon increase)

report code as follow:

SELECT awerks blifnr bekgrp agjahr amatnr abelnr abuzei aebeln

aebelp abwart alfbnr alfpos axblnr abudat a~menge

awrbtr awaers admbtr ahswae abwtar bbsart

INTO CORRESPONDING FIELDS OF et_out

FROM ekbe AS a JOIN ekko AS b ON aebeln = bebeln

  • AND AWERKS = BBUKRS

WHERE a~belnr IN s_belnr AND

a~ebeln IN s_ebeln AND

b~lifnr IN s_lifnr AND

b~bsart IN g_r_bsart AND

a~budat IN s_budat AND

a~vgabe = 1 AND

a~matnr IN s_matnr AND

a~werks = p_werks AND

b~ekgrp IN s_ekgrp AND

a~menge > 0 AND

a~bwart IN ('101','102','105','106','161','162','122','123') .

include other select .

ENDSELECT .

in debug I found that this statement can be perform

SELECT awerks blifnr bekgrp agjahr amatnr abelnr abuzei aebeln

aebelp abwart alfbnr alfpos axblnr abudat a~menge

but loop again,in this statement occur runtime dump!

so i want to know what limit about select ... endselect!

and it's working function!

thank you very much!

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