topic Re: range and dump in Application Development and Automation Discussions

range and dump

Former Member — Mon, 21 Apr 2008 17:12:09 GMT

i had this code


RANGES r_clienti FOR kna1-kunnr.
START-OF-SELECTION.
  CLEAR ok_exit.
  CLEAR sti_knvp2.
  IF NOT s_vendi[] IS INITIAL.
  SELECT kunnr FROM knvp INTO r_clienti-low
                        WHERE kunn2 IN s_vendi
                          AND vkorg EQ 'IT07'
                        AND kunnr IN dd_kunnr
                        AND parvw = 'V2'.           "ae-modif 19.04.08
     r_clienti-option = 'EQ'.
      r_clienti-sign = 'I'.
     APPEND r_clienti.
    ENDSELECT.

    DESCRIBE TABLE r_clienti LINES n_cli.
    IF n_cli < 1000.
      dd_kunnr[] = r_clienti[].
      IF dd_kunnr[] IS INITIAL.
        EXIT.
      ENDIF.
    ENDIF.

i want to take off the select/end select and i made

SELECT kunnr FROM knvp APPENDING TABLE sti_knvp2
                        WHERE kunn2 IN s_vendi
                          AND vkorg EQ 'IT07'
                          AND kunnr IN dd_kunnr
                          AND parvw = 'V2'.           "ae-modif 19.04.08
    LOOP AT sti_knvp2.
      r_clienti-low = sti_knvp2-kunnr.
      r_clienti-option = 'EQ'.
      r_clienti-sign = 'I'.
      MODIFY r_clienti.
    ENDLOOP.
    DESCRIBE TABLE r_clienti LINES n_cli.
    IF n_cli < 1000.
      dd_kunnr[] = r_clienti[].
      IF dd_kunnr[] IS INITIAL.
        EXIT.
      ENDIF.
    ENDIF.

but the report goes in dump and i can't understand why.

who can help me please?

Re: range and dump

former_member156446 — Mon, 21 Apr 2008 17:17:33 GMT

using the ranges will effect the performance... try if you can eliminate it..


SELECT kunnr FROM knvp into vl_kunnr 
                        WHERE kunn2 IN s_vendi
                          AND vkorg EQ 'IT07'
                          AND kunnr IN dd_kunnr
                          AND parvw = 'V2'.           "ae-modif 19.04.08

    LOOP AT sti_knvp2.
      r_clienti-low = vl_kunnr.
      r_clienti-option = 'EQ'.
      r_clienti-sign = 'I'.
      MODIFY r_clienti.
    ENDLOOP.

Re: range and dump

Former Member — Mon, 21 Apr 2008 17:18:24 GMT

What is the dump message you are getting and what is the structure of the table sti_knvp2 which you are using?

Regds,

Krish

Re: range and dump

Former Member — Mon, 21 Apr 2008 17:22:53 GMT

If the dump is because of range then you can try using for all entries in r_xxx where <field> eq r_xxx-low. In your case you are using 2 ranges - depending upon which range you feel can have more number of records, you can switch that using for all entries.

Regds,

Krish

Re: range and dump

Former Member — Mon, 21 Apr 2008 17:23:45 GMT

HI EBONGUE ANDRE ,

CHeck with the firlds in your internal table sti_knvp2.if it contain more fields other than Kunnr,Pls use into corresponding fields of table .

Hope this will work.

<REMOVED BY MODERATOR>

Thanks and regards,

Rajeshwar.

Edited by: Alvaro Tejada Galindo on Apr 21, 2008 1:33 PM

Re: range and dump

Former Member — Mon, 21 Apr 2008 17:26:32 GMT

This line should be an APPEND


    LOOP AT sti_knvp2.
      r_clienti-low = sti_knvp2-kunnr.
      r_clienti-option = 'EQ'.
      r_clienti-sign = 'I'.
      MODIFY r_clienti.        "  Should be APPEND
    ENDLOOP.

after you build the Range, you should also SORT and DELETE DUPLICATES.

Re: range and dump

Former Member — Tue, 22 Apr 2008 06:37:14 GMT

thanx yall a lot by appending instead of modify i solve the problem