Error while dowloading ALV output

[Former Member]

Hi All,

When am trying to download the ALV output to a spreadsheet it is giving an information message 'Filter criteria, sorting, totals and subtotals are not taken into account' and the followed by the message 'Export of a list object was terminated (internal error)'.This is occuring when the ALV does not contain any data otherwise it donload fine.In other standard report even if the ALV doesnt have data it downloads empty data to excel.what could be wrong?

THanks,

Rakesh.

[Former Member]

Hi rakesh,

You can put one condition to check the final internal table consists any data or not. If that table is not initial then display the output otherwise just display a message 'Data not found'.

I think this is the solution .

IF NOT T_FINAL[] IS INITIAL.
* Fill field catalog table
    PERFORM FILL_FIELDCATALOG.
* Fill Layout options
    PERFORM FILL_LAYOUT.

    CALL SCREEN 0100.
ELSE 
  MESSAGE ' No data found' Type 'E'.

  ENDIF.

Check whether you filled fieldcatalog correctly or not.

Regards,

Rajitha.

[Former Member]

Rakesh,

check your fieldcat properly.

are they maintained properly like table name and field name in caps and spell mistake should not be there.

and please give full error message for further analysis.

Amit.