DUMP in select query

[Former Member]

Hi friends,

I have one problem , I am IDoc information from EDIDC table for one year EDIDC have more 500000 records, my selet query going dump . could you please help me how to avoid this dump.

Regards,

jayachandran

[Former Member]

Hi Jayachandran

Try using PACKAGE SIZE Option in your select query.

Regards

Bala

[Former Member]

Use the package size option in the select statement while retrieving the data from table.

Sample code

SELECT * FROM EDIDC
                   PACKAGE SIZE 10000
                  APPENDING TABLE itab.    
            
              ENDSELECT.

Regards,

Srinivas.P.

[Former Member]

Hello Jai,

You can do it in following ways:

1. Do not use '*' instead use key field or the required one.

2. Use package size

3. Use into table instead of row by row transfer.

Thanks,

Augustin.