topic Re: insert into sorted table in Application Development and Automation Discussions

insert into sorted table

Former Member — Fri, 05 Mar 2010 11:30:38 GMT

hi experts


TYPES: BEGIN OF ty_line_layout1,
        matnr LIKE mara-matnr,
        maktx LIKE makt-maktx,
        mfrpn LIKE mara-mfrpn,
        mfrnr LIKE mara-mfrnr,
        kunnr LIKE kna1-kunnr,
        name1 LIKE kna1-name1,
        vwerk LIKE knvv-vwerk,
        name1_plant LIKE t001w-name1,
        menge LIKE bapiwmdve-com_qty,
        werks LIKE vbap-werks,
        name2 LIKE t001w-name1,
        count TYPE i,
        percent LIKE ztable-cbetr,
        p LIKE ztable-conwa,
      END OF ty_line_layout1.

TYPES ty_layout1 TYPE SORTED TABLE OF ty_line_layout1 WITH NON-UNIQUE
KEY mfrpn mfrnr.

DATA: layout1 TYPE ty_layout1 WITH HEADER LINE.
.
.
.

FORM retrieve_data.

  SELECT z~matnr z~mfrnr z~mfrpn z~kunnr z~werks COUNT(*) AS count
  FROM ztable AS z INNER JOIN knvv AS k ON z~kunnr = k~kunnr
  INTO CORRESPONDING FIELDS OF layout1
  WHERE z~kunnr IN customer AND
        z~datum IN datum AND
        k~vwerk IN dlvplant AND
        z~mfrpn <> '' AND
        z~mfrnr <> ''
  GROUP BY z~matnr z~mfrnr z~mfrpn z~kunnr z~werks.

    INSERT layout1.  "error 
  ENDSELECT.
.
.
.

i receive following short dump:

Runtime errors         TABLE_ILLEGAL_STATEMENT
Error analysis                                                                                
You attempted to change, delete or create a line in the                
internal table "\PROGRAM=ZZ\DATA=LAYOUT1[]", but no valid cursor exists
for the table.                                                         
Possible reasons:                                                      
1. The relevent ABAP/4 statement does not include the addition         
   "...INDEX...", although the statement is not                        
   inside a "LOOP...ENDLOOP" loop processing this table.               
2. The relevent ABAP/4 statement was called from within a              
   "LOOP...ENDLOOP" loop after a DELETE "\PROGRAM=ZZ\DATA=LAYOUT1[]".

error is triggered at insert statement. I don't understand. Why?

please someone elaborate me. i'm stuck in this weird problem.

thanks in advance.

Re: insert into sorted table

PedroGuarita — Fri, 05 Mar 2010 11:37:28 GMT

You could simplify your code, instead of inserting inside the select statement, just change the INTO CORRESPONDING FIELDS OF layout1 by INTO CORRESPONDING FIELDS OF TABLE layout1 and you won't need the insert statement.

Re: insert into sorted table

Former Member — Fri, 05 Mar 2010 11:37:57 GMT

Try this

APPEND layout1. Instead of INSERT layout1..

Maverick

Re: insert into sorted table

Former Member — Fri, 05 Mar 2010 11:38:42 GMT

Hi,

Please mention INSERT from where to where. I hope you are retrieveing the data and get it's stored on work are LAYOUT1.

Then you are trying to insert the data to table. But you have inserted into LAYOUT1. It will not work If you are trying to insert work

area to table. Try to store an internal table and then try to insert. It will work.

Re: insert into sorted table

ThomasZloch — Fri, 05 Mar 2010 12:01:20 GMT

Don't use tables with header lines, use separate work areas.

Then you can insert the work area into the table using "INSERT wa INTO TABLE itab" for sorted tables.

Thomas

http://help.sap.com/abapdocu_70/en/ABAPINSERT_ITAB_POSITION.htm#!ABAP_ALTERNATIVE_1@1@

Re: insert into sorted table

Former Member — Fri, 05 Mar 2010 12:50:40 GMT

thank you friends.

before i've post i tried with work area


insert wa into layout1.

but correct is:


insert wa into TABLE layout1.

i've also tried with append and it works for first append. at second append i have receive a short dump