topic Error during runtime in Application Development and Automation Discussions

Error during runtime

Former Member — Mon, 02 Apr 2007 16:03:42 GMT

Hello:

Error during runtime :


  SELECT OBJNR  GJAHR  KSTAR  PAROB
         WTG001 WTG002 WTG003 WTG004 WTG005 WTG006 WTG007 WTG008
         WTG009 WTG010 WTG011 WTG012 WTG013 WTG014 WTG015 WTG016
  INTO TABLE gt_coss
  FROM COSS
  WHERE LEDNR = '00'      AND "Ledger para objetos de Controlling
        GJAHR = P_anyo    AND "Ejercicio
        WRTTP = '04'      AND "Tipo de valor
        VERSN = '000'     AND "Versión
        VRGNG = 'RKL'     AND "Operación
        PAROB IN r_parob_1

"The maximum size of an SQL statement has been exceeded."

.It is because r_parob_1 has many entries. There is any way to solve this?
I have tried adding: %_HINTS DB2 '&prefer_in_itab_opt 0&&max_blocking_factor 100&'.
:There is no Error syntaxis but It doesn't do anything

There is any way to solve this without to split internal table?

Re: Error during runtime

former_member194669 — Mon, 02 Apr 2007 16:36:16 GMT

I think r_parob_1 contains unique values of Partner objects, instead of using range , you can use for all entries statement in the select.


  SELECT OBJNR  GJAHR  KSTAR  PAROB
         WTG001 WTG002 WTG003 WTG004 WTG005 WTG006 WTG007 WTG008
         WTG009 WTG010 WTG011 WTG012 WTG013 WTG014 WTG015 WTG016
  INTO TABLE gt_coss
  FROM COSS
  FOR ALL ENTRIES IN R_PAROB_1
  WHERE LEDNR = '00'      AND "Ledger para objetos de Controlling
        GJAHR = P_anyo    AND "Ejercicio
        WRTTP = '04'      AND "Tipo de valor
        VERSN = '000'     AND "Versión
        VRGNG = 'RKL'     AND "Operación
        PAROB  EQ R_PAROB_1-LOW.    " I think you don't have any value in HIGH

aRs

Re: Error during runtime

Former Member — Tue, 03 Apr 2007 10:48:20 GMT

OK, I don't have any value in HIGH.

Thanks!