Skip to Content

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

problem with select....where IN statement

Hi,

i have the following select-statement in my z-abap:

  DATA: s_kostl    TYPE RANGE OF cosp-objnr,

  DATA: s_kstar    TYPE RANGE OF kstar,

.

.

.

  SELECT (lv_feldname) INTO lv_betrag

                  FROM coss WHERE lednr = '00' AND

                             objnr IN s_kostl AND

                             gjahr = gjahr AND

                             kstar IN s_kstar AND

                             wrttp = '04' AND

                             versn = '000'.

now i get a dump, because s_kostl and/or s_kstar contains about 11.000 entries (DBIF_RSQL_INVALID_RSQL).

how can avoid this ? or how i have to 'rewrite' my SQL statment that the ranges-tabs s_kostl AND s_kstar can be processed

correctly ?

br, Martin

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